Address
Level 8/25 Restwell Street, Bankstown NSW 2200, Australia
Business Hours
Monday to Friday: 10AM - 6PM
Weekend: CLOSED
DP-080T00: Query and modify data with Transact-SQL
Learn to work confidently with data using Transact-SQL. This beginner-friendly, self-paced course teaches you how to write T-SQL queries to retrieve, filter, sort, join and summarise data, use subqueries and built-in functions, and insert, update and delete data in Microsoft SQL Server and Azure SQL databases. It’s ideal for anyone new to SQL, including analysts, developers and database professionals.
Duration
16 hours (2 days)
Modules
6 Modules
Course type
Microsoft
Course Overview
This beginner-level course introduces learners to Transact-SQL (T-SQL), Microsoft’s implementation of the SQL standard. Participants will learn how to query and modify data in relational databases hosted on Microsoft SQL Server, Azure SQL Database, Azure Synapse Analytics, and Microsoft Fabric. The course is ideal for anyone working with data or interested in learning SQL fundamentals.
Before You Begin
- Basic understanding of data and databases
- Familiarity with general IT or computing concepts
- No prior SQL experience required
- Interest in data analysis or database management
Key outcomes
- Query & Join Data Use SELECT and JOIN to retrieve related data.
- Modify SQL Records Apply INSERT, UPDATE, DELETE to manage database entries.
- Filter & Sort Results Use WHERE and ORDER BY for refined queries.
- Work with Azure SQL Understand T-SQL and manage cloud-hosted environments.
Tools you’ll use
SQL Server Management Studio (SSMS)
Azure Data Studio
Azure SQL Database
Azure Synapse Analytics
Skills you’ll gain
- SQL Query Writing
- Data Modification Techniques
- Table Join Operations
- Data Filtering Logic
- Azure SQL Usage
- Synapse Environment Navigation
- Relational Structure Understanding
- Database Interaction Skills
What You’ll Learn
6 modules
1Module 1: Introduction to Transact-SQL
1.1 Introduction
1.2 Work with schemas
1.3 Explore the structure of SQL statements
1.4 Examine the SELECT statement
1.5 Work with data types
1.6 Handle NULLs
1.7 Summary
1.2 Work with schemas
1.3 Explore the structure of SQL statements
1.4 Examine the SELECT statement
1.5 Work with data types
1.6 Handle NULLs
1.7 Summary
2Module 2: Sort and Filter Results in T-SQL
2.1 Introduction
2.2 Sort your results
2.3 Limit the sorted results
2.4 Page results
2.5 Remove duplicates
2.6 Filter data with predicates
2.7 Summary
2.2 Sort your results
2.3 Limit the sorted results
2.4 Page results
2.5 Remove duplicates
2.6 Filter data with predicates
2.7 Summary
3Module 3: Combine Multiple Tables with JOINs in T-SQL
3.1 Introduction
3.2 Understand joins concepts and syntax
3.3 Use inner joins
3.4 Use outer joins
3.5 Use cross joins
3.6 Use self joins
3.7 Summary
3.2 Understand joins concepts and syntax
3.3 Use inner joins
3.4 Use outer joins
3.5 Use cross joins
3.6 Use self joins
3.7 Summary
4Module 4: Write Subqueries in T-SQL
4.1 Introduction
4.2 Understand subqueries
4.3 Use scalar or multi-valued subqueries
4.4 Use self-contained or correlated subqueries
4.5 Summary
4.2 Understand subqueries
4.3 Use scalar or multi-valued subqueries
4.4 Use self-contained or correlated subqueries
4.5 Summary
5Module 5: Use Built-in Functions and GROUP BY in Transact-SQL
5.1 Introduction
5.2 Categorize built-in functions
5.3 Use scalar functions
5.4 Use ranking and rowset functions
5.5 Use aggregate functions
5.6 Summarize data with GROUP BY
5.7 Filter groups with HAVING
5.8 Summary
5.2 Categorize built-in functions
5.3 Use scalar functions
5.4 Use ranking and rowset functions
5.5 Use aggregate functions
5.6 Summarize data with GROUP BY
5.7 Filter groups with HAVING
5.8 Summary
6Module 6: Modify Data with T-SQL
6.1 Introduction
6.2 Insert data
6.3 Generate automatic values
6.4 Update data
6.5 Delete data
6.6 Merge data based on multiple tables
6.7 Summary
6.2 Insert data
6.3 Generate automatic values
6.4 Update data
6.5 Delete data
6.6 Merge data based on multiple tables
6.7 Summary
Certification & Credentials
Certificate track
16 hours (2 days)
Target Audience
Intended roles
- Data Analyst
Frequently asked questions
Is this course suitable for complete beginners?
Yes, it’s designed for those new to SQL and databases.
What platforms are covered in the course?
SQL Server, Azure SQL Database, Synapse, and Microsoft Fabric.
Will I learn how to modify data?
Yes, data modification using T-SQL is a key focus.
Are hands-on labs included?
Yes, practical exercises are part of the course.
Can I take this course online?
Yes, both instructor-led and self-paced formats are available.
| Duration | 16 hours (2 days) |
|---|---|
| Modules | 6 Modules |
| Course type | Microsoft |
| Category | Microsoft |
| Intended roles | Data Analyst |
| Prerequisites | Basic understanding of data and databases, Familiarity with general IT or computing concepts, No prior SQL experience required, Interest in data analysis or database management |
Be the first to review “DP-080T00: Query and modify data with Transact-SQL”
Reviews
There are no reviews yet.