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