Here you will find all you need regarding MS SQL:
During the following Scripts, the following Databases will be used: 1. ACDB 2. hr_script 3. Northwind 4. AdventureWorks 2012 5. AdventureWorks 2014
6. AdventureWorks_2017
SQL Basics:
01 - SELECT-ALIAS-DISTINCT
02 - WHERE - ORDER BY - TOP
03 - SCALAR_FUNCTIONS
04 - GROUP BY - HAVING
05 - JOIN - OUTER JOIN
06 - UNION-EXCEPT-INTERSECT
07 - SUBQUERIES
08 - DML
09 - CASE
DBA Database Design, Tables structure and indexing, T-SQL programming:
01 - DB Creation
02 - User Defined Datatypes
03 - Schemas & Tables
04 - Calculated Column
05 - Constraints
06 - Indexes
06A - Partitions
06B - Indexes & Partitions Exercise
07 - Execution Plan
08 - Variables - If Else - Goto - Loops
09 - Cursors
10 - Dynamic SQL
11 - Ranking Functions
12 - Temp Tables
13 - Table Variables
14 - SubQueris
15 - CTE
16 - Merge
17 - Views (includes views with encryption)
18 - Stored Procedures
19 - TVP - Table Valued Parameters
20 - User Defined Functions
21 - Transaction
22 - Triggers / Detailed link here
23 - Error Handling
23A - Try Catch
24 - XML
Advanced Dynamic SQL Cursors - Solution DDL Additional Demo Divide Sample Merge Solution The 3 and 5 Divide Question The Find_A_Question The One Line Question The Salary Question