Get in Touch

Calgary - Macleod Place II

5940 Macleod Trail SW, Calgary, Canada, T2H2H4

Strategically located just minutes from downtown, the centre offers easy accessibility as it's next to two major roadways and the Chinook Light Rapid Transit station is only two blocks away.

Calgary – Altius Centre

Altius Centre Suite 2500, 500 4th Avenue South West Calgary AB T2P 2V6, Calgary, Canada, T2P 2V6

A Premier Workspace with Seamless Citywide Connectivity Join Calgary’s elite business network at Altius Centre, seamlessly linked to the city through the Plus 15 Skywalk. Set up your office in the heart of downtown, surrounded by thriving industries and dynamic enterprises. Enhance your productivity in a contemporary workspace featuring a drop-in business lounge and a state-of-the-art videoconferencing studio. Enjoy effortless access to a wealth of amenities, all within walking distance via the skywalk.

Subcategories (2)

SSAS

SSAS
SSIS

SSIS

Explore Our Courses

SQL Server Management Studio (SSMS) Administration

 21 Hours

This instructor-led, live training in Calgary (online or onsite) is aimed at intermediate-level database administrators who wish to learn the necessary skills and knowledge to effectively manage and administer SQL Server databases using SQL Server Management Studio.

By the end of this training, participants will be able to:

  • Understand system requirements and perform installations.
  • Create, configure, and manage databases using SSMS.
  • Manage logins, users, roles, and permissions.
  • Perform various types of backups and restore databases.
  • Create, schedule, and manage jobs using SQL Server Agent.
  • Implement best practices for efficient and secure SQL Server administration.
Read more...

Microsoft SQL Server Database Administration

 40 Hours
This instructor-led, live training in Calgary covers core SQL Server administration skills. Participants will learn to install and configure environments, manage databases, and monitor performance. Ideal for IT professionals seeking hands-on experience with automation and troubleshooting.
Read more...

Microsoft SQL Server for Database Administrators: Intermediate to Advanced

 28 Hours

This instructor-led, live training in Calgary (online or onsite) is aimed at intermediate-level to advanced-level database administrators who wish to deepen their knowledge of SQL Server for efficient database management, performance tuning, high availability, and advanced troubleshooting.

By the end of this training, participants will be able to:

  • Administer and configure SQL Server instances using best practices.
  • Optimize performance of queries and databases.
  • Implement high availability and disaster recovery strategies.
  • Diagnose and resolve complex issues in production environments.A
Read more...

SQL Server 2022 Integration Services (SSIS) – Data Flows and Advanced Transformations

 14 Hours

This instructor-led training in Calgary focuses on designing advanced SSIS data flows and transformations. Participants will master Slowly Changing Dimensions, handle complex data sources, and deploy robust packages for efficient data warehousing and migration scenarios.

Read more...

Visual Studio for PLC Communication and Database Integration

 21 Hours

This instructor-led, live training in Calgary (online or onsite) is aimed at intermediate-level software developers and automation engineers who wish to build applications that communicate with PLCs and interact with SQL databases using Visual Studio.

By the end of this training, participants will be able to:

  • Develop .NET applications in Visual Studio for industrial automation.
  • Communicate with PLCs using industrial protocols such as OPC UA.
  • Implement database interactions with SQL Server for storing and retrieving PLC data.
  • Optimize application performance for real-time industrial environments.
Read more...

Introduction to SQL Server 2022 Integration Services (SSIS)

 28 Hours

This instructor-led, live training in Calgary (online or onsite) is aimed at beginner-level data professionals who wish to learn how to design, implement, and manage SSIS packages to perform data integration and transformation tasks.

By the end of this training, participants will be able to:

  • Understand the architecture and components of SSIS.
  • Design and implement ETL processes using SSIS.
  • Use SSIS tools to develop, deploy, and manage data integration solutions.
  • Troubleshoot and optimize SSIS packages for performance and reliability.
Read more...

Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

 14 Hours
This advanced SQL course in Calgary covers stored procedures, triggers, and error handling for Microsoft SQL Server. It helps developers build complex, production-grade database solutions with efficient transaction control and procedural logic for enterprise environments.
Read more...

Transact SQL Advanced

 7 Hours
This advanced Transact SQL course in Calgary equips delegates with skills to handle complex result sets and optimize database performance. It covers analytical functions, index management, query tuning, and basic data warehouse techniques for Microsoft SQL Server.
Read more...

T-SQL Fundamentals with SQL Server Training Course

 14 Hours
