Querying Data with Microsoft Transact-SQL

Course Description:

The DP-080: Querying Data with Microsoft Transact-SQL course introduces participants to the fundamentals of querying and managing data in Microsoft SQL Server and Azure SQL environments. This course provides a comprehensive overview of the Transact-SQL (T-SQL) language, focusing on its practical applications for querying, manipulating, and analyzing data.
Through hands-on labs and real-world examples, participants will learn how to write complex queries, retrieve and filter data, implement joins, work with functions, and manage data using T-SQL. The course is ideal for learners preparing for roles in database development, data analysis, or data engineering.
By the end of the course, participants will be able to:
1. Understand the structure and functionality of Microsoft SQL databases.
2. Write and execute basic to advanced T-SQL queries.
3. Retrieve, filter, and sort data using SELECT statements and WHERE clauses.
4. Use joins to combine data from multiple tables.
5. Work with T-SQL functions, including aggregate and scalar functions.
6. Implement subqueries, Common Table Expressions (CTEs), and views.
7. Modify and manage data using INSERT, UPDATE, DELETE, and MERGE statements.

Prerequisites:

This course is designed for beginners but assumes a basic understanding of database concepts. Recommended prerequisites include:
1. Familiarity with relational database concepts such as tables, relationships, and schemas.
2. Basic understanding of general IT concepts.
3. Interest in data querying and database management.

Audience Profile:

This course is ideal for:
1. Database Developers: Professionals building applications that query and manipulate data in SQL Server.
2. Data Analysts: Individuals analyzing data and writing queries for reporting and insights.
3. Data Engineers: Those involved in preparing and managing data for analytics and operations.
4. IT Professionals: Team members supporting SQL Server or Azure SQL databases.
5. Students and Beginners: Aspiring data professionals looking to learn T-SQL for career development.

Course Duration: 16 hours