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-Advanced SQL Join Types (Cross, Full Outer, Right & Self Join)
Advanced SQL Join Types (Cross, Full Outer, Right & Self Join)01:54:58
RESOURCE Advanced SQL Join Types (Cross, Full Outer, Right & Self Join)
CLASS-14-SQL Dates & Date Functions
SQL Dates & Date Functions01:36:36
RESOURCE SQL Dates & Date Functions