Master Data-Driven App Development with Azure SQL Databases.

Harness the power of SQL to create dynamic, data-driven applications tailored for real-world scenarios. This Microsoft Applied Skills course equips you with essential skills to design, implement, and optimize SQL databases, driving seamless performance and robust functionality.

Dive deep into best practices for building scalable applications, managing complex datasets, and ensuring data integrity. Whether you’re a developer aiming to elevate your skillset or a professional stepping into the realm of data-driven development, this course provides the tools and confidence to succeed. Say goodbye to database bottlenecks and hello to streamlined, efficient app solutions.

Key Benefits:

  • Build scalable, data-rich applications with SQL.
  • Learn advanced techniques for data management and integration.
  • Tackle common database challenges with proven solutions.

Lead the Era of AI and Cloud with Microsoft Malaysia’s Learning Partner of the Year 2024 today. Power your organization’s AI transformation with Microsoft Cloud. The AI you can trust.

Overview

This learning path prepares you for the task of developing data-driven applications by using Microsoft Azure SQL Database.

You’ll 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, you’ll 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, you’ll 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.

Skills Covered

  • Get started with Azure SQL Database for modern application development
  • Develop for Azure SQL Database
  • Develop a data API for Azure SQL Database
  • Explore data manipulation options in Azure SQL Database
  • Explore security practices for Azure SQL Database

Prerequisites

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

Target Audience

  • Developer

Course Curriculum

Module 1: Get started with Azure SQL Database for modern application development

You’ll explore different features and tools to help you develop in Azure SQL Database.

Learning objectives

By the end of this module, you’ll be able to:

  • Explain the deployment options available.
  • Explore Hyperscale capabilities.
  • Understand how serverless works.
  • Explain application resilience options for Azure SQL Database.
  • Understand AI capabilities for Azure SQL Database.

Prerequisites

  • Ability to navigate the Azure portal.
  • Experience with T-SQL programming language at a basic level.

Module 2: Develop for Azure SQL Database

You’ll learn different methods to develop and automate Azure SQL Database publishing for development purposes.

Learning objectives

By the end of this module, you’ll be able to:

  • Create and configure an Azure SQL Database.
  • Use SQL Database projects.
  • Build and deploy database projects in GitHub Actions and Azure DevOps.
  • Understand how to secure and monitor your Continuous Integration and Continuous Deployment (CI/CD) process.

Prerequisites

  • Ability to navigate the Azure portal.
  • Experience with T-SQL programming language at a basic level.

Module 3: Develop a data API for Azure SQL Database

We’ll explore the use of Azure’s Data API Builder, a powerful tool that simplifies the creation of REST and GraphQL endpoints for your Azure SQL Database. With features like automatic query generation, granular security controls, and seamless integration with other Azure services, the Data API Builder can transform your database into a versatile API with minimal effort.

Learning objectives

By the end of this module, you’ll be able to:

  • Use Data API Builder to create a data API for Azure SQL Database.
  • Develop a data API using a static Azure web app.
  • Develop a data API using Azure Web Apps.

Prerequisites

  • Experience using the Azure portal to create resources.
  • Experience with T-SQL programming language at a basic level.

Module 4: Explore data manipulation options in Azure SQL Database

Azure SQL Database allows you to import data using RESTful endpoints. This capability integrates Azure SQL Database with various external services and APIs, making it a versatile and user-friendly platform. Also, by combining Azure Functions with Azure SQL Database, you can create seamless workflows that automate data processing and enhance the functionality of your applications.

Learning objectives

By the end of this module, you’ll be able to:

  • Invoke an external REST endpoint in Azure SQL Database
  • Manipulate data in Azure SQL Database by using Azure Functions
  • Understand additional data movement tools

Prerequisites

  • Experience using the Azure portal to create resources.
  • Experience with T-SQL programming language at a basic level.

Module 5: Explore security practices for Azure SQL Database

You’ll explore different features and tools to help you secure an Azure SQL Database.

Learning objectives

By the end of this module, you’ll be able to:

  • Explain the authentication options available.
  • Configure managed identity to access Azure SQL Database.
  • Understand how firewall rules work.
  • Explain advanced data security features.

Prerequisites

  • Ability to navigate the Azure portal.
  • Experience with T-SQL programming language at a basic level.

Dates & Locations

Let’s make it work for you

Can’t find a date that fits? Need to train your whole team? Looking for a discount?
Speak to one of our learning experts today.

x Clear all selections

August 17, 2026 - August 17, 2026

Location: Kuala Lumpur
Modal: ILT
Availability: TBC
RM 1200

August 17, 2026 - August 17, 2026

Location: Online
Modal: VILT
Availability: TBC
RM 1200

November 16, 2026 - November 16, 2026

Location: Kuala Lumpur
Modal: ILT
Availability: TBC
RM 1200

November 16, 2026 - November 16, 2026

Location: Online
Modal: VILT
Availability: TBC
RM 1200
Trainocate exam and cert

Exam & Certification

To earn this Microsoft Applied Skills credential, learners demonstrate the ability to develop data-driven applications by using Microsoft Azure SQL Database.

Candidates for this top Microsoft Applied Skills credential should have experience developing data-driven applications. They should also be familiar with the Azure ecosystem and the components involved in developing applications that include Azure SQL Database. Candidates need a basic understanding of Git-based source control, in addition to how REST APIs interact with Azure SQL Database for data operations.

Tasks performed

  • 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

Training & Certification Guide

Addressing the AI Skills Gap in Malaysia

