![](https://www.myseminars.com.cy/storage/app/media/AA-KEK-Logos/SCP-LOGO-2.png)
Course DP-080T00: Querying Data with Microsoft Transact-SQL
- Πληροφορική - Επαγγελματίες IT
21 Οκτ 2024 06:14
04 Νοε 2024 06:14
Αγγλικά
12 ώρες
(
4 μέρες
)
![anad greek logo](https://www.myseminars.com.cy/storage/app/media/hrda%20logo.jpg)
ΠΕΡΙΓΡΑΦΗ
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
Αναλυτικό Κόστος Σεμιναρίου
Για Δικαιούχους ΑνΑΔ
- € 550.00
- € 240.00
- € 0.00
- € 310.00
Για μη-Δικαιούχους ΑνΑΔ
- € 550.00
- € 120.00
- € 81.70
- € 430.00
Κοστολογικές Πληροφορίες
For a person not eligible for the subsidy, we offer a discounted price of €430 (installments accepted x2 or x 3).
ΠΡΟΓΡΑΜΜΑ ΣΕΜΙΝΑΡΙΟΥ
Δευτέρα - 21 Οκτ 2024
Τοποθεσία:
OnLine Virtual Classroom
Τετάρτη - 23 Οκτ 2024
Τοποθεσία:
OnLine Virtual Classroom
Τετάρτη - 30 Οκτ 2024
Τοποθεσία:
OnLine Virtual Classroom
Δευτέρα - 04 Νοε 2024
Τοποθεσία:
OnLine Virtual Classroom