Table of Content 1 CHAPTERS

CHAPTER 1 SQL Server Administration: Basic Tutorials

All Exams > Database Management > SQL Server Administration: Basic Tutorials > All Videos

Video Lectures of SQL Server Administration: Basic Tutorials for Database Management Exam

Free Video Lectures for SQL Server Administration and Database Management

Learning SQL Server administration through structured video lectures gives you a significant edge when preparing for the Database Management exam. These tutorials walk you through everything from creating and altering databases to writing complex queries, all explained with clear visual demonstrations. Whether you're a beginner or brushing up on advanced concepts, watching expert-led lessons helps you grasp the logic behind each operation far more intuitively than reading alone. The course covers a comprehensive range of topics, making these videos an ideal starting point for your exam preparation.

SQL Server Administration: Basic Tutorials

Creating altering and dropping a database - Part 2

15:17 min

Creating and working with tables - Part 3

20:08 min

Adding a default constraint - Part 4

10:34 min

Cascading referential integrity constraint - Part 5

08:20 min

Adding a check constraint - Part 6

11:39 min

Identity Column in SQL Server - Part 7

15:12 min

How to get the last generated identity column value in SQL Server - Part 8

12:50 min

Unique key constraint - Part 9

08:12 min

Select statement in sql server - Part 10

21:54 min

Group by in sql server - Part 11

17:44 min

Joins in sql server - Part 12

17:43 min

Advanced or intelligent joins in sql server - Part 13

12:02 min

Self join in sql server - Part 14

11:19 min

Different ways to replace NULL in sql server - Part 15

11:42 min

Coalesce function in sql server Part 16

04:28 min

Union and union all in sql server Part 17

12:41 min

Stored procedures in sql server Part 18

20:11 min

Stored procedures with output parameters Part 19

18:20 min

Stored procedure output parameters or return values Part 20

16:45 min

Advantages of stored procedures Part 21

11:10 min

Built in string functions in sql server 2008 Part 22

16:14 min

LEFT; RIGHT; CHARINDEX and SUBSTRING functions in sql server Part 23

14:57 min

Replicate; Space; Patindex; Replace and Stuff string functions in sql server 2008 Part 24

11:52 min

DateTime functions in SQL Server Part 25

15:26 min

IsDate; Day; Month; Year and DateName DateTime functions in SQL Server Part 26

12:51 min

DatePart; DateAdd and DateDiff functions in SQL Server Part 27

21:29 min

Cast and Convert functions in SQL Server Part 28

17:26 min

Mathematical functions in sql server Part 29

15:51 min

Scalar user defined functions in sql server Part 30

19:07 min

Inline table valued functions in sql server Part 31

11:25 min

Multi statement table valued functions in sql server Part 32

14:07 min

Important concepts related to functions in sql server Part 33

16:34 min

Temporary tables in SQL Server Part 34

15:17 min

Indexes in sql server Part 35

11:14 min

Clustered and nonclustered indexes in sql server Part 36

16:49 min

Unique and Non Unique Indexes in sql server Part 37

11:02 min

Advantages and disadvantages of indexes in sql server Part 38

12:20 min

Views in sql server Part 39

14:51 min

Updatable views in sql server Part 40

11:38 min

Indexed views in sql server Part 41

13:40 min

View limitations in sql server Part 42

10:02 min

DML triggers in sql server Part 43

17:45 min

After update trigger Part 44

17:19 min

Instead of insert trigger Part 45

15:05 min

Instead of update triggers in sql server - Part 46.avi

22:27 min

Instead of delete triggers in sql server - Part 47.avi

10:03 min

Derived tables and common table expressions in sql server Part 48

17:53 min

CTE in sql server Part 49

12:57 min

Updatable common table expressions in sql server Part 50

15:02 min

Recursive CTE in sql server Part 51

12:22 min

Database normalization Part 52

12:11 min

Second normal form and third normal form Part 53

13:16 min

Pivot in sql server 2008 Part 54

12:25 min

Error handling in sql server 2000 Part 55

24:04 min

Error handling in sql server Part 56

17:47 min

Transactions in sql server Part 57

11:18 min

Transactions in sql server and ACID Tests Part 58

09:50 min

Subqueries in sql Part 59

14:34 min

Correlated subquery in sql Part 60

07:59 min

Creating a large table with random data for performance testing Part 61

17:18 min

What to choose for performance SubQuery or Joins Part 62

12:26 min

Cursors in sql server Part 63

13:58 min

Replacing cursors using joins in sql server Part 64

10:24 min

List all tables in a sql server database using a query Part 65

05:38 min

Writing re runnable sql server scripts Part 66

10:37 min

Alter database table columns without dropping table Part 67

04:06 min

Optional parameters in sql server stored procedures Part 68

27:52 min

