ΠΕΡΙΓΡΑΦΗ

Are you looking to master the art of querying data using Microsoft Transact-SQL? Look no further than Course DP-080T00, the ultimate course for data professionals who want to learn how to use T-SQL to retrieve and manipulate data.

Our course is designed to help you become proficient in all aspects of T-SQL, including data querying, data filtering, data sorting, and data aggregation. With our expert instructors and cutting-edge curriculum, you’ll learn the latest techniques and best practices for working with T-SQL.

Course DP-080T00 is a comprehensive 12-hour course that covers everything from the basics of T-SQL to advanced topics such as stored procedures, functions, and transactions. With hands-on labs and real-world scenarios, you’ll gain practical experience working with T-SQL in a real-world setting.

ΣΚΟΠΟΣ ΣΕΜΙΝΑΡΙΟΥ

During the course, you’ll benefit from:

• 12 hours of instructor-led training
• Interactive learning sessions
• Real-life case studies and examples
• Hands-on coding exercises
• Certification exam preparation material
• Dedicated support from expert trainers
• Access to recordings of all training sessions for future reference

At the end of the course, you’ll receive a Microsoft certificate of attendance, which will demonstrate your mastery of T-SQL and help you advance your career.

ΠΕΡΙΣΣΟΤΕΡΕΣ ΠΛΗΡΟΦΟΡΙΕΣ

Course Cariculum

Module 1: Introduction to Transact-SQL

• Understanding Transact-SQL Syntax
• Understanding Transact-SQL Constructs
• Understanding Transact-SQL Data Types

Module 2: Querying Tables with SELECT

• Retrieving Data with SELECT
• Filtering Data with WHERE
• Sorting Data with ORDER BY
• Joining Tables with INNER JOIN
• Joining Tables with OUTER JOIN

Module 3: Filtering and Grouping Data with Transact-SQL

• Grouping Data with GROUP BY
• Filtering Grouped Data with HAVING
• Filtering Data with TOP and OFFSET-FETCH
• Using SET Operators
• Using Subqueries

Module 4: Querying Data with Advanced Transact-SQL Components

• Creating and Using Views
• Creating and Using User-Defined Functions
• Creating and Using Stored Procedures
• Creating and Using Triggers
• Creating and Using Transactions

Module 5: Enhancing Queries with Advanced Transact-SQL Components

• Implementing Error Handling
• Implementing Transactions
• Using Pivot and Unpivot Operators
• Using the APPLY Operator
• Querying JSON Data

The course includes the following

• Online participation in all modules of first-class training
• Module recordings in your personal account (1-year access)
• Personal Microsoft Certificate at the end of the course