Data Private Public

Introduction to SQL Databases (55315)

3 days

Microsoft SQL Server SQL Data Microsoft Databases

Build foundational SQL Server database skills in this three-day course covering database concepts, modeling, normalization, relationships, and performance.

Talk to a Learning Consultant Register for a Public Class Request a Private Class

Register or Request Training

Course Overview

This three-day instructor-led course introduces fundamental database concepts in the context of SQL Server, including database types, database languages, data modeling, normalization, relationships, performance considerations, and commonly used database objects.

It is designed for professionals moving into database roles, people whose responsibilities are expanding to include database technologies, and developers who deliver content from SQL Server databases. This course updates and replaces course 10985C.

Course Benefits

Describe key database concepts in the context of SQL Server.
Describe database languages used in SQL Server.
Explain fundamental data modeling techniques.
Describe normalization and denormalization techniques.
Explain relationship types and their effects on database design.
Describe how database design affects performance.
Identify and describe commonly used database objects.

Delivery Methods

Public Class
Live expert-led online training from anywhere. Guaranteed to run .

Private Class
Delivered for your team at your site or online.

Course Outline

Introduction to Databases
1. Introduction to Relational Databases
2. Other Databases and Storage
3. Data Analysis
4. SQL Server Database Languages
Data Modeling
1. Data Modeling
2. Designing a Database
3. Relationship Modeling
Normalization
1. Fundamentals of Normalization
2. Normal Form
3. Denormalization
Relationships
1. Introduction to Relationships
2. Planning Referential Integrity
Performance
1. Indexing
2. Query Performance
3. Concurrency
Database Objects
1. Tables
2. Views
3. Stored Procedures, Triggers, and Functions

Class Materials

Each student receives a comprehensive set of materials, including course notes and all class examples.

Class Prerequisites

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

General computer literacy is required.

Follow-on Courses

Have questions about this course?

We can help with curriculum details, delivery options, pricing, or anything else. Reach out and we’ll point you in the right direction.

Talk to a Learning Consultant