DP-180 : Advanced Quering Data with Microsoft TRansact-SQL
This course will teach the advanced skills of Microsoft’s dialect of the standard SQL language.
The duration of the program :
Classroom |
Live Online |
|
This course can be valuable for anyone who needs to write SQL or Transact-SQL queries. This includes anyone working with data as a data analyst, a data engineer, a data scientist, a database administrator or a database developer. It can also be useful for others peripherally involved with data, or wanting to learn more about working with data such as solution architects, students and technology managers.
· SQL Server data types
· Create and Modify Tables
· Create and Modify Rows
· Create queries that use table expressions
· Use UNION, INTERSECT, EXCEPT and APPLY on multiple sets of data
· Implement window functions in queries
· Use PIVOT and grouping sets in queries
· Create and use Views, Stored Procedures and Functions
No available
| Location | Date | Time (UTC+2 ) | Delivery Format | Language |
|---|---|---|---|---|
| Live Online* | On hold | – | Instructor Led | Greek |
* Σύγχρονη εξ αποστάσεως εκπαίδευση με εισηγητή – Virtual Class
Last update : 22/08/2024 (DP-180)
