Learn Partitioning in PostgreSQL from Scratch (Udemy.com)
A-Z guide to design and implement partitions in PostgreSQL ( Postgres ) Database
Created by: Rajkumar V
Last updated November 2016
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
How it compares
Against the other 47 rated Udemy courses in PostgreSQL on CourseDuck:
- Rating3.9 out of 5higher than 17% of them
- Reviews87#30 of 48 by number of reviews
- Length1.5 hoursshorter than 93% of them
- Last updatedNovember 2016earlier than 97% of them
Quality Score
Overall Score : 78 / 100
Course Description
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
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.Who this course is for:
- Database Administrators
- Database or Data Warehouse programmers
- Application developers using PostgreSQL as their backend
- ETL developers
Instructor Details
- 3.9 Rating
87 Reviews
Rajkumar V
My name is Rajkumar and I am so excited to contribute the learning from my industrial experience.
With more than a decade of experience in IT, I have spent the majority of my time dealing with "DATA", that includes data modeling, data profiling, cleansing, data transformation, storage, retrieval, optimization, governance, mining and reporting.
I have played various roles in my career that includes Developer, Data Modeler, Tester, Project Lead, Product Consultant, Data Architect, ETL Specialist, Solution Architect, Release Manager etc.
To sum up, I am absolutely passionate about anything to do with "DATA" and I am looking forward to share my passion and knowledge with you!
More courses by Rajkumar V
Backup and Restore Fundamentals in PostgreSQL DB - Level 1 (2017)
3.8 (113 Reviews)
Provider: Udemy
Time: 1.9h
$39.99
Backup and Restore Fundamentals in PostgreSQL DB - Level 2 (2017)
3.7 (76 Reviews)
Provider: Udemy
Time: 1.8h
$29.99
More PostgreSQL courses
The Complete SQL Bootcamp: Go from Zero to Hero (2022)
4.7 (258,007 Reviews)
Provider: Udemy
Time: 8.9h
$159.99
SQL and PostgreSQL: The Complete Developer's Guide (2026)
4.7 (13,224 Reviews)
Provider: Udemy
Time: 22.2h
$139.99
SQL & Database Design A-Zâ„¢: Learn MS SQL Server + PostgreSQL (2025)
4.7 (5,426 Reviews)
Provider: Udemy
Time: 12.7h
$15.99
Zero to Hero in SQL: SQL for Data Analytics (2026)
4.6 (14,123 Reviews)
Provider: Udemy
Time: 10.4h
$129.99
SQL and PostgreSQL for Beginners: Become a SQL Expert (2026)
4.6 (8,732 Reviews)
Provider: Udemy
Time: 12.3h
$139.99
PostgreSQL Database Administration on Windows/Linux- Part 1 (2025)
4.6 (7,007 Reviews)
Provider: Udemy
Time: 14.3h
$74.99
Reviews
By Sergey Zhuravlev
ok
By Rafael Milezi de Miranda Reis
Audio quality
By stephen Appiah
good start
By Pavel Fryblik
quality of sound
By Tripermc
just a basic
By Federico Marenzi
many ppt, nothing code!!!
By Aswathi R Nair
Basics are quiet good..
By Vijay pimple
Need more practical examples
By Zoltan Nemes
Audio quality is very poor, I need to re listen to sections to try to understand what he is saying.
By Abdul Khan
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.
By Edgardo Robles
Focused course on partitioning. Audio quaility is not great.
By Alexander da Franca Fernandes
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.








