Intermediate Microsoft SQL Programming – Level II

Course Description

This advanced SQL course is designed for users who are ready to move beyond the basics and tackle more complex queries. Participants will learn to write advanced SELECT statements with refined filtering, perform a variety of joins (including outer, self, and cross joins), and master subqueries for dynamic data retrieval.

The course also covers set operations (UNION, INTERSECT, EXCEPT) and advanced aggregation techniques using GROUP BY, CASE, and powerful window functions like ROW_NUMBER() and RANK(). Through hands-on exercises, learners will develop the skills to build efficient, scalable, and insightful queries for real-world data analysis.

Course Objectives
- Write Advanced SQL SELECT Statements with Complex Filtering and Deduplication Techniques
- Perform Complex Joins Including Outer, Self, and Cross Joins to Retrieve Related Data
- Use Subqueries in Various Clauses to Support Nested and Correlated Data Retrieval
- Apply SQL Set Operations to Combine and Compare Query Results Effectively
- Implement Advanced Aggregation, Grouping, and Window Functions for Analytical Queries

Course Outline

Lesson 1: Advanced SQL SELECT Statement

Using DISTINCT to eliminate duplicates
Advanced filtering with LIKE, IN, and BETWEEN operators
Combining conditions with AND/OR

Lesson 2: Advanced Joins

LEFT JOIN, RIGHT JOIN, FULL OUTER JOIN
Self Joins and Cross Joins

Lesson 3: Subqueries

Using subqueries in SELECT, WHERE, and FROM clauses
Correlated subqueries vs. non-correlated subqueries
Nested queries for complex data retrieval Lesson

4: Set Operations

UNION, UNION ALL, INTERSECT, EXCEPT
When to use each set operation

Lesson 5: Advanced Aggregation and Grouping

GROUP BY with multiple columns
Using CASE statements for conditional aggregation
Window Functions (ROW_NUMBER(), RANK(), DENSE_RANK())

Course Information

Course Level: Intermediate

Credit: 16 hours

Fee: $995

Length: 2 days

Delivery: Virtual Live/Group On-site

Intermediate Microsoft SQL Programming – Level II

Course Information

Related Courses

Microsoft 365 Copilot for Word & Outlook

Microsoft 365 Copilot for SharePoint & OneDrive

Microsoft 365 Copilot for PowerPoint

Microsoft 365 Copilot for Business Productivity & Cross-App Workflows