🎁 New User? Get 20% off your first purchase with code NEWUSER20 Register Now →
Menu

Categories

intermediate Level ~90 hours estimated 7 books

Database Administration Career Path

Become a PostgreSQL database administrator. This reading list covers everything from initial setup and SQL fundamentals through performance tuning, security hardening, and high-availability configurations. Follow this path to build the complete DBA skillset that employers demand.

▸ Books in This List

1
SQL for Absolute Beginners

SQL for Absolute Beginners

by Thomas Ellison

SQL foundations — SELECT, INSERT, UPDATE, DELETE, JOINs, and query fundamentals.

2
Database Design & Modeling Fundamentals

Database Design & Modeling Fundamentals

by Thomas Ellison

Learn to design databases properly — normalization, relationships, and schema patterns.

3
PostgreSQL Database Setup: The Complete Guide

PostgreSQL Database Setup: The Complete Guide

by Thomas Ellison

PostgreSQL installation, configuration, postgresql.conf tuning, and user management.

4
PostgreSQL for Developers: Queries, Functions & Triggers

PostgreSQL for Developers: Queries, Functions & Triggers

by Thomas Ellison

Advanced SQL — window functions, CTEs, JSON operations, PL/pgSQL functions, and triggers.

5
PostgreSQL Administration & Performance Tuning

PostgreSQL Administration & Performance Tuning

by Thomas Ellison

DBA essentials — connection pooling, memory tuning, query optimization, indexing, and VACUUM.

6
PostgreSQL Security & Access Control

PostgreSQL Security & Access Control

by Thomas Ellison

Security hardening — authentication, RBAC, row-level security, SSL, and audit logging.

7
PostgreSQL Backup, Replication & High Availability

PostgreSQL Backup, Replication & High Availability

by Thomas Ellison

Production readiness — backups, PITR, streaming replication, Patroni failover, and DR planning.

About This Reading List

This curated reading list contains 7 carefully selected books at the intermediate level with an estimated reading time of 90 hours . Follow the recommended order for the best learning experience.

▸ Frequently Asked Questions

What is the "Database Administration Career Path" reading list?
It is a curated collection of 7 eBooks carefully selected and ordered to help you master the topic step by step. The list is designed for intermediate-level learners.
How many books are in this reading list?
This reading list contains 7 books, arranged in a recommended reading order for the best learning experience.
What skill level is this reading list for?
This reading list is designed for intermediate-level learners. Some foundational knowledge is recommended before diving in.
How long will it take to complete this reading list?
The estimated reading time is approximately 90 hours. This is an estimate based on average reading speed — your actual time may vary depending on your pace and how deeply you study each book.
Which book should I start with?
We recommend starting with "SQL for Absolute Beginners", which is the first book in the list. The books are arranged in an order that builds knowledge progressively.
Do I need to read the books in order?
While you can read the books in any order, we recommend following the suggested sequence. The list is structured so each book builds on concepts from the previous ones, providing the most effective learning path.
Can I buy the books individually?
Yes, each book in this reading list can be purchased individually. Click "View Book" on any title to see full details, reviews, and purchase options.