Course Content
SQL – Introduction
SQL Introduction, features, versions, and SQL vs NoSQL
0/2
SQL Introduction & Versions
02:25
SQL vs NoSQL
00:00
SQL – Installation and Setup
0/1
Install SOL Server on Windows
00:00
SQL – Create and Insert
0/3
Create a Database in SQL
00:00
Create a Table in SQL
00:00
Insert Records in SQL
00:00
SQL – Select Records
0/3
SELECT Statement in SOL
00:00
SELECT DISTINCT Statement in SOL
00:00
WHERE Clause in SOL
00:00
SQL – Order Records
0/1
ORDER BY Keyword in SQL
00:00
SQL – Operators
0/6
AND Operator in SQL
00:00
OR Operator in SQL
00:00
NOT Operator in SQL
00:00
IN Operator in SQL
00:00
Between Operator in SQL
00:00
LIKE Operator in SQL
00:00
SQL – Built-in Functions
0/5
MAX() Function in SQL
00:00
MIN() Function in SQL
00:00
SUM() Function in SQL
00:00
AVG() Function in SQL
00:00
COUNT() Function in SQL
00:00
SQL – Constraints
0/5
NOT NULL Constraint in SQL
00:00
UNIQUE Constraint in SQL
00:00
PRIMARY KEY Constraint in SQL
00:00
FOREIGN KEY Constraint in SQL
00:00
CHECK Constraint in SQL
00:00
SQL – Commands
0/2
ASC Command in SQL
00:00
DESC Command in SQL
00:00
SQL – Alter and Update
0/3
ALTER TABLE Statement in SQL
00:00
UPDATE Statement in SQL
00:00
Aliases in SQL
00:00
SQL – Advanced
0/7
Stored Procedures in SQL
00:00
Indexes in SOL
00:00
SELECT INTO Statement in SOL
00:00
SELECT TOP Clause in SOL
00:00
Backup a Database in SQL
00:00
Views in SQL
00:00
Drop a Table in SOL
00:00
Microsoft SQL Server Masterclass
    About Lesson

    Learn what is SQL and how it is based on RDBMS. We will discuss the features as well as Microsoft SQL Server and SQL Server Management Studio.

    Previous
    Next
    0% Complete