SQL Server
-
01 SQL Server - Intro to DBMS (78:24)
-
02 SQL Server - DB Architecture Part1 (58:27)
-
03 SQL Server - DB Architecture Part2 (58:43)
-
04 SQL Server - Data Types Part1 (64:56)
-
05 SQL Server - Data Types Part2 (64:46)
-
06 SQL Server - Business Integrity Part1 (47:35)
-
07 SQL Server - Keys (53:39)
-
08 SQL Server - Relationships (79:48)
-
09 SQL Server - FKs, Cascade Features, Check Constraints, Identity (52:44)
-
10 SQL Server - SQL Commands Part1 (60:06)
-
11 SQL Server - SQL Commands Part2 and Transactions (54:33)
-
12 SQL Server - SQL Commands Part3 (61:56)
-
13 SQL Server - Identity and Delete Vs Truncate (57:44)
-
14 SQL Server - School Case Study (65:01)
-
15 SQL Server - Supplier and Indian Bank Case Study (54:48)
-
16 SQL Server - Indian Bank Case Study (54:21)
-
17 SQL Server - Basic Queries (60:08)
-
18 SQL Server - Aggregate Functions in Queries (43:23)
-
19 SQL Server - Group By Clause Queries (56:12)
-
20 SQL Server - Group in a Group and Distinct Queries (55:52)
-
21 SQL Server - Date and Time Functions Part1 (53:30)
-
22 SQL Server - Date and Time Functions Part2 (36:08)
-
23 SQL Server - Having Clause and Into Keyword and Temp Tables (70:55)
-
24 SQL Server - Inner and Outer Join (69:28)
-
25 SQL Server - Cross Join (56:07)
-
26 SQL Server - Self Join, ISNULL and Coaleasce Functions (58:11)
-
27 SQL Server - String Functions (69:56)
-
28 SQL Server - String_Agg, Between and Case Statement (47:33)
-
29 SQL Server - Between and Case Statement and Sub Queries (58:25)
-
30 SQL Server - Correlated Sub Queries (66:50)
-
31 SQL Server - System Tables (52:27)
-
32 SQL Server - Derived Tables and Interview Qns on Get New Customers (62:08)
-
33 SQL Server - Interview Qns and Cube and Rollup Operators (50:06)
-
34 SQL Server - Ranking Functions and CTE (58:09)
-
35 SQL Server - Derived Tables Vs CTE vs Temp Tables (67:08)
-
36 SQL Server - Incr Loadin with Merge Statement (53:22)
-
Data Types
-
DB Arch
-
hghhg
-
INDIAN BANK CASE STUDY
-
SCHOOL CASE STUDY
-
Supplier CASE STUDY
