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
