Learn Partitioning in PostgreSQL from Scratch

A-Z guide to design and implement partitions in PostgreSQL ( Postgres ) Database

3.55 (83 reviews)

Udemy

platform

English

language

Databases

What you will learn

Understand what, when and how to partition

Implement partitions in production system

Write optimized queries to make use of the designed partitions

Handle maintenance tasks related to partitions

Automate all the tasks that has got to do with partitions

Why take this course?

Learn the key terminologies, basic concepts, implementation techniques that you will need to build a, fully functional partitioned tables with PostgreSQL database. Every concepts or topics are covered with hands on demo session, along with English Caption / Subtitles to provide better clarity.

Many of the key concepts learned in this course can be applied on other databases as well.

Handling huge volume of data / big tables in RDBMS

There are plenty of opportunities in data domain, and being able to learn and appreciate the importance of data volume handling through Partitions in RDBMS, will give you a confidence to tackle the challenges that you encounter in real time projects.

Content and Overview

Through this 7 session course, with more than 40 lectures, 6 Quiz chapters along with additional resources, you will

Understand what, when and how to Partition.
Gain confidence in implementing Partitions in Production system
Know how to write optimized queries on the partitioned tables
Be able to handle maintenance tasks related to partitions
Understand how to automate all the tasks related to partitions

You can test the knowledge gained through the sessions by attending quizzes and every use case mentioned in the course are explained with demo sessions thereby enabling you to practice the newly learned skills.

Downloadable Resources

You can also download the source code files used during the demo sessions, to practice at your end. The source code files are available for download as part of the last section named "Resources".

Learners who complete this course will gain the knowledge and confidence to implement a fully functional and automated Partitioning solutions in the projects.

Screenshots

Learn Partitioning in PostgreSQL from Scratch - Screenshot_01

Learn Partitioning in PostgreSQL from Scratch - Screenshot_02

Learn Partitioning in PostgreSQL from Scratch - Screenshot_03

Learn Partitioning in PostgreSQL from Scratch - Screenshot_04

Reviews

Sai

January 1, 2024

I see only examples for RANGE partition. No examples for LIST partition and as well as mixed partitions like RANGE-LIST , LIST-RANGE and RANGE-LIST-RANGE or RANGE-LIST-LIST which can be implemented.

Gentry

August 4, 2021

The audio quality is so bad. The instructor does have an accent, but the main issue is the quality of the microphone, not the instructor. The content itself isn't bad but it is so difficult to understand and I am constantly replaying the video. The autotranscribe feature does not work either, so I am not really able to get a lot of the smaller details. The instructor is very informative and knows the material well. I find that the material is quite fast, even being someone who is familiar with the topic, it is hard to keep up with what he is doing. I would restructure the course to be more interactive because it is just a video following the instructor, which is helpful but not very interactive like many other courses on Udemy. As I am going through this, I am realizing many ways to teach myself this content by doing a sample project, which makes me think the instructor should be providing these materials.

Louie

July 17, 2021

Excellent!!! Must have course who is dealing with large tables and databases. Teaching methods are based on demos and real life scenarios. The instructor already provides excellent PostgreSQL functions and queries ready to be implemented to your databases.

Heder

July 9, 2020

This course is so rich! Rajkumar knows his trade from inside out and teaches it right to the point during the course. Through it I obtained valuable knowledge on how to implement partitions in Postgres: absorbing this content would be a daunting task without having proper guidance (I tried researching it on my own). The only drawback is really the audio quality which is poor throughout the course but it's far from making it impossible to follow and/or understand. Congrats Rajkumar.

Alexander

April 15, 2018

The content is great but the English speaking is a kind of hell to understand. Subtitles should be mandatory for this course, the automatic one useless. So, that's a great course but I'm having a hard time trying to follow what have being said in every 30 seconds.

Abdul

June 6, 2017

Good informational course, but can be better. I would like to see more hands-on lab and practice examples. Also, I think lectures needs to be bit more elaborative.

Zsolt

June 1, 2017

The quality of the microphone could be better but the course was very useful for me, thank you very much !

James

December 1, 2016

This course provide very useful information about how to create partition table in PostgreSQL. The explanations and demos are very practical and can easily apply to my work senario.

Charts

Price

Rating

Enrollment distribution

Learn Partitioning in PostgreSQL from Scratch - Distribution chart