< Back To All Road Maps

Database Administrator Roadmap

A complete guide to becoming a PostgreSQL Database Administrator in 2022

Database Administrator Roadmap

A complete guide to becoming a PostgreSQL Database Administrator in 2022

Learn basics of RDBMS

  • What is SQL
  • What is RDBMS
  • Object models in RDBMS
  • Relational model
  • Database Concepts

Pick a SQL

  • PostgreSQL
  • MySQL
  • Oracle
  • Microsoft SQL Server
  • MariaDB

Install and Run a SQL (PostgreSQL)

  • Install PostgreSQL on Windows
  • Install PostgreSQL on Linux
  • Install PostgreSQL using Docker
  • Learn how to configure PostgreSQL on Cloud Server

Learn Basic SQL concepts

  • Basic of SQL data types
  • Data Manipulation Language (DML) Queries
  • Data Query Language (DDL) Queries
  • Data Query Language (DQL) Queries
  • Data Control Language (DCL) Queries

Learn how to Configure Postgres with other services

  • Configure Postgres with Java
  • Configure Postgres with Python
  • Configure Postgres with PHP
  • Configure Postgres with Ruby on Rails
  • Configure Postgres with Node
  • Configure Postgres with .net core

Learn PostgreSQL security concepts

  • Authentication, permissions, and SSL settings
  • Object previleges
  • SQL injection
  • Row-Level Security

Learn Infrastructure Database Administrator Skills

  • Data Replication
  • Backup and Data Recovery
  • Upgrading precedures
  • Connection Pooling
  • High Data cluster management
  • Resources usages and planning

Learn Automation

  • Automate the SQL shells script using Bash
  • Automate the SQL shells script using Python
  • Automate the SQL shells script using Perl
  • Automate the SQL shells script using Java

Learn DBA Application Skills and Advance Topics

  • Data Migration
  • Data import, export, loading and processing
  • Data partitioning and sharding patterns
  • Processes and memory architecture
  • Vacuum processing
  • Physical storage and file layout
  • Storage parameters
  • Workload-dependant tuning: OLTP, OLAP, HTAP
  • Recursive CTE

Learn SQL Troubleshooting and Optimization techniques

  • Experience with operating system tools
  • Work with pg_stat_activity and pg_stat_statements
  • Query Analyzing
  • Log Analyzing
  • External tracing
  • Troubleshooting with USE, RED, Golden signals
  • Optimize SQL database with B-tree, Hash, GiST, SP-GiST, GIN, BRIN
  • Optimized SQL schema design patterns

Get Certified

  • PostgreSQL v12 Database Administration on Windows and Linux
  • Oracle Certified Associate - Oracle9i Database Administrator (OCA)
  • Oracle Certified Professional - Oracle 9i Database Administrator (OCP)
  • Microsoft Certified Database Administrator (MCDBA)
  • Pro: Windows Server 2008, Enterprise Administrator (MCITP)
  • TS: SQL Server 2008, Implementation and Maintenance (MCTS)