Course content

0h09m

Connecting to SQL Server using SSMS - Part 1

In this video we will learn
1. Connecting to SQL Server using SSMS
2. What is SQL Server Management Studio
3. Different authentication methods used to connect to SQL Server

Text version of the video
http://csharp-video-tutorials.blogspot.com/2012/08/connecting-to-sql-server-using-ssms.html

Slides
http://csharp-video-tutorials.blogspot.com/2013/08/part-1-connecting-to-sql-server.html

All SQL Server Text Articles
http://csharp-video-tutorials.blogspot.com/p/free-sql-server-video-tutorials-for.html

All SQL Server Slides
http://csharp-video-tutorials.blogspot.com/p/sql-server.html

All Dot Net and SQL Server Tutorials in English
https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd

All Dot Net and SQL Server Tutorials in Arabic
https://www.youtube.com/c/KudvenkatArabic/playlists

0h15m

Creating altering and dropping a database - Part 2

In this video we will learn
1. Creating, altering and dropping a database
2. Putting a database in single user mode

Text version of the video
http://csharp-video-tutorials.blogspot.co.uk/2012/08/creating-altering-and-dropping-database.html

Slides
http://csharp-video-tutorials.blogspot.com/2013/08/part-2-creating-altering-and-dropping.html

All SQL Server Text Articles
http://csharp-video-tutorials.blogspot.com/p/free-sql-server-video-tutorials-for.html

All SQL Server Slides
http://csharp-video-tutorials.blogspot.com/p/sql-server.html

All Dot Net and SQL Server Tutorials in English
https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd

All Dot Net and SQL Server Tutorials in Arabic
https://www.youtube.com/c/KudvenkatArabic/playlists

0h20m

Creating and working with tables - Part 3

In this video we will learn
1. Creating tables
2. Enforcing primary key and foreign key constraints

Text version of the video
http://csharp-video-tutorials.blogspot.co.uk/2012/08/creating-and-working-with-tables-part-3.html

Slides
http://csharp-video-tutorials.blogspot.com/2013/08/part-3-creating-and-working-with-tables.html

All SQL Server Text Articles
http://csharp-video-tutorials.blogspot.com/p/free-sql-server-video-tutorials-for.html

All SQL Server Slides
http://csharp-video-tutorials.blogspot.com/p/sql-server.html

All Dot Net and SQL Server Tutorials in English
https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd

All Dot Net and SQL Server Tutorials in Arabic
https://www.youtube.com/c/KudvenkatArabic/playlists

0h10m

Adding a default constraint - Part 4

In this video we will learn, how to specify a column default using a default constraint

Text version of the video
http://csharp-video-tutorials.blogspot.com/2012/08/default-constraint-in-sql-server-part-4.html

Slides
http://csharp-video-tutorials.blogspot.com/2013/08/part-4-default-constraint.html

All SQL Server Text Articles
http://csharp-video-tutorials.blogspot.com/p/free-sql-server-video-tutorials-for.html

All SQL Server Slides
http://csharp-video-tutorials.blogspot.com/p/sql-server.html

All Dot Net and SQL Server Tutorials in English
https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd

All Dot Net and SQL Server Tutorials in Arabic
https://www.youtube.com/c/KudvenkatArabic/playlists

0h08m

Cascading referential integrity constraint - Part 5

In this video, we will learn about Cascading referential integrity constraint

Text version of the video
http://csharp-video-tutorials.blogspot.com/2012/08/cascading-referential-integrity.html

Slides
http://csharp-video-tutorials.blogspot.com/2013/08/part-5-cascading-referential-integrity.html

All SQL Server Text Articles
http://csharp-video-tutorials.blogspot.com/p/free-sql-server-video-tutorials-for.html

All SQL Server Slides
http://csharp-video-tutorials.blogspot.com/p/sql-server.html

All Dot Net and SQL Server Tutorials in English
https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd

All Dot Net and SQL Server Tutorials in Arabic
https://www.youtube.com/c/KudvenkatArabic/playlists

0h11m

Adding a check constraint - Part 6

In this video we will learn
1. How to add a check constraint in SQL Server
2. The purpose or use of check constraint

Text version of the video
http://csharp-video-tutorials.blogspot.co.uk/2012/08/check-constraint-in-sql-server-part-6.html

Slides
http://csharp-video-tutorials.blogspot.com/2013/08/part-6-check-constraint.html

All SQL Server Text Articles
http://csharp-video-tutorials.blogspot.com/p/free-sql-server-video-tutorials-for.html

All SQL Server Slides
http://csharp-video-tutorials.blogspot.com/p/sql-server.html

All Dot Net and SQL Server Tutorials in English
https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd

All Dot Net and SQL Server Tutorials in Arabic
https://www.youtube.com/c/KudvenkatArabic/playlists

0h15m

Identity Column in SQL Server - Part 7

In this video we will learn
1. What is Identity column
2. Creating an Identity column
3. Supply explicit values for identity columns using IDENTITY_INSERT
4. Reset identity value using DBCC CHECKIDENT command

Text version of the video
http://csharp-video-tutorials.blogspot.com/2012/08/identity-column-in-sql-server-part-7.html

Slides
http://csharp-video-tutorials.blogspot.com/2013/08/part-7-identity-column.html

All SQL Server Text Articles
http://csharp-video-tutorials.blogspot.com/p/free-sql-server-video-tutorials-for.html

All SQL Server Slides
http://csharp-video-tutorials.blogspot.com/p/sql-server.html

All Dot Net and SQL Server Tutorials in English
https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd

All Dot Net and SQL Server Tutorials in Arabic
https://www.youtube.com/c/KudvenkatArabic/playlists

0h12m

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

In this video we will learn
1. Retrieve the last generated identity column value
2. Difference between SCOPE_IDENTITY(), @@Identity and IDENT_CURRENT('TableName')

Text version of the video
http://csharp-video-tutorials.blogspot.com/2012/08/how-to-get-last-generated-identity.html

Slides
http://csharp-video-tutorials.blogspot.com/2013/08/part-8-retrieving-identity-column-values.html

All SQL Server Text Articles
http://csharp-video-tutorials.blogspot.com/p/free-sql-server-video-tutorials-for.html

All SQL Server Slides
http://csharp-video-tutorials.blogspot.com/p/sql-server.html

All Dot Net and SQL Server Tutorials in English
https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd

All Dot Net and SQL Server Tutorials in Arabic
https://www.youtube.com/c/KudvenkatArabic/playlists

0h08m

Unique key constraint - Part 9

In this video we will learn
1. What is unique key constraint
2. When do you use unique key constraint over primary key constraint
3. Difference between unique key constraint and primary key constraint

Text version of the video
http://csharp-video-tutorials.blogspot.com/2012/08/unique-key-constraint-part-9.html

Slides
http://csharp-video-tutorials.blogspot.com/2013/08/part-9-unique-key-constraint.html

All SQL Server Text Articles
http://csharp-video-tutorials.blogspot.com/p/free-sql-server-video-tutorials-for.html

All SQL Server Slides
http://csharp-video-tutorials.blogspot.com/p/sql-server.html

All Dot Net and SQL Server Tutorials in English
https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd

All Dot Net and SQL Server Tutorials in Arabic
https://www.youtube.com/c/KudvenkatArabic/playlists

0h21m

Select statement in sql server - Part 10

In this video we will learn
1. Select specific or all columns
2. Distinct rows
3. Filtering with where clause.
4. Wild Cards in SQL Server
5. Joining multiple conditions using AND and OR operators
6. Sorting rows using order by
7. Selecting top n or top n percentage of rows

Text version of the video
http://csharp-video-tutorials.blogspot.com/2012/08/select-statement-part-10.html

Slides
http://csharp-video-tutorials.blogspot.com/2013/08/part-10-all-about-select.html

All SQL Server Text Articles
http://csharp-video-tutorials.blogspot.com/p/free-sql-server-video-tutorials-for.html

All SQL Server Slides
http://csharp-video-tutorials.blogspot.com/p/sql-server.html

All Dot Net and SQL Server Tutorials in English
https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd

All Dot Net and SQL Server Tutorials in Arabic
https://www.youtube.com/c/KudvenkatArabic/playlists

0h17m

Group by in sql server - Part 11

In this video we will learn
1. Grouping rows using GROUP BY
2. Filtering Groups
3. Difference between WHERE and HAVING clause in sql server

Text version of the video
http://csharp-video-tutorials.blogspot.com/2012/08/group-by-part-11.html

Slides
http://csharp-video-tutorials.blogspot.com/2013/08/part-11-group-by.html

All SQL Server Text Articles
http://csharp-video-tutorials.blogspot.com/p/free-sql-server-video-tutorials-for.html

All SQL Server Slides
http://csharp-video-tutorials.blogspot.com/p/sql-server.html

All Dot Net and SQL Server Tutorials in English
https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd

All Dot Net and SQL Server Tutorials in Arabic
https://www.youtube.com/c/KudvenkatArabic/playlists

0h17m

Joins in sql server - Part 12

In this video we will learn about
1. The different types of Joins in sql server
2. Cross Join
3. Inner Join
4. Outer Join -- Left , Right and Full Outer Join.

Text version of the video
http://csharp-video-tutorials.blogspot.com/2012/08/joins-in-sql-server-part-12.html

Slides
http://csharp-video-tutorials.blogspot.com/2013/08/part-12-joins.html

All SQL Server Text Articles
http://csharp-video-tutorials.blogspot.com/p/free-sql-server-video-tutorials-for.html

All SQL Server Slides
http://csharp-video-tutorials.blogspot.com/p/sql-server.html

All Dot Net and SQL Server Tutorials in English
https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd

All Dot Net and SQL Server Tutorials in Arabic
https://www.youtube.com/c/KudvenkatArabic/playlists

0h12m

Advanced or intelligent joins in sql server - Part 13

In this video we will learn
1. Advanced or intelligent joins in SQL Server
2. Retrieve only the non matching rows from the left table
3. Retrieve only the non matching rows from the right table
4. Retrieve only the non matching rows from both the left and right table

Text version of the video
http://csharp-video-tutorials.blogspot.com/2012/08/advanced-joins-part-13.html

Slides
http://csharp-video-tutorials.blogspot.com/2013/08/part-13-advanced-joins.html

All SQL Server Text Articles
http://csharp-video-tutorials.blogspot.com/p/free-sql-server-video-tutorials-for.html

All SQL Server Slides
http://csharp-video-tutorials.blogspot.com/p/sql-server.html

All Dot Net and SQL Server Tutorials in English
https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd

All Dot Net and SQL Server Tutorials in Arabic
https://www.youtube.com/c/KudvenkatArabic/playlists

0h11m

Self join in sql server - Part 14

In this video we will learn about
1. Self Join - Joining a table with itself
2. Self Join is not a different type of join. It can be classified as Inner Self Join, Outer Self Join (Left, Right and Full), or Cross Self Join.

Text version of the video
http://csharp-video-tutorials.blogspot.com/2012/08/self-join-in-sql-server-part-14.html

Slides
http://csharp-video-tutorials.blogspot.com/2013/08/part-14-self-join.html

All SQL Server Text Articles
http://csharp-video-tutorials.blogspot.com/p/free-sql-server-video-tutorials-for.html

All SQL Server Slides
http://csharp-video-tutorials.blogspot.com/p/sql-server.html

All Dot Net and SQL Server Tutorials in English
https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd

All Dot Net and SQL Server Tutorials in Arabic
https://www.youtube.com/c/KudvenkatArabic/playlists

0h11m

Different ways to replace NULL in sql server - Part 15

In this video we will learn about the different ways to replace NULL values in sql server.
1. ISNULL() function
2. CASE statement
3. COALESCE() function

Text version of the video
http://csharp-video-tutorials.blogspot.com/2012/08/different-ways-to-replace-null-in-sql.html

Slides
http://csharp-video-tutorials.blogspot.com/2013/08/part-15-different-ways-to-replace-null.html

All SQL Server Text Articles
http://csharp-video-tutorials.blogspot.com/p/free-sql-server-video-tutorials-for.html

All SQL Server Slides
http://csharp-video-tutorials.blogspot.com/p/sql-server.html

All Dot Net and SQL Server Tutorials in English
https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd

All Dot Net and SQL Server Tutorials in Arabic
https://www.youtube.com/c/KudvenkatArabic/playlists

0h04m

Coalesce function in sql server Part 16

In this video we will learn, how to use coalesce() function in sql server, with an example

Text version of the video
http://csharp-video-tutorials.blogspot.com/2012/08/coalesce-function-in-sql-server-part-16.html

Slides
http://csharp-video-tutorials.blogspot.com/2013/08/part-16-coalesce-function-in-sql-server.html

All SQL Server Text Articles
http://csharp-video-tutorials.blogspot.com/p/free-sql-server-video-tutorials-for.html

All SQL Server Slides
http://csharp-video-tutorials.blogspot.com/p/sql-server.html

All Dot Net and SQL Server Tutorials in English
https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd

All Dot Net and SQL Server Tutorials in Arabic
https://www.youtube.com/c/KudvenkatArabic/playlists

0h12m

Union and union all in sql server Part 17

In this video we will learn about the
1. Purpose of UNION and UNION ALL
2. Difference between UNION and UNION ALL
3. Difference between JOIN and UNION

Text version of the video
http://csharp-video-tutorials.blogspot.com/2012/08/union-and-union-all-in-sql-server-part.html

Slides
http://csharp-video-tutorials.blogspot.com/2013/08/part-17-union-and-union-all.html

All SQL Server Text Articles
http://csharp-video-tutorials.blogspot.com/p/free-sql-server-video-tutorials-for.html

All SQL Server Slides
http://csharp-video-tutorials.blogspot.com/p/sql-server.html

All Dot Net and SQL Server Tutorials in English
https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd

All Dot Net and SQL Server Tutorials in Arabic
https://www.youtube.com/c/KudvenkatArabic/playlists

0h20m

Stored procedures in sql server Part 18

In this video we will learn
1. What is a stored procedure
2. Stored Procedure example
3. Creating a stored procedure with parameters
4. Altering SP
5. Viewing the text of the SP
6. Dropping the SP
7. Encrypting stored procedure

Text version of the video
http://csharp-video-tutorials.blogspot.com/2012/08/stored-procedures-part-18.html

Slides
http://csharp-video-tutorials.blogspot.com/2013/08/part-18-stored-procedures.html

All SQL Server Text Articles
http://csharp-video-tutorials.blogspot.com/p/free-sql-server-video-tutorials-for.html

All SQL Server Slides
http://csharp-video-tutorials.blogspot.com/p/sql-server.html

All Dot Net and SQL Server Tutorials in English
https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd

All Dot Net and SQL Server Tutorials in Arabic
https://www.youtube.com/c/KudvenkatArabic/playlists

0h18m

Stored procedures with output parameters Part 19

In this video we will learn
1. Creating and executing stored procedures with output parameters
2. Learn about some of the useful system stored procedures

Text version of the video
http://csharp-video-tutorials.blogspot.com/2012/08/stored-procedures-with-output.html

Slides
http://csharp-video-tutorials.blogspot.com/2013/08/part-19-stored-procedures-with-output.html

All SQL Server Text Articles
http://csharp-video-tutorials.blogspot.com/p/free-sql-server-video-tutorials-for.html

All SQL Server Slides
http://csharp-video-tutorials.blogspot.com/p/sql-server.html

All Dot Net and SQL Server Tutorials in English
https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd

All Dot Net and SQL Server Tutorials in Arabic
https://www.youtube.com/c/KudvenkatArabic/playlists

0h16m

Stored procedure output parameters or return values Part 20

In this video we will
1. Understand what are stored procedure return values
2. Difference between stored procedure return values and output parameters
3. When to use output parameters over return values

Text version of the video
http://csharp-video-tutorials.blogspot.com/2012/08/stored-procedure-output-parameters-or.html

Slides
http://csharp-video-tutorials.blogspot.com/2013/08/part-20-stored-procedure-output.html

All SQL Server Text Articles
http://csharp-video-tutorials.blogspot.com/p/free-sql-server-video-tutorials-for.html

All SQL Server Slides
http://csharp-video-tutorials.blogspot.com/p/sql-server.html

All Dot Net and SQL Server Tutorials in English
https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd

All Dot Net and SQL Server Tutorials in Arabic
https://www.youtube.com/c/KudvenkatArabic/playlists