Wednesday, 14 January 2015

Video tutorials to learn T-SQL Programming


  1. What is Transact-SQL and How Does It Fit? (2008/R2)
  2. Basics of Transact-SQL: Batches, Scripts, GO, and Statements
  3. How to Declare and Initialize Variables in T-SQL (Part 2)
  4. SQL Server Data Types: An Overview
  5. Overview of SQL Server Data Types: Numbers
  6. Overview of SQL Server Data Types: Date and Time
  7. Overview of SQL Server Data Types: Time Zone Aware Dates
  8. SQL Server Constraints: Server or Client-Side Constraints?
  9. Foreign Keys in SQL Server: What They Are and How to Use Them
  10. Implementing EAV Models in SQL Server (Entity-Attribute-Value)
  11. The Four Steps SQL Server Goes Through to Run Your Query
  12. The Basics of Execution Plans and SHOWPLAN in SQL Server
  13. Creating Scalar UDFs: Syntax and Basics
  14. Multistatement UDFs in SQL Server 2008/R2: The Syntax and Basics
  15. How to Encrypt Your Source Code in SQL Server
  16. Introduction to Indexes in SQL Server
  17. The Basics of INSERT in T-SQL
  18. Three Syntaxes for INSERT in T-SQL
  19. The OUTPUT Clause in T-SQL
  20. Nested Transactions in T-SQL
  21. T-SQL Triggers: Why Are They So Popular?
  22. SQL Server Stored Procedures: Returning Data to the Client
  23. SQL Server Output Parameters: Understanding the Syntax
  24. SQL Server Performance Tuning Tools

No comments:

Post a Comment