When will I receive my Course Certificate?

If you complete the course successfully, your electronic Course Certificate will be added to your Accomplishments page - from there, you can print your Course Certificate or add it to your LinkedIn profile.

Why can’t I audit this course?

This course is currently available only to learners who have paid or received financial aid, when available.

Is financial aid available?

Yes. In select learning programs, you can apply for financial aid or a scholarship if you can’t afford the enrollment fee. If fin aid or scholarship is available for your learning program selection, you’ll find a link to apply on the description page.

PostgreSQL 17: Optimizing Performance & Security

PostgreSQL 17: Optimizing Performance & Security

This course is part of Mastering PostgreSQL 17 Specialization

Instructor: Packt - Course Instructors

Included with

Learn more

4 modules

Gain insight into a topic and learn the fundamentals.

Intermediate level

Recommended experience

5 hours to complete

Flexible schedule

Learn at your own pace

4 modules

Gain insight into a topic and learn the fundamentals.

Intermediate level

Recommended experience

5 hours to complete

Flexible schedule

Learn at your own pace

What you'll learn

Deploy and manage PostgreSQL in production environments
Get to grips with handling redundancy and data safety
Secure PostgreSQL with encryption and access controls

Details to know

Shareable certificate

Add to your LinkedIn profile

See how employees at top companies are mastering in-demand skills

Learn more about Coursera for Business

logos of Petrobras, TATA, Danone, Capgemini, P&G and L'Oreal

Build your subject-matter expertise

This course is part of the Mastering PostgreSQL 17 Specialization

When you enroll in this course, you'll also be enrolled in this Specialization.

Learn new concepts from industry experts
Gain a foundational understanding of a subject or tool
Develop job-relevant skills with hands-on projects
Earn a shareable career certificate

There are 4 modules in this course

This course focuses on enhancing the performance and security of PostgreSQL 17. Learners will gain in-depth knowledge of optimizing queries, writing efficient stored procedures, and securing PostgreSQL databases. Mastering these strategies is crucial in the professional world, especially for database administrators, developers, and security experts.

By diving into system logs and query optimization, you'll learn to troubleshoot and fine-tune your PostgreSQL setup, ensuring high performance and scalability. This hands-on course will help you create more secure, faster, and more efficient PostgreSQL databases. What sets this course apart is its combination of both theoretical knowledge and practical applications, with real-world examples to reinforce the concepts. You'll be equipped with tools that can be directly applied to your work environment. This course is part two of a three-course Specialization designed to provide a comprehensive learning pathway in this subject area. While it delivers standalone value and practical skills, learners seeking a more integrated and in-depth progression may benefit from completing the full Specialization.

This module explores how to monitor and analyze PostgreSQL databases using system statistics and log files. Learners will discover how to inspect database activity, evaluate table and index performance, and configure effective logging for troubleshooting and optimization. By the end, you'll be equipped to maintain database health and diagnose issues using PostgreSQL's built-in tools.

What's included

1 video8 readings1 assignment

1 videoTotal 1 minute

Overview1 minute

8 readingsTotal 48 minutes

Introduction7 minutes
Inspecting Databases5 minutes
Inspecting Tables5 minutes
Digging into Indexes5 minutes
Tracking, Archiving, and Streaming6 minutes
Inspecting Transactions in Real Time4 minutes
Using pg_stat_statements7 minutes
Creating Log Files9 minutes

1 assignmentTotal 16 minutes

PostgreSQL Log Files and System Statistics16 minutes

This module explores advanced techniques for improving PostgreSQL query performance, including reading and interpreting execution plans, optimizing joins, and leveraging parallelism. Learners will gain practical skills in diagnosing performance bottlenecks, adjusting system parameters, and applying partitioning strategies to large datasets.

What's included

1 video16 readings1 assignment

1 videoTotal 1 minute

Overview1 minute

16 readingsTotal 89 minutes

Introduction6 minutes
Applying Transformations6 minutes
Making the Process Fail6 minutes
Introducing Join Pruning5 minutes
Approaching Plans Systematically5 minutes
Inspecting Estimates3 minutes
Inspecting Buffer Usage5 minutes
Getting Joins Right6 minutes
Enabling and Disabling Optimizer Settings4 minutes
Understanding Genetic Query Optimization9 minutes
Modifying Inherited Structures5 minutes
Using Range Partitioning6 minutes
Adjusting Parameters for Good Query Performance5 minutes
Speeding Up Sorting6 minutes
Making Use of Parallel Queries6 minutes
Parallelism in Practice6 minutes

