Microsoft Sql - The Complete Guide For Beginners (Tsql)

Learn SQL from scratch with practical T-SQL examples—ideal for aspiring developers and data analysts (Microsoft SQL)

What you'll learn

Understand the fundamentals of SQL and T-SQL, including syntax, queries, and data types

Write powerful SELECT queries to retrieve data from one or more tables

Use filters, sorting, and wildcards to refine results

Perform data manipulation with INSERT, UPDATE, and DELETE statements

Work with joins, subqueries, and common table expressions (CTEs) to handle complex data

Explore stored procedures, functions and views in SQL Server

Learn how to use SQL Server Management Studio (SSMS) with the AdventureWorks sample database

Requirements

No prior SQL or database experience needed – this course is designed for absolute beginners

A computer with Windows OS (SQL Server installation)

Willingness to learn by doing – the course includes hands-on exercises

Description

SQL (Structured Query Language) is the universal language for working with data—and it's one of the most in-demand skills across industries like tech, finance, healthcare, marketing, and more. Whether you’re building web applications, analyzing customer trends, or automating business reports, SQL is the foundation of all data-related tasks.Microsoft SQL Server is one of the most widely used database systems in the world, powering everything from small business tools to large enterprise systems. In this course, you’ll learn to work with SQL Server using T-SQL (Transact-SQL)—Microsoft’s powerful extension of standard SQL.Are you new to databases and want to master Microsoft SQL Server from the ground up?Do you want to confidently write queries, understand how data is stored, and prepare for real-world data tasks or interviews?This beginner-friendly course is your complete step-by-step guide to learning SQL Server and T-SQL (Transact-SQL)—from installation to advanced querying techniques.Why This Course?Designed for beginners: Concepts explained simply and visuallyReal-world focus: Learn using the AdventureWorks2022 sample databaseHands-on approach: Practice queries with immediate feedbackCovers both theory and application: Understand not just how, but whyUpdated content: Aligned with modern SQL Server versions and practicesCourse Structure:Each section includes:Clear explanations of SQL conceptsReal examples using AdventureWorks2022Practice questions and answersQuizzes and exercises to reinforce learningWhy Learn SQL Server?SQL is one of the most in-demand skills across tech, finance, marketing, and beyond. Microsoft SQL Server is widely used by businesses to store, analyze, and manage data. Whether you're a developer, analyst, or aspiring data professional, learning SQL gives you a competitive edge.Start your data journey today.Enroll now and master the language of data—T-SQL with Microsoft SQL Server!

Overview

Section 1: Introduction

Lecture 1 Welcome

Lecture 2 Install SQL Server

Lecture 3 Install SSMS

Lecture 4 What are tables and Query?

Lecture 5 Connect to SQL Server

Lecture 6 Restore Adventure Works

Lecture 7 Data Types in SQL

Section 2: Select Statement (5)

Lecture 8 Basic Fundamentals

Lecture 9 Select with Hello World

Lecture 10 Select statement and Alias Names

Lecture 11 Select from Table

Lecture 12 DISTINCT and TOP Keywords

Lecture 13 Alias Names

Lecture 14 Quick SELECT

Lecture 15 Assignment

Section 3: Filtering Data (6)

Lecture 16 Filtering Records

Lecture 17 Data and WHERE Clause

Lecture 18 WHERE clause with multiple conditions

Lecture 19 BETWEEN logical operator

Lecture 20 IN operator

Lecture 21 NOT operator

Lecture 22 IS NULL operator

Lecture 23 Wildcards Part 1

Lecture 24 Wildcards Part 2

Lecture 25 Assignment - Filtering Data

Section 4: Sorting Data (7)

Lecture 26 ORDER BY clause

Lecture 27 Order multiple columns

Lecture 28 Order by row number

Lecture 29 Assignment - Sorting Data

Section 5: Aggregate Functions(8)

Lecture 30 Counting Rows

Lecture 31 Common Aggregate Functions

Lecture 32 Assignment - Aggregate Function

Section 6: Grouping Rows(9)

Lecture 33 GROUP BY Clause

Lecture 34 WHERE clause with GROUP BY

Lecture 35 Multiple aggregate functions in GROUP BY

Lecture 36 HAVING clause

Lecture 37 Optimized Query

Lecture 38 Assignment - Grouping Rows

Section 7: Switch Case(10)

Lecture 39 CASE statement

Lecture 40 CASE and GROUP BY

Lecture 41 CASE and WHERE clause

Lecture 42 Assignment - Switch Case

Section 8: Joining Tables(11)

Lecture 43 INNER JOIN Theory

