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: Core Concepts and Advanced SQL Techniques

PostgreSQL 17: Core Concepts and Advanced SQL Techniques

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
Optimize database performance and handle complex queries
Implement replication and security strategies for high availability

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 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.

This module explores the latest enhancements introduced in PostgreSQL 17, including new system views for performance monitoring, advanced partition management capabilities, and expanded JSON functionalities. Learners will gain practical insights into how these features can improve database administration and development workflows.

What's included

1 video4 readings1 assignment

This module explores the critical concepts of transactions and locking in PostgreSQL, including how transactional DDLs work, the implications of different isolation levels, and strategies for managing concurrency. Learners will also examine alternative solutions for generating unique values and understand the impact of operations like VACUUM FULL on database performance.

What's included

1 video5 readings1 assignment

This module delves into advanced indexing strategies in PostgreSQL, exploring how different index types, operator classes, and clustering techniques can dramatically impact query performance and storage efficiency. Learners will discover when and how to use various indexes, optimize queries, and extend PostgreSQL's indexing capabilities for specialized use cases such as full-text and fuzzy searches.

What's included

1 video14 readings1 assignment

1 videoTotal 1 minute

Overview1 minute

14 readingsTotal 71 minutes

Introduction6 minutes
Digging into the PostgreSQL Cost Model5 minutes
Making Use of Sorted Output6 minutes
Using Indexes Intelligently4 minutes
Improving Speed Using Clustered Tables6 minutes
Clustering Tables6 minutes
Reducing Space Consumption4 minutes
Introducing Operator Classes4 minutes
Creating New Operators6 minutes
Understanding PostgreSQL Index Types3 minutes
Extending GiST5 minutes
BRINs5 minutes
Taking Advantage of pg_trgm4 minutes
Understanding Full-Text Searches7 minutes

1 assignmentTotal 16 minutes

Mastering Indexing Strategies16 minutes

This module delves into advanced SQL techniques, including performance optimization with indexing, efficient data aggregation using grouping sets and window functions, and handling complex data types like JSON and range types in PostgreSQL. Learners will also explore recursion, parallel query support, and methods for managing duplicates and partitioning data. By the end, you'll be equipped to write more powerful and efficient SQL queries for sophisticated data analysis tasks.

What's included

1 video11 readings1 assignment

1 videoTotal 1 minute

Overview1 minute

11 readingsTotal 73 minutes

Introduction7 minutes
When to Use Range Types6 minutes
Investigating Performance13 minutes
Using Sliding Windows6 minutes
Removing Duplicates Using EXCLUDE TIES and EXCLUDE GROUP6 minutes
NTile() Function6 minutes
The first_value(), nth_value(), and last_value() Functions7 minutes
Adding Support for Parallel Queries6 minutes
Handling Recursions5 minutes
Working with JSON and JSONB5 minutes
Accessing a JSON Document6 minutes

1 assignmentTotal 16 minutes

Mastering Complex SQL Techniques16 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 Courses499,028 learners

Offered by

Packt

Explore more from Data Management

Packt
PostgreSQL 17: Optimizing Performance & Security
Course
Packt
PostgreSQL 17: High Availability & Advanced Administration
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.