SQL Training Courses
| 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-203T00 - Data Engineering on Microsoft Azure | In this course, the student will learn how to implement and manage data engineering workloads on Microsoft Azure, using Azure services such as Azure Synapse Analytics, Azure Data Lake Storage Gen2, Azure Stream Analytics, Azure Databricks, and others. The course focuses on common data engineering tasks such as orchestrating data transfer and transformation pipelines, working with data files in a data lake, creating and loading relational data warehouses, capturing and aggregating streams of real-time data, and tracking data assets and lineage. |
| 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. |
| DP-600T00 - Microsoft Fabric Analytics Engineer | This course covers methods and practices for implementing and managing enterprise-scale data analytics solutions using Microsoft Fabric. Students will build on existing analytics experience and will learn how to use Microsoft Fabric components, including lakehouses, data warehouses, notebooks, dataflows, data pipelines, and semantic models, to create and deploy analytics assets.
This course is best suited for those who have expertise in using Power BI for data transformation, modeling, visualization, and sharing. Also, learners should have prior experience in building and deploying data analytics solutions at the enterprise level. |
| 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 visualization tools. With hands-on exercises, this course enhances financial data retrieval, aggregation, and visualization, 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. |