In this course, you will learn fundamental database concepts for Microsoft SQL Server 2016, including database types, database languages and database designs.
This course incorporates material from the Official Microsoft Learning Product 10985: Introduction to SQL Databases.
Each individual Microsoft Official Course On-Demand includes 3 months (or 12 months with purchase of Microsoft Total Access Collection) of 24x7 access to the following:
HD-quality streaming videos that adapt to your connection speed and device
Hands-on live labs with integrated lab steps and ability to save and resume labs
Knowledge checks for comprehensive assessments
24x7 mentoring via chat, email and phone
What You’ll Learn
Key database concepts in the context of SQL Server 2016.
Database languages used in SQL Server 2016.
Data modeling techniques.
Normalization and denormalization techniques.
Relationship types and effects in database design.
Effects of database design on performance.
Commonly used database objects.
Who Needs to Attend
People who are moving into a database role or whose role has expanded to include database technologies.
This is a foundation-level course and therefore only requires general computer literacy.
Querying Data with Transact-SQL (M20761)
Provisioning SQL Databases (M20765)
1. Introduction to Databases
Other types of databases
2. Data Modeling
ANSI/SPARC database model
Entity relationship modeling
Why normalize data?
Levels of normalization
6. Database Objects
Other database objects
Lab 1: Querying SQL Server
Lab 2: Entity relationship modeling
Lab 3: Normalizing raw data
Lab 4: Designing relationships
Lab 5: Query performance
Lab 6: Using SQL Server in a hybrid cloud