I receive a lot of emails about where to get quick and excellent resources for explaining most of the concepts of Transact-SQL (T SQL) and Microsoft SQL Server in general
What is Transact-SQL or T SQL.
T-SQL (Transact-SQL) is a set of programming extensions from Sybase and Microsoft that add several features to the Structured Query Language (SQL) including transaction control, exception and error handling, row processing, and declared variables. Microsoft’s SQL Server and Sybase’s SQL server support T-SQL statements.
(http://searchsqlserver.techtarget.com/definition/T-SQL)
Transact-SQL is a powerful extension of the general SQL language.
My Top 3 Transact-SQL freebee resources for quick introduction and excellent explanations of the syntax and general functions of T-SQL are these 3 Youtube channels.
- WiseOwlTutorials Youtube Channel (SQL Tutorials) which can be found here
- Bhaskar Jogi Youtube Channel (SQL Tutorials) which can be found here and
- kudvenkat Youtube Channel (SQL Tutorials) which can be found here
These tutorials are pretty good and they nail the concepts clearly for easy understanding.
Video explanations are quick and easy to understand and you can pause , rewind or see the examples yourselves
They are of same level of quality as most paid Transact-SQL courses , the only differences is that paid courses might give you real world live data or big data sets or databases to practise with whereas these ones do not give you live databases to practice with.
However, in case you need a sample database to practise, you can create any database sample you want by using free data generating services as I already covered in this article : Free Data Generating Websites
Hope you find these resources useful.
Happy Transacting!
