Udemy Business

Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

Master SQL Server from Basic to Advanced - 25 hrs Training

Name: Master SQL Server from Basic to Advanced - 25 hrs Training
Rating: 5.0 (11 reviews)

Complete SQL Server Training: SQL Queries, Joins, CTEs, Stored Procedures, Triggers, and Database Development

Created byajay parmar

Last updated 6/2026

English

What you'll learn

Write SQL queries confidently to retrieve, filter, sort, summarize, and analyze data using real-world business scenarios.
Design and manage SQL Server databases by creating tables, relationships, primary keys, foreign keys, and other constraints while maintaining data integrity.
Develop advanced database solutions using Stored Procedures, Triggers, Views, Common Table Expressions (CTEs), and error-handling techniques.
Improve database performance through indexing, query optimization techniques, and practical troubleshooting methods used in real-world projects.

Course content

8 sections • 78 lectures • 24h 38m total length

Basic Terms use in Database18:56
Dowload SQL Server1:30
I am attaching here the part2 sql also. i have attached databases also , though you can too create these yourself as they are very small and easy to create.
Download SSMS and Adventure database1:30
Select Query | Where Clause | Order By35:53
Your Score is your level
NOT IN | IN operators16:26
Objective Questions Part120:24
As keyword and Group by50:54
HAVING Clause9:42
OVER Clause17:13
Over and Group by concept - Nested Aggregations20:44
OVER For cumulative totals13:24
OVER for Cumulative Total with Partitions15:28
Check your score.
Questions GroupBy - Next level discussion47:44

SQL Inner Join19:18
SQL Left Join3:18
SQL Right Join4:23
SQL Full Join11:14
SQL Cross Join4:23
SQL Project Non Match IDs Union All Derived Table9:27
SQLProject Union All Rules And How To Solve Derived Table12:21
SQL Nested Joins10:48
SQL Self Join Find Reporting Manager Project11:00
SQL Self Join Reporting Manager Consecutively Thrice Project214:20
SQL Derived Table Audience More Than 50k Consecutively Thrice Project 323:11
SQL Joins Between Queries17:20
SQL Joins Behaviour With Minus Plus9:46
SQL Project22:15

Interview Questions - Part 131:47
Interview Questions - Part 230:21
Interview Questions - Part 319:18
Interview Questions - Part 416:24
DML DDL And Database Schema Table Introduction - Part 524:34
Create Drop Databases Tables Schema - Part 627:25
Create Copy Table - Part 76:55
Rename Columns Delete - Part 87:11
Update SQL - Part 926:29
Update SQL Customer Table Show Discount - Part 1021:09
Update Customer Order Quantities - Part 1127:39

Insert SQL - Part 115:46
Select For InsertSelect IntoQuery Project GetOther Tbl Column IntoMain Table P-232:51
Project Add Pending Orders If ID exist - Part 317:23
Import Excel Using SQL And Issues In Driver issues Solution Chatgpt - Part 433:40
Intro Referential Integrity - Part 514:24
Creating PK FK And Referential Integrity - Part 641:58
Delete Query Behaviour Referential Integrity - Part 734:46
Update Query Behaviour Referential Integrity - Part 815:54
INSERT Query Behaviour Temp Disable Able Constraints - Part 927:35
Questions Check Your Progress - Part 107:27

Triggers AFTER Update Create Log - Part 117:22
Triggers AFTER Delete Log - Part 24:21
Trigger INSTEAD OF INSERT Project Part1 Give Identifier To Duplicate Emails28:48
Trigger INSTEAD OF INSERT Project Creating Insert Query Part2 To HandleDuplicate21:31
Trigger INSTEAD OF INSERT Project Part3 Putting More Conditions Handle Duplicate30:31
Trigger INSTEAD OF UPDATE Project DISCARD Negative Qty12:38
Triggers AFTER Trigger Introduction Basic Syntax Formation5:42
Triggers AFTER Insert Update Log Creation20:27

Requirements

Basic Excel functions is fine to take up this course. No coding required.

Description

This course is designed for beginners, working professionals, data analysts, software developers, database developers, and anyone preparing for SQL Server interviews.

Throughout the course, every concept is explained using practical examples, hands-on exercises, interview scenarios, and real-world business cases.

In This Course You Will Learn

• SQL Server Installation and Configuration

• Creating and Managing Databases

• Understanding Tables, Rows, Columns, and Data Types

• Creating Tables Using SQL Scripts

• Primary Key Constraint

• Foreign Key Constraint

• Unique Constraint

• Referential Integrity Concepts

• INSERT Statements from Basic to Advanced

• UPDATE Statements with Real-World Examples

• DELETE Statements and Data Management

• SELECT Queries and Data Retrieval

• Filtering Data Using WHERE Clause

• Sorting Data Using ORDER BY

• Aggregate Functions and Group By

• HAVING Clause

• Working with NULL Values

• String Functions

• Date Functions

• Mathematical Functions

• SQL Server Joins (INNER JOIN)

• LEFT JOIN

• RIGHT JOIN

• FULL OUTER JOIN

• SELF JOIN

• Joining Multiple Tables

• UNION and UNION ALL

• Subqueries

• Correlated Subqueries

• Common Table Expressions (CTEs)

• Views and Their Practical Usage

• Stored Procedures from Basic to Advanced

• Input Parameters

• Output Parameters

• Error Handling Using TRY...CATCH

• Dynamic SQL Concepts

• SQL Server Triggers

• AFTER Triggers

• INSTEAD OF Triggers

• Handling Duplicate Records Through Triggers

• Bulk Insert Scenarios Using Triggers

• SQL Server Indexes

• Clustered Indexes

• Non-Clustered Indexes

• Understanding Query Performance

• Query Optimization Concepts

• Execution Plan Basics

• Transactions and Data Consistency

• Interview Questions and Practical Scenarios

• Excel and SQL Server Integration

• Power Query and SQL Server Integration

• Real-World Database Development Scenarios

Course Features

• Step-by-Step Learning Approach

• Beginner to Advanced Coverage

• Practical Hands-On Examples

• Real-World Business Scenarios

• Interview-Oriented Training

• Industry Best Practices

• Detailed Explanations of Every Topic

• Exercises for Practice

• Project-Based Learning

• Suitable for Students and Working Professionals

Who this course is for:

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

Master SQL Server from Basic to Advanced - 25 hrs Training

What you'll learn

Explore related topics

Course content

SQL Server Basics13 lectures • 4hr 30min

SQL INTERMEDIATE - OFFSET, TOP RANK, OVER , LAG, RANK DENSE , IIF , SELECT END11 lectures • 2hr 33min

JOINS14 lectures • 2hr 53min

DDL | DML Queries11 lectures • 3hr 59min

KEYS | COSNTRAINTS WITH REFERENTIAL INTEGRITY10 lectures • 4hr 2min

COMMON TABLE EXPRESSIONS - CTEs8 lectures • 2hr 9min

STORED PROCEDURES BEGINS3 lectures • 2hr 10min

TRIGGERS BEGINS8 lectures • 2hr 21min

Requirements

Description

Who this course is for: