T-SQL Tutorial T-SQL Advanced Database Management T-SQL References

T-SQL - Tutorial



A relational database organizes data into data tables in which data types may be related to each other. These relations help structure the data. Transact-SQL (T-SQL) is Microsoft's and Sybase's proprietary extension to the SQL (Structured Query Language) used to interact with relational 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.

About Tutorial

This tutorial provides basic and advanced concepts of T-SQL. It is designed for beginners and professionals as well. Every topic is explained with examples which make you learn T-SQL in a very easy way. In this tutorial, you will learn how to create new database, perform various operations on database like insert new records, update records, delete records and view records etc. Additionally, you will also learn how to create database/table, drop database/table, set permission on tables, procedures, and views and create stored procedure, function in a database.

We believe in learning by examples therefore each and every topic is explained with lots of examples that makes you learn T-SQL in a very easy way.

Prerequisite

There is no prerequisite for this tutorial however a basic understanding of database would be an added advantage.