Develop data-driven applications by using Azure SQL Database (DP-3020)

This hands-on course teaches developers and solution architects how to build, deploy, and secure data-driven applications using Azure SQL Database. Learn how to create and configure databases, automate deployment with CI/CD pipelines, and develop APIs using Azure services. Gain practical experience in data manipulation, security best practices, and integrating external data sources to enhance your application’s performance and resilience. Develop data-driven applications by using Azure SQL Database (DP-3020) Benefits In this course, you will: Learn to develop and deploy cloud-based applications using Azure SQL Database. Automate database publishing with GitHub Actions and Azure DevOps. Create REST and GraphQL-based APIs with Azure Data API Builder. Import and export data using RESTful endpoints and Azure Functions. Implement security best practices, including authentication, managed identities, and advanced data security. Prerequisites Experience using the Azure portal to create resources. Basic knowledge of security concepts like identities, permissions, and encryption. Basic knowledge of networking concepts like virtual networks, subnetting, and hybrid scenarios. Basic knowledge of Azure Policy and Azure Arc concepts. Develop Data-Driven Apps with Azure SQL Training Outline Learning Objectives Module 1: Get Started with Azure SQL Database for Modern Application Development Overview of deployment options and Hyperscale capabilities. Understanding the serverless compute tier. Enabling application resilience with Azure SQL Database. Exploring AI capabilities for Azure SQL Database. Module 2: Develop for Azure SQL Database Creating and configuring an Azure SQL Database. Using SQL Database Projects for development. Automating database deployment with GitHub Actions and Azure DevOps. Securing and monitoring CI/CD pipelines. Module 3: Develop a Data API for Azure SQL Database Introduction to Azure Data API Builder for REST and GraphQL endpoints. Developing a data API using Azure Static Web Apps. Deploying a data API with Azure Web App for Containers. Module 4: Explore Data Manipulation Options in Azure SQL Database Importing data using RESTful endpoints. Manipulating data with Azure Functions. Exploring data movement tools for automation and integration. Module 5: Explore Security Practices for Azure SQL Database Authentication methods and configuring managed identities. Implementing firewall rules and advanced data security. Securing access and monitoring database security threats.