Introduction to Transact-SQL
1h 4mBeginner2023-10-11
Authors
Jess Pomfret
Database Platform Architect and Microsoft MVP
Course details
Relational databases and SQL servers have been a cornerstone of businesses for decades, and as data growth increases at an exponential pace, learning to work with data held in SQL Server databases is more important than ever. In this course, Jess Pomfret introduces Transact-SQL, an extension of SQL used to interact with relational databases that includes additional programming constructs and features beyond standard SQL, particularly procedural programming. Jess starts with the basics, guiding you through your first SELECT statement to help you get the data you need out of a database. She then shows how to add functionality to help filter, manipulate, and present the results you need. By the end of this course, you’ll be well equipped to write the T-SQL you need to get the job done.
Skills covered
SQLDatabase AdministrationIntroduction toDatabase DevelopmentDatabase ManagementData AnalysisProgramming LanguagesData ScienceBusiness Analysis and StrategyBusiness Software and ToolsOpen SourceSoftware Development
Concepts
0. Introduction
- 01 - Transact-SQL
- 02 - What you should know
- 03 - What is T-SQL
- 04 - CoderPad tour
1. Introducing SELECT
- 05 - Structure of a SELECT statement
- 06 - Aliasing columns and tables
- 07 - Adding calculations to your result set
- 08 - Solution - Simple SELECT statement
2. Filtering the Result Set
- 09 - Filtering data with WHERE using equalities
- 10 - Handling inequalities with WHERE clauses
- 11 - Find rows where strings partially match
- 12 - Filtering numeric data
- 13 - Combining multiple operators into one WHERE clause
- 14 - Understanding how NULL data affects query results
- 15 - Solution - Filtered SELECT statement
3. Manipulating the Result Set
- 16 - ORDER BY
- 17 - TOP
- 18 - DISTINCT
- 19 - Solution - Intermediate SELECT statement
4. Joins
- 20 - INNER JOIN
- 21 - LEFT JOIN
- 22 - FULL OUTER JOIN
- 23 - Combining more than two tables
- 24 - Solution - Joins
5. DDL and DML - Creating and Changing Data
- 25 - Create a table
- 26 - Insert data into a table
- 27 - Update data within a table
- 28 - Delete data from a table
- 29 - TRUNCATE a table
- 30 - Update data with a join
Conclusion
- 31 - Next steps