Overview

Google, IBM & Meta Certificates — All 10,000+ Courses at 40% Off

One annual plan covers every course and certificate on Coursera. 40% off for a limited time.

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.

Syllabus

Log Files and System Statistics

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.

Optimizing Queries for Good Performance

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.

Writing Stored Procedures

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.

Managing PostgreSQL Security

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.