Sql Server Part2- Intermediate Level
Published 5/2025
Created by ajay parmar
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Level: Intermediate | Genre: eLearning | Language: English | Duration: 11 Lectures ( 2h 33m ) | Size: 1.3 GB
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.
Who this course is for
Data Analysts and those who work with medium or especially large datasets.
Sql Server Part2- Intermediate Level
