Autoplay
Autocomplete
Previous Lesson
Complete and Continue
MS SQL Tutorial - Basic to Advanced
Important
Special Note
Preview Videos of SQL Tutorial
Demo #1: SQL RIGHT OUTER JOIN (2:16)
Demo #2: SQL CROSS JOIN (3:09)
Demo #3: Query Optimization (Basic) (7:18)
Demo #4: A Quick Introduction to SQL Server Management Studio (2:21)
Download Working files
SQL Files
Introduction to SQL
0101 What is SQL - Structured Query Language? (0:50)
0102 Why should we learn SQL? (1:37)
SQL Quiz #1
An Overview of SQL
0201 What is DBMS and RDBMS? (1:09)
SQL Quiz #2.0
0202 Data Definition Language DDL and Data Manipulation Language DML (1:26)
SQL Quiz #2.1
Setup a Testing Environment
0301 Downloading Microsoft SQL Server (1:43)
0302 Instaliing microsoft SQL Server 1 and 2 (4:58)
0303 Installing AdventureWorks Database (4:22)
0304 A Quick Introduction to SQL Server Management Studio (2:21)
Important SQL Clauses (DML)
0401 Create example databases tables and data rows 1 (7:06)
0402 Create example databases tables and data rows 2 (7:15)
0403 Learn about SQL FROM Clause (2:32)
SQL Quiz #4.0
0404 SQL SELECT DISTINCT Statement (3:13)
0405 Learn about SQL WHERE Clause (2:30)
SQL Quiz #4.1
SQL Tutorial Feedback
Conditions and Operators (DML)
0501 SQL AND Operator (1:45)
0502 SQL OR Operator (2:06)
0503 SQL IN Operator (3:12)
SQL Quiz # 5.0
0504 SQL EXISTS Condition (3:11)
0505 SQL NOT IN or NOT EXISTS Conditions (3:30)
SQL Quiz #5.1
0506 SQL Comparison Operators (2:50)
0507 SQL LIKE Operator (4:08)
SQL Quiz # 5.2
0508 SQL BETWEEN Operator (4:09)
SQL Quiz # 5.3
Data grouping, sorting, select and dates (DML)
0601 Learn about SQL ORDER BY Clause (3:43)
0602 Learn about SQL GROUP BY Clause 1 (4:13)
0603 Learn about SQL GROUP BY Clause 2 (3:24)
0604 Learn about SQL HAVING Clause (3:05)
0605 SQL LIMIT or TOP Clause (2:46)
SQL Quiz # 6.0
0606 SQL Aliases (2:13)
SQL Quiz # 6.1
0607 SQL Wildcards (3:52)
SQL Quiz # 6.2
0608 SQL Dates (5:26)
SQL Quiz # 6.3
Conditions and Operators (DML)
0701 SQL Numeric Operators (2:39)
0702 SQL Concatenation Operator (2:59)
SQL Quiz # 7
Insert, Read, Update, Delete the Data Rows (DML)
0801 SQL INSERT INTO SELECT Statement (8:09)
SQL Quiz # 8.0
0802 Update data rows using UPDATE Statement (6:32)
SQL Quiz # 8.1
0803 Delete data rows using DELETE Statement (3:19)
SQL Quiz # 8.2
SQL Tutorial Feedback
SQL JOINS (DML)
0901 What are JOINS in SQL Types of SQL JOINS? (1:08)
0902 SQL INNER JOIN (3:45)
SQL Quiz # 9.0
SQL Quiz # 9.1
0903 SQL LEFT OUTER JOIN (3:45)
0904 SQL RIGHT OUTER JOIN (2:16)
SQL Quiz # 9.2
0905 SQL FULL OUTER JOIN (2:50)
0906 SQL CROSS JOIN (3:09)
0907 SQL Join with Condition (5:14)
0908 SQL UNION Operator (3:25)
SQL Quiz # 9.3
0909 SQL UNION ALL Syntax (1:27)
SQL Quiz # 9.4
0910 SQL Case (2:44)
0911 Nested Case (5:14)
0912 SQL VIEWS (8:42)
SQL Quiz # 9.5
SQL Functions
1001 Functions in SQL and Types of SQL functions (5:55)
1002 INLINE TABLE VALUED FUNCTION (5:46)
1003 SQL COUNT() Function (5:14)
1004 SQL SUM() Function (2:49)
1005 SQL MIN() Function (2:25)
1006 SQL MAX() Function (2:18)
1007 SQL AVG() Function (2:42)
1008 SQL LEN() Function (2:40)
1009 SQL UCASE() Function (1:34)
1010 SQL LCASE() Function (1:25)
1011 SQL ROUND() Function (2:47)
SQL Quiz # 10.0
1012 SQL FORMAT() Function (3:50)
1013 SQL CAST() Function (3:26)
1014 SQL NULLIF Function (2:24)
SQL Quiz #10.1
SQL Data Types
1101 What is data type in SQL? (2:05)
1102 Integer Numbers in SQL (Exact Values) (3:51)
1103 Fixed Point Numbers in SQL (Exact Values) (3:51)
SQL Quiz #11
DDL
1201 CREATE DATABASE Learn how to create and display databases (6:38)
1202 USE statement Select and use existing database (1:26)
1203 DROP DATABASE Remove or delete database from database management system (3:39)
1204 CREATE TABLE (2:44)
1205 Temp table (4:12)
SQL Quiz# 12.0
1206 ALTER TABLE statement Modify or update the database table details (4:34)
SQL Quiz # 12.1
1208 DROP TABLE Remove or delete an existing table (1:07)
1207 TRUNCATE TABLE Statement (3:44)
SQL Quiz# 12.2
1209 DROP COLUMN Example (1:55)
1210 Understand Constraints in SQL (1:10)
1211 NOT NULL Constraint in SQL (3:39)
1212 UNIQUE Constraint in SQL (2:26)
1213 PRIMARY KEY Constraint in SQL (4:19)
1214 FOREIGN KEY Constraint in SQL (5:37)
1215 CHECK Constraint in SQL (3:37)
SQL Quiz# 12.3
1216 DEFAULT Constraint in SQL (1:44)
1217 AUTO INCREMENT or SEQUENCE in SQL (4:09)
1218 Query Optimization (Basic) (7:18)
1219 Cascading in SQL server (6:52)
1220 Pivot in SQL Server (Basic) (3:53)
SQL Quiz # 12.4
SQL Tutorial Feedback
SQL Quiz #5.1
Complete and Continue