Course Outline
Pre-Requisites
This is a foundation level course and therefore only requires general computer literacy.
Lessons
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.
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.
Training Location
Online Classroom
your office
your city,
your province
your country
I would never take another course that starts at 11AM and goes to 9PM again. The way the course was laid out really took away from the capturing of what was presented as it was 5-6 hours of watching a screen before getting to the actual labs. There has to be a better way to lay out this particular course. In my previous course, the lectures were broken up by labs which worked out fantastic and kept you engaged in the course. There were days when in order to actually complete the labs, would go over the 9PM day end time frame. Was able to get the primary labs done, but if you want to get all the content completed, you cannot complete it in the window of this course, you will need to come back on your own time.