12 PostgreSQL Interview Questions
See if you can read through the list below and answer every question. If you can - you are going to crush this interview!
See if you can read through the list below and answer every question. If you can - you are going to crush this interview!
What workload analysis and running queries can teach us about the performance differences in JSON, indexing, and concurrency.
Using pg_notify in Postgres alongside the NOTIFY and LISTEN syntax is all that's needed to build a real time updating dashboard.
Learn how to use inheritance in your Postgres database to save time and effort with data management.
Deleted records from your database could still be taking up space on your disk. Learn how to use VACUUM to reduce size and improve performance of your databases.
Learn how to create a web app using Flask, connect to a Postgres database, and deploy the app and database to Heroku.
Create a database schema for any situation with the power of JSON.
Universally Unique IDs (UUIDs) use random numbers to create unique IDs. UUIDs use more storage, but they provide a good solution for distributed databases and security.
SQL triggers are less common but can be a great solution for certain situations. I'll provide examples for how to use triggers to enforce data integrity and track changes to a database.