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.
©2026 Catils. This content is protected by copyright law. Copy or Reproduction without permission is prohibited.
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.
Event Venue & Nearby Stays
Regus – AB, Calgary – McDougall, 639 5 Ave SW, Suite 2500 Calgary,, Calgary, Canada
CAD 1210.17 to CAD 1551.72
