Contact Us

Contact Us






Introduction to SQL Databases 3 days | | $1,785 PLUS TAX

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. Prerequisite: 

TARGET AUDIENCE

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 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

INTRODUCTION TO DATABASES

  • » Introduction to relational databases
  • » Other types of database
  • » Data analysis
  • » Database languages
  • » Lab : Querying SQ Server

DATA MODELLING

  • » Data modelling
  • » ANSI/SPARC database model
  • » Entity relationship modelling
  • » Lab : Entity relationship modelling

NORMALIZATION

  • » Why normalize data?
  • » Normalization terms
  • » Levels of normalization
  • » De-normalization
  • » Lab : Normalizing raw data

RELATIONSHIPS

  • » Schema mapping
  • » Referential integrity
  • » Lab : Designing relationships

PERFORMANCE

  • » Indexing
  • » Query performance
  • » Concurrency
  • » Lab : Query performance

DATABASE OBJECTS

  • » Tables
  • » Views
  • » Stored procedures
  • » Other database objects
  • » Lab : Using SQL Server in a hybrid cloud
  • Please call for dates