Gain insights into T-SQL syntax, table creation, data manipulation, and relationships. Delve into advanced constructs like stored procedures, functions, and triggers to enhance your database development skills.

tsql.tar.gz

T-SQL-SPA

T-SQL is a dialect of SQL that is used in Microsoft SQL Server. The popularity of Microsoft's database management system sustains high market demand for people well versed in T-SQL. 

This course teaches the core concepts and syntax of T-SQL. First, you will learn how to create tables, insert data, update existing records, and create relationships between tables. Then, you will be exposed to more advanced constructs of T-SQL, like stored procedures, functions, and triggers. 

By the end of the course, you will be sufficiently adept with T-SQL and be able to perform your day-to-day tasks as software and database developers effectively.

Querying Databases Using Transact-SQL

A **subquery** is a query that is part of another large query. T-SQL queries can be complex and consist of multiple subqueries.

## Why subqueries?

Let’s consider these tables for `Schools` and `Students` with the following structure.

The `Schools` table is newly created, and we want to fill it with values from the `Students` table's `School` column. Our traditional approach would be to use an `INSERT INTO` statement and insert all values manually.  Here are the steps that we would take:


1. We manually identify school names that need to be inserted into the `Schools` table.
2. We manually eliminate duplicate values.
3. We manually provide the input values for our `INSERT INTO` statement.

A **subquery** is a query that is part of another large query. T-SQL queries can be complex and consist of multiple subqueries.

# Why subqueries?

Let’s consider these tables for `Schools` and `Students` with the following structure.

Learn how to nest queries inside other queries.


Before We Start

T-SQL Basics

Querying Multiple Tables

Grouping and Aggregation

Subqueries

T-SQL Fundamentals Assessment

Built-in Functions

T-SQL Programming Basics

Additional Programming Constructs

Course Comprehension Assessment

Conclusion

Introduction to Subqueries

Why subqueries?