See how Insoft Services is responding to COVID-19

Course 40563G: Microsoft Cloud Workshop: Real-time data with Azure Database for PostgreSQL Hyperscale

X

Contact Us

We would love to hear from you. Please complete this form to pre-book or request further information about our delivery options.

Subscribe

I'd like to receive emails with the latest updates and promotions from Insoft.

Data Protection & Privacy

I hereby allow Insoft Ltd. to contact me on this topic. Further, I authorise Insoft Ltd. processing, using collecting and storing my personal data for the purpose of these activities. All your data will be protected and secured as outlined in our privacy policy.


Upcoming Courses


Dec 7, 2020
09:00 - 17:00 (CEST)
Online

  • Course 40563G: Microsoft Cloud Workshop: Real-time data with Azure Database for PostgreSQL Hyperscale
    1 days  (Instructor Led Online)  |  Azure

    Course Details

    In the Microsoft Cloud Workshop: Real-time data with Azure Database for PostgreSQL Hyperscale (Course 40563G) 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 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.

     

    See other Microsoft courses

    Objectives

    At the end of this workshop, you will be better 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.

    Outline

    Module 1: Whiteboard Design Session – Real-time data with Azure Database for PostgreSQL Hyperscale

    Lessons

    • 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

    Lessons

    • 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

    Target Audience

    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.

    Prerequisites

    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.