Part 69 Merge in SQL Server

07:14 min

SQL server concurrent transactions

07:34 min

SQL server dirty read example

08:50 min

SQL server lost update problem

08:29 min

Non repeatable read example in sql server

05:45 min

Phantom reads example in sql server

06:38 min

Snapshot isolation level in sql server

09:16 min

Read committed snapshot isolation level in sql server

06:58 min

Difference between snapshot isolation and read committed snapshot

12:41 min

SQL Server deadlock example

05:14 min

SQL Server deadlock victim selection

07:50 min

Logging deadlocks in sql server

04:25 min

SQL Server deadlock analysis and prevention

08:58 min

Capturing deadlocks in sql profiler

10:21 min

SQL Server deadlock error handling

05:00 min

Handling deadlocks in ado net

10:27 min

Retry logic for deadlock exceptions

26:00 min

How to find blocking queries in sql server

07:35 min

SQL Server except operator

05:14 min

Difference between except and not in sql server

04:41 min

Intersect operator in sql server

05:29 min

Difference between union intersect and except in sql server

03:50 min

Cross apply and outer apply in sql server

08:16 min

DDL Triggers in sql server

12:31 min

Server scoped ddl triggers

05:58 min

SQL server trigger execution order

06:43 min

Audit table changes in sql server

06:45 min

Logon Triggers in SQL Server

08:56 min

Select into in sql server

11:55 min

Difference between where and having in sql server

06:36 min

Table valued parameters in SQL Server

06:46 min

Send datatable as parameter to stored procedure

09:27 min

Grouping Sets in SQL Server

09:36 min

Rollup in SQL Server

09:01 min

Cube in SQL Server

07:42 min

Difference between cube and rollup in SQL Server

05:38 min

Grouping function in SQL Server

12:49 min

GROUPING ID function in SQL Server

12:38 min

Debugging sql server stored procedures

15:11 min

Over clause in SQL Server

09:13 min

Row Number function in SQL Server

07:24 min

Rank and Dense Rank in SQL Server

10:08 min

Difference between rank dense rank and row number in SQL

04:43 min

Calculate running total in SQL Server 2012

06:23 min

NTILE function in SQL Server

05:10 min

Lead and Lag functions in SQL Server 2012

07:27 min

FIRST VALUE function in SQL Server

02:48 min

Window functions in SQL Server

11:00 min

Difference between rows and range

05:52 min

LAST VALUE function in SQL Server

05:35 min

UNPIVOT in SQL Server

04:33 min

Reverse PIVOT table in SQL Server

08:16 min

Choose function in SQL Server

05:32 min

IIF function in SQL Server

04:00 min

TRY PARSE function in SQL Server 2012

07:34 min

TRY CONVERT function in SQL Server 2012

07:46 min

EOMONTH function in SQL Server 2012

05:46 min

DATEFROMPARTS function in SQL Server

03:54 min

Difference between DateTime and SmallDateTime in SQL Server

08:45 min

DateTime2FromParts function in SQL Server 2012

05:28 min

Difference between DateTime and DateTime2 in SQL Server

10:42 min

Offset fetch next in SQL Server 2012

09:04 min

Identifying object dependencies in SQL Server

05:50 min

sys dm sql referencing entities in SQL Server

08:05 min

sp depends in SQL Server

05:09 min

Sequence object in SQL Server 2012

12:22 min

Difference between sequence and identity in SQL Server

05:29 min

Guid in SQL Server

09:29 min

How to check GUID is null or empty in SQL Server

06:39 min

Dynamic SQL in SQL Server

12:12 min

Implement search web page using ASP NET and Stored Procedure

10:54 min

Implement search web page using ASP NET and Dynamic SQL

10:20 min

Prevent sql injection with dynamic sql

10:28 min

Dynamic SQL in Stored Procedure

09:32 min

Sql server query plan cache

14:20 min

Exec vs sp executesql in sql server

09:16 min

Dynamic sql table name variable

11:59 min

Quotename function in SQL Server

10:28 min

Dynamic SQL vs Stored Procedure

06:02 min

Dynamic sql output parameter

05:25 min

Temp tables in dynamic sql

04:36 min

Join for Free

SQL Server Administration: Basic Tutorials

148 videos

Top Courses Database Management

Explore Courses

Video lectures for SQL Server Administration: Basic Tutorials 2026 is part of Database Management exam preparation. The videos have been prepared according to the Database Management exam syllabus. The Video lectures, notes, tests & MCQs are made for Database Management 2026 Exam. Find important definitions, questions, notes, meanings, examples, exercises, MCQs and online tests here.

Video lectures of SQL Server Administration: Basic Tutorials in English & Hindi are available as part of Database Management exam. Download more important topics, notes, lectures and mock test series for Database Management Exam by signing up for free.