Course Overview
Azure Database for PostgreSQL is a Platform as a Service database service in the Microsoft cloud. It bases itself on the PostgreSQL open-source relational database and includes built-in high availability, automatic backup and restore, as well as comprehensive security features. The pay-as-you-go pricing model provides predictable performance and near-instant scaling.
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.
What are the skills covered
- Explore PostgreSQL architecture
- Understand client-server communication in PostgreSQL
- Understand PostgreSQL query processing
- Secure Azure Database for PostgreSQL
- Procedures and functions in PostgreSQL
- Understand write-ahead logging
- Configure and manage Azure Database for PostgreSQL
- Understand concurrency in PostgreSQL
- Tune queries in Azure Database for PostgreSQL
- Migrate to Azure Database for PostgreSQL flexible server
Who should attend this course
- Database Administrator
Course Curriculum
What are the Prerequisites
- Demonstrate an understanding of relational databases.
- Demonstrate an understanding of basic SQL.
Download Course Syllabus
Course Modules
Learning objectives
After completing this module, you’ll be able to:
- Describe the architecture of PostgreSQL.
- Describe the options for creating an Azure Database for PostgreSQL server.
- Understand PostgreSQL shared memory.
Prerequisites
- Demonstrate an understanding of relational databases.
- Demonstrate an understanding of basic SQL.
PostgreSQL is a client-server system, which allows many clients to connect to a central server. In this module, you learn how PostgreSQL manages connections from clients, and look at some common PostgreSQL client tools.
Learning objectives
After completing this module, you’ll be able to:
- Understand connection handling.
- Understand the PostgreSQL client tools.
Prerequisites
- Demonstrate an understanding of relational databases.
- Demonstrate an understanding of basic SQL.
The Azure Database for PostgreSQL server receives SQL queries and returns the relevant results. Each SQL query goes through several stages in order to return the correct results as quickly as possible.
Learning objectives
After completing this module, you’ll be able to:
- Identify the query processing components.
- Understand EXPLAIN.
Prerequisites
- Demonstrate an understanding of relational databases.
- Demonstrate an understanding of basic SQL.
Azure Database for PostgreSQL includes comprehensive security features including encryption, authentication, and granting permissions to database users. In this module, you learn about the security features of Azure Database for PostgreSQL.
Learning objectives
After completing this module, you’ll be able to:
- Describe the security features of Azure Database for PostgreSQL.
- Create database users and grant permissions.
- Understand encryption in Azure Database for PostgreSQL.
Prerequisites
- Demonstrate an understanding of relational databases.
- Demonstrate an understanding of basic SQL.
PostgreSQL supports stored procedures and functions to make SQL queries reusable. In this module, you learn how to create and run stored procedures and functions.
Learning objectives
After completing this module, you’ll be able to:
- Create a stored procedure in Azure Database for PostgreSQL.
- Call a stored procedure in Azure Database for PostgreSQL.
- Create and use a function in Azure Database for PostrgreSQL.
Prerequisites
- Demonstrate an understanding of relational databases.
- Demonstrate an understanding of basic SQL.
Azure Database for PostgreSQL is an ACID compliant database service. Write-ahead logging ensures changes are both atomic and durable. In this module, you learn how Azure Database for PostgreSQL implements write-ahead logging.
Learning objectives
After completing this module, you’ll be able to:
- Describe write-ahead logging.
- Describe replication and logical decoding.
Prerequisites
- Demonstrate an understanding of relational databases.
- Demonstrate an understanding of basic SQL.
Azure Database for PostgreSQL employs system catalogs and views to manage metadata efficiently. Understanding these can significantly enhance database performance and streamline the administration of PostgreSQL systems.
Learning objectives
After completing this module, you’ll be able to:
- Describe system catalogs and system views in Azure Database for PostgreSQL.
- Investigate metadata in Azure Database for PostgreSQL.
- Explain the purpose of the vacuum process.
- Configure vacuum server parameters.
Prerequisites
- Demonstrate an understanding of relational databases.
- Demonstrate an understanding of basic SQL
Azure Database for PostgreSQL is a multi-user relational database solution. The increase in users brings a risk of conflicts and so it is important to understand the concurrency systems that are in place.
Learning objectives
After completing this module, you’ll be able to:
- Describe Multi-Version Content Control and snapshots in Azure Database for PostgreSQL.
- Describe isolation levels in Azure Database for PostgreSQL.
- Describe locking in Azure Database for PostgreSQL.
Prerequisites
- Demonstrate an understanding of relational databases.
- Demonstrate an understanding of basic SQL.
Database management systems (DBMSs) need systems to understand the data and the queries that are running against this data. It’s important to understand how performance tuning works and how you can assess performance metrics.
Learning objectives
After completing this module, you’ll be able to:
- Describe statistics in Azure Database for PostgreSQL.
- Assess query performance with the Query Store.
Prerequisites
- Demonstrate an understanding of relational databases.
- Demonstrate an understanding of basic SQL.
Azure Database for PostgreSQL Flexible Server supports data migration from PostgreSQL servers. This module covers online and offline migration tools and methods, helping you choose the right approach for your scenario.
Learning objectives
After completing this module, you’ll be able to:
- Understand the different online and offline migration options.
- Identify the different migration tools available.
- Select the appropriate migration tool for your specific scenario.
Prerequisites
- Demonstrate an understanding of relational databases.
- Demonstrate an understanding of basic SQL.
Request More Information
Training Options
- ILT: Instructor-Led Training
- VILT: Virtual Instructor-Led Training
RM1,200.00Enroll Now
RM1,200.00Enroll Now
RM1,200.00Enroll Now
RM1,200.00Enroll Now
RM1,200.00Enroll Now
RM1,200.00Enroll Now
Exam & Certification
Note: There is no exam directly associated with this course. However, Microsoft offers an extensive portfolio of industry-recognized certifications that can help you stand out as a tech professional in 2025 and beyond. Achieving Microsoft certification is one of the most effective ways to validate your skills and accelerate your career.
With our expert-led training, you’ll be prepared to:
- Master in-demand capabilities across Cloud, Data & AI, and Cybersecurity — areas driving global digital transformation.
- Prove your expertise with a globally respected credential recognized by employers worldwide.
- Advance your career by enhancing your credibility, increasing your earning potential, and opening doors to new opportunities.
Explore our full range of Microsoft certifications and start building the skills that matter today.
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-3020: Develop data-driven applications by using Azure SQL Database
This learning path prepares you for the task of developing data-driven applications by using Microsoft Azure SQL Database.
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.
