SQL Server 2016 Database Objects


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


Overview/Description
In order to properly design and implement a relational database schema, it is important to have an understanding of the fundamentals of SQL Server 2016. This course covers creating and altering tables, designing normalization, as well as the various data types available in SQL Server 2016. This course is one of a series of courses that cover the objectives for 70-762: Developing SQL Databases exam.

Target Audience
Database professionals and developers looking to become skilled in SQL Server 2016 database

Prerequisites
None

Expected Duration (hours)
1.8

Lesson Objectives

SQL Server 2016 Database Objects

  • start the course
  • create tables in SQL Server 2016
  • use the DROP TABLE statement to drop a table from a database
  • use the ALTER TABLE statement to modify a table
  • add and removing columns from a table
  • duplicate a table
  • rename a table
  • use constraints to ensure integrity of data
  • describe the best practices to follow when selecting a naming convention
  • describe the numeric data type category in SQL Server 2016
  • describe the date and time data type category in SQL Server 2016
  • describe the character and unicode data type category in SQL Server 2016
  • describe the binary strings data type category in SQL Server 2016
  • describe the special data types category in SQL Server 2016
  • recognize the process of normalization in SQL Server 2016
  • describe the first normal form level of normalization
  • describe the second normal form level of normalization
  • describe the third normal form level of normalization
  • discuss when to denormalize a database
  • demonstrate how to create a SQL Table

    • Course Number:
    df_sqld_a01_it_enus

    Expertise Level
    Intermediate