Eccentrix - Trainings catalog - Microsoft - Azure - Develop data-driven applications by using Azure SQL Database (DP-3020)

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

This learning path enables you to master the development of data-driven applications with Microsoft Azure SQL Database. You will develop complete expertise in creating and configuring an optimized Azure SQL Database, creating and deploying database projects using GitHub Actions and Azure Pipelines, and advanced automation of the publishing process.

You will also discover how to effectively leverage the Data API builder for Azure SQL Database and how to develop a high-performance Data API with Azure Web Apps and Static Web Apps. Additionally, you will acquire the strategic skills necessary to import data via external REST endpoints, export data using Azure Functions, and robustly secure an Azure SQL Database.

These essential skills will enable you to efficiently develop and manage modern applications with Azure SQL Database, ensuring optimal performance and enhanced security.

Related trainings

Exclusives

  • Technical lab: Available for 180 days of online access
  • Class material: Complete and up to date with Microsoft Learn
  • Proof of attendance: Digital badge for completing the official Microsoft course
  • Fast and guaranteed schedule: Maximum wait of 4 to 6 weeks after participant registrations, guaranteed date

Private class

Reserve this training exclusively for your organization with pricing adapted to the number of participants. Our pricing for private classes varies according to the size of your group, with a guaranteed minimum threshold to maintain pedagogical quality.

  • Volume-based pricing discount according to the number of participants
  • Training delivered in an environment dedicated to your team
  • Scheduling flexibility according to your availability
  • Enhanced interaction among colleagues from the same organization
  • Same exclusive benefits as our public training sessions

How to get a proposal?

Use the request form by specifying the number of participants. We will quickly send you a complete proposal with the exact pricing, available dates, and details of all the benefits included in your private training.

Develop Data-Driven Applications with Azure SQL Database DP-3020 Training Plan: Detailed Modules

  • Explain deployment options
  • Explore Hyperscale capabilities
  • Understand the serverless compute tier
  • Enable application resilience with Azure SQL Database
  • Understand AI capabilities for Azure SQL Database
  • Exercise: Enable application resilience with Azure SQL Database
  • Create and configure an Azure SQL Database
  • Use SQL Database Projects
  • Build and deploy database projects in GitHub Actions and Azure DevOps
  • Secure and monitor Continuous Integration and Continuous Deployment (CI/CD)
  • Exercise: Configure and deploy CI/CD pipelines for Azure SQL Database projects
  • Explore Data API Builder for Azure SQL Database
  • Develop a data API using Azure Static Web Apps
  • Develop a data API using Azure Web App for Containers
  • Exercise: Develop a Data API for Azure SQL Database
  • Use RESTful endpoints to import data to Azure SQL Database
  • Manipulate data in Azure SQL Database with Azure Functions
  • Understand the data movement tools available
  • Exercise: Import and export data for development in Azure SQL Database
  • Explore authentication methods
  • Configure managed identity
  • Understand firewall rules
  • Explore advanced data security
  • Exercise: Configure managed identity for Azure SQL Database

Recommended prerequisite knowledge

  • Experience with relational databases.
  • Basic knowledge of security concepts like identities and permissions.
  • Experience using the Azure portal to create resources and set permissions.

Credentials and certification

Features

  • Preparatory training for obtaining a Microsoft Applied Skills credential.
  • Performance is assessed through an interactive remote lab.
  • Duration: 120 minutes
  • Cost: $0

Assessment’s technical tasks

  • Develop an Azure SQL Database
  • Develop a data API
  • Enable a read-only Azure SQL Database
  • Import data by using an external REST endpoint
  • Export data by using an Azure Function
  • Secure an Azure SQL Database

View all assessment details on Microsoft Learn >>

Eccentrix Corner Articles: Develop Data-Driven Applications with Azure SQL Database DP-3020 Resources

Explore our technical articles on Develop Data-Driven Applications with Azure SQL Database DP-3020 published on Eccentrix Corner. These resources dive deeper into key concepts, share best practices, and provide practical guides to maximize your learning and success. Our experts share real-world insights to help you master developing data-driven applications with Azure SQL Database.

Azure SQL Database Data Driven Apps Training

The Azure SQL Database Data Driven Apps training is designed for application developers, data engineers, and IT professionals seeking to master the capabilities of Azure SQL Database. This course focuses on designing, implementing, and optimizing data-driven applications to manage large data volumes and extract valuable insights.

Through hands-on exercises and real-world use cases, participants will learn to leverage Azure SQL Database features to build efficient data pipelines, optimize performance, and deliver advanced applications tailored to organizational needs.

Why Take This Training?

Azure SQL Database is a powerful platform combining the capabilities of relational databases and cloud services to meet modern application development needs. This training provides essential skills to create integrated solutions that enable organizations to make data-driven decisions based on reliable insights.

By taking this course, you will be prepared to address complex challenges in application development and data management within cloud environments.

Skills Developed During the Training

  1. Creating Application Data Pipelines
    Learn to design and configure automated data flows for efficient application data management.

  2. Optimizing Application Performance
    Develop techniques to enhance Azure SQL Database solutions’ performance and ensure scalability.

  3. Integrating Multiple Data Sources
    Connect data from diverse sources to create a comprehensive and unified view in your applications.

  4. Implementing Advanced Data APIs
    Use API tools to generate actionable insights from large datasets.

  5. Automating Application Processes
    Streamline workflows to simplify data management and enable real-time analysis.

  6. Interactive Visualization and Reporting
    Create customized dashboards and interactive reports to meet organizational needs.

A Practical, Expert-Led Training

This training is delivered by certified Azure instructors, combining theoretical teaching with hands-on exercises. Participants will work on real-world projects, allowing them to apply the concepts learned directly.

Who Should Attend?

  • Application developers responsible for creating and optimizing data-driven applications
  • IT professionals specializing in data analysis and cloud solution implementation
  • Data architects aiming to integrate Azure SQL Database into complex environments
  • Analysts seeking to deepen their skills in application development and visualization

Build Advanced Application Solutions with Azure SQL Database

The Develop Data-Driven Applications with Azure SQL Database (DP-3020) training equips you with the essential tools and techniques to create high-performance application solutions. Enroll today to transform your application development skills and deliver impactful results for your organization.

Frequently Asked Questions - Azure SQL Database Training (FAQ)

The training covers application pipeline creation, performance optimization, data integration, and advanced API development techniques.

Basic understanding of Azure SQL Database and application development concepts is recommended but not mandatory.

Azure SQL Database, GitHub Actions, Azure Pipelines, Data API builder, Azure Web Apps, and Static Web Apps.

Yes, the course features practical labs and real-world projects for applying application development skills.

The course is designed for intermediate to advanced levels, but beginners with solid foundations can also benefit.

It enables more efficient data-driven application development, improved performance, and scalable solution creation.

Request form for a private class training

Dear Customer,

We thank you for your interest in our services. Here is the important information that will be provided to us upon completion of this form:

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

Language: English

Duration: 1 day / 7 hours

Number of participants from your organization *

Minimum number of participants: 6

Organization name *
Your first and last name *
Telephone number *
Professional email *
Please provide a work or professional email address.
How did you hear about us? *
Comments or Remarks
Promotional code
The General Conditions are accessible on this page.

Our website uses cookies to personalize your browsing experience. By clicking ‘I accept,’ you consent to the use of cookies.