• Online, Self-Paced
Course 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.

Learning Objectives

SQL Tables

  • 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

Data Types

  • 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

Designing for Normalization

  • 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

Practice: Implementing SQL Tables

  • demonstrate how to create a SQL Table

Framework Connections

The materials within this course focus on the Knowledge Skills and Abilities (KSAs) identified within the Specialty Areas listed below. Click to view Specialty Area details within the interactive National Cybersecurity Workforce Framework.