1. Introduction
2. SQL Server setting up
3. SQL Database basics
-
1. Section Introduction (1:09)
-
2. Overview of Databases (9:15)
-
3. Creating Database (6:34)
-
4. SQL Data Types (3:47)
-
5. Column Data Types on Workbench (7:23)
-
6. Creating Table (3:44)
-
7. Overview of Primary and Foreign Key (3:29)
-
8. Primary Key (6:08)
-
9. Foreign Key (11:33)
-
10. Creating Temporary tables (12:23)
-
11. EER – Enhanced Entity Relationship Diagrams (4:21)
4. SQL DML (Data Manipulation Language)
5. SQL DDL (Data Definition Language)
6. SQL DCL (Data Control Language)
7. SQL Statement Basic
8. Filtering Data rows
9. Aggregate functions for Data Analysis
10. SQL Data Analytic statements
11. SQL Group by statement
12. JOINS
13. SQL Constraints
15. Advanced SQL Functions
16. SQL Stored procedures
17. Import & Export data
18. Backup and Restore Database
