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
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.
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.
Get to know the list of topics covered as part of this section - Building the Foundation
Understand, What is Partitioning and What to Partition in PostgreSQL database
Understand, why to partition a table
Understand the factors to be considered for determining the Partition key
Demo session for the concepts learned in previous session - Inheritance - Part - 1
Demo session for the concepts learned in previous session - Inheritance - Part - 2
Demo session for the concepts learned in previous session - Inheritance - Part - 3
Understand how constraints are used as part of Inheritance in PostgreSQL database
Understand the concept Check Constraints
Understand the concepts, Functions and Triggers
Understand the concept Vacuum, through a hands on demo session
Understand how to use, Analyze and Explain commands in Postgres
Summary of the Module
In order to answer the questions, you should have attended the Vacuum session and attempted the assignment task mentioned as part of the session
Understand the different types of Partitioning such as
Understand the different types of Partitioning through a hands-on demo session
Understand Trigger based Partitioning with a demo
Understand Rules based Partitioning with a demo
Understand the key rules to be followed while developing a query on partitioned tables
Get to know, how to partition existing tables with data in it
Get to know, how to automate partition table creation by scheduling
Get to know, how to automate data insertion into corresponding partitioned tables
Get to know, how to list partitioned tables in PostgreSQL database
Get to know, how to make a partitioned table back to Non partitioned table.
Get to know, how to handle retention policies with Partitioning in an automated way
Get to know, how to handle partition key value changes
Concluding session with reference to helpful links and Thank You Note.
Please feel free to download the source codes used throughout this course.
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!