Lecture 44 INNER JOIN in Action

Lecture 45 INNER JOIN and column selection

Lecture 46 Join three tables

Lecture 47 NULL values are ignored in join

Lecture 48 LEFT JOIN

Lecture 49 Right JOIN

Lecture 50 Joins and WHERE clause

Lecture 51 SELF JOIN

Lecture 52 CROSS JOIN

Lecture 53 Assignment - Joining Table

Section 9: SET Operators(12)

Lecture 54 UNION and UNION ALL

Lecture 55 UNION in Complex Example

Lecture 56 EXCEPT and INTERSECT

Lecture 57 Assignment - SET Operators

Section 10: String SQL Functions (13)

Lecture 58 CASE, LEFT and TRIM

Lecture 59 LEFT and RIGHT

Lecture 60 SUBSTRING

Lecture 61 CHARINDEX

Lecture 62 REPLACE and REVERSE

Lecture 63 Assignment - String SQL Functions

Section 11: Date SQL Functions (14)

Lecture 64 GETDATE

Lecture 65 DATEADD

Lecture 66 DATEPART

Lecture 67 DATEDIFF

Lecture 68 ISDATE

Lecture 69 Assignment - Date SQL Functions

Section 12: Data Type Conversion (15)

Lecture 70 CAST

Lecture 71 CONVERT

Lecture 72 Assignment - Data Type Conversions

Section 13: Math SQL Functions(16)

Lecture 73 FLOOR and CEILING

Lecture 74 ROUND

Lecture 75 More functions

Lecture 76 Random in SQL

Lecture 77 Assignment - Math SQL Functions

Section 14: Working with NULL

Lecture 78 NULLIF

Lecture 79 ISNULL

Lecture 80 COALESCE

Lecture 81 Assignment - Working with NULL

Section 15: Query Execution

Lecture 82 Execution Sequence

Lecture 83 Execution Sequence Example

Section 16: Subquery in SQL (18)

Lecture 84 Scalar Subquery

Lecture 85 Column Subquery

Lecture 86 Derived Table

Lecture 87 Derived Table and JOIN

Lecture 88 Derived Table and JOIN use case

Lecture 89 Common Table Expression

Lecture 90 Common Table Expression Example

Lecture 91 Assignment - Subquery in SQL

Section 17: Working with Tables and Database(2)

Lecture 92 Create and delete database

Lecture 93 Create table without query

Lecture 94 Delete table without query

Lecture 95 Create and drop table

Lecture 96 Create table and constraints

Lecture 97 Create table with constraints

Lecture 98 Apply constraints

Lecture 99 Constraints in Depth

Lecture 100 Shortcut to generate create statements

Section 18: Insert/Update/Delete records (3)

Lecture 101 Insert statement

Lecture 102 Insert without column names

Lecture 103 Update statement

Lecture 104 Delete statement

Lecture 105 Restore Adventure Works

Section 19: Views (19)

Lecture 106 Create View

Lecture 107 Edit View

Lecture 108 Join and Views

Lecture 109 Delete View

Lecture 110 Assignment - Views

Section 20: User Defined Functions (20)

Lecture 111 Create Scalar valued functions

Lecture 112 Updating and calling Scalar functions

Lecture 113 Inline table valued functions

Lecture 114 Calling table valued functions

Lecture 115 Multi line table valued functions

Lecture 116 Calling multi line table valued functions

Lecture 117 Assignment - User Defined Functions

Section 21: Transactions in SQL

Lecture 118 Transaction Theory

Lecture 119 Transactions Demo

Lecture 120 Check data before update

Lecture 121 Try Catch with transactions

Section 22: Temp Table and Temp Variables (25)

Lecture 122 Schemas

Lecture 123 Table Variables

Lecture 124 Create Temp Table

Lecture 125 Scope of local Temp Table

Lecture 126 Global Temp Table

Lecture 127 Assignment - Temp Table and Temp Variables

Section 23: Stored Procedures (26)

Lecture 128 Variables and PRINT

Lecture 129 IF ELSE

Lecture 130 Create Stored Procedure

Lecture 131 Execute a Stored Procedure

Lecture 132 NOCOUNT

Lecture 133 Assignment - Stored Procedures

Absolute beginners who want to learn SQL from scratch,Developers and software engineers who want to build a strong foundation in database querying,Data analysts and business users looking to move beyond Excel and automate data tasks with SQL,Students and recent graduates preparing for interviews or internships that require SQL knowledge,Anyone working with data who wants to learn how to retrieve, filter, and manipulate data efficiently using SQL Server