SQL Server TrackCourse 1 of 7

Microsoft SQL Server Querying Data

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.

16 hours · 11 sessionsCAD $275Beginner to AdvancedHands-On Learning
Enrol in This Course

What you'll learn

  • 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

Prerequisites

No prior SQL experience required. Basic computer literacy recommended.

Part of the SQL Server Track

Master Microsoft's enterprise database platform.

7 courses · approx. 20–28 weeksBeginner to Advanced
View full track

Course Modules

11 modules · instructor-led, hands-on delivery

01Overview and Installation
02Introduction to Data Query
03Database Design and Creation
04Writing Basic Queries
05Working with Operators and Functions
06Querying Multiple Tables
07Aggregating Data
08Subqueries and Set Operations
09Advanced Query Techniques
10Functions and Views
11Query Performance Basics

Other courses in this track

01

Microsoft SQL Server Querying Data(current)

16 hours · 11 sessionsCAD $275
02
Microsoft SQL Server Database Development34 hours · 22 sessionsCAD $519
03
Microsoft SQL Server Database Administration28 hours · 19 sessionsCAD $427
04
05
Microsoft SQL Server Security and Protection13 hours · 9 sessionsCAD $325

Ready to Enrol?

CAD $275 · Get in touch and we'll get you started in Microsoft SQL Server Querying Data.

Send an Enquiry