Introduction to SQL Databases (M10985)

In this course, you will learn fundamental database concepts for Microsoft SQL Server 2016, including database types, database languages and database designs.

Course Outline

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.

Note:

  • Redeem three SATVs* for a Classroom, Virtual Classroom, or Virtual Classroom Fit session
  • Redeem three SATVs for an individual GK Digital Learning course plus digital Microsoft Official Courseware (dMOC)
  • Redeem two SATVs for an individual GK Digital Learning course
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
Follow-On Courses
  • Querying Data with Transact-SQL (M20761)
  • Provisioning SQL Databases (M20765)
Who Needs To Attend
  • Individuals moving into a database role or whose role has expanded to include database technologies
Training Exclusives

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

  • Practice Labs
  • 24x7 Mentoring
  • Indexed Class Recordings
  • Unlimited Retakes
  • Digital Courseware
Course 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
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

Training Location

Online Classroom
your office

your city, your province
your country