- Choose how you want to learn: online or in a classroom
- About this course
- Overview
- Course details
- Prerequisites
- Community Share this page Facebook Twitter LinkedIn Email
Compare learning environments | On-demand training | Classroom training | |
---|---|---|---|
Find a Microsoft Learning Partner | Find an on-demand training partner | Find a classroom training partner | |
Anytime access | Yes | No | |
Anywhere access to recorded instructor | Yes | No | |
Microsoft official training content | Yes | Yes | |
In-depth training | Yes | Yes | |
Hands-on labs | Yes | Yes | |
SATV redemption | Yes | Yes | |
Ask instructor questions in person | No | Yes | |
Attend live class in person | No | Yes | |
Attend live class remotely | No | Yes | |
Time commitment | Self-paced (3 month access) | 3 days |
Audience(s): | IT Professionals |
Technology: | Microsoft SQL Server |
Level: | 300 |
This Revision: | A |
Delivery method: | Classroom |
Length: | 2 days |
Language(s): | English |
First published: | 28 July 2016 |
About this course
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.
Audience profile
The primary audience for this course is people who are moving into a database role, or whose role has expanded to include database technologies.
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
Course OutlineModule 1: Introduction to databasesThis module introduces key database concepts in the context of SQL Server 2016.Lessons
Lab : Querying SQL Server After completing this module, you will be able to: Module 2: Data ModellingThis module describes data modelling techniques.Lessons
Lab : Entity relationship modellingAfter completing this module, you will be able to:
Lab : Normalizing raw data After completing this module, you will be able to: Module 4: RelationshipsThis module describes relationship types and effects in database design.Lessons
Lab : Designing relationships After completing this module, you will be able to: Module 5: PerformanceThis module introduces the effects of database design on performance.Lessons
Lab : Query performance After completing this module, you will be able to: Module 6: Database ObjectsThis module introduces commonly used database objects.Lessons
Lab : Using SQL Server in a hybrid cloud After completing this module, you will be able to: |
- This is a foundation level course and therefore only requires general computer literacy.
- Looking for training resources, events and advice from peers? Join the Microsoft Training and Certification Community.Preparing for an exam now? Find your Microsoft Certification Study Group.Talk to us on these social networks: