Introduction to SQL Databases

Introduction to SQL Databases (M10985)

Introduction

This course will give delegates an understanding of fundamental database concepts. The course also looks at database types design and languages.

Prerequisites

There are no prerequisites for this course and only basic computer literacy is needed.

Aimed at

This course is primarily aimed at those looking to move into a database role or expanding Into database technologies.

Duration

This course has a duration of 3 days

Course outline

Module 1: Introduction to databases

This module introduces key database concepts
in the context of  SQL Server 2016.

Lessons

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

Lab : Querying SQL Server

Module 2: Data Modelling

This module describes data modelling techniques.

Lessons

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

Lab: Entity relationship modelling

Module 3: Normalization

This module describes normalization and denormalization techniques.

Lessons

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

Module 4: Relationships

This module describes relationship types and effects in database design.

• Schema Mapping
• Referential Integrity 

Module 5: Performance

Lessons

• Indexing
• Query performance
• Concurrency

Lab : Query performance

Module 6: Database Objects This module Introduces commonly used database objects.

Lessons

• Tables
• Views
• Stored procedures
• Other database objects

Lab: using SQL Server In a hybrid cloud