Database Indexing :-- SQL Query Planner and Optimizer- Index Scan vs Index Only Scan- Key vs Non-Key Column Database Indexing - Combining Database Indexes- Database Optimizers- Create Index Concurrently- Bloom Filters
Prerequisite knowledge
Worked with Databases before Basic SQL Knowledge
Learning outcomes
This session will enable the learners to take a deeper dive into Database engineering with the topic of Database Indexing.
Software / Hardware requirements
Postgresql Database
Related courses
Database Management - Database Partioning
1.5 hours session
Database Management - Database Sharding
1.5 hours session
Database Operations -Getting Started with Postgres Database