| Course Name |
Hours |
List Price |
Content |
| DP-080T00: Querying Data with Microsoft Transact-SQL |
14.00 |
$1,159.00 |
|
Description: This course will teach the basics of Microsofts 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.
Audience Profile
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.
# of Days:
Setting:
|
| DP-3001: Migrate SQL Server Workload to Azure SQL |
7.00 |
$579.00 |
|
Description: This course prepares you for the task of migrating SQL Server workloads to Azure SQL Database.
Youll learn how to assess SQL Server components and compatibility for migration using the Azure SQL Migration Extension and Database Migration Assistant. This training guides you through the process of provisioning and configuring Azure SQL Database resources. You gain hands-on experience in choosing the best migration option to meet business requirements for downtime, handling migration state, and monitoring database migration.
Additionally, youll also learn to perform post-migration tasks like disaster recovery and monitoring for Azure SQL Database. These skills are essential for ensuring a smooth, efficient transition to Azure SQL Database, and maintaining its operation post-migration.
# of Days:
Setting:
|
| DP-3020: Develop data-driven applications with Azure SQL Database |
7.00 |
$579.00 |
|
Description: This course prepares you for the task of developing data-driven applications by using Microsoft Azure SQL Database.
Youll learn how to create and configure an Azure SQL Database, build and deploy database projects using GitHub Actions and Azure Pipelines, and automate the publishing process. Additionally, youll explore how to use Data API builder for Azure SQL Database and develop a data API with Azure Web Apps and Static Web App.
Furthermore, youll gain skills in importing data via an external REST endpoint, exporting data using an Azure Function, and securing an Azure SQL Database. These essential skills will empower you to effectively develop and manage applications using Azure SQL Database.
# of Days:
Setting:
|
| DP-800T00: Develop AI-enabled database solutions |
28.00 |
$2,399.00 |
|
Description: This course provides students with 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.
# of Days:
Setting:
|