CLASS-2-HOW TO INSTALL SQL SERVER
HOW TO INSTALL SQL SERVER01:15:14
CLASS-3-DATA TYPE ,DATABASE AND CREATE TABLE
DATA TYPE ,DATABASE AND CREATE TABLE00:44:22
RESOURCE DATA TYPE ,DATABASE AND CREATE TABLE
CLASS-4-CREATE TABLE
CREATE TABLE01:14:32
RESOURCE CREATE TABLE
CLASS-5-INSERT INTRO
INSERT INTRO01:04:01
RESOURCE INSERT INTRO
CLASS-6-INSERT Statement
INSERT Statement01:06:10
RESOURCE INSERT Statement
CLASS-7-PRIMARY KEY
PRIMARY KEY01:10:44
RESOURCE PRIMARY KEY
CLASS-9-CREATE TABLE
CREATE TABLE00:58:55
RESOURCES-CREATE TABLE
CLASS-17-DEFAULT, and CHECK Constraints in SSMS
DEFAULT, and CHECK Constraints in SSMS00:47:26
RESOURCE DEFAULT, and CHECK Constraints in SSMS
CLASS-18-HAVING and ORDER BY in SQL
HAVING and ORDER BY in SQL00:56:25
RESOURCE HAVING and ORDER BY in SQL
CLASS-19-Set Operators in SSMS
Set Operators in SSMS01:03:26
RESOURCE Set Operators in SSMS
CLASS-20-INNER JOIN
INNER JOIN00:55:18
RESOURCE INNER JOIN
CLASS-21-LEFT JOIN
LEFT JOIN00:51:29
RESOURCE LEFT JOIN
CLASS-22-OUTER JOIN ANTI JOIN
OUTER JOIN ANTI JOIN00:44:28
RESOURCE OUTER JOIN ANTI JOIN
CLASS-23-SELF JOIN IN SQL
SELF JOIN IN SQL01:05:34
RESOURCE SELF JOIN IN SQL
CLASS-24-DATE FUNCTION
DATE FUNCTION00:47:14
RESOURCE DATE FUNCTION
CLASS-25-ORDER DATE
ORDER DATE00:46:38
RESOURCE ORDER DATE
CLASS-26-SQL Subquery
SQL Subquery00:59:34
RESOURCE SQL Subquery
CLASS-27-SQL Subquery 2
SQL Subquery 200:49:56
RESOURCE SQL Subquery 2
CLASS-28-SQL QUESTIONS
SQL QUESTIONS00:29:02
RESOURCE SQL QUESTIONS
CLASS-29-CTE in SSMS Basics
CTE in SSMS Basics00:53:43
RESOURCE CTE in SSMS Basics
class-30-Recursive CTE in SSMS
Recursive CTE in SSMS00:42:32
resource Recursive CTE in SSMS
class-31-Agg Window Functions
Agg Window Functions00:37:22
resource Agg Window Functions
CLASS-32-RANKING WINDOW FUNCTION
RANKING WINDOW FUNCTION00:52:03
RESOURCE RANKING WINDOW FUNCTION
CLASS-33-Lead Lag SQL Notes
Lead Lag SQL Notes00:27:51
RESOURCE Lead Lag SQL Notes
CLASS-34-WINDOW FUNCTION
WINDOW FUNCTION00:52:40
RESOURCE WINDOW FUNCTION
CLASS-36-SELECT
SELECT00:56:27
RESOURCE SELECT
CLASS-37-FLIGHT PROJECT
FLIGHT PROJECT00:44:51
RESOURCE FLIGHT PROJECT
CLASS-38-CREATE TABLE
CREATE TABLE00:48:05
RESOURCE CREATE TABLE
CLASS-40-ferrari_class
ferrari_class00:06:32
RESOURCE ferrari_class
CLASS-41-MASTER DATA
MASTER DATA00:57:02
RESOURCE MASTER DATA
