Introduction to SQL Databases SQL Server 2016 training is a three-day that is designed for professionals aspiring to acquire knowledge and skills for SQL Server 2016. This course will qualify individuals to seek a role as database professionals and also beneficial for those whose job role is expanding to encompass database elements.
This course describes the fundamental database concepts including database types, database languages, and database designs.
Completion of this course will equip participants with the following skill set and knowledge base:
Module 1: Introduction to databases
This module describes the key database concepts in the context of SQL Server 2016.
Lessons
Lab: Querying SQL Server
Module 2: Data Modelling
This module lays emphasis on data modelling techniques.
Lessons
Lab: Entity relationship modelling
Module 3: Normalization
This module describes normalization and de-normalization techniques.
Lessons
Lab: Normalizing raw data
Module 4: Relationships
This module describes relationship types and effects in database design.
Lessons
Lab: Designing relationships
Module 5: Performance
This module introduces the effects of database design on performance.
Lessons
Lab: Query performance
Module 6: Database Objects
This module introduces commonly used database objects.
Lessons
Lab: Using SQL Server in a hybrid cloud
The individuals who are seeking a role in database management, or whose role has expanded to include database technologies.
This is a foundation level course and therefore only requires general computer literacy.
Name | Code | Fee |
---|
OR