Querying Data with Microsoft Transact-SQL (DP-080T00)
This Querying Data with Microsoft Transact-SQL training class teaches 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.
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.
- 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.
Public expert-led online training from the convenience of your home, office or anywhere with an internet connection. Guaranteed to run .
Private classes are delivered for groups at your offices or a location of your choice.
Webucator is a Microsoft Certified Partner for Learning Solutions (CPLS). This class uses official Microsoft courseware and will be delivered by a Microsoft Certified Trainer (MCT).
- Introduction to Transact-SQL
- Work with schemas
- Explore the structure of SQL statements
- Examine the SELECT statement
- Work with data types
- Handle NULLs
- Sort and filter results in T-SQL
- Sort your results
- Limit the sorted results
- Page results
- Remove duplicates
- Filter data with predicates
- Combine multiple tables with JOINs in T-SQL
- Understand joins concepts and syntax
- Use inner joins
- Use outer joins
- Use cross joins
- Use self joins
- Write Subqueries in T-SQL
- Understand subqueries
- Use scalar or multi-valued subqueries
- Use self-contained or correlated subqueries
- Use built-in functions and GROUP BY in Transact-SQL
- Categorize built-in functions
- Use scalar functions
- Use ranking and rowset functions
- Use aggregate functions
- Summarize data with GROUP BY
- Filter groups with HAVING
- Modify data with T-SQL
- Insert data
- Generate automatic values
- Update data
- Delete data
- Merge data based on multiple tables
Each student will receive a comprehensive set of materials, including course notes and all the class examples.
Experience in the following is required for this Microsoft SQL Server class:
- Working knowledge of relational databases.
- Basic knowledge of the Microsoft Windows operating system and its core functionality.
$1,269.10 / student
Request a Private Class
- Private Class for your Team
- Online or On-location
- Customizable
- Expert Instructors