MySQL Database Basics
Learn how to install MariaDB or MySQL-compatible database services, connect to the SQL shell, manage databases and users, and perform basic backup and restore operations. This course introduces the database administration fundamentals that Linux and DevOps practitioners often need in application environments.
Why It Matters
Many production services depend on relational databases, and operators often need to install them, verify access, create application users, and protect data with backups. Even if you are not a dedicated database administrator, you still need to understand the basics of database service setup and maintenance in Linux environments.
What You Will Learn
- Install and verify a MariaDB or MySQL-style database server.
- Connect to the SQL shell and perform basic interactive administration.
- Create databases and users with the access they need.
- Back up and restore database content for maintenance and recovery.
- Understand the database workflow behind application migrations.
- Apply these skills in a practical database migration challenge.
Course Roadmap
The course begins with installing a MariaDB database server and confirming that the service is running correctly. You then connect to the SQL shell, where you learn the basic workflow for interacting with the database engine directly.
Next, the course focuses on managing databases and users so you can separate application data and control access more deliberately. After that, you learn backup and restore basics, which are essential for maintenance, migration, and recovery planning.
The course ends with the Application Database Migration challenge, where installation, access management, and data protection skills come together in a realistic application-support scenario.
Who This Course Is For
This course is for Linux learners, junior administrators, and DevOps beginners who need a practical introduction to managing a MySQL-compatible database service.
Outcomes
By the end of this course, you will be able to install a basic database service, connect and administer it from the SQL shell, manage databases and users, and carry out simple backup and restore tasks with more confidence.
