All Courses
SQL Server TrackBeginner to Advanced

SQL Server

Master Microsoft's enterprise database platform.

The most comprehensive SQL Server track available in BC. From writing your first query to designing high-availability systems, this track takes you from beginner to database professional across seven in-depth courses.

7 courses · approx. 20–28 weeksBeginner to Advanced

What you'll be able to do

Query and manipulate data using T-SQL
Design, build, and administer enterprise databases
Tune queries and indexes for peak performance
Implement security, backup, and disaster recovery strategies
Build ETL pipelines with SQL Server Integration Services

Courses in this track

7 courses · taken in sequence for best results

01
Microsoft SQL Server Querying Data16 hours · 11 sessionsCAD $275

This comprehensive course is designed for everyone from beginners to advanced users. Hands-on training guides you through essential querying techniques, from writing basic SELECT statements to mastering complex joins, subqueries, functions, views, and performance optimisation. Build practical skills to retrieve data efficiently, strengthen your database querying expertise, and boost your career opportunities in data science.

Learning outcomes

Understand the fundamentals of SQL Server querying
Write basic to advanced SQL queries
Master data retrieval, filtering, sorting, and aggregation
Gain skills in joining tables and subqueries
Explore advanced querying techniques including window functions, CTEs, and set operations
View course details
02
Microsoft SQL Server Database Development34 hours · 22 sessionsCAD $519

This hands-on training covers everything from fundamental database concepts to advanced development techniques, including writing efficient queries, designing robust tables, implementing stored procedures and functions, managing concurrency, and working with modern data types like XML, JSON, and spatial data.

Learning outcomes

Understand core database concepts and SQL Server architecture
Design and implement efficient tables, views, functions, and stored procedures
Handle errors and ensure data integrity using constraints and triggers
Perform complex data manipulation using MERGE and table-valued parameters
Develop highly concurrent applications with proper transaction and locking management
View course details
03
Microsoft SQL Server Database Administration28 hours · 19 sessionsCAD $427

This course provides a thorough foundation for effectively managing and maintaining SQL Server environments. Starting with installation and data storage configuration, the course covers security management, backup and recovery strategies, automation using SQL Server Agent, performance monitoring, and high availability solutions to ensure resilient and scalable SQL Server deployments.

Learning outcomes

Install and configure SQL Server with optimised storage settings
Implement robust security and user authorisation measures
Design and manage backup and recovery strategies for data protection
Automate routine administrative tasks and configure alerts
Monitor and troubleshoot SQL Server performance and connectivity issues
View course details
04

This comprehensive course equips database professionals with the skills needed to optimise query and system performance effectively. Covering essential topics from identifying performance bottlenecks and analysing costly queries to advanced indexing strategies and execution plan management, participants will learn how to enhance SQL Server responsiveness and efficiency. The course also delves into critical areas such as blocking and deadlock resolution, cursor cost analysis, and workload optimisation.

Learning outcomes

Identify system performance bottlenecks and top performance killers in SQL Server
Analyse, design, and deploy indexes to support multiple queries within the database workload
Analyse and resolve bookmark lookup and statistics-related issues in execution plans
Understand performance tuning exceptions and tricks within the SQL Server environment
Analyse and resolve fragmentation, transaction blocking, and deadlocks
View course details
05
Microsoft SQL Server Security and Protection13 hours · 9 sessionsCAD $325

Covering a broad spectrum of topics from foundational security concepts to advanced encryption techniques, this course offers in-depth knowledge of securing SQL Server environments against modern threats — including SQL injection, denial-of-service, and data breaches. Participants will explore server and network security best practices, user authentication and authorisation mechanisms, data protection strategies, and auditing techniques to ensure compliance and robust monitoring.

Learning outcomes

Understand and apply multiple layers of SQL Server security including service accounts, encryption algorithms, and database encryption mechanisms
Configure server and network security settings such as SSL encryption, firewall rules, and service management
Manage user authentication and authorisation including Windows and SQL Server authentication
Implement advanced data protection techniques including column-level permissions, roles, schemas, and views
Configure SQL Server auditing for compliance and robust monitoring
View course details

This course equips IT professionals and database administrators with the essential skills to design, implement, and manage robust HADR solutions using AlwaysOn Availability Groups, Windows Clustering, Failover Cluster Instances, Log Shipping, Replication, and Distributed Availability Groups. Learn how to safeguard your data against downtime and disasters, optimise failover processes, and maintain continuous business operations.

Learning outcomes

Understand the core concepts of SQL Server High Availability and Disaster Recovery
Configure and manage AlwaysOn Availability Groups for seamless failover and disaster recovery
Set up and administer Windows Server Failover Clustering and SQL Server Failover Cluster Instances
Evaluate and select appropriate HADR solutions based on organisational needs and infrastructure
View course details

This comprehensive course provides in-depth training on Microsoft SQL Server Integration Services (SSIS), focusing on both development and administration aspects. Participants will learn how to design, develop, deploy, and manage robust data integration solutions using SSIS, covering ETL processes, control flow, data flow, error handling, package deployment, security, performance tuning, and automation of SSIS packages.

Learning outcomes

Understand the architecture and components of SQL Server Integration Services
Develop efficient and scalable ETL solutions using SSIS
Monitor and troubleshoot SSIS package execution and performance
Automate SSIS workflows using SQL Server Agent and other scheduling tools
View course details

Ready to Enrol?

Get in touch and we'll help you find the right starting point.

Send an Enquiry