Course Structure

The course is divided into several chapters that discuss different concepts.

T-SQL basics

In this chapter, we’ll look at the basic syntax of T-SQL and the basic operations that can be performed using this language. We’ll see examples of how we can create and remove databases and tables, along with data insertion and retrieval.

Querying multiple tables

In real-life applications, we often have interrelated data. This chapter covers how we can achieve relationships between tables and read data from interrelated tables.

Grouping and aggregation

For analysis, we often have to group data based on a particular attribute or perform aggregate calculations on data. This chapter will cover these concepts.

Subqueries

T-SQL queries can be complex and contain other queries inside them. In this chapter, we’ll learn how to construct subqueries and when it is appropriate to use them.

T-SQL programming

T-SQL is not just a query language but is also a procedural programming language. Toward the end of the course, we’ll learn about the programming capabilities of T-SQL.