Course Date | Start Time | End Time | Time Zone | Location | Days | Price | |
---|---|---|---|---|---|---|---|
Nov 25, 2024 | 09:00 | 05:00 | EST | Live Virtual Class | 2 | $1,190 USD | Purchase |
Querying Data with Microsoft Transact-SQL
This course will teach you how to use Transact-SQL to query and modify 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 Days
Audience
- Individuals who need to write basic SQL or Transact-SQL queries: Data Analysts, Data Engineers, Data Scientists, Database Administrators and Database Developers
- Individuals peripherally involved with data, or wanting to learn more about working with data such as Solution Architects, students, and Technology Managers
Learning Objectives
- 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 return data values
- Create groups of data and aggregate the results
- Modify data with Transact-SQL using INSERT, UPDATE, DELETE and MERGE
Topics
- Getting Started with Transact-SQL
- Sorting and Filtering Query Results
- Using Joins and Subqueries
- Using Built-in Functions
- Modifying Data