CLASS-1-SQL SERVER INSTALLATION
SQL SERVER INSTALLATION01:57:58
CLASS-2-SQL INTRODUCTION
SQL INTRODUCTION02:07:01
RESOURCE SQL INTRODUCTION
CLASS-3- CREATE COMMAND
CREATE COMMAND01:54:18
RESOURCE CREATE COMMAND
CLASS-4-PRIMARY KEY , DEFAULT
PRIMARY KEY , DEFAULT01:54:04
RESOURCE PRIMARY KEY , DEFAULT
CLASS-5-FOREIGN KEY , CHECK CONSTRAINT
FOREIGN KEY , CHECK CONSTRAINT02:01:44
RSEOURCE FOREIGN KEY , CHECK CONSTRAINT
CLASS-6-DROP, DELETE, TRUNCATE ,ALTER
Drop_Delete_Truncate _Alter01:59:36
RESOURCE Drop_Delete_Truncate _Alter
CLASS-7-ALTER_INDENTIY COLUMN_UPDATE
ALTER_INDENTIY COLUMN_UPDATE01:42:53
RESOURCE ALTER_INDENTIY COLUMN_UPDATE
CLASS-8-MERGE AND COMMIT
MERGE AND COMMIT01:40:20
RESOURCE MERGE AND COMMIT
CLASS-9-COMMIT, ROLLBACK, SAVE POINT, ARITHMETIC, LOGICAL, COMPARISON
COMMIT, ROLLBACK, SAVE POINT, ARITHMETIC, LOGICAL, COMPARISON01:50:45
RESOURCE COMMIT, ROLLBACK, SAVE POINT, ARITHMETIC, LOGICAL, COMPARISON
CLASS-10-IN, BETWEEN, NULL, LIKE, NOT, GROUP, HAVING
IN, BETWEEN, NULL, LIKE, NOT, GROUP, HAVING01:47:06
RESOURCE IN, BETWEEN, NULL, LIKE, NOT, GROUP, HAVING00:00:00
CLASS-11-GROUP AND HAVING
GROUP AND HAVING02:10:51
RESOURCE GROUP AND HAVING
CLASS-12-DISTINCT, GROUP HAVING AND UNION
DISTINCT, GROUP HAVING AND UNION01:15:37
RESOURCE DISTINCT, GROUP HAVING AND UNION
CLASS-13-INTERSECT EXCEPT AND SELF JOIN
INTERSECT EXCEPT AND SELF JOIN01:50:54
RESOURCE INTERSECT EXCEPT AND SELF JOIN
CLASS-14-FULL OUTER JOIN AND LEFT JOIN
FULL OUTER JOIN AND LEFT JOIN01:56:27
RESOURCE FULL OUTER JOIN AND LEFT JOIN
CLASS-15-CROSS JOIN AND SELF JOIN
CROSS JOIN AND SELF JOIN01:26:19
RESOURCE CROSS JOIN AND SELF JOIN00:00:00
CLASS-16-SUBQUERY
SUBQUERY01:42:41
RESOURCE SUBQUERY
CLASS-17-STRING AND SUBQUERY
STRING AND SUBQUERY01:36:31
RESOURCE STRING AND SUBQUERY
CLASS-18-DATE FUNCTION
DATE FUNCTION01:32:17
RESOURCE DATE FUNCTION
CLASS-19-STRING FUNCTION
STRING FUNCTION01:33:16
RESOURCE STRING FUNCTION
CLASS-20-SUBQUERY
SUBQUERY01:28:14
RESOURCE SUBQUERY
CLASS-21-Exists_correalted_subquer
Exists_correalted_subquer01:21:37
RESOURCE-Exists_correalted_subquer
CLASS-22-WINDOW FUNCTION
WINDOW FUNCTION01:24:60
RESOURCE WINDOW FUNCTION
CLASS-23-FRAME
FRAME01:25:50
RESOURCE FRAME
CLASS-24-RANKING WINDOW FUNCTION
RANKING WINDOW FUNCTION01:59:43
RESOURCE RANKING WINDOW FUNCTION
CLASS-25-LEAD_LAG_FIRST_LAST_VALUE
LEAD_LAG_FIRST_LAST_VALUE01:46:16
RESOURCE-LEAD_LAG_FIRST_LAST_VALUE
CLASS-27-CAST and CONVERT in SQL
CAST and CONVERT in SQL00:29:21
RESOURCE CAST and CONVERT in SQL
CLASS-28-Isnull_Coalesce in SQL , Pivot in SQL and RECURSIVE CTE in SQL
Isnull_Coalesce in SQL , Pivot in SQL and RECURSIVE CTE in SQL01:39:21
RESOURCE Isnull_Coalesce in SQL , Pivot in SQL and RECURSIVE CTE in SQL
CLASS-29-VIEW IN SQL
VIEW IN SQL01:23:46
RESOURCE VIEW IN SQL
CLASS-30-PROCEDURES
PROCEDURES01:31:41
RESOURCE PROCEDURES
CLASS-31-FUNCTION IN SQL SERVER
FUNCTION IN SQL SERVER01:31:00
RESOURCE FUNCTION IN SQL SERVER
CLASS-32-TRIGGERS
TRIGGERS01:16:12
RESOURCE TRIGGERS
CLASS-33-FLIGHT_PROJECT
FLIGHT_PROJECT01:15:21
RESOURCE FLIGHT_PROJECT
