Description

Lecture 01. Connecting to SQL Server using SSMS - Part 1
Lecture 02. Creating altering and dropping a database - Part 2
Lecture 03. Creating and working with tables - Part 3
Lecture 04. Adding a default constraint - Part 4
Lecture 05. Cascading referential integrity constraint - Part 5
Lecture 06. Adding a check constraint - Part 6
Lecture 07. Identity Column in SQL Server - Part 7
Lecture 08. How to get the last generated identity column value in SQL Server - Part 8
Lecture 09. Unique key constraint - Part 9
Lecture 10. Select statement in sql server - Part 10
Lecture 11. Group by in sql server - Part 11
Lecture 12. Joins in sql server - Part 12
Lecture 13. Advanced or intelligent joins in sql server - Part 13
Lecture 14. Self join in sql server - Part 14
Lecture 15. Different ways to replace NULL in sql server - Part 15
Lecture 16. Coalesce function in sql server Part 16
Lecture 17. Union and union all in sql server Part 17
Lecture 18. Stored procedures in sql server Part 18
Lecture 19. Stored procedures with output parameters Part 19
Lecture 20. Stored procedure output parameters or return values Part 20
Lecture 21. Advantages of stored procedures Part 21
Lecture 22. Built in string functions in sql server 2008 Part 22
Lecture 23. LEFT, RIGHT, CHARINDEX and SUBSTRING functions in sql server Part 23
Lecture 24. Replicate, Space, Patindex, Replace and Stuff string functions in sql server 2008 Part 24
Lecture 25. DateTime functions in SQL Server Part 25
Lecture 26. IsDate, Day, Month, Year and DateName DateTime functions in SQL Server Part 26
Lecture 27. DatePart, DateAdd and DateDiff functions in SQL Server Part 27
Lecture 28. Cast and Convert functions in SQL Server Part 28
Lecture 29. Mathematical functions in sql server Part 29
Lecture 30. Scalar user defined functions in sql server Part 30
Lecture 31. Inline table valued functions in sql server Part 31
Lecture 32. Multi statement table valued functions in sql server Part 32
Lecture 33. Important concepts related to functions in sql server Part 33
Lecture 34. Temporary tables in SQL Server Part 34
Lecture 35. Indexes in sql server Part 35
Lecture 36. Clustered and nonclustered indexes in sql server Part 36
Lecture 37. Unique and Non Unique Indexes in sql server Part 37
Lecture 38. Advantages and disadvantages of indexes in sql server Part 38
Lecture 39. Views in sql server Part 39
Lecture 40. Updatable views in sql server Part 40
Lecture 41. Indexed views in sql server Part 41
Lecture 42. View limitations in sql server Part 42
Lecture 43. DML triggers in sql server Part 43
Lecture 44. After update trigger Part 44
Lecture 45. Instead of insert trigger Part 45
Lecture 46. Instead of update triggers in sql server - Part 46.avi
Lecture 47. Instead of delete triggers in sql server - Part 47.avi
Lecture 48. Derived tables and common table expressions in sql server Part 48
Lecture 49. CTE in sql server Part 49
Lecture 50. Updatable common table expressions in sql server Part 50
Lecture 51. Recursive CTE in sql server Part 51
Lecture 52. Database normalization Part 52
Lecture 53. Second normal form and third normal form Part 53
Lecture 54. Pivot in sql server 2008 Part 54
Lecture 55. Error handling in sql server 2000 Part 55
Lecture 56. Error handling in sql server Part 56
Lecture 57. Transactions in sql server Part 57
Lecture 58. Transactions in sql server and ACID Tests Part 58

What's New in Version 1.1

Fix Bug