Course description

Learn fundamental database concepts for Microsoft SQL Server 2016.

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:

What You’ll Learn

Who Needs to Attend

People who are moving into a database role or whose role has expanded to include database technologies.

Prerequisites

This is a foundation-level course and therefore only requires general computer literacy.

Follow-On Courses:

Course Outline

1. Introduction to Databases

2. Data Modeling

3. Normalization

4. Relationships

5. Performance

6. Database Objects

Labs

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