MS-40563: Real-time with PostgreSQL Hyperscale


Duration: 1 Day
Mode of Delivery: Online -Instructor-led training
Job role: Data Engineer
Preparation for exam: None
Cost: USD$1,000.00

In this workshop, you will learn how to use advanced features of the managed PostgreSQL PaaS service on Azure to make your database more scalable and able to handle the rapid ingest of streaming data while simultaneously generating and serving pre-aggregated data for reports. You will design a resilient stream processing pipeline to ingest, process, and save real-time data to Postgres. Next, you will learn how to explore and gain insights from flat files at scale, perform aggregates, and save the valuable information to your database. Finally, you will create complex reports containing advanced visualizations, using a drag-and-drop interface, and use them to build a customizable dashboard that gets updated in real-time.



This workshop is intended for Cloud Architects and IT professionals who have architectural expertise of infrastructure and solutions design in cloud technologies and want to learn more about Azure and Azure services as described in the ‘About this Course’ and ‘At Course Completion’ areas. Those attending this workshop should also be experienced in other non-Microsoft cloud technologies, meet the course prerequisites, and want to cross-train on Azure.



Skills Gained

After completing this course, students will be able to:
• Implement a highly scalable, managed open source database solution.
• Ensure that it can handle real-time, roll-up and serve data for advanced visualizations.

Course outline

Module 1: Whiteboard Design Session – Real-time data with Azure Database for PostgreSQL Hyperscale
• Review the customer case study
• Design a proof-of-concept solution
• Present the solution

Module 2: Hands-on Lab – Real-time data with Azure Database for PostgreSQL Hyperscale
• Connect to and set up your database
• Add secrets to Key Vault and configure Azure Databricks
• Send clickstream data to Kafka and process it in real time
• Rollup real-time data in PostgreSQL
• Create advanced visualizations in Power BI


Click on the following link to see the current Course Schedule
Our minimum class-size is 3 for this course.
If there are no scheduled dates for this course, it can be customized to suit the time and skill needs of clients and it can be held online, at a rented location or at your premises.
Click on the following link below to arrange for a custom course: Enquire about a course date

Product Information

PostgreSQL is a powerful, open source object-relational database system with over 30 years of active development that has earned it a strong reputation for reliability, feature robustness, and performance.


CERTFICATE OF COMPLETION: Participants will receive a certificate of completion at the end of a course. This is not an official certification for the product and/or software. Our courses do indicate the appropriate certification exam(s) that the participant can sit. Data Vision Systems does not provide certification or deliver the certification exams. Participants are responsible for arranging and paying for the certification exams on the appropriate certification body.

CANCELLATION POLICY: There is never a fee for cancelling seven business days before a class for any reason. Data Vision Systems reserves the right to cancel any course due to insufficient registration or other extenuating circumstances. Participants will be advised prior to doing so.


There are no reviews yet.

Be the first to review “MS-40563: Real-time with PostgreSQL Hyperscale”

Your email address will not be published. Required fields are marked *