10985 Introduction to SQL Databases

Price
$1,785.00

SATV Eligible

Duration
3 Days

Delivery Methods
VILT Private Group

This three-day instructor-led 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 designs.

Upcoming Class Dates and Times

Jan 25 - Jan 27, 2021

8:00AM - 4:00PM Central

3 Days

Virtual Instructor Led

GTR

Enroll

Mar 15 - Mar 17, 2021

8:00AM - 4:00PM Central

3 Days

Virtual Instructor Led

GTR

Enroll

May 10 - May 12, 2021

8:00AM - 4:00PM Central

3 Days

Virtual Instructor Led

GTR

Enroll

Jun 28 - Jun 30, 2021

8:00AM - 4:00PM Central

3 Days

Virtual Instructor Led

GTR

Enroll

Who Should Attend

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

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

Agenda

1 - Introduction to databases

Introduction to relational databases
Other types of database
Data analysis
Database languages

2 - Data Modelling

Data modelling
ANSI/SPARC database model
Entity relationship modelling

3 - Normalization

Why normalize data?
Normalization terms
Levels of normalization
Denormalization

4 - Relationships

Schema mapping
Referential integrity

5 - Performance

Indexing
Query performance
Concurrency

6 - Database Objects

Tables
Views
Stored procedures
Other database objects