Database Administration – The Backbone of the Modern Tech World
Moving beyond basic SQL queries, this course introduces the specific roles, architectures, and administration tasks for the world's most popular relational database engines: SQLite, MySQL, MariaDB, PostgreSQL, and Microsoft SQL Server.
The Serverless Option - SQLite
Explore the unique architecture of SQLite, a file-based database engine widely used in mobile apps, IoT, and small-scale applications.
The Web Standards - MySQL & MariaDB
Learn the administration basics of the world's most popular open-source databases, focusing on user management, storage engines, and the relationship between MySQL and its fork, MariaDB.
The Object-Relational Powerhouse - PostgreSQL
Dive into PostgreSQL's advanced architecture, covering configuration files (pg_hba.conf), concurrency control (MVCC), and its focus on strict standards compliance.
The Enterprise Standard - Microsoft SQL Server
Understand the ecosystem of MSSQL, including T-SQL differences, SQL Server Management Studio (SSMS), and integration with Windows environments.
Core DBA Tasks: Backup, Security, & Maintenance
A comparative look at how to handle critical DBA responsibilities—such as backups, user permissions, and maintenance—across these different platforms.