Microsoft Applied Skills: Configure and migrate to Azure Database for PostgreSQL (DP-3021)
Exam
Exam fees included
Course code
msdp3021
Course pricing varies based on delivery method and location.
Why choose Firebrand
150,000 +
professionals trained worldwide
25+
years of delivering accredited IT training
Top 20
IT training company globally
70%
of learners return for another course
What you’ll learn
On this Microsoft: Configure and migrate to Azure Database for PostgreSQL course you’ll gain an understanding of Azure Database for PostgreSQL which 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.
You’ll also:
Learn about the PostgreSQL architecture, and how to manage different aspects of Azure Database for PostgreSQL.
Learn how PostgreSQL manages connections from clients, and look at some common PostgreSQL client tools.
Learn about the security features of Azure Database for PostgreSQL.
Learn how to create and run stored procedures and functions.
Learn how Azure Database for PostgreSQL implements write-ahead logging.
Understand how performance tuning works and how you can assess performance metrics.
At the end of this course, you’ll achieve your Microsoft: Configure and migrate to Azure Database for PostgreSQL certification.
At Firebrand, we are one of the few companies in the world to be designated a Microsoft Cloud Partner. Through our Lecture | Lab | Review method, you’ll access official courseware, learn from certified instructors, and train in a distraction-free environment.
Audience
This course is ideal for:
Database Administrators: Those who manage and maintain databases, ensuring their performance, security, and availability.
Intermediate-Level Learners: Individuals who already understand relational databases and basic SQL.
IT Professionals: Those looking to enhance their skills in managing PostgreSQL databases within the Azure environment.
Curriculum
Module 1: Explore PostgreSQL architecture
Module 2: Understand client-server communication in PostgreSQL
Module 3: Understand PostgreSQL query processing
Module 4: Secure Azure Database for PostgreSQL
Module 5: Procedures and functions in PostgreSQL
Module 6: Understand write-ahead logging
Module 7: Configure and manage Azure Database for PostgreSQL
Module 8: Understand concurrency in PostgreSQL Tune queries in Azure Database for PostgreSQL
Module 9: Migrate to Azure Database for PostgreSQL flexible server
Prerequisites
Before attending this course, you should demonstrate an understanding of relational databases and basic SQL.
Exam info
There is no assessment associated to this course.
70% of our customers return to book more training. Here's why.
Interested in this course?
Speak to one of our learning advisors for information on upcoming course dates, pricing, delivery options and team training.
No obligation • Free consultation
Talk to a Firebrand expert
Get personalised guidance from our learning advisors and discover the best way to achieve your training goals.
- Course recommendations
- Flexible training options
- Team and private delivery available
FAQs
Yes, we do provide courses suitable for beginners. However, Firebrand's accelerated courses aren't easy and it's essential that you are interested and actively pursuing a career in IT.
Traditional training providers usually run their courses from 9am to 5pm. At Firebrand Training we maximise the number of learning hours to minimise the number of training days, so you’ll be back to your job as quickly as possible. You don’t waste time travelling to several courses and finding an exam centre after that.
Firebrand's accelerated courses are constantly reviewed. We ask our delegates for feedback after every course. We are official partners with leading vendors and therefore, we're provided with certification changes and updates, which we can then implement in our course delivery at a very early stage. This feedback is then analysed in view of changes or discrepancies. We will then address the topics mentioned and have a panel of subject matter experts provide us with valuable suggestions for improvement and solutions.
If you need to learn new skills and you want to be able to put them into practice quickly, then Firebrand is the right training company for you.
Our unique accelerated training method means that we are your fastest way to learn. By delivering training for up to 12 hours per day, seven days per week, with exam centres on-site, we ensure that you are trained and certified quicker than anywhere else, having spent less time out of the office away from the day job.
Train your team
Since 2001 we’ve trained 135,000+ employees from thousands of large and small organisations, saving them more than one million hours in training time.