

Querying Data With Microsoft Transact-SQL
Overview:
Introduction
T-SQL or Transact SQL is the query language specific to the Microsoft SQL Server product. It can help perform operations like retrieving the data from a single row, inserting new rows, and retrieving multiple rows. It is a procedural language that is used by the SQL Server
Course Objectives
At the end of this course the participants will be able to:
-
Use SQL Server query tools
-
Write SELECT statements to retrieve columns from one or more tables
-
Sort and filter selected data
-
Use built-in functions to returned data values
-
Create groups of data and aggregate the results
-
Modify data with Transact-SQL using INSERT, UPDATE, DELETE and MERGE
Targeted Audience
-
Data Analyst
-
Data Engineer
-
Data Scientist
-
Database administrator
-
Database Developer
Course Outline
Unit 1: Getting started with Transact- SQL
-
Introduction to Transact-SQL
-
Using the SELECT statement
-
Get started with SQL Server query tools and writing queries in T-SQL
Unit 2: Sorting and Filtering Query Result
-
Sorting query results
-
Filtering the data
-
Sort and filter data returned by SELECT queries
Unit 3: Using Join and Subqueries
-
Using JOIN operations
-
Using subqueries
-
Write queries with JOIN operations
-
Write SELECT statements using subqueries
Unit 4: Using Build and Functions
-
Getting started with scalar functions
-
Grouping aggregated results
-
Built-in functions
Unit 5: Modifying Data.
-
Inserting data into tables
-
Modifying and deleting data