Live Chat
Monday - Friday 8am - 6pm EST Chat Now
Contact Us
Monday - Friday 8am - 8pm EST 1-866-716-6688 Other Contact Options

Cart () Loading...

    • Quantity:
    • Delivery:
    • Dates:
    • Location:


Introduction to SQL Databases (M10985)

Learn fundamental database concepts for Microsoft SQL Server 2016.

GK# 4393 Vendor# M10985

$895 - $2295 USD

Enroll Request Group Training

Course Overview


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.

This course is also available in the On-Demand delivery format with digital Microsoft Official Courseware (dMOC). Click here to purchase.


  • Delivery Format:
  • Date:
  • Location:
  • Access Period:


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


Viewing outline for:

Classroom Live Outline

1. Introduction to Databases

  • Relational databases
  • Other types of databases
  • Data analysis
  • Database languages

2. Data Modeling

  • ANSI/SPARC database model
  • Entity relationship modeling

3. Normalization

  • Why normalize data?
  • Normalization terms
  • Levels of normalization
  • Denormalization

4. Relationships

  • Schema mapping
  • Referential integrity

5. Performance

  • Indexing
  • Query performance
  • Concurrency

6. Database Objects

  • Tables
  • Views
  • Stored procedures
  • Other database objects


Viewing labs for:

Classroom Live 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



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

Who Should Attend

  • Individuals moving into a database role or whose role has expanded to include database technologies

Vendor Credits


SATV Redemption

Redeeming your Microsoft Software Assurance Training Vouchers:

  • Redeem five SATVs for a Classroom Live or Virtual Classroom Live session
  • Redeem five SATVs for an individual On-Demand course plus digital Microsoft Official Courseware (dMOC)
  • Redeem two SATVs for an individual On-Demand course

For more information on Microsoft SATVs, click here.

Follow-On Courses

Training Exclusives

This course comes with 12 months access to the following benefits:

  • Practice Labs
  • 24x7 Mentoring
  • Indexed Class Recordings
  • Unlimited Retakes
  • Digital Courseware
Find out more
Course Delivery

This course is available in the following formats:

Classroom Live

Receive face-to-face instruction at one of our training center locations.

Duration: 3 day

Virtual Classroom Live

Experience expert-led online training from the convenience of your home, office or anywhere with an internet connection.

Duration: 3 day


Train at your own pace with 24/7 access to courses that help you acquire must-have technology skills.

Duration: 6 hours

Request this course in a different delivery format.