Download PDF
of this course

MS10985 - Introduction to SQL Databases (MS10985)

  • Overview
  • Who Should Attend
  • Certifications
  • Prerequisites
  • Objectives
  • Content
  • Schedule
Course Overview

Duration : 3 Days

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.

Who Should Attend

  • The primary audience for this course is people who are moving into a database role, or whose role has expanded to include database technologies.

Course Certifications

This course is part of the following Certifications:

Prerequisites

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

Course Objectives

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 Content

Module 1 : Introduction to databases 

This modules introduces key database concepts in the context of SQL Server 2016

Lessons 

  • Introduction to relational databases
  • Other types of database 
  • Data analysis
  • Database lanuages

Lab : Querying SQ Server 

After completing this module , you will be able to :

  • Describe what a database is
  • Understand basic relational aspects 
  • Describe database languages uses in SQL Server 2016
  • Describe data analytics
  • Describe database languages used in SQL Server 2016

 

Module 2 : Data Modelling 

This module describes data modelling techniques

Lessons

  • Data Modelling 
  • ANSI/SPARC database model
  • Entity relationship modelling

Lab : Entity relationship modelling

After completing this module , you will be able to :

  • Understand the commmon data modelling techniques
  • Describe the ANSI/SPARC database model
  • Describe enetity relationship modelling 

 

Module 3 : Normalization and denormalization techniques

Lessons 

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

Lab : Normalizing raw data 

After completing this module , you will be able to :

  • Describe normlization benefits and notation
  • Describe important normalization terms 
  • Describe the normalization levels
  • Describe the normalization levels
  • Describe the role of denormalization

 

Module 4 : Relationships

This module describes relationship types and effects in database design.

Lessons 

  • Schema mapping
  • Referential integrity

Lab : Designing relationships

After completing this module , you will be able to :

  • Describe relationship types
  • Describe the use, types , and effects referrential integrity

 

Module 5 : Performance 

This module introduces the effetcs of database design on performance.

Lessons

  • Indexing
  • Query performance
  • Concurrency

Lab : Query performance

After completing this module , you will be able to :

  • Discuss the performance effetcs of indexing 
  • Describes the performance effetcs of join and search types
  • Describe the performance effetcs of concurrency 

 

Module 6 : Database Objects

This module introduces commonly used database objects

Lessons 

  • Tables 
  • Views
  • Stored procedures
  • Other database objects

Lab : Using SQL Server in a hybrid cloud

After completing this module , you will be able to :

  • Describe the use of tables in SQL Server 2016
  • Describe the use of views in SSQL Server 2016
  • Describe the use of stored procedures in SQL Server 2016
  • Describe other database objects commonly used in SQL Server 2016

Course ID: MS10985


Show Schedule for 1 Month  3 Months  All 
Date Country Location Register