Learning Transact-SQL
Offered By: LinkedIn Learning
Course Description
Overview
Get an introduction to Transact-SQL (T-SQL), a Microsoft-specific extension of SQL.
Syllabus
Introduction
- Transact-SQL
- What you should know
- What is T-SQL?
- CoderPad tour
- Structure of a SELECT statement
- Aliasing columns and tables
- Adding calculations to your result set
- Solution: Simple SELECT statement
- 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
- ORDER BY
- TOP
- DISTINCT
- Solution: Intermediate SELECT statement
- INNER JOIN
- LEFT JOIN
- FULL OUTER JOIN
- Combining more than two tables
- Solution: Joins
- 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
- Next steps
Taught by
Jeff Jones
Related Courses
Introduction to DatabasesMeta via Coursera Analyzing Big Data with SQL
Cloudera via Coursera Managing Google Workspace 日本語版
Google Cloud via Coursera Creating Advanced Reports with SAS Visual Analytics
SAS via Coursera Query Client Data with LibreOffice Base
Coursera Project Network via Coursera