Microsoft Sql - The Complete Guide For Beginners (tsql)
 

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