Name: SQL Server “Rookie to Rock Star”: 2-Day Workshop in Ottawa, ON
Start: 2026-04-08T09:00:00-04:00
End: 2026-08-26T22:00:00-04:00
Location: regus ON, Ottawa - Albert & Metcalfe

$SQL Server \u201cRookie to Rock Star\u201d: 2-Day Workshop in Ottawa, ON$

Intensive hands-on course providing an introduction to relational database design concepts, SQL, data modeling, and industry standards.
About this Event

Group Discounts:

Save 10% when registering 3 or more participants
Save 15% when registering 10 or more participants

About This Course

Duration: 2 Days (9:00 AM – 5:00 PM)
Delivery Mode: Classroom / In-Person Workshop
Language: English
Credits: 16 PDUs / Training Hours
Certification: Course Completion Certificate Provided
Refreshments: Lunch, tea/coffee, and snacks included

Course Overview

SQL Server “Rookie to Rock Star” is an intensive hands-on two-day workshop that provides an introduction to relational database design concepts and industry standards. Students learn the tools and processes for data modeling in Relational Database Management Systems (RDBMS). The course focuses on the Structured Query Language (SQL) to define and manipulate data, along with advanced database concepts and current trends.

Learning Objectives

Learn relational database design concepts and industry standards.
Understand data modeling in Relational Database Management Systems (RDBMS).
Define and manipulate data using Structured Query Language (SQL).
Design and implement a database application.
Understand current trends in databases including replication, data warehousing, and OLAP.

Target Audience

Participants who want an introduction to relational database design, SQL, data modeling, and database application development.

Why choose this course?

This two-day workshop is an intensive hands-on course that covers relational database design concepts, SQL, data modeling, normalization, UML techniques, and advanced database topics. It also discusses current trends such as data warehousing, OLAP, and database uses of web technology, enabling participants to design and implement a database application upon successful completion.

Want to train your entire team together?

This course can be delivered in Classroom mode and can be customized based on individual or team requirements.

📧 Contact us today to schedule a customized in-house, face-to-face session at

Agenda
Day 1
Module 1: Explain the database approach, environment, application life cycle
Module 2: Explain the functions and characteristics of the relational model.
Module 3: Describe and work through the normalization process.
Module 4: Apply UML techniques of database design including:

Info: • Enhanced entity-relationship modeling using UML
• Functional dependencies
• Derivation of relations schema from EER model

Module 5: Apply database design process to implement a database application.
Module 6: Explain database security issues and data protection techniques
Module 7: Explain the use of databases in data warehousing and OLAP.
Module 8: Use SQL - DDL to implement a relational database.
Module 9: Use SQL for data manipulation such as the basic Select statement.
Module 10: Use SQL for advanced manipulation such as Group BY, Having, and Cor
Day 2
Module 11: Limit results using SQL/T-SQL; create stored procedures and trigger
Module 12: Discuss techniques for transaction management, concurrency control
Module 13: Analyzing SQL Server Query Plans.
Module 14: Query Optimization.