YoVDO

Learning Transact-SQL

Offered By: LinkedIn Learning

Tags

Transact-SQL (T-SQL) Courses Relational Databases Courses Data Filtering Courses Data Manipulation Courses Data Aggregation Courses

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
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

Taught by

Jeff Jones

Related Courses

Introduction to Databases
Meta 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