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