10985 Introduction to SQL Databases
CLASS DATE(s):
5/11/2020 - 5/13/2020
8/3/2020 - 8/5/2020

COURSE LENGTH: 3 Days

COURSE COST: $1495

COURSE TIMES: 9:00am - 4:30pm

Printable version of this course
print
Register for this course
register

COURSE OVERVIEW

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.

This is largely a theory based course and does not cover end-to-end how to create a database in SQL Server.

AUDIENCE 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

This is a foundation level course and therefore only requires general computer literacy.

FOLLOW UP COURSES  

*Course Cost listed does not include the cost of courseware. Course is subject to a minimum enrollment to run the course. Course may run virtually as a virual live instructor led class if the minimum enrollment is not met. For more information, please contact: 207-775-0244 or email: learn@vtec.org.

COURSE TOPICS:


Module 1: Introduction to databases
Introduction to relational databases
Other types of database
Data analysis
Database languages
Lab : Querying SQL Server

Module 2: Data Modelling
Data modelling
ANSI/SPARC database model
Entity relationship modelling
Lab : Entity relationship modelling

Module 3: Normalization
Why normalize data?
Normalization terms
Levels of normalization
Denormalization
Lab : Normalizing raw data

Module 4: Relationships
Schema mapping
Referential integrity
Lab : Designing relationships

Module 5: Performance
Indexing
Query performance
Concurrency
Lab : Query performance

Module 6: Database Objects
Tables
Views
Stored procedures
Other database objects
Lab : Using SQL Server in a hybrid cloud