Advanced Database Administration
Coursera
Dive deep into advanced Oracle database administration with this comprehensive course. You'll gain mastery over RMAN operations, database duplication, flashback recovery, and patch management, all critical for ensuring database resilience and efficiency. With hands-on labs, you'll build practical skills in backup, recovery, and automation techniques. The course begins with an in-depth exploration of RMAN in multitenant environments, guiding you through backup and recovery in CDBs and PDBs. You'll practice RMAN commands, database duplication methods, and recovery scenarios, gaining a robust foundation in advanced backup solutions. Next, you'll delve into utilities like Oracle Data Pump and SQL Loader, enabling efficient data movement and management. Moving further, you'll explore automatic storage management (ASM), scheduler automation, and ADR diagnostic tools, empowering you to streamline storage and troubleshoot effectively. The course also covers applying database patches and performing upgrades, ensuring you're prepared to manage the latest Oracle environments confidently. Designed for experienced DBAs, this course is perfect for those looking to elevate their expertise in Oracle database administration. Prerequisites include a solid understanding of Oracle database fundamentals and experience in basic database management.
More resources on Database Administration
use-the-index-luke.com
A practical guide to database indexing and query optimization, offering clear explanations of how indexes work, how to design them, and tutorials with SQL examples across major relational databases.
Learn PostgreSQL Tutorial - Full Course for Beginners
Four-hour freeCodeCamp course walking through PostgreSQL from installation and psql basics to table design, constraints, joins, aggregate functions, exporting data and UUID keys. Viewers finish able to set up a database and run realistic queries against it.
DBA Stack Exchange
Stack Exchange site where working database administrators answer questions on query tuning, replication, backups, indexing and upgrades across MySQL, PostgreSQL, SQL Server and Oracle. Voting surfaces tested answers, and searching past threads usually resolves operational problems quickly.
Percona Blog
Engineering blog from Percona, a MySQL, PostgreSQL and MongoDB support vendor. Posts benchmark storage engines, dissect replication and failover behaviour, and explain version changes, giving practitioners evidence-based guidance on tuning and operating open-source databases in production.
Database Administration: The Complete Guide
Craig Mullins covers the DBA role end to end: data modelling, schema design, change management, backup and recovery, performance monitoring, security and disaster planning. Written to be DBMS-independent, so the practices carry across Oracle, DB2 and SQL Server.
dba-oracle.com
DBA-Oracle is a resource focused on Oracle database administration, offering tutorials, guides, and practical tips for DBAs. Content covers SQL/PLSQL, performance tuning, backup and recovery (RMAN), high availability (RAC/Data Guard), security, and other DBA best practices.