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.

  1. WiseOwlTutorials Youtube Channel (SQL Tutorials) which can be found here
  2.  Bhaskar Jogi Youtube Channel (SQL Tutorials) which can be found  here  and
  3.  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!

People Who Read The Above Post Also Read This:

Websites to Learn and Practice SQL for Free Default ThumbnailRank a Place Visited By a Customer- Microsoft SQL Server – T-Transact Default ThumbnailSplitting Values in one Column to Multiple Columns using CASE Expression Statement SQL Server The sp_execute_external_script (Transact-SQL) Definition And Arguments

Similar Posts

|

MySQL – Summarizing Data – SUM COUNT -MIN -MAX – AVG – DOGNITION Database

Bydatapandasadmin

Summarizing  Data This week we are looking at five most common aggregate functions used to summarize information stored in tables: COUNT and SUM very frequently. COUNT is the only aggregate function that can work on any type of variable. The other four aggregate functions are only appropriate for numerical data. All aggregate functions require you…

|

Creating Oracle PL/SQL Tables for Intercollegiate Athletic Database – Data Warehousing

Bydatapandasadmin

Creating Oracle  tables for Intercollegiate Athletic Database. Part of Assignment one of Data Warehousing for Business Intelligence on Coursera –1 CREATE TABLE FACILITY CREATE TABLE FACILITY( FACNO VARCHAR(12), FACNAME VARCHAR(255) NOT NULL, CONSTRAINT PK_FAC PRIMARY KEY (FACNO) ); –2.REATE TABLE EMPLOYEE CREATE TABLE EMPLOYEE( EMPNO VARCHAR(12), EMPNAME VARCHAR(255) NOT NULL, DEPARTMENT VARCHAR(100) NOT NULL, EMAIL VARCHAR(50) NOT…

|

Splitting Values in one Column to Multiple Columns using CASE Expression Statement SQL Server

Bydatapandasadmin

Sometimes, you would want to split values in a column into separate rows  in SQL server.  This is a simple guide. Lets check the fields in the table we will be working with. select [orderID] ,[itemType] ,[price] ,[quantity] from [Antrak].[dbo].[ClothingSale] Let’s check the result:   We can see that the itemType field has different values…

Visual Explanation illustration and presentation of SQL JOINS query statements

Bydatapandasadmin

SQL Joins can sometimes be a bit confusing, particularly if you a newbie. I have below 2 visual representations which should help enhance your visual understanding of SQL JOINS First is from From CodeProject, by C L Moffatt You can check full explanation here: Sql Joins visually explained   2. Second was from Duke University….

Drop Shipping Ecommerce Database ER Diagram and Conceptual Modeling
|

Drop Shipping Ecommerce Database ER Diagram and Conceptual Modeling

Bydatapandasadmin

In this short article, we look at a sample ERD Diagram which is designed using ER-Assistant software (usage of this software is covered here: How To Use ER Assistant) after we have finished with the Conceptual Modeling. Hence in the first place, we have to gather some Data requirements. This involves business logic and requirements,…

Pyodbc Sqlalchemy Python 2 and 3 SQL Server Native Client 11.0
|

Pyodbc Sqlalchemy Python 2 and 3 SQL Server Native Client 11.0

Bydatapandasadmin

This is a sample code to use Python to connect to SQL Server Native Client. import sqlalchemy import pyodbc try: import urllib params = urllib.quote_plus(“DRIVER={SQL Server Native Client 11.0};SERVER=.\MSSQLSERVER_ENT;DATABASE=MagicDirect;Trusted_Connection=yes;”) engine = sqlalchemy.create_engine(‘mssql+pyodbc:///?odbc_connect=%s”‘ % params) results.to_sql(“clusterSegments”, engine, if_exists = ‘replace’)# except (RuntimeError, TypeError, NameError): print(‘Error in Conneccting’) print(RuntimeError, TypeError, NameError) finally: print(“connected”) People Who Read The…

Leave a Reply

Your email address will not be published. Required fields are marked *