Setting Up PostgreSQL
4 Topics
1
Installing PostgreSQL
How to install PostgreSQL locally on macOS, Linux, and Windows.
Interviewers expect candidates to understand the PostgreSQL installation process, version management, and configuration basics — especially for backend roles involving database operations and deployment.
2
pgAdmin and psql
Using pgAdmin graphical console and psql command line tool.
Backend engineers must be fluent in psql for production debugging, log analysis, and emergency fixes — interviewers often test your ability to navigate psql efficiently without a GUI.
3
Creating Databases and Users
Writing DDL statements to create database targets and user accounts.
Database creation and user management are fundamental DBA skills. Interviewers test whether you understand role-based access, database isolation, and the principle of least privilege.
4
Database Permissions
Granting and revoking system access rights using SQL GRANT/REVOKE commands.
Permission management is a critical security skill. Interviewers test whether you understand the GRANT/REVOKE model, role inheritance, and the principle of least privilege in database security.