Course 10985-C: Introduction to SQL Databases

Microsoft

Course 10985-C: Introduction to SQL Databases

Share This Learning Path

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.

Audience Profile

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

Prerequisites

Course outline

Module 1: Introduction to databases

Module Overview

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

Lessons

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

Lab Sessions

Exploring and querying SQL Server databases

Lab Lessons

Exploring an OLTP Schema and a Data Warehouse Schema
Querying a Database by Using Transact-SQL

After completing this module, students will be able to:

Describe what a database is.
Understand basic relational aspects.
Describe database languages used in SQL Server.
Describe data analytics.

Module 2: Data Modelling

Module Overview

This module describes data modelling techniques.

Lessons

Data modelling
ANSI/SPARC database model
Entity relationship modelling

Lab Sessions

Identify components in entity relationship modelling

Lab Lessons

Identify Entities
Identify Relationships
Finalize Your Model

After completing this module, students will be able to:

Understand the common data modelling techniques.
Describe the ANSI/SPARC database model.
Describe entity relationship modelling.

Module 3: Normalization

Module Overview

This module describes normalization and denormalization techniques.

Lessons

Fundamentals of Normalization
Normal form
Denormalization

Lab Sessions

Normalizing data

Lab Lessons

Normalizing to First Normal Form
Normalizing to Second Normal Form
Normalizing to Third Normal Form
Denormalizing Data

After completing this module, students will be able to:

Describe normalization benefits and notation.
Describe important normalization terms.
Describe the normalization levels.
Describe the role of denormalization.

Module 4: Relationships

Module Overview

This module describes relationship types and effects in database design.

Lessons

Introduction to relationships
Planning referential integrity

Lab Sessions

Planning and implementing referential integrity

Lab Lessons

Planning Referential Integrity
Implementing Referential Integrity by Using Constraints
Implementing Cascading Referential Integrity

After completing this module, students will be able to:

Describe relationship types.
Describe the use, types, and effects of referential integrity.

Module 5: Performance

Module Overview

This module introduces the effects of database design on performance.

Lessons

Indexing
Query performance
Concurrency

Lab Sessions

Performance issues

Lab Lessons

Designing for Efficient Queries

After completing this module, students will be able to:

Discuss the performance effects of indexing.
Describe the performance effects of join and search types.
Describe the performance effects of concurrency.

Module 6: Database Objects

Module Overview

This module introduces commonly used database objects.

Lessons

Tables
Views
Stored procedures, triggers and functions

Lab Sessions

Using SQL server

Lab Lessons

Creating a Table and Constraints
Creating a View
Creating a Stored Procedure

After completing this module, students will be able to:

Describe the use of tables in SQL Server.
Describe the use of views in SQL Server.
Describe the use of stored procedures in SQL Server.
Describe other database objects commonly used in SQL Server.

Book Your Seat

Find Learning Paths

Course AZ-800T00-A: Administering Windows Server Hybrid Core Infrastructure

Join our community of certified professionals

About Us

ICTC is the leader in technical certification courses and exams. Our labs consist of a latest tech PCs and our instructors are certified from each vendor

Policy for the Prevention and Combating of Violence and Harassment in the Workplace.

Learn

View all the provided certifications and there relevant courses. Book online for a certification exam.

Contact Us

International Computer Training Center