CAREER TALK & SQL SERVER INTRO
CLASS-1-SQL SERVER INTRO & SELECT QUERY
SQL SERVER-100:00:00
RESOURCES-SQL SERVER-1
CLASS-2-SQL STATEMENT
SQL STATEMENT02:14:47
RESOURCES-CLASS-2
CLASS-3-DML
DML00:00:00
RESOURCES-DML
CLASS-4-OPERATOR
OPERATOR00:00:00
RESOURCES-OPERATOR
CLASS-5-Operator-Subquery
Subquery02:00:52
Resources_SQL5
CLASS-6-SUB QUERY
SUB QUERY01:59:46
RESOURCE SUB QUERY
CLASS-8-STRING FUNCTIONS
STRING FUNCTIONS01:51:46
RESOURCE-STRING FUNCTIONS00:00:00
CLASS-9-DATE FUNCTIONS
DATE FUNCTIONS01:54:04
RESOURCE DATE FUNCTIONS
CLASS-10-JOINS
JOINS01:55:09
RESOURCE – JOINS
CLASS-11-ASSESSMENT
ASSESSSMENT01:41:51
RESOURCE ASSESSMENT
CLASS-12-WINDOW FUNCTIONS
WINDOW FUNCTIONS01:55:06
RESOURCE WINDOW FUNCTION
CLASS-13-Agg_window function, Ranking window function
Agg_window function, Ranking window function01:42:09
RESOURCE Agg_window function, Ranking window function
CLASS-14-LEAD AND LAG
LEAD AND LAG00:57:26
RESOURCE LEAD AND LAG
CLASS-15-LAST_VALUE, FIRST_VALUE, NTH_VALUE, COALESCE, ISNULL
LAST_VALUE, FIRST_VALUE, NTH_VALUE, COALESCE, ISNULL01:45:58
RESOURCE LAST_VALUE, FIRST_VALUE, NTH_VALUE, COALESCE, ISNULL
CLASS-16-DOUBTS SOLVING
DOUBTS SOLVING00:42:19
RESOURCE DOUBTS SOLVING
CLASS-17-FLIGHT PROJECT
FLIGHT PROJECT01:50:11
RESOURCE FLIGHT PROJECT
CLASS-18-PIVOT AND VIEW
PIVOT AND VIEW01:54:34
RESOURCE PIVOT AND VIEW
CLASS-19-PROCEDURES
PROCEDURES00:25:49
RESOURCE PROCEDURES