Free sample drills
One real-world question and answer per topic, written for experienced database professionals. Open any topic to read its free sample.
SQL Server DBA
- Availability Groups operational administration
- Backup, restore, and recovery planning
- Concurrency, transaction log management, and database recovery models
- Data movement, bulk operations, SQL Server Agent, and automation
- Database design review, data types, partitioning, compression, and filegroup strategy
- High availability and disaster recovery
- Index design, maintenance, and statistics management
- Monitoring, alerting, baselining, and operational diagnostics
- Performance troubleshooting and query tuning
- Query Store, execution plans, waits, blocking, and deadlock analysis
- Replication administration and troubleshooting
- Routine maintenance, integrity checks, and capacity management
- Security, authentication, authorization, and auditing
- SQL Server configuration, memory, CPU, storage, and tempdb administration
- SQL Server installation, unattended deployment, startup options, and system database recovery
- Upgrade, patching, migration, compatibility levels, and deprecation management
- What's new in the current version
- DarlingData (Erik Darling)
- dbatools for SQL Server Administration
- First Responder Kit
- Ola Hallengren Maintenance Solution
- sp_WhoIsActive
- Common SQL Server Database Administration Tasks & Troubleshooting
- SQL Server Database Administration Quick Reference
- Vocabulary
Azure SQL Server DBA
- Deployment Options, Service Tiers & Cost Management
- Connectivity & Networking
- Identity, Security & Compliance, Azure-specific
- High Availability & Disaster Recovery
- Backup, Restore & Retention
- Monitoring & Performance, Azure-specific
- Scaling, Elastic Pools & Hyperscale
- Managed Instance Administration
- Azure SQL Database Specifics (Logical Server & Limits)
- Automation & Infrastructure Management
- Data Integration & Replication
- Migration: Discovery, Assessment & Planning
- Migration: Methods & Tooling
- Migration: Cutover, Validation & Post-Migration
- What's new in the current version
- Common Azure SQL Server Database Administration Tasks & Troubleshooting
- Azure SQL Server Database Administration Quick Reference
- Managed Instance operations
- Vocabulary
PostgreSQL DBA
- Architecture & Internals for Administrators
- Installation, Configuration & Memory
- Roles, Authentication & Security
- Backup, PITR & Restore
- High Availability & Streaming Replication
- Logical Replication & Data Movement
- Vacuum, Autovacuum, Bloat & Wraparound
- Indexing & Statistics
- Query Performance & EXPLAIN
- Locking, Concurrency & Transactions
- Monitoring & Diagnostics
- Partitioning, Storage & Maintenance Operations
- Upgrade, Patching & Migration
- Connection Management
- Extensions & Contrib Modules
- What's new in the current version
- pgBackRest
- Patroni
- PgBouncer
- pgBadger
- Common PostgreSQL Database Administration Tasks & Troubleshooting
- PostgreSQL Database Administration Quick Reference
- Vocabulary
Oracle DBA
- Architecture & Internals for Administrators
- Installation, Configuration & Memory
- Multitenant Architecture
- Storage, Tablespaces, ASM & Partitioning
- Security & Access Control
- Backup, Recovery & Flashback
- Data Guard & High Availability
- Real Application Clusters
- Indexing & Optimizer Statistics
- SQL Tuning & Execution Plans
- Performance Diagnostics, AWR & Monitoring
- Transactions, Concurrency & Locking
- Resource Management, Scheduler & Jobs
- Networking, Listener & Connection Management
- Upgrade, Patching & Migration
- What's new in the current version
- Oracle Recovery Manager (RMAN)
- Oracle Data Pump & SQL*Loader
- AutoUpgrade, OPatch & Datapatch
- SQL*Plus & SQLcl
- Common Oracle Database Administration Tasks & Troubleshooting
- Oracle Database Administration Quick Reference
- Vocabulary
MySQL / MariaDB DBA
- Architecture & Internals for Administrators
- Installation, Configuration & Memory
- Accounts, Authentication & Security
- Backup, PITR & Restore
- Replication
- High Availability & Clustering
- Binary Logging & Data Movement
- InnoDB, Storage & Maintenance Operations
- Indexing & Statistics
- Query Performance & EXPLAIN
- Locking, Concurrency & Transactions
- Monitoring & Diagnostics
- Upgrade, Patching & Migration
- Connection Management
- Online Schema Changes & Partitioning
- Percona XtraBackup
- MariaDB Backup
- ProxySQL
- Percona Toolkit
- Common MySQL / MariaDB Database Administration Tasks & Troubleshooting
- MySQL / MariaDB Database Administration Quick Reference
- What's new in the current version
- Vocabulary
MongoDB DBA
- Architecture & Internals for Administrators
- Installation, Configuration & Memory
- Security & Access Control
- Backup, PITR & Restore
- Replication
- Sharding
- Indexing
- Query Performance & Explain
- Collections, Schema Validation & Data Types
- Transactions, Concurrency & Locking
- Monitoring & Diagnostics
- Upgrade, Patching & Migration
- Connection Management
- Change Streams & Data Movement
- Time Series & Special Collections
- What's new in the current version
- MongoDB Database Tools
- Percona Backup for MongoDB
- MongoDB Atlas Operations
- Common MongoDB Database Administration Tasks & Troubleshooting
- MongoDB Database Administration Quick Reference
- Vocabulary
Redis / Valkey DBA
- Architecture & Internals for Administrators
- Installation, Configuration & OS Tuning
- Security & Access Control
- Persistence: RDB & AOF
- Backup & Restore
- Replication
- Sentinel & High Availability
- Cluster & Sharding
- Memory Management & Eviction
- Data Types & Keyspace Design for Operators
- Latency & Performance Diagnostics
- Monitoring & Diagnostics
- Client Connections (server side only)
- Pub/Sub, Streams & Scripting for Operators
- Upgrade, Patching & Migration
- Redis versus Valkey: Differences
- What's new in the current version
- Redis and Valkey Command-Line Tools
- Common Redis / Valkey Database Administration Tasks & Troubleshooting
- Redis / Valkey Database Administration Quick Reference
- Vocabulary
Snowflake DBA
- Architecture & Core Concepts for Administrators
- Accounts, Editions & Organization Administration
- Access Control & Roles
- Authentication & Network Security
- Virtual Warehouses & Compute
- Cost Management & Resource Governance
- Storage, Tables & Micro-partitions
- Time Travel, Fail-safe & Cloning
- Data Loading & Unloading Operations
- Dynamic Tables, Streams & Tasks for Operators
- Query Performance Diagnostics
- Monitoring, Auditing & Alerting
- Replication, Failover & Business Continuity
- Data Sharing & Marketplace Administration
- Data Governance & Privacy
- Iceberg Tables & External Storage
- What's new in the current version
- Snowflake Command-Line Tools
- Common Snowflake Database Administration Tasks & Troubleshooting
- Snowflake Database Administration Quick Reference
- Vocabulary