We are happy to advise you!
1­-855­-778­-7246    Contact

Introduction to SQL Databases (10985)


Course Content

This three-day instructor-led course is the starting point if you are looking to move into a database professional role or if your job role is expanding to encompass database elements. You will learn fundamental database concepts including database types, database languages, and database designs.

Who should attend

IT Professionals who are moving into a database role, or whose role has expanded to include database technologies.


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

Course Objectives

  • Learn key database concepts in the context of SQL Server 2016
  • Become familiar with database languages used in SQL Server 2016
  • Describe data modelling techniques
  • Perform normalization and denormalization techniques
  • Describe relationship types and effects in database design
  • Understand the effects of database design on performance
  • Know commonly used database objects

Outline: Introduction to SQL Databases (10985)

Module 1: Introduction to Databases

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

Module 2: Data Modelling

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

Module 3: Normalization

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

Module 4: Relationships

  • Schema mapping
  • Referential integrity

Module 5: Performance

  • Indexing
  • Query performance
  • Concurrency

Module 6: Database Objects

  • Tables
  • Views
  • Stored procedures
  • Other database objects


  • Querying SQL Server
  • Entity relationship modelling
  • Normalizing raw data
  • Designing relationships
  • Query performance
  • Using SQL Server in a hybrid cloud
Online Training

Duration 3 days

  • CAD 1,995
Classroom Training

Duration 3 days

  • Canada: CAD 1,995

Currently there are no training dates scheduled for this course.