Microsoft SQL Server Masterclass

Welcome to our Microsoft SQL Server Course.

In this Video Course, learn SQL and its concept. SQL Server is a relational database management system (RDBMS) developed by Microsoft. RDBMS is the basis for SQL and all modern database systems such as Microsoft SQL Server, Oracle, MySQL, and Microsoft Access. We have covered Microsoft SQL Server in this course. The course is for beginners and consists of 38 lessons, and more than 100 live running queries, including creating new databases and tables.

The course begins with SQL Introduction and free versions provided by Microsoft for SQL Server. Then, we have shown how to set up and install it on both Windows 10 and Windows 11. We proceed further with creating a new database and table, to perform various operations on it. With that, we have also covered live-running queries in every lesson.

Note: The flow would be step-by-step and the explanations would include a tutorial-like format, to make it easier for beginners to understand a new database and table and its concepts, with live running queries as examples. We have also created some quizzes to polish your SQL skills.

While learning, you will get an opportunity to work on various hands-on exercises and understand the role of databases in a real-world application.

Course Lessons

Section 1: SQL Introduction

1. SQL Introduction
2. SOL vs NOSOL

Section 2: SQL Installation and Setup

3. Install SOL Server on Windows 11

Section 3: Create and Insert

4. Create a Database
5. Create a Table
6. Insert Records

Section 4: Select Records in SQL

7. SELECT Statement in SOL
8. SELECT DISTINCT Statement in SOL
9. WHERE Clause in SOL

Section 5: Order Records in SQL

10. ORDER BY Keyword in SQL

Section 6: Operators in SQL

11. AND Operator
12. OR Operator
13. NOT Operator
14. IN Operator
15. BETWEEN Operator
16. LIKE Operator

Section 7: Built-in Functions in SQL

17. MAX() Function
18. MIN() Function
19. SUM() Function
20. AVG() Function
21. COUNT() Function

Section 8: Constraints in SQL

22. NOT NULL Constraint
23. UNIQUE Constraint
24. PRIMARY KEY Constraint
25. FOREIGN KEY Constraint
26. CHECK Constraint

Section 9: SQL Commands

27. ASC Command
28. DESC Command

Section 10: Alter and Update in SQL

29. ALTER TABLE Statement
30. UPDATE Statement
31. Aliases

Section 11: Advanced SQL

32. Stored Procedures in SQL
33. Indexes in SOL
34. SELECT INTO Statement in SOL
35. SELECT TOP Clause in SOL
36. Backup a Database in SQL
37. SOL Views
38. Drop a Table in SOL