Querying Data With Microsoft Transact-SQL DP080 | SQL Server Training in Hamilton

Querying Data with Microsoft Transact-SQL DP080 Course Outline

Module 1: Introduction to Transact-SQL

• Introduction
• Work with Schemas
• Explore the Structure of SQL Statements
• Examine the SELECT Statement
• Work with Data Types
• Handle NULLs
• Exercise - Work with SELECT Statements

Module 2: Sort and Filter Results in T-SQL

• Introduction
• Sort Your Results
• Limit the Sorted Results
• Page Results
• Remove Duplicates
• Filter Data with Predicates
• Exercise - Sort and Filter Query Results

Module 3: Combine Multiple Tables with JOINs in T-SQL

• Introduction
• Understand Joins Concepts and Syntax
• Use Inner Joins
• Use Outer Joins
• Use Cross Joins
• Use Self Joins
• Exercise - Query Multiple Tables with Joins

Module 4: Write Subqueries in T-SQL

• Introduction
• Understand Subqueries
• Use Scalar or Multi-Valued Subqueries
• Use Self-Contained or Correlated Subqueries
• Exercise - Use Subqueries

Module 5: Use Built-In Functions and GROUP BY in Transact-SQL

• Introduction
• Categorise Built-In Functions
• Use Scalar Functions
• Use Ranking and Rowset Functions
• Use Aggregate Functions
• Summarise Data with GROUP BY
• Filter Groups with HAVING
• Exercise - Use Built-In Functions

Module 6: Modify Data with T-SQL

• Introduction
• Insert Data
• Generate Automatic Values
• Update Data
• Delete Data
• Merge Data Based on Multiple Tables
• Exercise - Modify Data

Who should attend this Querying Data with Microsoft Transact-SQL DP080 Course?

This Querying Data with Microsoft Transact-SQL DP080 Training Course is designed for individuals who want to develop proficiency in querying and manipulating data using the Transact-SQL language within Microsoft SQL Server. This training course is especially beneficial for the following professionals:

• Database Developers
• Database Administrators
• Data Analysts
• Data Engineers
• IT Administrators
• DevOps Engineers
• Business Analysts

Prerequisites of the Querying Data with Microsoft Transact SQL DP080 Course

There are no formal prerequisites for this Querying Data with Microsoft Transact SQL DP080 Training Course. However, basic familiarity with database concepts and SQL concepts would be beneficial for the delegates.

Querying Data with Microsoft Transact-SQL DP080 Training Course Overview

The Querying Data with Microsoft Transact-SQL DP080 Training Course provides a comprehensive introduction to querying data using Transact-SQL, the primary language used to manage and manipulate data in Microsoft SQL Server. This course is essential for anyone looking to understand the foundations of database querying, crucial for roles in Database Management, Data Analysis, and Software Development.

Proficiency in Transact-SQL is vital for professionals such as Database Administrators, Data Analysts, and Software Developers. Mastery of this language allows these professionals to efficiently query and manage data, ensuring data integrity and optimising database performance. By developing these skills, individuals can significantly enhance their career prospects in data-driven environments.

This 2-day training course equips delegates with the essential skills needed to query data using Microsoft Transact-SQL. Through a combination of theoretical knowledge and practical exercises, participants will learn to write efficient queries, retrieve and manipulate data, and understand key concepts such as joins, subqueries, and functions. This course ensures that delegates can confidently apply Transact-SQL in real-world scenarios.

Course Objectives

• To understand the fundamentals of Transact-SQL
• To learn how to write basic and advanced SQL queries
• To retrieve data from single and multiple tables
• To use filtering and sorting techniques to refine query results
• To implement joins to combine data from multiple tables
• To apply aggregate functions to summarise data

After completing the course, delegates will be proficient in writing and executing Transact-SQL queries, capable of retrieving and manipulating data efficiently, and prepared to apply these skills in real-world scenarios to enhance their professional capabilities.

What’s included in this Querying Data with Microsoft Transact SQL DP080 Course?

• World-Class Training Sessions from Experienced Instructors
• Querying Data with Microsoft Transact SQL DP080 Certificate
• Digital Delegate Pack