DP-080T00 : Querying Data with Microsoft Transact-SQL
This course will teach the basics of Microsoft’s dialect of the standard SQL language: Transact-SQL. Topics include both querying and modifying data in relational databases that are hosted in Microsoft SQL Server-based database systems, including: Microsoft SQL Server, Azure SQL Database and, Azure Synapse Analytics.
The duration of the program :
Classroom |
Live Online |
|
This course can be valuable for anyone who needs to write basic 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.
· MODULE Introduction to Transact-SQL
· MODULE Sort and filter results in T-SQL
· MODULE Combine multiple tables with JOINs in T-SQL
· MODULE Write Subqueries in T-SQL
· MODULE Use built-in functions and GROUP BY in Transact-SQL
· MODULE Modify data with T-SQL
No available
· Basic knowledge of the Microsoft Windows operating system and its core functionality.
· Working knowledge of relational databases.
| Location | Date | Time (UTC+2 ) | Delivery Format | Language |
|---|---|---|---|---|
| Live Online* | 25,27-Nov & 2,4-Dec | Mon, Wed 17:30-20:45 | Instructor Led | Greek |
* Σύγχρονη εξ αποστάσεως εκπαίδευση με εισηγητή – Virtual Class
Last update : 27/12/2023 (DP-080T00)
