CLASS-1-SQL & Database Concepts
SQL & Database Concepts00:55:08
RESOURCE SQL & Database Concepts
CLASS-3-INSERT Command in SQL
INSERT Command in SQL01:52:58
RESOURCE INSERT Command in SQL
CLASS-4-PRIMARY KEY AND Unique Constraint
PRIMARY KEY AND Unique Constraint01:46:54
RESOURCE PRIMARY KEY AND Unique Constraint
CLASS-5-CHECK_CONSTRAINTS AND DEFAULT-CONSTRAINT
CHECK_CONSTRAINTS AND DEFAULT-CONSTRAINT01:48:27
RESOURCE CHECK_CONSTRAINTS AND DEFAULT-CONSTRAINT
CLASS-6-Identity, DROP in SQL Notes AND KEYS
Identity, DROP in SQL Notes AND KEYS01:35:05
RESOURCE Identity, DROP in SQL Notes AND KEYS
CLASS-7-CASE WHEN, DELETE AND UPDATE
CASE WHEN, DELETE AND UPDATE01:50:26
RESOURCE CASE WHEN, DELETE AND UPDATE
CLASS-8-Arithmetic Operators and Logical Operators
Arithmetic Operators and Logical Operators01:21:18
RESOURCE Arithmetic Operators and Logical Operators
CLASS-9-Between Operator , IN and NOT IN AND IS NULL , IS NOT NULL
Between Operator , IN and NOT IN AND IS NULL , IS NOT NULL01:39:02
RESOURCE Between Operator , IN and NOT IN AND IS NULL , IS NOT NULL
CLASS-10-Like Operator and Set Operator
Like Operator and Set Operator02:00:53
RESOURCE Like Operator and Set Operator
CLASS-11-Aggregate Functions , GROUP BY AND HAVING BY
Aggregate Functions , GROUP BY AND HAVING BY01:25:17
RESOURCE Aggregate Functions , GROUP BY AND HAVING BY
CLASS-12-INNER_JOIN , LEFT ANTI JOIN AND LEFT JOIN IN SQL
INNER_JOIN , LEFT ANTI JOIN AND LEFT JOIN IN SQL01:39:06
RESOURCE INNER_JOIN , LEFT ANTI JOIN AND LEFT JOIN IN SQL
CLASS-13-CROSS JOIN,FULL OUTER , RIGHT JOIN AND SELF JOIN
CROSS JOIN,FULL OUTER , RIGHT JOIN AND SELF JOIN01:54:58
RESOURCE CROSS JOIN,FULL OUTER , RIGHT JOIN AND SELF JOIN
CLASS-14-DATES IN SQL
DATES IN SQL01:36:36
RESOURCE DATES IN SQL
CLASS-15-DATE FUNCTIONS
DATE FUNCTIONS02:00:02
RESOURCE DATE FUNCTIONS
CLASS-16-SQL Tables and Functions
SQL Tables and Functions01:16:35
RESOURCE SQL Tables and Functions
CLASS-17-DATES
DATES00:20:46
RESOURCE DATES
CLASS-18-SUB QUERY
SUB QUERY02:16:05
RESOURCE SUB QUERY
CLASS-19-SUB QUERY
SUB QUERY01:24:37
RESOURCE SUB QUERY
CLASS-20-Aggregate Window Functions and any_all_exists_not_exists
Aggregate Window Functions and any_all_exists_not_exists01:35:43
RESOURCE Aggregate Window Functions and any_all_exists_not_exists
CLASS-21-lead_lag_first_value_AND SQL Ranking Functions
lead_lag_first_value_AND SQL Ranking Functions01:43:57
RESOURCE lead_lag_first_value_AND SQL Ranking Functions
CLASS-22-Frame in SSMS
Frame in SSMS01:41:46
RESOURCE Frame in SSMS
CLASS-23-CTE IN SQL
CTE IN SQL02:20:08
RESOURCE CTE IN SQL
CLASS-24-NULL HANDLING , PIVOT AND VIEWS
NULL HANDLING , PIVOT AND VIEWS01:42:26
RESOURCE NULL HANDLING , PIVOT AND VIEWS
CLASS-25-TRIGGER
TRIGGER01:56:03
RESOURCES-TRIGGER
CLASS-26-TRIGGER & INDEX
TRIGGER01:40:09
RESOURCES-TRIGGER
