Integrate SQL solutions with Azure services
Intermediate
Developer
Database Administrator
Azure SQL Database
SQL Server
Create REST and GraphQL APIs for SQL databases using Data API Builder, deploy to Azure hosting services, and implement monitoring and event-driven change patterns.
Learning objectives
By the end of this module, you'll be able to:
- Create configuration files for Data API Builder with database connections and runtime settings
- Define entities for REST and GraphQL with field mappings, caching, and relationships
- Configure REST and GraphQL endpoints with custom paths and operations
- Expose database views, stored procedures, and GraphQL relationships
- Explore deployment options for Data API Builder, including Azure Container Apps, App Service, and Static Web Apps
- Set up Azure Monitor configurations with Application Insights and Log Analytics
- Handle database changes using Change Data Capture, Azure Functions, and Change Event Streaming
Prerequisites
- Experience with SQL Server, Azure SQL Database, or SQL databases in Microsoft Fabric
- Familiarity with T-SQL for creating tables, views, and stored procedures
- Basic understanding of REST APIs and JSON
- Access to an Azure subscription for deployment exercises