SQL Server
SQL Server tutorial for beginners
Free SQL Server course, 91 video lessons by kudvenkat.
91 Lesson
19 hr 6 min
15 Enrolled
Certificate: Yes
Intro Course content
91 Lesson · 19 hr 6 min
01
Connecting to SQL Server using SSMS - Part 1
09:41
02
Creating altering and dropping a database - Part 2
15:17
03
Creating and working with tables - Part 3
20:08
04
Adding a default constraint - Part 4
10:34
05
Cascading referential integrity constraint - Part 5
08:20
06
Adding a check constraint - Part 6
11:39
07
Identity Column in SQL Server - Part 7
15:12
08
How to get the last generated identity column value in SQL Server - Part 8
12:50
09
Unique key constraint - Part 9
08:12
10
Select statement in sql server - Part 10
21:54
11
Group by in sql server - Part 11
17:44
12
Joins in sql server - Part 12
17:43
13
Advanced or intelligent joins in sql server - Part 13
12:02
14
Self join in sql server - Part 14
11:19
15
Different ways to replace NULL in sql server - Part 15
11:42
16
Coalesce function in sql server Part 16
04:28
17
Union and union all in sql server Part 17
12:41
18
Stored procedures in sql server Part 18
20:11
19
Stored procedures with output parameters Part 19
18:20
20
Stored procedure output parameters or return values Part 20
16:45
21
Advantages of stored procedures Part 21
11:10
22
Built in string functions in sql server 2008 Part 22
16:14
23
LEFT RIGHT CHARINDEX and SUBSTRING functions in sql server Part 23
14:57
24
Replicate Space Patindex Replace and Stuff string functions in sql server 2008 Part 24
11:52
25
DateTime functions in SQL Server Part 25
15:26
26
IsDate Day Month Year and DateName DateTime functions in SQL Server Part 26
12:51
27
DatePart DateAdd and DateDiff functions in SQL Server Part 27
21:29
28
Cast and Convert functions in SQL Server Part 28
17:26
29
Mathematical functions in sql server Part 29
15:51
30
Scalar user defined functions in sql server Part 30
19:07
31
Inline table valued functions in sql server Part 31
11:25
32
Multi statement table valued functions in sql server Part 32
14:07
33
Important concepts related to functions in sql server Part 33
16:34
34
Temporary tables in SQL Server Part 34
15:17
35
Indexes in sql server Part 35
11:14
36
Clustered and nonclustered indexes in sql server Part 36
16:49
37
Unique and Non Unique Indexes in sql server Part 37
11:02
38
Advantages and disadvantages of indexes in sql server Part 38
12:20
39
Views in sql server Part 39
14:51
40
Updatable views in sql server Part 40
11:38
41
Indexed views in sql server Part 41
13:40
42
View limitations in sql server Part 42
10:02
43
DML triggers in sql server Part 43
17:45
44
After update trigger Part 44
17:19
45
Instead of insert trigger Part 45
15:05
46
Instead of update triggers in sql server - Part 46.avi
22:27
47
Instead of delete triggers in sql server - Part 47.avi
10:03
48
Derived tables and common table expressions in sql server Part 48
17:53
49
CTE in sql server Part 49
12:57
50
Updatable common table expressions in sql server Part 50
15:02
51
Recursive CTE in sql server Part 51
12:22
52
Database normalization Part 52
12:11
53
Second normal form and third normal form Part 53
13:16
54
Pivot in sql server 2008 Part 54
12:25
55
Error handling in sql server 2000 Part 55
24:04
56
Error handling in sql server Part 56
17:47
57
Transactions in sql server Part 57
11:18
58
Transactions in sql server and ACID Tests Part 58
09:50
59
Subqueries in sql Part 59
14:34
60
Correlated subquery in sql Part 60
07:59
61
Creating a large table with random data for performance testing Part 61
17:18
62
What to choose for performance SubQuery or Joins Part 62
12:26
63
Cursors in sql server Part 63
13:58
64
Replacing cursors using joins in sql server Part 64
10:24
65
List all tables in a sql server database using a query Part 65
05:38
66
Writing re runnable sql server scripts Part 66
10:37
67
Alter database table columns without dropping table Part 67
04:06
68
Optional parameters in sql server stored procedures Part 68
27:52
69
Part 69 Merge in SQL Server
07:14
70
sql server concurrent transactions
07:34
71
sql server dirty read example
08:50
72
sql server lost update problem
08:29
73
Non repeatable read example in sql server
05:45
74
Phantom reads example in sql server
06:38
75
Snapshot isolation level in sql server
09:16
76
Read committed snapshot isolation level in sql server
06:58
77
Difference between snapshot isolation and read committed snapshot
12:41
78
SQL Server deadlock example
05:14
79
SQL Server deadlock victim selection
07:50
80
Logging deadlocks in sql server
04:25
81
SQL Server deadlock analysis and prevention
08:58
82
Capturing deadlocks in sql profiler
10:21
83
SQL Server deadlock error handling
05:00
84
Handling deadlocks in ado net
10:27
85
Retry logic for deadlock exceptions
26:00
86
How to find blocking queries in sql server
07:35
87
SQL Server except operator
05:14
88
Difference between except and not in sql server
04:41
89
Intersect operator in sql server
05:29
90
Difference between union intersect and except in sql server
03:50
91
Cross apply and outer apply in sql server
08:16
