SQL Server

Part 1 – Connecting to SQL Server

Part 2 – Creating, altering and dropping a database

Part 3 – Creating and working with tables

Part 4 – Default Constraint

Part 5 – Cascading referential integrity constraint

Part 6 – CHECK constraint

Part 7 – Identity Column

Part 8 – Retrieving Identity Column values

Part 9 – Unique key constraint

Part 10 – All about “SELECT”

Part 11 – Group By

Part 12 – JOINS

Part 13 – Advanced JOINS

Part 14 – Self Join

Part 15 – Different ways to replace NULL in SQL Server

Part 16 – COALESCE() function in SQL Server

Part 17 – UNION and UNION ALL

Part 18 – Stored Procedures

Part 19 – Stored procedures with output parameters

Part 20 - Stored procedure output parameters or return values

Part 21 – Advantages of stored procedures

Part 22 – String functions

Part 23 – String functions Continued

Part 24 – String functions Continued

Part 25 – DateTime functions in SQL Server

Part 26 –DateTime functions continued

Part 27 –DateTime functions continued

Part 28 –Cast and Convert functions

Part 29 –Mathematical functions

Part 30 – User defined functions

Part 31 – Inline Table Valued Functions

Part 32 – Multi-Statement Table Valued Functions

Part 33 – Functions – Important Concepts

Part 34 – Temporary Tables

Part 35 – Indexes

Part 36 - Clustered & NonClustered indexes

Part 37 – Unique & Non-Unique indexes

Part 38 – Adv. & Dis-adv. of Indexes

Part 39 – Views in SQL Server

Part 40 – Updateable Views

Part 41 – Indexed Views

Part 42 –View Limitations

Part 43 –DML Triggers

Part 44 –DML Triggers

Part 45 –Instead Of Insert Trigger

Part 46 –Instead Of Update Trigger

Part 47 –Instead Of Delete Trigger

Part 48 –Derived Tables & CTE

Part 49 – CTE

Part 50 – Updatable CTEs

Part 51 – Recursive CTEs

Part 52 – Normalization

Part 53 – 2NF & 3NF

Part 54 – Pivot in SQL Server 2008

Part 55 – Error Handling in SQL Server 2000

Part 56 – Error Handling in SQL Server 2005 & Later versions

Part 57 – Transactions in SQL Server

Part 58 – Transaction ACID Test

Part 59 – SubQueries in SQL Server

Part 60 – Co related SubQueries

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

Part 62 – What to choose for performance - SubQueries or Joins?

Part 63 – Cursors in SQL Server

Part 64 – Replacing cursors using joins

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

Part 66 – Writing re-runnable SQL Server scripts

Part 67 – Alter database table columns without dropping table

Part 68 - Optional parameters in sql server stored procedures

Part 69 - Merge in SQL Server

Part 70 - SQL Server concurrent transactions

Part 71 - SQL Server dirty read example

Part 72 - SQL Server lost update problem

Part 73 - Non repeatable read example in sql server

Part 74 - Phantom reads example in sql server

Part 75 - Snapshot isolation level in sql server

Part 76 - Read committed snapshot isolation level in sql server

Part 77 - Difference between snapshot isolation and read committed snapshot

Part 78 - SQL Server deadlock example

Part 79 - SQL Server deadlock victim selection

Part 80 - Logging deadlocks in sql server

Part 81 - SQL Server deadlock analysis and prevention

Part 82 - Capturing deadlocks in sql profiler

Part 83 - SQL Server deadlock error handling

Part 84 - Handling deadlocks in ado.net

Part 85 - Retry logic for deadlock exceptions

Part 86 - How to find blocking queries in sql server

Part 87 - SQL Server except operator

Part 88 - Difference between except and not in sql server

Part 89 - Intersect operator in sql server

Part 90 - Difference between union intersect and except in sql server

Part 91 - Cross apply and outer apply in sql server

Part 92 - DDL Triggers in sql server

Part 93 - Server-scoped DDL triggers

Part 94 - SQL Server trigger execution order

Part 95 - Audit table changes in sql server

Part 96 - Logon triggers in sql server

Part 97 - Select into in sql server

Part 98 - Difference between where and having in sql server

Part 99 - Table valued parameters in SQL Server

Part 100 - Send datatable as parameter to stored procedure

Part 101 - Grouping Sets in SQL Server

Part 102 - Rollup in SQL Server

Part 103 - Cube in SQL Server

Part 104 - Difference between cube and rollup in SQL Server

Part 105 - Grouping function in SQL Server

Part 106 - GROUPING_ID function in SQL Server

Part 107 - Debugging sql server stored procedures

Part 108 - Over clause in SQL Server

Part 109 - Row_Number function in SQL Server

Part 110 - Rank and Dense_Rank in SQL Server

Part 111 - Difference between rank dense_rank and row_number in SQL

Part 112 - Calculate running total in SQL Server 2012

Part 113 - NTILE function in SQL Server

Part 114 - Lead and Lag functions in SQL Server 2012

Part 115 - FIRST_VALUE function in SQL Server

Part 116 - Window functions in SQL Server

Part 117 - Difference between rows and range

Part 118 - LAST_VALUE function in SQL Server

Part 119 - UNPIVOT in SQL Server

Part 120 - Reverse PIVOT table in SQL Server

Part 121 - Choose function in SQL Server

Part 122 - IIF function in SQL Server

Part 123 - TRY_PARSE function in SQL Server 2012

Part 124 - TRY_CONVERT function in SQL Server 2012

Part 125 - EOMONTH function in SQL Server 2012

Part 126 - DATEFROMPARTS function

Part 127 - Difference between DateTime and SmallDateTime in SQL Server

Part 128 - DateTime2FromParts function in SQL Server 2012

Part 129 - Difference between DateTime and DateTime2 in SQL Server

Part 130 - Offset fetch next in SQL Server 2012

Part 131 - Identifying object dependencies in SQL Server

Part 132 - sys.dm_sql_referencing_entities in SQL Server

Part 133 - sp_depends in SQL Server

Part 134 - Sequence object in SQL Server 2012

Part 135 - Difference between sequence and identity in SQL Server

Part 136 - Guid in SQL Server

Part 137 - How to check GUID is null or empty in SQL Server

Part 138 - Dynamic SQL in SQL Server

Part 139 - Implement search web page using ASP.NET and Stored Procedure

Part 140 - Implement search web page using ASP.NET and Dynamic SQL

Part 141 - Prevent sql injection with dynamic sql

Part 142 - Dynamic SQL in Stored Procedure

Part 143 - Sql server query plan cache

Part 144 - exec vs sp_executesql in sql server

Part 145 - Dynamic sql table name variable

Part 146 - Quotename function in SQL Server

Part 147 - Dynamic SQL vs Stored Procedure

Part 148 - Dynamic sql output parameter

Part 149 - Temp tables in dynamic sql