Microsoft Data & Power BI
DP-080T00 Query and modify data with Transact-SQL
Learn to query and modify data with Transact-SQL.
2 daysIntermediate6 modulesDP-080T00
About this course
Learn to query and modify data with Transact-SQL. Over two days you will select, sort and filter data, join tables, write subqueries, use built-in functions, group and aggregate, and insert, update and delete data.
Curriculum
6 modules
- Work with schemas
- Explore the structure of SQL statements
- Examine the SELECT statement
- Work with data types
- Handle NULLs
- Module assessment
- Sort your results
- Limit the sorted results
- Page results
- Remove duplicates
- Filter data with predicates
- Module assessment
- Understand joins concepts and syntax
- Use inner joins
- Use outer joins
- Use cross joins
- Use self joins
- Module assessment
- Understand subqueries
- Use scalar or multi-valued subqueries
- Use self-contained or correlated subqueries
- Module assessment
- 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 assessment
- Insert data
- Generate automatic values
- Update data
- Delete data
- Merge data based on multiple tables
- Module assessment
Who it's for
Analysts, developers and anyone starting with SQL Server or Azure SQL.
Before you start
No formal prerequisites. Bring curiosity and a willingness to practise.
Related courses
More in Microsoft Data & Power BI →Intermediate
55128 Writing Reports with Report Builder and SSRS Level 2
Microsoft Data & Power BI
View course →Intermediate
55232 Writing Analytical Queries for Business Intelligence
Microsoft Data & Power BI
View course →Foundation
55315 Introduction to SQL Databases
Microsoft Data & Power BI
View course →Intermediate55353
Administering a SQL Database Infrastructure (55353)
Microsoft Data & Power BI
View course →IntermediateDP-300 Exam Prep/DP-300T00
Administering Microsoft Azure SQL Solutions (DP-300 Exam Prep/DP-300T00)
Microsoft Data & Power BI
View course →Foundation
Data Analysis using Power BI Desktop - Level 1: Report Builder
Microsoft Data & Power BI
View course →Let's plan your next step together.
Tell us the course or certification you have in mind and we'll send the outline, upcoming dates, fees and private-team options.