Master T-SQL fundamentals in this hands-on course in Calgary. Learn to use SQL Server Management Studio, create tables with DDL and DML, and build complex queries with joins and subqueries. Ideal for beginners seeking core database skills and practical experience with modern relational systems.
Read more...

Administering in Microsoft SQL Server

 21 Hours
In Calgary, this training empowers administrators to manage SQL Server effectively. Learners master database creation, SQL syntax for data retrieval, and security protocols. You will also explore advanced features like replication, automation, and BI to build complex, real-world solutions.
Read more...

Microsoft SQL Server (MSSQL)

 14 Hours
This instructor-led course in Calgary is designed for delegates already acquainted with SQL Server. It focuses on set-based querying, query tuning, working with indexes, and analyzing execution plans. Participants will master table expressions, ranking functions, and partitioned tables.
Read more...

MS SQL Server: SQL Advanced level for Data Analysts

14 Hours

This course is designed to provide a thorough understanding of advanced SQL syntax and techniques available in Microsoft SQL Server. By mastering analytical functions, table joins, subqueries, and aggregation techniques, participants will learn how to move data analysis tasks from MS Excel directly to the database layer. This approach not only improves efficiency but also supports the development of robust IT systems based on Microsoft SQL Server.

Read more...

SQL language in MSSQL

 14 Hours
This hands-on SQL training in Calgary teaches efficient query writing for Microsoft SQL Server. It covers relational models, data retrieval, filtering, and aggregation. Participants master multi-table joins, subqueries, and DML operations to reliably manipulate business intelligence datasets.
Read more...

Learning SQL with Microsoft SQL Server

 21 Hours
This instructor-led training in Calgary covers the essentials of SQL with Microsoft SQL Server, helping participants master querying, database design, and normalization. Through hands-on exercises, learners will gain practical skills in T-SQL to optimize data and connect seamlessly with Excel.
Read more...

Business Intelligence with SSAS

 14 Hours
This hands-on training in Calgary explores SQL Server Analysis Services for advanced BI and data modeling. Participants will learn to design OLAP cubes, leverage MDX queries, and deploy robust solutions, gaining practical skills to drive data-driven decision-making for modern business operations.
Read more...

Last Updated:

Testimonials (5)

data was personalised to our organisations

Vincent Long - ASSMANG PTY LTD

Course - T-SQL Fundamentals with SQL Server Training Course

personalised to our understanding and data

Vincent Long - ASSMANG PTY LTD

Course - Business Intelligence with SSAS

The instructor brought his A game again as he superbly took my staff through the customized training with expert timing, knowledge, support, and rapport with my staff.

James - Shawnee Mission School District

Course - Administering in Microsoft SQL Server

The lecture about cte

Glyssa Mae - Metropolitan Bank and Trust Company

Course - Transact SQL Advanced

Lot of content and exactly the requested one.

Pascal - Diehl

Course - Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

Upcoming Courses

Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

2026-11-19 09:30
14 hours
Calgary – Altius Centre
CA$ 4,770 (Online)
CA$ 6,770 (Classroom)

Microsoft SQL Server for Database Administrators: Intermediate to Advanced

2026-12-03 09:30
28 hours
Calgary - Macleod Place II
CA$ 9,115 (Online)
CA$ 13,115 (Classroom)

Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

2026-12-17 09:30
14 hours
Calgary – Altius Centre
CA$ 4,770 (Online)
CA$ 6,770 (Classroom)

SQL Server 2022 Integration Services (SSIS) – Data Flows and Advanced Transformations

2026-12-31 09:30
14 hours
Calgary - Macleod Place II
CA$ 6,420 (Online)
CA$ 8,420 (Classroom)

T-SQL Fundamentals with SQL Server Training Course

2027-01-14 09:30
14 hours
Calgary – Altius Centre
CA$ 4,770 (Online)
CA$ 6,770 (Classroom)

Other regions in Canada

Other Countries

These courses are also available in other countries
Online Microsoft SQL Server training in Calgary, SQL Server training courses in Calgary, Weekend MS SQL Server courses in Calgary, Evening SQL Server training in Calgary, MS SQL Server instructor-led in Calgary, MS SQL Server coaching in Calgary, Weekend MS SQL Server training in Calgary, SQL Server classes in Calgary, MS SQL Server boot camp in Calgary, Online Microsoft SQL Server training in Calgary, MS SQL Server on-site in Calgary, MS SQL Server private courses in Calgary, MS SQL Server instructor in Calgary, SQL Server trainer in Calgary, MS SQL Server instructor-led in Calgary, SQL Server one on one training in Calgary, Evening Microsoft SQL Server courses in Calgary