Course Details

Previous Page


SQL Server Database Fundamentals: Creating, Optimizing, and Securing Databases


Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number



Overview/Description
The Data Definition Language or DDL is used to create databases and their components. In this course, you will learn how to create databases, tables, views, and stored procedures using DDL. The learning path describes how databases can be normalized according to specific guidelines to increase storage capacity and scalability. You'll also learn how to use indexes to make your databases more responsive. Finally, you'll learn about the core security considerations for SQL Server databases, how to assign permissions to database objects, and how to back up and restore databases. This course can be used as part of the preparation for Microsoft's exam 98-364, Database Fundamentals, which leads to a Microsoft Technical Associate or MTA certification.

Target Audience
Individuals who want to learn the fundamentals of SQL Server relational databases

Prerequisites
None

Expected Duration (hours)
2.6

Lesson Objectives

SQL Server Database Fundamentals: Creating, Optimizing, and Securing Databases

  • start the course
  • create a new SQL Server database with its specific syntax and parameters and review its schema by using SQL Server Management Studio or SSMS and Data Definition Language or DDL
  • use, alter, and drop SQL Server databases by using SQL Server Management Studio or SSMS and Data Definition Language or DDL
  • create SQL Server tables and define their properties by using SQL Server Management Studio or SSMS and Data Definition Language or DDL
  • alter and drop SQL Server tables by using SQL Server Management Studio or SSMS and Data Definition Language or DDL
  • compare TRUNCATE to DELETE and use the TRUNCATE command to remove data from a SQL Server table
  • describe the purpose and performance impact of views and create a view in a SQL Server database by using SQL Server Management Studio or SSMS graphical designer or by using Transact-SQL or T-SQL
  • create and use stored procedures in SQL Server databases
  • compare the stored functions with stored procedures and create and use a stored function within a SQL Server database
  • describe the purpose of normalizing relational databases
  • describe the normalization guidelines for relational databases and define the first normal form or 1NF
  • describe the normalization guidelines for relational databases and define the second normal form or 2NF
  • describe the normalization guidelines for relational databases and define the third normal form or 3NF
  • describe clustered and nonclustered indexes in the context of their use in a SQL Server database
  • create clustered and nonclustered indexes in SQL Server databases
  • describe the main considerations for relational database security
  • identify and describe SQL Server fixed and user-defined server and database roles, the guest account, and how to revoke it by using SQL Server Management Studio or SSMS
  • create, assign, and manage permissions to a SQL Server login
  • list the options available in SQL Server for database backups and restores
  • use SQL Server to back up databases
  • use SQL Server to restore databases
  • use the appropriate commands to create and normalize tables in a SQL Server database
  • Course Number:
    df_dbfu_a02_it_enus