Introduction to Transact SQL (T-SQL) using Microsoft SQL Server

A more comprehensive, 60 minute, version of this course is also available at Udemy : https://www.udemy.com/t-sql-for-data-analysts/?couponCode=ANALYTICS50%25OFF

Link to code used in demo : https://drive.google.com/file/d/0B9J0yv0y0P5XME9FNTYzYmR2dUE/view?usp=sharing&resourcekey=0-klPtSGZEtESBxE3OaXuZhA

Transact-Structured Query Language (T-SQL) is Microsoft’s (& Sybase’s) proprietary extension to SQL. T-SQL is central to using Microsoft SQL Server. All applications that communicate with an instance of SQL Server do so by sending Transact-SQL statements to the server, regardless of the user interface of the application.

In this tutorial I provide an introduction to Transact -SQL using Microsoft SQL Server. I also 1) Explain what is Transact SQL (T-SQL). 2) Provide an overview of 20 key T-SQL statements. 3) Demonstration 20 key T-SQL statements 4) Provide sample code used in the tutorial to download @ http://www.analyticsinaction.com/tsql/

T-SQL statements covered include : SELECT Query, UPDATE Query, INSERT, AS, ORDER, CREATE, TRUNCATE, DROP TABLE, DROP DATABASE, INNER JOIN, WHERE, GROUP, SET, BETWEEN and more!