Euro-training Center
 Querying Data With Microsoft Transact SQL G1770 QR Code
Share   Like Download Brochure (PDF) Dates and locations

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

 

Select training course venue