Duration:

3 Days

Audience:

Employees of federal, state and local governments; and businesses working with the government.

Course Description:

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 design

Learning 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 de-normalization techniques
  • Describe relationship types and effects in database design
  • Describe the effects of database design on performance
  • Describe commonly used database objects

Course Outline

1 – INTRODUCTION TO DATABASES
  • Introduction to relational databases
  • Other types of database
  • Data analysis
  • Database languages
  • Lab : Querying SQ Server
2 – DATA MODELLING
  • Data modelling
  • ANSI/SPARC database model
  • Entity relationship modelling
  • Lab : Entity relationship modelling
3 – NORMALIZATION
  • Why normalize data?
  • Normalization terms
  • Levels of normalization
  • De-normalization
  • Lab : Normalizing raw data
4 – RELATIONSHIPS
  • Schema mapping
  • Referential integrity
  • Lab : Designing relationships
5 – PERFORMANCE
  • Indexing
  • Query performance
  • Concurrency
  • Lab : Query performance
6 – DATABASE OBJECTS
  • Tables
  • Views
  • Stored Procedures, Triggers and Functions
  • Lab : Using SQL Server