Learning Transact-SQL

Introduction

• Transact-SQL
• What you should know
• What is T-SQL?
• CoderPad tour

1. Introducing SELECT

• Structure of a SELECT statement
• Aliasing columns and tables
• Adding calculations to your result set
• Solution: Simple SELECT statement

2. Filtering the Result Set

• Filtering data with WHERE using equalities
• Handling inequalities with WHERE clauses
• Find rows where strings partially match
• Filtering numeric data
• Combining multiple operators into one WHERE clause
• Understanding how NULL data affects query results
• Solution: Filtered SELECT statement

3. Manipulating the Result Set

• ORDER BY
• TOP
• DISTINCT
• Solution: Intermediate SELECT statement

4. Joins

• INNER JOIN
• LEFT JOIN
• FULL OUTER JOIN
• Combining more than two tables
• Solution: Joins

5. DDL and DML: Creating and Changing Data

• Create a table
• Insert data into a table
• Update data within a table
• Delete data from a table
• TRUNCATE a table
• Update data with a join

Conclusion

• Next steps