fbpx

Introduction to Microsoft SQL Server

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

Address

Training @ any New Horizons Training Centers   View map

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

 

 

Target Student and Prerequisites

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 Content

  • Introduction to relational databases
  • Other types of database
  • Data analysis
  • Database languages
  • Lab : Querying SQ Server
 
  • 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
  • Data modelling
  • ANSI/SPARC database model
  • Entity relationship modelling
  • Lab : Entity relationship modelling
 
  • Why normalize data?
  • Normalization terms
  • Levels of normalization
  • De-normalization
  • Lab : Normalizing raw data
 
  • Schema mapping
  • Referential integrity
  • Lab : Designing relationships
 
  • Indexing
  • Query performance
  • Concurrency
  • Lab : Query performance
 
  • Tables
  • Views
  • Stored Procedures, Triggers and Functions
  • Lab : Using SQL Server
× Need any help? Chat with us now