DP-080T00: Querying Data with Microsoft Transact-SQL Training Certification Course

Download Course Contents

Querying Data with Microsoft Transact-SQL - DP-080T00 Course Overview

Enroll for 2-day Querying Data with Microsoft Transact-SQL - DP-080T00 training course from Koenig Solutions accredited by Microsoft. In this course you will learn about the basics of Microsoft's dialect of the standard SQL language: Transact-SQL.

Through a blend of hands-on labs and interactive lectures, you will learn about both querying and modifying data in relational databases that are hosted in Microsoft SQL Server-based database systems, including: Microsoft SQL Server, Azure SQL Database and, Azure Synapse Analytics.

Target Audience:

  • Data Analyst
  • Data Engineer
  • Data Scientist
  • Database administrator
  • Database Developer

 

Learning Objectives:

After completing this course, you 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

 

 

  • 1. Do you have limited Window for training?
  • 2. Can you only spend 4-hours per day?
  • 3. Do you want to start training immediately?
  • If your answer is yes to any one of the above, you need 1-on-1- Training
The 1-on-1 Advantage
Methodology
Flexible Dates
4-Hour Sessions
  • View video
  • The course will be free if we are not able to start within 7 days of booking.
  • Only applicable for courses on which this logo appears.

Your will learn:

Module 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
  • Sorting query results
  • Filtering the data
  • Sort and filter data returned by SELECT queries
  • Using JOIN operations
  • Using subqueries
  • Write queries with JOIN operations
  • Write SELECT statements using subqueries
  • Getting started with scalar functions
  • Grouping aggregated results
  • Built-in functions
  • Inserting data into tables
  • Modifying and deleting data
Live Online Training (Duration : 16 Hours)
Group Training 900 Per Participant Incl. Official Courseware
26 - 27 May GTR Co-Students 08:00 AM - 04:00 PM CST
(8 Hours/Day)
06 - 07 Jun 09:00 AM - 05:00 PM CST
(8 Hours/Day)
04 - 05 Jul 09:00 AM - 05:00 PM CST
(8 Hours/Day)
1-on-1 Training 1800 1000 + If you accept merging of other students. Incl. Official Courseware
4 Hours
8 Hours
Week Days
Weekend

Start Time : At any time

12 AM
12 PM

1-On-1 Training is Guaranteed to Run (GTR)
Classroom Training (Available: London, Dubai, India, Sydney, Vancouver)
Duration : On Request
Fee : On Request
On Request
Classroom Training is available. Enquire for the fee Click
Comfort Track

If you think 16 hours is too fast, we can offer Comfort Track for 32 hours for only USD 2,000

This Course Similar To Introduction To SQL Databases

Course Prerequisites
  • Basic knowledge of relational databases.

 

Request More Information

Add Name and Email Address of participant (If different from you)

FAQ's


No, the published fee includes all applicable taxes.
The Fee includes:
  • Official courseware
  • Testing Via Qubits
  • Remote Labs
Yes, Koenig Solutions is a Microsoft Learning Partner
  • Introduction To SQL Databases