Introduction to SQL Databases (55315)

This course updates and replaces course 10985C previously published under the same title.

Course Outline

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 course updates and replaces course 10985C previously published under the same title.

WHAT YOU'LL LEARN

At course completion

Describe key database concepts in the context of SQL Server
Describe database languages used in SQL Server
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

OUTLINE

Module 1: Introduction to databases

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

Lessons

Introduction to Relational Databases
Other Databases and Storage
Data Analysis
SQL Server Database Languages

Module 2: Data Modeling

This module describes data modelling techniques.

Lessons

Data Modelling
Designing a Database
Relationship Modeling

Module 3: Normalization

This module describes normalization and denormalization techniques.

Lessons

Fundamentals of Normalization
Normal Form
Denormalization

Module 4: Relationships

This module describes relationship types and effects in database design.

Lessons

Introduction to Relationships
Planning Referential Integrity

Module 5: Performance

This module introduces the effects of database design on performance.

Lessons

Indexing
Query Performance
Concurrency

Module 6: Database Objects

This module introduces commonly used database objects.

Lessons

Tables
Views
Stored Procedures, Triggers and Functions

LABS

Lab: Exploring SQL Server Databases and Tables

Explore SQL Server
Query Databases and Tables

Lab: Identify Components in Relationship Modeling

Modeling a database

Lab: Normalizing Data

Normalizing Tables

Lab: Planning and Implementing Referential Integrity

Implementing Referential Integrity

Lab: Performance Issues

Using Indexes

Lab: Using SQL Server Objects

Using Tables
Using Views
Using Stored Procedures

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. Developers that deliver content from SQL Server databases will also benefit from this material.

Training Location

Online Classroom
your office

your city, your province
your country

Current price: $1,885.50

Regular price: $2,095.00

For more information, call 1-877-313-8881

Registration is fast, and will take approximately 3 minutes. There is no membership fee.

Course details

Course Start Date: 24-June-2024

Time: 09:00:00 - 17:00:00

Duration: 3 days 09:00 AM - 05:00 PM

Location: Virtual

Delivery Methods(s): Instructor Led

Discount Seats Available: 2

Category: Microsoft SQL Training

Cancellation Policy

We require 16 calendar days notice to reschedule or cancel any registration. Failure to provide the required notification will result in 100% charge of the course. If a student does not attend a scheduled course without prior notification it will result in full forfeiture of the funds and no reschedule will be allowed. Within the required notification period, only student substitutions will be permitted. Reschedules are permitted at anytime with 16 or more calendar days notice. Enrollments must be rescheduled within six months of the cancel date or funds on account will be forfeited.

Additional Details

Pre-Requisites: This is a foundation level course and therefore only requires general computer literacy.

Certificates Offered: Certificate of Completion

This course is also scheduled on the following dates:

June 24th (Virtual)

August 12th (Virtual)

October 21st (Virtual)