In a world where data is an extremely prized possession, it is crucial to know how to manage it. Drawing tables in a paper notebook and writing numbers down by hand can only get you so far. No modern business will achieve much without using virtual databases.
In this T-SQL tutorial, I will teach you how to work with the Microsoft SQL Server database management system. Transact SQL, also known as T-SQL, plays a critical role it using this system, so I will guide you through every concept and component of this query language. In just over seven hours that you will spend learning Transact SQL, you will find out everything you need to start creating and managing your own databases in Microsoft SQL Server.
While there are multiple types of databases, relational ones (such as MySQL and Oracle) are the most commonly used. They are easy to handle because of their clear structure of columns and rows. Every column defines a data type, and each row represents a separate data record. Typically, you would be using SQL (Structured Query Language) for this kind of work.
However, if you decide to use Microsoft SQL Server, you will need to get the gist of T-SQL programming. As you will see in this T-SQL tutorial, it is basically upgraded SQL: it has all the same basics, plus some extensions that allow you to use extra features, including but not limited to row processing or exception and error handling. Learning Transact SQL is a must for every aspiring database developer or administrator, as well as data analysts, report developers, and even web developers.
My T-SQL tutorial consists of more than seven hours of useful video lectures. During them, we will discuss all the fundamentals of T-SQL programming, including:
Next to the video lectures, the Transact SQL tutorial will also include text files. In them, you will find practice activities and demonstrations scripts. After all, the theory is worth nothing if you don’t know how to use it in practice, right?
When I first started learning Transact SQL, I had to use many different sources and do a ton of experimenting to understand each and every feature. That’s why now, having over a decade of experience in working with databases and six Microsoft certifications (including Microsoft Certified Solution Expert Data Management and Analytics and Microsoft Certified Solution Expert Business Intelligence), I have done my best to make this T-SQL tutorial as complete, useful and beginner-friendly as possible. Start learning today, and get ready to jump-start your career!
I am a Microsoft Certified Trainer. Having more than 11 Years of rich experience. Successfully self-employed, I am a trusted consultant for businesses large and small. Currently working as a Corporate Trainer & Consultant for SQL Server and Microsoft Business Intelligence. Also worked as a SQL Server Developer. Lives in Delhi, India.
My style is to teach in such a way so that student should be able to create images or diagrams of the concept in his/her mind. Because I believe we understand, remember, and learn all the things in pictures, diagrams or images. This is the science of learning.
My Microsoft Certifications are:
Microsoft Certified Solution Expert Data Platform
Microsoft Certified Solution Expert Business Intelligence
Microsoft Certified Solution Expert Data Management and Analytics
Microsoft Certified Solution Associate SQL Server 2012/2014
Microsoft Certified Trainer
Microsoft Certified Professional