Learn Partitioning in PostgreSQL from Scratch (Udemy.com)

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

( 17 Reviews )

Created by: Rajkumar V

Produced in 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

Quality Score

Content Quality

Video Quality

Qualified Instructor

Course Pace

Course Depth & Coverage

Overall Score : 68 / 100

Course Description

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.Who this course is for:

Database Administrators
Database or Data Warehouse programmers
Application developers using PostgreSQL as their backend
ETL developers

Time: 1.5h

Instructor Details

Rajkumar V

3.4 Rating
17 Reviews

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!

Backup and Restore Fundamentals in PostgreSQL DB - Level 1

Backup and Restore Fundamentals in PostgreSQL DB - Level 1 (2017)
3.7 (17 Reviews)

- Provider: Udemy
- Time: 2h

$11.99

Backup and Restore Fundamentals in PostgreSQL DB - Level 2

Backup and Restore Fundamentals in PostgreSQL DB - Level 2 (2017)
4.2 (10 Reviews)

- Provider: Udemy
- Time: 2h

$11.99

All courses by Rajkumar V

Reviews

3.4

17 total reviews

5 star 4 star 3 star 2 star 1 star

Write a Review

By Sergey Zhuravlev

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.