1-Day Instructor-Led Training
Microsoft Official Content
Hands On Labs
After-Course Instructor-Coaching Included
#8740
Develop data-driven applications by using Azure SQL Database (DP-3020)
Course 8740
- Duration: 1 day
- Language: English
- Level: Intermediate
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 Apps with Azure SQL Delivery Methods
In-Person
Online
Upskill your whole team by bringing Private Team Training to your facility.
Develop Data-Driven Apps with Azure SQL Course Information
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
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.
Questions about this course?
Customize Your Team Training Experience
Fill out the form below or call 888-843-8733
Need Help Finding The Right Training Solution?
Our training advisors are here for you.
Develop Data-Driven Apps with Azure SQL FAQs
No. Applied Skills credentials are not replacing Certifications. We are expanding our credentialing portfolio to better meet the needs of our learners and customers by allowing people to validate very specific skill sets with this new offering.
Certifications are role-based and evaluate a broader range of skills needed to be successful in critical roles that organizations need to be successful in today’s rapidly changing technical environment.
Applied Skills credentials are scenario-based and evaluate a narrower skill set specific to a critical business problem or challenge that organizations are facing.
If you want to demonstrate that you have the range of skills needed to succeed in a given job role, a Certification is the right way to go. If you want to validate your skills on a specific business problem or scenario your organization faces, an Applied Skills credential will make more sense.
Here are some key differentiators between Certifications and Applied Skills:
- Breadth of skills validated: Certifications typically validate 4-6 skill sets, while Applied Skills validate one specific skill set.
- Focus: Certifications are job role-based, while Applied Skills are product-based.
- Purpose: Certifications are intended to validate skills needed for the technical aspects of job roles that leverage Microsoft solutions and technologies. Applied Skills are intended to validate specific scenarios that may be hindering an organization’s digital transformation goals.
Many of the Applied Skills credentials can be used to help you prepare for Certification exams. Because Applied Skills are awarded based on performance within a lab, that experience may set you up for success on a Certification. All role-based Certification exams require experience, so earning an Applied Skills credential is one way to get some of the experience needed to pass the exam. However, not all skills assessed on a Certification exam will have an associated Applied Skills assessment lab, so you should not rely on Applied Skills alone. Visit how to prepare for a Certification exam.
If you want to demonstrate that you have skill sets that were not assessed by the Certification, are Certification “adjacent,” or are needed for a specific project that you would like to do or are working on. An Applied Skill credential would be a great way to show your employer and peers that you have those skills and the skills validated by your Certification.
It depends on your technical expertise and why you want to earn a Microsoft credential.
If you are exploring technology or just beginning your learning journey in technology, starting with a fundamentals certification makes the most sense because it focuses on ensuring you have the foundational knowledge you need to get started in technology.
If you have experience and want to explore how Microsoft technologies and solutions are used to solve critical business problems, an Applied Skills credential is a great way to validate fundamental world skills focused on specific projects or scenarios.
If you have some experience and are pursuing a job that leverages Microsoft solutions, a role-based certification is the logical solution to validate role-based skills. Note that some Applied Skills credentials relate to our certifications and may provide another way to prepare for a certification exam.