Introduction to SQL Databases - 10985 Course Outline
This three-day instructor-led course is aimed at people looking to move into a database professional role or whose job role is expanding to encompass database elements. The course describes fundamental database concepts including database types, database languages, and database designs.
*** NOTE: This class also available in On-Demand, eLearning Format ***
Too busy at work to miss 5 days out of the office to take this class? Consider the MOC On-Demand version of this course. Watch videos developed by Microsoft, take the same hands-on labs, access an online expert 24/7, and study at on your own time, at your own pace. For details on this alternative format, go to
MOC On-Demand 10985: Introduction to SQL Databases 2016
The primary audience for this course is 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.
At course completion
After completing this course, students will be able to:
• Describe key database concepts in the context of SQL Server 2016
• Describe database languages used in SQL Server 2016
• Describe data modelling techniques
• Describe normalization and denormalization techniques
• Describe relationship types and effects in database design
• Describe the effects of database design on performance
• Describe commonly used database objects
Module 1: Introduction to databases
This module introduces key database concepts in the context of SQL Server 2016.
Introduction to relational databases
Other types of database
Lab : Querying SQ Server
Module 2: Data Modelling
This module describes data modelling techniques.
ANSI/SPARC database model
Entity relationship modelling
Lab : Entity relationship modelling
Module 3: Normalization
This module describes normalization and denormalization techniques.
Why normalize data?
Levels of normalization
Lab : Normalizing raw data
Module 4: Relationships
This module describes relationship types and effects in database design.
Lab : Designing relationships
Module 5: Performance
This module introduces the effects of database design on performance.
Lab : Query performance
Module 6: Database Objects
This module introduces commonly used database objects.
Other database objects
Lab : Using SQL Server in a hybrid cloud
View outline in Word