Course DP-080T00: Querying Data with Microsoft Transact-SQL

- Πληροφορική - Επαγγελματίες IT

24 Ιουν 2025 18:00 15 Ιουλ 2025 21:15 OnLine Virtual Classroom
Αγγλικά
21 ώρες ( 7 μέρες )
anad greek logo
Course DP-080T00: Querying Data with Microsoft Transact-SQL

ΠΕΡΙΓΡΑΦΗ

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
Αναλυτικό Κόστος Σεμιναρίου

Για Δικαιούχους ΑνΑΔ

  • € 750.00
  • € 420.00
  • € 0.00
  • € 330.00
  • € 330.00

Για μη-Δικαιούχους ΑνΑΔ

  • € 750.00
  • € 296.00
  • € 86.26
  • € 454.00
  • € 540.26
ΠΡΟΓΡΑΜΜΑ ΣΕΜΙΝΑΡΙΟΥ

Τρίτη - 24 Ιουν 2025

Ώρα

18:00 - 21:15

Τοποθεσία:

OnLine Virtual Classroom

Τρίτη - 15 Ιουλ 2025

Ώρα

18:00 - 21:15

Τοποθεσία:

OnLine Virtual Classroom

Εκδήλωση Ενδιαφέροντος : Course DP-080T00: Querying Data with Microsoft Transact-SQL

Σεμινάρια στην ίδια κατηγορία από τον ίδιο διοργανωτή
Course DP-080T00: Querying Data with Microsoft Transact-SQL...

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 professiona...

24/06/2025 18:00

21.00 ώρες (7 μέρες)

Αγγλικά

Επιχορηγημένο-ΑνΑΔ

Live Online

DORA Ready: AI-Enhanced Digital Resilience in Financial Institutions (...

DORA Ready: AI-Enhanced Digital Resilience in Financial Institutions is a highly specialized training program designed to equip professionals in the financial s...

01/07/2025 18:00

18.00 ώρες (4 μέρες)

Αγγλικά

Επιχορηγημένο-ΑνΑΔ

OnLine Virtual Classroom

Artificial Intelligence for Business...

This course provides a practical introduction to artificial intelligence (AI) for business professionals, focusing on real-world applications to improve decisio...

10/07/2025 18:00

14.00 ώρες (5 μέρες)

Αγγλικά

Επιχορηγημένο-ΑνΑΔ

Live Online