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

This course will teach the basics of Microsoft's dialect of the standard SQL language: Transact-SQL. Topics include 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.

Duration: 2.0 days

Enquire Now

Schedule

Singapore | 02 May 2024 - 03 May 2024 Singapore
Virtual ILT | 02 May 2024 - 03 May 2024 Singapore
Virtual ILT | 13 May 2024 - 14 May 2024 Philippines
Virtual ILT | 22 Apr 2024 - 23 Apr 2024 India
Kuala Lumpur | 27 May 2024 - 28 May 2024 Malaysia
Virtual ILT | 27 May 2024 - 28 May 2024 Malaysia

Start learning today!

Click Hereto customize your Training

Objectives

  • Understand what SQL is for
  • Identify database objects in schemas
  • Identify SQL statement types
  • Use the SELECT statement
  • Work with data types
  • Handle NULLs
  • Sort your results
  • Limit the sorted results
  • Return paged results
  • Remove duplicates
  • Filter data with predicates
  • Describe join concepts and syntax
  • Write queries that use inner and outer joins
  • Write queries that use cross joins
  • Write queries that use self joins
  • Understand what subqueries are
  • Use scalar or multi-valued subqueries
  • Use self-contained or correlated subqueries
  • Categorize built-in functions
  • Use scalar functions
  • Use ranking and rowset functions
  • Use aggregate functions
  • Summarize data with GROUP BY
  • Filter groups with HAVING
  • Insert data into a table
  • Generate automatic values
  • Update data in a table
  • Delete data from a table
  • Merge data based on multiple tables

Content

1. Introduction to Transact-SQL

This module provides an introduction to relational databases, the SQL language and Transact-SQL. You will learn what kinds of statements make up the SQL language and look at the SELECT statement in detail.

Click here to know more

2. Sort and filter results in T-SQL

Learn how to sort and filter query results

Click here to know more

3. Combine multiple tables with JOINs in T-SQL

Explore T-SQL queries accessing data from multiple tables with various kinds of JOIN operations.

Click here to know more

4. Write Subqueries in T-SQL

Learn how to use subqueries to combine multiple SELECT statements and compose nested queries.

Click here to know more

5. Use built-in functions and GROUP BY in Transact-SQL

Learn how to use functions in Transact-SQL, and how to group aggregated results.

Click here to know more

6. Modify data with T-SQL

Learn how to use Transact-SQL to insert, update, and delete data in a database.

Click here to know more

Audience

This course can be valuable for anyone who needs to write basic SQL or Transact-SQL queries. This includes anyone working with data as a data analyst, a data engineer, a data scientist, a database administrator or a database developer. It can also be useful for others peripherally involved with data, or wanting to learn more about working with data such as solution architects, students and technology managers.

Prerequisites

N/A

Certification

product-certification
This course is not associated with any Certification.

Course Benefits

product-benefits
  • Career growth
  • Broad Career opportunities
  • Worldwide recognition from leaders
  • Up-to Date technical skills
  • Popular Certification Badges

Microsoft Popular Courses

ms-700t00

The Managing Microsoft Teams course is designed for those aspiring to be Microsoft 365 Teams Administrators to deploy, configure and manage Office 365 workloads

az-900t00

This course is a high-level overview of Azure. The course will provide foundational level knowledge of cloud services and how those services are provided with M

sc-900t00

This course provides foundational level knowledge on security, compliance, and identity concepts and related cloud-based Microsoft solutions.

mb-335t00

MB-335T00 is a course code that refers to a specific training program or course offered by Microsoft. Unfortunately, as of my knowledge cutoff in September 2021
Enquire Now
 
 
 
 
vUAYQH
By clicking "Submit", I agree to the Terms Of Use and Privacy Policy