CLS
Data Management

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

Querying Data with Microsoft Transact-SQL covers writing queries, filtering and sorting data, joining tables and using built-in functions to retrieve and manipulate data efficiently.

Total Duration
16 Hours
Level
Beginner
Category
Data Management
Partner
Microsoft
About this course

About this course

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, Azure Synapse Analytics, and Microsoft Fabric.

Target Audience

Data Engineers who need to have a good understanding of T-SQL and relational database querying.
IT Professionals moving into database development and administration.
Database Administrators who wish to improve their skills with Microsoft SQL Server and T-SQL
IT Professionals who are transitioning to the field of database development and administration.
SQL Developers who must write efficient queries and maintain relational data.
Anyone who needs to write basic SQL or Transact-SQL queries.

Prerequisites

Familiarity with working with tables of data

Course Outline

  • 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 Row set 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
Learning outcomes

What you'll learn

Execute SELECT statements using Transact-SQL to retrieve precise data sets from relational databases.
Construct queries using WHERE clauses and ORDER BY to filter and sort result sets for effective data analysis.
Implement INNER and OUTER JOINs to combine data from multiple tables for comprehensive reporting.
Write SELECT statements to retrieve columns from one or more tables
Combine data from multiple tables using JOIN operations
Understand database objects such as tables, views, and schemas
Sort and filter selected data

Skills you'll learn

7 skills
T-SQL Querying
Filtering and Sorting
Data and Views
Transaction Management
Data Types Management
Database Programming
Query Optimization

Certificate

  • Attendance Certificate from CLS Learning Solutions
  • This course enables you to pass DP-080T00: Querying Data with Microsoft Transact-SQL
DP-080T00: Querying Data with Microsoft Transact-SQL

Potential Career Paths

SQL Developer
Database Developer
Data Analyst
Business Intelligence Analyst
Data Engineer
BI Developer