Overview

This Introduction to SQL Databases training class 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.

The primary audience for this course is people who are moving into a database role, or whose role has expanded to include database technologies.

Goals

Learn to describe key database concepts in the context of SQL Server 2016.
Learn to describe database languages used in SQL Server 2016.
Learn to describe data modelling techniques.
Learn to describe normalization and denormalization techniques.
Learn to describe relationship types and effects in database design.
Learn to describe the effects of database design on performance.
Learn to describe commonly used database objects.

Outline

Introduction to databases
1. Introduction to relational databases
2. Other types of database
3. Data analysis
4. Database languages
5. Lab: Querying SQL Server
Data Modelling
1. Data modelling
2. ANSI/SPARC database model
3. Entity relationship modelling
4. Lab: Entity relationship modelling. After completing this module, you will be able to:
  1. Understand the common data modelling techniques
  2. Describe the ANSI/SPARC database model
  3. Describe entity relationship modelling
Normalization
1. Why normalize data?
2. Normalization terms
3. Levels of normalization
4. Denormalization
5. Lab: Normalizing raw data
Relationships
1. Schema mapping
2. Referential integrity
3. Lab: Designing relationships
Performance
1. Indexing
2. Query performance
3. Concurrency
4. Lab: Query performance
Database Objects
1. Tables
2. Views
3. Stored procedures
4. Other database objects
5. Lab: Using SQL Server in a hybrid cloud

Class Materials

Each student in our Live Online and our Onsite classes receives a comprehensive set of materials, including course notes and all the class examples.

Class Prerequisites

Experience in the following is required for this SQL Server class:

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

Preparing for Class

Onsite: Course Setup
Live Online: Course Setup | WebEx Setup

No cancelation for low enrollment

Certified Microsoft Partner

Registered Education Provider (R.E.P.)

GSA schedule pricing

72,346

Students who have taken Live Online Training

15,155

Organization who trust Webucator for their training needs

100%

Satisfaction guarantee and retake option

9.42

Students rated our trainers 9.42 out of 10 based on 5,232 reviews

MOC 10985 - Introduction to SQL Databases

Customized Onsite Training

Live Online Training

Upcoming Classes