Transact-SQL Fundamentals in SQL Server

Summary

This Drill covers fundamental T-SQL activities such as making queries, sorting and filtering, and using table joins. It also covers control-of-flow language, and using functions (including aggregate functions) to manipulate data.

Audience

This Drill is for developers who want to learn the skills needed to use Transact-SQL to interact with a SQL Server database.

What you'll learn

You will learn the basic skills needed to use the T-SQL language to access Microsoft’s popular SQL Server database. This includes making queries, sorting and filtering data, and using table joins. You’ll also cover control-of-flow language, and using functions (including aggregate functions) to manipulate data.

What you need to know

We assume that you’re already familiar with programming concepts and you’ve used Visual Studio. You’ll also need to be comfortable with Visual C# or Visual Basic syntax, and have a working knowledge of SQL and SQL Server (or general database fundamentals, at least). Although not essential, experience with Transact-SQL (T-SQL) would be useful.