|
Querying Data with Microsoft Transact-SQL (DP-080T00) (replacing 20761)
Code:
MDP-080T00
Duration:
2 Day
|
$1545
USD
|
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.
Elite Total Access Collection for Microsoft
Access this course and thousands of others for only $2,999.
Microsoft Azure Certification Video
This course is available in the following formats:
Duration: 2 Day
Duration: 2 Day
|
Delivery Format: Virtual Classroom
|
$ 1545 |
|
|
Delivery Format: Virtual Classroom
|
$ 1545 |
|
|
Delivery Format: Virtual Classroom
|
$ 1545 |
|
|
Delivery Format: Virtual Classroom
|
$ 1545 |
Students will learn to,
- Introduction to Transact-SQL
- Sort and filter results in T-SQL
- Combine multiple tables with JOINs in T-SQL
- Write Subqueries in T-SQL
- Use built-in functions and GROUP BY in Transact-SQL
- Modify data with T-SQL
Module 1: Introduction to Transact-SQL
- Understand what SQL is for
- Identify database objects in schemas
- Identify SQL statement types
- Use the SELECT statement
- Work with data types
- Handle NULLs
Module 2: Sort and filter results in T-SQL
- Sort your results
- Limit the sorted results
- Return paged results
- Remove duplicates
- Filter data with predicates
Module 3: Combine multiple tables with JOINs in T-SQL
- 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
Module 4: Write Subqueries in T-SQL
- Understand what subqueries are
- Use scalar or multi-valued subqueries
- Use self-contained or correlated subqueries
Module 5: 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
Module 6: Modify data with T-SQL
- Insert data into a table
- Generate automatic values
- Update data in a table
- Delete data from a table
- Merge data based on multiple tables
Module 1: Introduction to Transact-SQL
- Understand what SQL is for
- Identify database objects in schemas
- Identify SQL statement types
- Use the SELECT statement
- Work with data types
- Handle NULLs
Module 2: Sort and filter results in T-SQL
- Sort your results
- Limit the sorted results
- Return paged results
- Remove duplicates
- Filter data with predicates
Module 3: Combine multiple tables with JOINs in T-SQL
- 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
Module 4: Write Subqueries in T-SQL
- Understand what subqueries are
- Use scalar or multi-valued subqueries
- Use self-contained or correlated subqueries
Module 5: 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
Module 6: Modify data with T-SQL
- Insert data into a table
- Generate automatic values
- Update data in a table
- Delete data from a table
- Merge data based on multiple tables
- Lab : Get started with SQL Server query tools and writing queries in T-SQL
- Lab : Sort and filter data returned by SELECT queries
- Lab : Write queries with JOIN operations
- Lab : Write SELECT statements using subqueries
- Lab : Built-in functions
- Lab : Modify data
- Lab : Get started with SQL Server query tools and writing queries in T-SQL
- Lab : Sort and filter data returned by SELECT queries
- Lab : Write queries with JOIN operations
- Lab : Write SELECT statements using subqueries
- Lab : Built-in functions
- Lab : Modify data
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.