Become Database Administrator

From SQL basics to high availability and recovery you can trust.

Difficulty: Medium10 stepsDuration: 9 to 15 months

Become Database Administrator.

Step-by-step learning plan

  1. 1. Learn SQL properly

    Technologies

    SELECTJoinsAggregationTransactions

  2. 2. Understand relational modelling

    Technologies

    NormalisationKeysConstraintsIndexes

  3. 3. Install and configure an engine

    Technologies

    PostgreSQLMySQLSQL ServerParameters

  4. 4. Master backup and recovery

    Technologies

    DumpsPITRpgBackRestRestore drills

  5. 5. Tune performance

    Technologies

    Execution plansIndexingVacuumCaching

  6. 6. Secure the data

    Technologies

    RolesTLSAuditingEncryption

  7. 7. Set up replication and HA

    Technologies

    Streaming replicationPatroniFailoverRead replicas

  8. 8. Monitor databases

    Technologies

    PrometheusGrafanapg_statAlerting

  9. 9. Automate DBA operations

    Technologies

    AnsiblePythonCI for migrations

  10. 10. Explore cloud databases

    Technologies

    RDSAuroraAzure SQLCost model