Analytics in Action

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

Jan 16th in Resources, T-SQL by admin

11

Transact – Structure Query Language (T-SQL) is Microsoft’s (& Sybase’s) proprietary extension to  SQL. Its used for querying, altering and defining databases.  Transact-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. Although  you can often avoid writing SQL, but using  SQL GUI tools, there are still many situations where knowing  basic T-SQL code allow to achieve tasks difficult or impossible with the GUI.

T-SQL is used in all versions of SQL Server , albeit with some minor changes with versions (SQL 2005, 2008, 2012, Azure).

In this video I will

1) Demonstrate the core T- SQL concepts

2) Demonstrate  20  common SQL statements or examples.

3) Quickly & effeciently provide you with the knowledge to write and understand 95% of T-SQL common statements.

Download T-SQL Code used in demonstration.  This code works with SQL Server 2008 or 2012 (Denali) and SQL Azure.

Udemy Button

 

Related posts:

  1. Using SQL Server Integration Services (SSIS) to load a SQL Azure table
« »

admin

11 Responses to “Introduction to Transact-SQL (T-SQL) using Microsoft SQL Server”

  1. ken
    Jan 25th

    very helpful tutorial

    Reply
  2. Raz
    Jul 22nd

    The best tutorial I found with no price! Thank you!

    Reply
    • admin
      Jul 22nd

      Glad you found the tutorial useful and it suited your budget! :) Cheers Steve

      Reply
  3. JinzUtAreZ
    Aug 30th

    thanks very helpful tutorial =)

    Reply
    • admin
      Aug 31st

      Thanks for the comment. Pleased you found the video useful. Regards
      steve

      Reply
  4. Michael
    Sep 18th

    Hi Steve

    Can I have the PowerPoint presentation?
    I would prefer printouts as well coz it make’s it very handy.
    If it’s okay with you, please email it to me.

    Thank you so much

    Reply
    • admin
      Sep 19th

      Hi – would be happy to, but unfortunately the slide deck is on a PC in a storage unit in South Africa and I am in New Zealand.

      Reply
  5. Oscar Llanes
    Mar 30th

    Hi thanks a lot for this amazing tutorial and the way you explain is very good

    Reply
  6. tamil
    Apr 8th

    Nice Video and very useful..

    Could you please upload details on datatypes used in T-SQL with detail description of what it is and their syntax used while creating tables.

    Reply
    • admin
      May 4th

      Good suggestion, datatypes can seem confusing and complex. I am planning to release a post on Data types in the future. However, I don’t have a definitive timeline yet. Regards Steve

      Reply