The Artificial Intelligence (AI) surge across global industries has created immense potential for innovation and economic growth. For Malaysia, AI is pivotal in its ambition to become a digital-first economy. However, despite this goal, the country faces a significant AI skills gap—a shortfall in the number of skilled professionals equipped to meet the rising demands for AI expertise across various industries. This blog examines the causes, impact, and initiatives underway to bridge this gap, ensuring Malaysia remains competitive in the digital age.

AI Mastery Program: Learn AI with Microsoft in 2024

Artificial Intelligence (AI) has been one of the hottest topics in the tech industry for the past decade. With its rapid advancements and potential to impact our daily lives, learning AI has become a highly sought-after skill.

We are thrilled to announce the launch of our Microsoft AI Mastery Program in 2024, made possible through our partnership with Microsoft, a renowned leader in AI technology. This program is tailored for individuals and tech professionals passionate about acquiring and mastering the fundamental and advanced principles of AI.

Top AI Skills Malaysia Needs Today: Advance Your IT Career in 2024

In the quest for AI-driven innovation, Malaysia seeks sharp minds with the right IT skills. Data science, machine learning—these are the tools in high demand. This article examines the AI skills Malaysia needs, the industries driving this change, and how to develop these skills to enhance your career trajectory.

In-demand Cloud Technology Skills – Insights from Malaysia’s Job Market

As Malaysia accelerates its digital transformation journey, cloud technology has emerged as a critical component of the nation’s economic growth. The adoption of cloud services is driving innovation across various sectors, from finance to manufacturing, and creating a robust demand for skilled cloud professionals.

This article dives into the most in-demand cloud technology skills in Malaysia, backed by market data and insights from industry reports, and highlights the key roles that are shaping the future of cloud technology.

Master Your Cloud Career: Essential Azure Certifications for 2024

Targeting the most valuable Azure certifications for 2024? In the evolving landscape of cloud computing, Azure certifications stand out by offering professionals the leverage to thrive. This article presents a focused rundown of crucial Azure certifications, shining a light on their career-boosting effects and elucidating steps to get certified. No fluff – just actionable insights to empower your journey in the cloud.

The Future of Cloud Careers in Malaysia 2024

As Malaysia advances its digital economy, the demand for cloud professionals is growing rapidly. Cloud technology has become an essential part of the modern IT landscape, and businesses across various sectors are increasingly relying on cloud infrastructure to drive digital transformation.

This article explores the current state of cloud careers in Malaysia, key roles and career pathways, and emerging cloud trends that are shaping the future of cloud technology.

Top Microsoft Applied Skills Courses to Boost Your Career

Microsoft Applied Skills are scenario-based practical credentials that confirm your ability to tackle real-world challenges using Microsoft technologies.

In this article, we will dive into what these skills are, how they differ from traditional certifications, and the benefits they bring to your career. Expect insights on top courses, the assessment process, and tips for success.

Maximize Your Productivity with Microsoft Copilot: A Complete Guide

Microsoft Copilot is an AI assistant within Microsoft 365 apps like Word, Excel, and Teams. It automates tasks and offers smart insights to boost productivity. This guide shows what Microsoft Copilot is, how it works, and ways it can simplify your tasks.

DP-300T00: Implement Scalable Database Solutions using Azure SQL

This course provides students with the knowledge and skills to administer a SQL Server database infrastructure for cloud, on-premises and hybrid relational databases and who work with the Microsoft PaaS relational database offerings.

DP-3001: Migrate SQL Server workloads to Azure SQL Database

This learning path prepares you for the task of migrating SQL Server workloads to Azure SQL Database.

DP-3014: Build Machine Learning Solutions using Azure Databricks

Azure Databricks is a cloud-scale platform for data analytics and machine learning. Data scientists and machine learning engineers can use Azure Databricks to implement machine learning solutions at scale.

DP-3015: Getting Started with Cosmos DB NoSQL Development

This course teaches developers to utilize Azure Cosmos DB for NoSQL API and SDK. Students will learn query execution, resource configuration, SDK operations, and design strategies for non-relational data modeling and data partitioning.

DP-3021: Configure and migrate to Azure Database for PostgreSQL

In this learning path, you learn the main features of PostgreSQL and how they work in Azure Database for PostgreSQL. You learn about the different Azure Database for PostgreSQL implementation options, and how to configure a server for your needs.

Microsoft Certified: Power BI Data Analyst Associate

The Microsoft Certified: Power BI Data Analyst Associate certification equips professionals with advanced skills to prepare, model, visualize, and analyze data using Power BI.

Microsoft Certified: Azure AI Engineer Associate

This certification validates the skills of Azure AI Engineers in building, managing, and deploying AI solutions using Azure AI. Candidates participate in all phases of AI solution development, from design and development to deployment, integration, and monitoring.

Microsoft Certified: Azure Data Scientist Associate

The Microsoft Certified: Azure Data Scientist Associate certification is designed for professionals who specialize in data science and machine learning on the Azure platform.

Microsoft Certified: Fabric Analytics Engineer Associate

The Microsoft Fabric Analytics Engineer Associate certification (exam DP‑600) is an intermediate-level credential for data engineers and analysts.

Microsoft Certified: Fabric Data Engineer Associate

The Microsoft Certified: Fabric Data Engineer Associate certification is a role-based credential designed for professionals who specialize in data engineering on the Microsoft Fabric platform.

Frequently Asked Questions

Speak to a Training Consultant

All courses are HRD Claimable.
Get in touch with our team via the form or WhatsApp us on +6011-5119 6631

Preferred mode of training
Checkboxes