DP-080T00: Querying Data with Transact-SQL

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

25 Ιουν 2024 18:15 04 Ιουλ 2024 21:30 OnLine Virtual Classroom
Ελληνικά
12 ώρες ( 4 μέρες )
anad greek logo
DP-080T00: Querying Data with 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.

Enroll now and take the first step towards becoming a master of T-SQL. Don’t miss this opportunity to expand your knowledge and skills in one of the most essential and widely-used data querying languages.

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

Course Content

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


Course Benefits

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

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

  • € 550.00
  • € 240.00
  • € 0.00
  • € 310.00
  • € 310.00

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

  • € 550.00
  • € 120.00
  • € 81.70
  • € 430.00
  • € 511.70

Κοστολογικές Πληροφορίες

For a person not eligible for the subsidy, we offer a discounted price of €430 (installments accepted x2 or x 3).

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

Τρίτη - 25 Ιουν 2024

Ώρα

18:15 - 21:30

Τοποθεσία:

OnLine Virtual Classroom

Πέμπτη - 27 Ιουν 2024

Ώρα

18:15 - 21:30

Τοποθεσία:

OnLine Virtual Classroom

Τρίτη - 02 Ιουλ 2024

Ώρα

18:15 - 21:30

Τοποθεσία:

OnLine Virtual Classroom

Πέμπτη - 04 Ιουλ 2024

Ώρα

18:15 - 21:30

Τοποθεσία:

OnLine Virtual Classroom

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

Σεμινάρια στην ίδια κατηγορία από τον ίδιο διοργανωτή
PCAP - Certified Associate in Python Programming Certification...

Welcome to the PCAP Certification Course – Your Gateway to Mastering Python Programming! Are you interested in pursuing a career in Python programming? Do yo...

19/05/2025 18:00

60.00 ώρες (20 μέρες)

Ελληνικά

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

Live Online

FortiSwitch Administrator...

In this course, you will learn how to use the most common FortiSwitch features. Through interactive labs, you will explore VLAN configurations, link aggregation...

20/05/2025 18:00

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

Ελληνικά

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

Live Online

Microsoft Certified: Windows Server Hybrid Administrator Associate...

Are you looking to enhance your expertise in configuring and managing Windows Server on-premises, hybrid, and infrastructure as a service (IaaS) platform worklo...

28/05/2025 18:00

42.00 ώρες (14 μέρες)

Ελληνικά

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

Live Online

ISO/IEC 27001 Information Security Management System (ISMS)...

The ISO/IEC 27001 Information Security course is a comprehensive program designed to provide participants with a deep understanding of the international standar...

02/06/2025 18:00

28.00 ώρες (9 μέρες)

Αγγλικά

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

Live Online

LINUX Professional Institute-LPIC1...

The Linux Professional Institute LPIC-1 course is designed to impart comprehensive knowledge and skills essential for proficient Linux system administration. Pa...

02/06/2025 18:30

90.00 ώρες (30 μέρες)

Ελληνικά

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

Live Online