1 assignmentTotal 16 minutes

Optimizing Database Query Performance16 minutes

This module explores the creation and optimization of stored procedures in PostgreSQL, including language options, flow control, variable scope, and advanced data handling techniques. Learners will gain practical skills in writing efficient procedures using PL/pgSQL, PL/Python, and other supported languages, while addressing challenges such as quoting, security, and large data sets.

What's included

1 video11 readings1 assignment

1 videoTotal 1 minute

Overview1 minute

11 readingsTotal 64 minutes

Introduction7 minutes
Introducing Dollar Quoting5 minutes
Exploring Various Stored Procedure Languages6 minutes
Loops and Flow Control6 minutes
Managing Scopes5 minutes
Using Cursors to Fetch Data in Chunks5 minutes
Utilizing Composite Types8 minutes
Writing Stored Procedures in PL/pgSQL5 minutes
Making Use of the SPI Interface6 minutes
Introducing PL/Python5 minutes
Improving Functions6 minutes

1 assignmentTotal 16 minutes

Exploring Stored Procedures and Database Constructs16 minutes

This module explores essential PostgreSQL security practices, including configuring authentication, managing user roles, and setting permissions at various levels. Learners will gain hands-on experience with tools like pg_hba.conf, and learn to implement security controls from network access to row-level restrictions. By the end, you'll be able to inspect, modify, and audit security settings to protect your PostgreSQL databases.

What's included

1 video11 readings1 assignment

1 videoTotal 1 minute

Overview1 minute

11 readingsTotal 55 minutes

Introduction5 minutes
Living in a World Without TCP4 minutes
Managing the pg_hba.conf File5 minutes
Inspecting the Content of pg_hba.conf via SQL4 minutes
Handling Instance-Level Security6 minutes
Creating and Modifying Users3 minutes
Defining Database-Level Security6 minutes
PostgreSQL 15 and Beyond5 minutes
Handling Column-Level Security4 minutes
Digging into Row-Level Security7 minutes
Inspecting and Handling Permissions6 minutes

1 assignmentTotal 16 minutes

PostgreSQL Security Fundamentals16 minutes

Earn a career certificate

Add this credential to your LinkedIn profile, resume, or CV. Share it on social media and in your performance review.

Instructor

Packt - Course Instructors

Packt

1,763 Courses500,581 learners

Offered by

Packt

Explore more from Data Management

Packt
PostgreSQL 17: High Availability & Advanced Administration
Course
Packt
PostgreSQL 17: Core Concepts and Advanced SQL Techniques
Course

Why people choose Coursera for their career

Felipe M.

Learner since 2018

"To be able to take courses at my own pace and rhythm has been an amazing experience. I can learn whenever it fits my schedule and mood."

Jennifer J.

Learner since 2020

"I directly applied the concepts and skills I learned from my courses to an exciting new project at work."

Larry W.

Learner since 2021

"When I need courses on topics that my university doesn't offer, Coursera is one of the best places to go."

Chaitanya A.

"Learning isn't just about being better at your job: it's so much more than that. Coursera allows me to learn without limits."

Open new doors with Coursera Plus

Unlimited access to 10,000+ world-class courses, hands-on projects, and job-ready certificate programs - all included in your subscription

Learn more

Advance your career with an online degree

Earn a degree from world-class universities - 100% online

Explore degrees

Join over 3,400 global companies that choose Coursera for Business

Upskill your employees to excel in the digital economy

Learn more

Frequently asked questions

Yes, you can preview the first video and view the syllabus before you enroll. You must purchase the course to access content not included in the preview.

If you decide to enroll in the course before the session start date, you will have access to all of the lecture videos and readings for the course. You’ll be able to submit assignments once the session starts.

Once you enroll and your session begins, you will have access to all videos and other resources, including reading items and the course discussion forum. You’ll be able to view and submit practice assessments, and complete required graded assignments to earn a grade and a Course Certificate.