--- title: Database Administration description: Database administration focuses on the installation, configuration, maintenance, and security of database management systems. Learners will understand backup and recovery procedures, user access control, performance monitoring, and ensuring high availability of data. category: programming-tech subcategory: databases difficulty: beginner, intermediate, advanced url: /subject/database-administration --- # Database Administration Database administration focuses on the installation, configuration, maintenance, and security of database management systems. Learners will understand backup and recovery procedures, user access control, performance monitoring, and ensuring high availability of data. ## Available Resources 1 Videos • 1 Books • 1 Courses • 6 Websites ## Videos ### 1. 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. **Difficulty:** Beginner | **Price:** Free **Link:** https://www.youtube.com/watch?v=qw--VYLpxG4 **Tags:** postgresql, sql, psql, database-design, freecodecamp ## Websites ### 1. 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. **Difficulty:** Beginner | **Price:** Free **Link:** https://dba.stackexchange.com/ **Tags:** database-administration, sql, q-and-a, troubleshooting, performance-tuning ### 2. 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. **Difficulty:** Beginner | **Price:** Free **Link:** https://www.percona.com/blog/ **Tags:** mysql, postgresql, performance-tuning, database-administration, open-source ### 3. 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. **Difficulty:** Intermediate | **Language:** English | **Price:** Free **Link:** https://dba-oracle.com **Tags:** websites, technology-computer-science, database--backend ### 4. SQLShack Free article library started by ApexSQL, written by SQL Server professionals, covering T-SQL, indexing, query tuning, backup and recovery, high availability, auditing and SSIS. Readers can follow step-by-step examples to administer, secure and tune SQL Server instances. **Difficulty:** Intermediate | **Language:** English | **Price:** Free **Link:** https://sqlshack.com **Tags:** sql-server, t-sql, database-administration, performance-tuning, backup-and-recovery ### 5. 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. **Difficulty:** Intermediate | **Language:** English | **Price:** Free **Link:** https://use-the-index-luke.com **Tags:** websites, technology-computer-science, computer-sciences ### 6. sqlservercentral.com SQLServerCentral is a community-driven resource for SQL Server professionals. It offers tutorials, articles, scripts, forums, and news covering SQL Server administration, development, and performance optimization. **Difficulty:** Intermediate | **Language:** English | **Price:** Free **Link:** https://sqlservercentral.com **Tags:** websites, technology-computer-science, database--backend ## Books ### 1. Database Administration: The Complete Guide **Author:** Craig S. Mullins 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. **Difficulty:** Intermediate | **Language:** English | **Price:** Paid **Link:** https://www.amazon.com/dp/0201741296?tag=edmonddante07-20 **Tags:** books, technology-computer-science, database ## Courses ### 1. Advanced Database Administration 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. **Difficulty:** Beginner | **Language:** English | **Price:** Free **Link:** https://www.coursera.org/learn/packt-advanced-oracle-database-administration-5d9rn **Tags:** courses, technology-computer-science, database--backend --- *This content is part of Dantes.io - Your Treasure Map to Knowledge* *Curated by humans at Dantes.io. Personal study use welcome; republishing this curation requires permission (team@dantes.io).* View this page online: https://dantes.io/subject/database-administration