Enjoying the preview?
This is the free first lesson. Get full access — request a demo or sign in.
MySQL: Partitions
How to effectively manipulate partitions.Preview the first lesson free — get full access to all 6 lessons.
Advanced Provider : Kati Gordon 6 Lessons · 9m in Arabic, German, English, Spanish, French, Portuguese, Chinese
Course Description
This module provides an overview of partitioning in PostgreSQL. Partitioning is the practice of splitting one table into multiple smaller tables. It’s useful when you have a large table and some columns are frequently occurring in the where clause whenever it is queried. In this module, you’ll gain an understanding of partition creation using range, hash, and lists. This module also touches on how material views are useful and how you can create them.
What You'll Learn
- Create partitions using range to split a large table into smaller tables
- Create partitions using hash for distributing table data
- Create partitions using list to organize table data
- Determine when to use a partition and which partition fits a given scenario
- Build materialized views and understand their purpose
- Apply partitioning to columns that frequently appear in query WHERE clauses
Key Takeaways
- Partitioning is the practice of splitting one table into multiple smaller tables.
- Partitioning is useful when a table is large and some columns frequently occur in the WHERE clause when the table is queried.
- Partitions can be created using range, hash, and list methods.
- The module covers when to use a partition and which partitions to use in any scenario.
- Materialized views serve a specific purpose and the module shows how to create them.
Frequently Asked Questions
What does this course cover?
It provides an overview of partitioning, including creating partitions using range, hash, and list, plus how materialized views are useful and how to create them.
What is partitioning?
Partitioning is the practice of splitting one table into multiple smaller tables, which is useful when you have a large table and some columns are frequently occurring in the WHERE clause whenever it is queried.
What skills will I gain from this course?
The course addresses skills including data partitioning, database partitioning, disk partitioning, basic partitioned access methods, recursive partitioning, and PostgreSQL.
What lessons are included?
Lessons include Creating Partitions Using Range, Creating Partitions Using Hash, Creating Partitions Using List, Materialized Views, and Creating Materialized Views.
Will I learn when to use a partition?
Yes. The learning objectives include knowing which partitions to use in any scenario and when to use a partition.
