Database Engineering — Skills Plan
Planned skill map for Database Engineering. The curriculum will be developed and released in stages.
Study PostgreSQL, MongoDB, and Redis through data modeling, transactions, indexes, query performance, caching, backup, access control, and recovery.
Potential roles: Database Engineer · Backend Engineer · DBA
Before you start
- SQL and relational modeling
- Networking and application basics
What you’ll build
- Design and migrate a production schema
- Build a cache-backed API
- Practice recovery from a database incident
Prerequisites
PLANNED- SQL and relational modeling
Build the SQL and relational modeling knowledge needed to follow the Database Engineering foundations.
- Networking and application basics
Build the Networking and application basics knowledge needed to follow the Database Engineering foundations.
Foundations
PLANNED- PostgreSQL architecture and operations
Explain how PostgreSQL architecture and operations works and where it fits in the Database Engineering learning path.
- Transactions and isolation
Explain how Transactions and isolation works and where it fits in the Database Engineering learning path.
- Indexes and query plans
Explain how Indexes and query plans works and where it fits in the Database Engineering learning path.
- Schema migrations
Explain how Schema migrations works and where it fits in the Database Engineering learning path.
Core Skills
PLANNED- JSONB and full-text search
Use JSONB and full-text search to implement a working capability and verify its behavior in Database Engineering.
- Partitioning and data lifecycle
Use Partitioning and data lifecycle to implement a working capability and verify its behavior in Database Engineering.
- MongoDB documents and aggregation
Use MongoDB documents and aggregation to implement a working capability and verify its behavior in Database Engineering.
- Redis data structures and caching
Use Redis data structures and caching to implement a working capability and verify its behavior in Database Engineering.
- Connection pooling and access control
Use Connection pooling and access control to implement a working capability and verify its behavior in Database Engineering.
Advanced / Production
PLANNED- Replication, backup, and recovery
Evaluate Replication, backup, and recovery trade-offs against the performance, reliability, and safety needs of Database Engineering systems.
- Performance diagnosis and tuning
Evaluate Performance diagnosis and tuning trade-offs against the performance, reliability, and safety needs of Database Engineering systems.
- High availability and failover
Evaluate High availability and failover trade-offs against the performance, reliability, and safety needs of Database Engineering systems.
- Database security and auditing
Evaluate Database security and auditing trade-offs against the performance, reliability, and safety needs of Database Engineering systems.
- Monitoring and capacity planning
Evaluate Monitoring and capacity planning trade-offs against the performance, reliability, and safety needs of Database Engineering systems.
Real-World Projects
PLANNED- Design and migrate a production schema
Deliver a working outcome with Design and migrate a production schema, then test it against the project requirements.
- Build a cache-backed API
Deliver a working outcome with Build a cache-backed API, then test it against the project requirements.
- Practice recovery from a database incident
Deliver a working outcome with Practice recovery from a database incident, then test it against the project requirements.
Career / Interview Preparation
PLANNED- Query-plan analysis
Explain your approach to Query-plan analysis, defend key trade-offs, and discuss what you learned.
- Transaction and index trade-offs
Explain your approach to Transaction and index trade-offs, defend key trade-offs, and discuss what you learned.
- Database design review
Explain your approach to Database design review, defend key trade-offs, and discuss what you learned.
- Operations scenario walkthrough
Explain your approach to Operations scenario walkthrough, defend key trade-offs, and discuss what you learned.
Discussion
0Have a better approach? Found something outdated? Share it — your knowledge helps everyone learning here.