Mastering PostgreSQL 17

Packt via Coursera Specialization

Go to class Write review

Details

Go to class

Provider

Coursera Specialization
Pricing

Paid Course
Languages

English
Certificate

Certificate Available
Level

Intermediate

Found in

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.

Get Full Access

This specialization provides an in-depth journey through PostgreSQL 17, covering core concepts, advanced SQL techniques, performance optimization, security, high availability, and more. The first course focuses on the foundational aspects of PostgreSQL 17, exploring its new features, transaction handling, and advanced SQL capabilities. In the second course, learners delve into performance tuning, query optimization, stored procedures, and secure database management practices. The third course builds on this foundation, focusing on high availability, backups, recovery, and troubleshooting, preparing learners to manage complex PostgreSQL installations. By the end of the specialization, you will be equipped to administer PostgreSQL databases at an advanced level, optimizing them for performance and ensuring they remain secure and available.

Syllabus

Course 1: PostgreSQL 17: Core Concepts and Advanced SQL Techniques
Course 2: PostgreSQL 17: Optimizing Performance & Security
Course 3: PostgreSQL 17: High Availability & Advanced Administration

Courses

0 reviews

View details

This course focuses on mastering PostgreSQL 17's core features and advanced SQL techniques, which are vital for database professionals. You'll explore new enhancements in PostgreSQL 17, along with an in-depth understanding of transaction management, indexing, and complex SQL queries. By the end of the course, you'll be proficient in using PostgreSQL 17 to improve database performance, security, and efficiency, and will be able to apply advanced SQL techniques to real-world database challenges. What sets this course apart is its blend of foundational PostgreSQL concepts with practical, hands-on exercises that help bridge the gap between theory and real-world database management. This course is ideal for database administrators, developers, and anyone seeking to deepen their knowledge of PostgreSQL and SQL, with a foundational understanding of databases required. This course is part one 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.
0 reviews

View details

This course focuses on PostgreSQL's high availability and advanced administration techniques. In today's data-driven world, managing database reliability and performance is essential for businesses. You will develop key skills to handle critical aspects of PostgreSQL administration, such as backup and recovery, replication, troubleshooting, and migration. This practical knowledge enables you to ensure that your databases run smoothly, even in complex, mission-critical environments. This course combines theoretical knowledge with real-world scenarios to help you manage PostgreSQL environments effectively. You’ll learn how to optimize and troubleshoot PostgreSQL databases to meet performance and reliability goals. This course is designed for database administrators and system engineers with prior experience in PostgreSQL or database administration. A basic understanding of SQL and database systems will be beneficial. This course is part three 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.
0 reviews

View details

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.