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

Querying Data with Microsoft Transact-SQL - DP-080T00 Certification Training 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

 

 

Test your current knowledge Qubits42

Querying Data with Microsoft Transact-SQL - DP-080T00 (16 Hours) Download Course Contents

Live Virtual Classroom
Group Training 850
02 - 03 Aug 09:00 AM - 05:00 PM CST
(8 Hours/Day)
06 - 07 Sep 09:00 AM - 05:00 PM CST
(8 Hours/Day)
1-on-1 Training (GTR) 950
4 Hours
8 Hours
Week Days
Week End

Start Time : At any time

12 AM
12 PM

GTR=Guaranteed to Run
Classroom Training (Available: London, Dubai, India, Sydney, Vancouver)
Duration : On Request
Fee : On Request
On Request
Special Solutions for Corporate Clients! Click here Hire Our Trainers! Click here

Customers who bought this course also bought

• Microsoft Power Platform Fundamentals
• DP-900: Microsoft Azure Data Fundamentals
• AZ-900T01: Microsoft Azure Fundamentals (1 day)
• Microsoft Dynamics 365 Fundamentals (ERP)
• AZ-120T00-A :Planning and Administering Microsoft Azure for SAP Workloads
• Microsoft Dynamics 365: Finance and Operations Apps Developer
• AZ-900T01: Microsoft Azure Fundamentals (2 days)
• DA-100 Analyze Data with Power BI
• Microsoft Azure AI Fundamentals
• Web Server IIS Mastery

Course Modules

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
Module 2: Sorting and Filtering Query Results
  • Sorting query results
  • Filtering the data
  • Sort and filter data returned by SELECT queries
Module 3: Using Joins and Subqueries
  • Using JOIN operations
  • Using subqueries
  • Write queries with JOIN operations
  • Write SELECT statements using subqueries
Module 4: Using Built-in Functions
  • Getting started with scalar functions
  • Grouping aggregated results
  • Built-in functions
Module 5: Modifying Data
  • Inserting data into tables
  • Modifying and deleting data
Download Course Contents

Request More Information

Course Prerequisites
  • Basic knowledge of relational databases.

 

FAQ's