What are database indexes and how do they work
· SQL & Databases
Speed up queries with B-tree and hash indexes while understanding the tradeoffs of write performance and storage.
Category: SQL & Databases
60 questions in SQL & Databases.
What is PostgreSQL partitioning
· SQL & Databases
Scale large tables by splitting them into smaller, manageable partitions based on range, list, or hash strategies.
How to implement row level security in PostgreSQL
· SQL & Databases
Restrict data access at the row level using PostgreSQL Row-Level Security policies tied to user roles.
How to use PostgreSQL functions
· SQL & Databases
Create reusable SQL and PL/pgSQL functions in PostgreSQL for business logic, triggers, and queries.
What is PostgreSQL full text search
· SQL & Databases
Implement powerful text search in PostgreSQL using tsvector, tsquery, and GIN indexes without external engines.
How to use PostgreSQL arrays
· SQL & Databases
Store and query multi-value data natively using PostgreSQL array types and operators.
How to use the psql command line tool
· SQL & Databases
Interact with PostgreSQL efficiently using the psql CLI, meta-commands, scripting, and customization options.
What is MVCC in PostgreSQL
· SQL & Databases
Understand Multi-Version Concurrency Control and how PostgreSQL handles concurrent reads and writes without locking.
How to implement database migrations
· SQL & Databases
Manage schema evolution safely and reproducibly with versioned migration scripts and tools.
What are PostgreSQL extensions
· SQL & Databases
Enhance PostgreSQL capabilities with extensions that add data types, functions, indexes, and foreign data wrappers.