Autoplay
Autocomplete
Previous Lesson
Complete and Continue
BB SQL Server-English
SQL Server
01 SQL Server - DB Architecture Part1 (58:27)
02 SQL Server - DB Architecture Part2 (58:43)
03 SQL Server - Data Types Part1 (64:55)
04 SQL Server - Data Types Part2 (64:46)
05 SQL Server - Business Integrity Part1 (47:35)
06 SQL Server - Keys (53:39)
07 SQL Server - Relationships (79:48)
08 SQL Server - FKs, Cascade Features, Check Constraints, Identity (52:44)
09 SQL Server - SQL Commands Part1 (60:06)
10 SQL Server - SQL Commands Part2 and Transactions (54:33)
11 SQL Server - SQL Commands Part3 (61:56)
12 SQL Server - Identity and Delete Vs Truncate (57:44)
13 SQL Server - School Case Study (65:01)
14 SQL Server - Supplier and Indian Bank Case Study (54:48)
15 SQL Server - Indian Bank Case Study (54:21)
16 SQL Server - Basic Queries (60:08)
17 SQL Server - Aggregate Functions in Queries (43:23)
18 SQL Server - Group By Clause Queries (56:12)
19 SQL Server - Group in a Group and Distinct Queries (55:52)
20 SQL Server - Date and Time Functions Part1 (53:30)
21 SQL Server - Date and Time Functions Part2 (36:08)
22 SQL Server - Having Clause and Into Keyword and Temp Tables (70:55)
23 SQL Server - Inner and Outer Join (69:28)
24 SQL Server - Cross Join (56:07)
25 SQL Server - Self Join, ISNULL and Coaleasce Functions (58:11)
26 SQL Server - String Functions (69:56)
27 SQL Server - String_Agg, Between and Case Statement (47:33)
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
Date Time Assignments
DB Arch
Emp Exercises
INDIAN BANK CASE STUDY
Joins
Keys and Interview Qns
Keys
SCHOOL CASE STUDY
Supplier CASE STUDY
T-SQL
01 SQL Server - Client Server Architecture (50:43)
02 SQL Server - Views Part1 (46:44)
03 SQL Server - Views Part2 (52:24)
04 SQL Server - Views Part3 (54:52)
05 SQL Server - Views Part4 - Schemas and Indexed Views (72:20)
06 SQL Server - T-SQL Programming - Create Varibles (65:52)
07 SQL Server - T-SQL Programming and Intro to Stored Procedures (49:01)
08 SQL Server - Global Variables and Stored Procedures (72:25)
09 SQL Server - Temp Tables Vs Table Variable and Stored Procedures (69:31)
10 SQL Server - SQL and MSBI Interview Prepartion (42:56)
11 SQL Server - Indexes Part1 (55:52)
12 SQL Server - Indexes Part2 (48:17)
13 SQL Server - Indexes Part3 (53:23)
14 SQL Server - Security and Stored Procedures with Execution Plan Cache (59:30)
15 SQL Server - Complex Stored Procedures - IBank Case Study Part1 (72:28)
16 SQL Server - IBank Case Study Part2 and School SP and Loan Statement Stored Procedures (64:11)
17 SQL Server - Debugging Stored Procedures (12:47)
18 SQL Server - Output Parameters and Exception Handling (68:36)
19 SQL Server - Recompile Stored Procedures (71:04)
20 SQL Server - Types of Stored Procedures (15:21)
21 SQL Server - User Defined Functions Part1 (64:30)
22 SQL Server - User Defined Functions Part2 (58:01)
23 SQL Server - Interview Question (12:24)
24 SQL Server - Triggers Part1 (57:51)
25 SQL Server - Triggers Part2 (70:59)
26 SQL Server - Cursors Part1 (36:33)
27 SQL Server - Cursors Part2 (50:43)
28 SQL Server - Linked Server (57:22)
Case Study for SQL Server
Backup Files-20221202T104802Z-001
SQL Software
SQL Server Software
Job Preparation.
Interview Preparation Material
Resumes
Resumes
How to upload Resume in Naukari Portal
How to upload resume in Naukri portal (27:30)
Imp Files
Emp
Date and Time
INDIAN BANK CASE STUDY
SCHOOL CASE STUDY
Supplier CASE STUDY
Teach online with
12 SQL Server - Identity and Delete Vs Truncate
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock