Sql Server Part2- Intermediate Level

SQL - Deep dive into fundamentals

What you'll learn

In this course, you’ll master the most essential SQL skills used in real-world data analysis.

You’ll learn how to work with SQL subqueries. search patterns, deep dive into OVER Clause

We’ll explore subqueries to filter, transform, and analyze data dynamically.

You'll understand how to use IF conditions for decision-making within queries.

Advanced topics like RANK() with OVER() and OFFSET will help you perform powerful row-based calculations and pagination.

By the end of this course, you’ll be confident writing both basic and advanced SQL queries used in day-to-day data projects.

Requirements

If you have finished SQL Part1, you are good to start. In part1, we have covered basics of select query with other important features

Description

What You’ll Learn – Key SQL Server Concepts (This is our PART2)Subqueries (Inner Queries):Learn to use queries inside SELECT, FROM, or WHERE to filter and shape your results dynamically.Nested Subqueries:Understand how to write subqueries inside other subqueries to solve more complex data problems.ROW_NUMBER(), RANK(), DENSE_RANK() with OVER():Generate row numbers and rankings for each row in a result set using the OVER() clause.OVER() with PARTITION BY:Reset row numbers or rankings within each group (like department-wise ranks) using PARTITION BY.Reverse Row Numbers:Create row numbers in descending order using ORDER BY … DESC within the OVER() function.Search Patterns with Wildcards (LIKE, %, _):Use pattern-matching to find flexible string matches (e.g., names starting with "A" or ending with "Z").RANK() vs. DENSE_RANK():Know when to use each ranking function and understand how they handle ties differently.IIF(condition, true, false) – Inline IF:A shorthand conditional function that lets you return different values based on a condition.CASE…WHEN…THEN…ELSE…END:Handle multiple conditions within a query — similar to IF…ELSE IF…ELSE logic in programming. Know the difference between these two approaches and which one should you choose when?OFFSET and FETCH NEXT:Learn how to skip rows and fetch a specific number of rows — useful for pagination and efficient data browsing.

Overview

Section 1: Introduction

Lecture 1 OFFSET with Fetch Next and TOP

Lecture 2 IIF function and Select End

Lecture 3 Row number with OVER

Lecture 4 Print Reverse numbers and Partition

Lecture 5 RANK DENSE with Over

Lecture 6 LAG with OVER

Lecture 7 SubQuery_FindMaxdiscountRecords

Lecture 8 SubQuery_Using_IN_NotIN_operator

Lecture 9 SubQuery More Example Using IN_Not IN

Lecture 10 SubQuery - 2ndHighestSalary

Lecture 11 Search methods using patterns and wild cards

Data Analysts and those who work with medium or especially large datasets.