1. Course Introduction and Table of Contents

• Welcome to the Course

2. Database and Database Management Systems FREE CHAPTER

• Introduction to Database and Database Management Systems

3. RDBMS and NonRDBMS

• Introduction to RDBMS and NonRDBMS

4. SQL Commands

• Different Types of SQL Commands

5. Installing Microsoft SQL Server

• Step-by-Step Guide to Installing MS SQL

6. Basic Database Operations

• Types of Databases in SQL Server and Basic Operations
• Essential Database Operations

7. Fundamental Table Operations

• SQL Data Types, Constraints, and Keys
• Creating and Deleting Tables in SQL
• Altering Tables and Viewing Table Schemas in SQL
• Data Manipulation and Table Management in SQL

8. Importing Sample Databases

• Importing the Northwind Database

9. Using Aggregate Functions in MSSQL

• Introduction to Aggregate Functions in MSSQL
• Using MAX, SUM, AVG, and COUNT in MSSQL

10. Clauses in MSSQL

• Distinct and Group By Clauses
• Where Clause and Operators
• Order By, Having, and Select Clauses

11. Grouping Sets Clause

• Using the GROUPING SETS Clause in SQL Server
• Selecting Data with the GROUPING SETS Clause and GROUP BY Clause

12. SQL Basic Operators

• Understanding Comparison and NULL Operators in SQL
• Using the LIKE and EXISTS Operators in SQL

13. Union and Intersect Operators

• Union and Intersect Operators

14. Introduction to Popular Data Types

• Exploring Exact Numeric Data Types in SQL Server
• Understanding Character, Binary, Date, and Time Data Types in SQL Server

15. Popular Datatypes

• Creating and Inserting Data using Popular Data Types

16. Mastering Primary Key Constraints in SQL

• Applying Primary Key Constraints
• Managing Primary Key Constraints

17. Mastering Foreign Key Constraints in SQL

• Creating Foreign Key Constraints
• Managing Foreign Key Constraints

18. NOT NULL and UNIQUE Constraints

• Using the NOT NULL Constraint
• Understanding the UNIQUE Constraint

19. CHECK and DEFAULT Constraints

• Working with CHECK Constraints
• Understanding DEFAULT Constraints

20. ER Diagrams

• ER Diagram Overview - Building Effective Data Models

21. SQL String Functions

• SQL Popular String Functions - Part 1
• SQL Popular String Functions - Part 2

22. SQL Popular Date Functions

• Understanding SQL Server Date Time Functions
• Using Date and Time Functions in SQL

23. SQL Popular Mathematical Functions

• Math Made Easy: SQL Popular Mathematical Functions

24. SQL Popular Convert Functions

• SQL Magic: Popular Convert Functions

25. Joins - Introduction and Table Preparation

• Introduction to Joins and Join Types
• Table Preparation - Creating the Trainee Table
• Table Preparation - Creating the Fee and Semester Tables

26. Inner Join

• Exploring Inner Join

27. Outer Join

• Mastering Outer Joins

28. Self Join

• Exploring Self Join

29. Cross Join

• Mastering Cross Joins

30. Stored Procedure Basics

• Features and Benefits of Stored Procedures
• Creating and Executing Our First Stored Procedure

31. Stored Procedure Parameters and Return

• Stored Procedure Input and Return Parameters

32. SQL Subqueries

• Writing SQL Subqueries

33. SQL Views

• Introduction to SQL Views

34. SQL Triggers - DDL Triggers

• SQL Triggers - DDL Triggers

35. SQL Triggers - DML Trigger

• SQL Triggers DML Trigger - Introduction and AFTER Trigger
• SQL Triggers DML Trigger - INSTEAD OF Trigger and Examples

36. SQL Transactions

• SQL Transactions - Introduction and States
• SQL Transactions - COMMIT and ROLLBACK Operations

37. Normalization

• Introduction to Normalization

38. Database Backup and Restore

• Backup and Restore Database

39. Database Security

• Securing Your Database