SQL Server 2016 Database Objects

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

Prerequisite
None

Expected Duration
108 minutes

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.

Objective

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

MONTHLY SUBSCRIPTION

$129/month
 

ANNUAL SUBSCRIPTION

$1295/year

Multi-license discounts available for Annual and Monthly subscriptions.