Lesson - 01

• Introduction to SQL Server Management studio.
• Create-Delete new database
• Create new table use designer and script
• Alter table
• Delete table
• Insert row int table

Lesson - 02

• What is primary key and foreign key ?
• Why RDBMS Relational Database Management Systyem ?
• Check constraint
• Default constraint
• Cascading referential integrity constraint real world use case and examples

Lesson - 03

• Identity columns, Auto increment identity value
• Identity On-Off when insert new row into table
• How to get last generated identity value
• Unique key constraint

Lesson - 04

• Select statements
• Get distinct records. distinct behaviour with single and multiple columns select.
• Where clause examples.
• Operators and wild cards examples.
• Like operator
• In operator
• Not operator
• Searching and sorting data

Lesson - 05

• Group by consept in SQL Server
• Sum, Min Max and Average functions.
• Group by multiple columns
• Group by multiple aggregation
• Having clause

Lesson - 06

• Joins in SQL Server
• Inner join
• Left join
• Right join
• Full join

Lesson - 07

• Cross join
• Self join
• Advance or intelligent joins

Lesson - 08

• Isnull function
• Case when function
• Coalesce function
• Union and Union All

Lesson - 09

• What is stored procedures
• How to write stored procedures
• Alter stored procedures
• Delete stored procedures
• How to encript stored procedures
• Use sp_helptext stored procedure

Lesson - 10

• Stored procedures with output parameter.
• Stored procedure return values.
• When to use output parameter over return values.
• Advantage of stored procedures.
• What is SQL injection attack ?

Lesson - 11

• String functions
• Left, Right, Ltrim and Rtrim functions
• CharIndex and Substring functions
• Replicate function
• PatIndex function

Lesson - 12

• Date time functions
• GetDate function
• GetUTCdate function
• IsDate function
• Day, Month, Year and Date name function
• Cast and Convert function

Lesson - 13

• User defined functions in SQL
• Scalar function in SQL
• Inline table valued function

Lesson - 14

• Temp tables in SQL
• How to create aleter and delete temp tables
• Difference between global and local temp tables

Lesson - 15

• Indexes in SQL Server.
• Cluster and non cluster indexes in SQL
• Unique and non unique indexes in SQL
• Indexes pros and cons

Lesson - 16

• Views in SQL server
• Why use view ?
• Create view in SQL
• Delete view in SQL
• View limitations

Lesson - 17

• Triggers in SQL
• After triggers
• Instead of trigger

Lesson - 18

• Disable and enable trigger
• Alter and delete trigger
• Record insert, delete and update actions using triggers

Lesson - 19

• What is CTE(Comman Table Expression) in SQL ?
• Drive Table and CTE
• How to write CTE

Lesson - 20

• Recursive CTE
• Example of CTE
• Display family tree using CTE

Lesson - 21

• Subquries in SQL
• Corelated Subquries
• Subquries example

Lesson - 22

• Rownumber function in SQL
• Rank function in SQL
• Dense_rank function in SQL

Lesson - 23

• Diffrence rownumber, rank and denserank function
• Delete duplicate records using CTE and rownumber function
• Find Nth higest salary using CTE and dense_rank function

Lesson - 24

• Get list of all tables
• Get list of all stored procedures
• Get list of all columns
• Write rerunnable quires

Lesson - 25

• Select into statement
• Table backup using select into statement
• Create empty table using select into statement

Lesson - 26

• Transactions in SQL server
• When to use transactions
• Commit and rollback transaction
• Transaction Isolation lavel

Lesson - 27

• Revision - 1
• Meth functions

Lesson - 28

• Revision - 2
• Paging in SQL server using offset fetch next

Lesson - 29

• Revision - 3
• Generate database scripts

Lesson - 30

• Revision - 4
• Backup and restore database

Lesson - 31

• Database design tips and tricks