| Name | Description |
| DP-300T00 - Administering Microsoft Azure SQL Solutions |
This course provides students with the knowledge and skills to administer a SQL Server database infrastructure for cloud, on-premises and hybrid relational databases and who work with the Microsoft PaaS relational database offerings. Additionally, it will be of use to individuals who develop applications that deliver content from SQL-based relational databases. |
| DP-601T00 - Implementing a Lakehouse with Microsoft Fabric |
This course is designed to build your foundational skills in data engineering on Microsoft Fabric, focusing on the Lakehouse concept. This course will explore the powerful capabilities of Apache Spark for distributed data processing and the essential techniques for efficient data management, versioning and reliability by working with Delta Lake tables. This course will also explore data ingestion and orchestration using Dataflows Gen2 and Data Factory pipelines. This course includes a combination of lectures and hands-on exercises that will prepare you to work with lakehouses in Microsoft Fabric. |
| SQL for Finance professionals |
This focused course equips finance professionals with practical SQL skills for data analysis and reporting. Participants will learn SQL fundamentals, connect Excel to cloud databases, write tailored financial queries and use Excel's data modelling and visualisation tools. With hands-on exercises, this course enhances financial data retrieval, aggregation and visualisation, making data-driven decision-making more efficient.
The course structure ensures that finance professionals gain practical SQL skills applicable to their daily tasks, enhancing their data analysis and reporting capabilities.
|
| Develop AI-enabled database solutions (DP-800T00) |
This course provides the knowledge and skills to design and develop AI enabled database solutions across Microsoft SQL platforms, including SQL Server, Azure SQL and SQL databases in Microsoft Fabric. It is intended for professionals who build modern data solutions that integrate structured and semi-structured data and incorporate AI features into scalable enterprise applications. It will also be valuable for individuals who develop applications that rely on SQL based data services enhanced with vector search, embeddings and other AI driven capabilities. |