Monte Cristo Logo
Monte Cristo

Database Administration

13 resources

Level
Type

📹Videos(3)

video👁️ 0

PostgreSQL Administration Tutorial for Beginners

Comprehensive tutorial on PostgreSQL admin tasks from Reddit r/PostgreSQL thread

beginner🇬🇧
video👁️ 0

MySQL DBA Tutorial

Practical MySQL administration guide

beginner🇬🇧
video👁️ 0

SQL Tutorial for Beginners

Comprehensive SQL tutorial covering basics to advanced queries

beginner🇬🇧

🎓Courses(2)

course👁️ 0

Databases and SQL for Data Science with Python

Working knowledge of SQL (or Structured Query Language) is a must for data professionals like Data Scientists, Data Analysts and Data Engineers. Much of the world's data resides in databases. SQL is a powerful language used for communicating with and extracting data from databases. In this course you will learn SQL inside out- from the very basics of Select statements to advanced concepts like JOINs. You will: -write foundational SQL statements like: SELECT, INSERT, UPDATE, and DELETE -filter result sets, use WHERE, COUNT, DISTINCT, and LIMIT clauses -differentiate between DML & DDL -CREATE, ALTER, DROP and load tables -use string patterns and ranges; ORDER and GROUP result sets, and built-in database functions -build sub-queries and query data from multiple tables -access databases as a data scientist using Jupyter notebooks with SQL and Python -work with advanced concepts like Stored Procedures, Views, ACID Transactions, Inner & Outer JOINs through hands-on labs and projects You will practice building SQL queries, work with real databases on the Cloud, and use real data science tools. In the final project you’ll analyze multiple real-world datasets to demonstrate your skills.

beginner🇬🇧
course👁️ 0

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.

beginner🇬🇧

📚Books(2)

book👁️ 0

Oracle Database Administration

Oracle Database Administration - A book resource

intermediate🇬🇧
book👁️ 0

MySQL Crash Course

MySQL Crash Course - A book resource

intermediate🇬🇧

🌐Websites(6)

scroll for more →
website👁️ 0

DBA Stack Exchange

Q&A for database administrators

beginner🇬🇧
website👁️ 0

Percona Blog

MySQL and DBA best practices

beginner🇬🇧
website👁️ 0

Use The Index, Luke

SQL index performance guide

beginner🇬🇧
website👁️ 0

sqlshack.com

SQLShack is a technical resource with tutorials, how-tos, and code samples for SQL Server database administration. It covers maintenance, performance tuning, backups, security, and other common DBA tasks.

intermediate🇬🇧
website👁️ 0

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.

intermediate🇬🇧
website👁️ 0

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.

intermediate🇬🇧

Frequently Asked Questions

What are the best free resources to learn Database Administration?

Dantes has curated 9 resources for Database Administration, including 3 videos, 3 courses, 3 websites. All resources are hand-picked for quality — no algorithmic filler. Browse the full list above to find the format that works best for you.

Is Database Administration hard to learn?

Database Administration is approachable at the beginner level — there are resources here specifically for those starting from scratch. As you progress, intermediate and advanced material is also available to take your skills further.

What types of Database Administration learning resources are available on Dantes?

For Database Administration, Dantes has curated 3 videos, 3 courses, 3 websites. Each resource type serves a different learning style: videos and YouTube for visual learners, books for depth, courses for structured progression, and websites for quick reference.

How does Dantes select Database Administration resources?

Dantes is an algorithm-free learning directory. Resources are hand-curated based on quality, accuracy, and usefulness — not engagement metrics or paid placements. The goal is to surface the best learning material for Database Administration, whether it's a free YouTube series, a classic textbook, or an open courseware from a top university.

Go deeper

Test your understanding of Database Administration

Explain it out loud. An AI tutor listens and asks questions that expose gaps you didn't know you had.