O'Reilly School of Technology > Individual Courses > DBA 2: Administering MySQL

DBA 2: Administering MySQL

In this course, you will learn how to estimate database capacity needs and install a MySQL server.

Upon completion of this course, you will be able to:

  • Set up database users, grant permissions, and apply advanced security to database objects.
  • Create and maintain database objects.
  • Perform data security through backups and restoration.
  • Provide data to external systems using exports, and include external data using imports.
  • Track database performance and troubleshoot problems.
  • Develop a complete database and demonstrate administrative tasks.

From beginning to end, you will learn by doing Unix and MySQL-based projects and submitting them for instructor feedback.  These projects, as well as the final project, will add to your portfolio and contribute to certificate completion. Besides a browser and Internet connection, all software is provided online by the O’Reilly School of Technology.

This course counts toward the Database Administration Certificate.

Prerequisites: DBA 1: Introduction to Database Administration and Linux Systems Administration: The Command Line, or equivalent skills.  This course is meant for the beginning or intermediate database administrator.

90 Clock-hours  6 CEUs  $398.00 $278.60

Add to Cart:   Proceed with Enrollment

Course Details and Syllabus

Course: DBA 2: Administering MySQL
Tuition: $398 $278.60
Time Frame: This course is online and self-paced. You can expect to work approximately 90 hours on this course.
Technical Requirements: As long as you have a web browser and internet connection, you can take this course from anywhere in the world.
CEUs: 6 Continuing Education Units with official letter from O’Reilly Media.
Software: The web-based Learning Sandbox® provided for you will contain all your lessons, projects, quizzes, account files, editors, and programming tools necessary to build your skills from beginning to end, even beyond coursework. In addition, you’ll be provided with a mySQL account that can be accessed through the Sandbox or, if you prefer, any normal SSH program. No other software is needed.
Instructor: You will have one instructor throughout the course who will evaluate your projects and quizzes, hand them back for improvement when necessary, and coach you throughout your skills advancement.
Book: All required course materials and software are included online within the Learning Sandbox®. However, within a few weeks of enrolling, you’ll receive the e-book High Performance MySQL, 3rd Edition as a reference resource from O’Reilly.
Certificates: Completion of this course counts toward the Database Administration Certificate Series.
Prerequisites: DBA 1: Introduction to Database Administration and Linux Systems Administration: The Command Line
(or equivalent skills)
Topics: Database Capacity, Users and Permissions, Advanced Security, Indexing Databases, Maintaining Databases, Backups & Restores, Bulk Exports and Imports, Performance, and Troubleshooting
Syllabus:
  • DBA 2 Lab 1 — Introduction
    • How to Learn using OST Courses
    • Understanding the Learning Sandbox
    • Getting Started with MySQL
    • Installing MySQL
  • DBA 2 Lab 2 — Estimating Database Capacity
    • Introducing the sakila database
    • Examining Disk Usage and Space Requirments
    • Estimating Database Load
  • DBA 2 Lab 3 — Users and Permissions
    • Planning for Users
    • Adding and Removing Users
    • Setting up and Using Permissions
    • Copying Permissions to New Users
  • DBA 2 Lab 4 — Advanced Security
    • Column Security
    • Row Security
  • DBA 2 Lab 5 — Indexing Databases, Part I
    • What are Indexes?
    • Primary Keys
    • Other Indexes
    • Foreign Keys
    • Adding Indexes on Existing Tables
  • DBA 2 Lab 6 — Indexing Databases, Part II
    • Selecting Columns
    • Picking Good Columns to Index
    • Managing Indexes
  • DBA 2 Lab 7 — Maintaining Databases
    • Analyzing Tables
    • Optimizing Tables
    • Maintaining Tables
  • DBA 2 Lab 8 — Backups & Restores
    • Backups
    • Using mysqldump
    • Using mysqlhotcopy
    • Restores from SQL files
    • Restores from mysqlhotcopy
  • DBA 2 Lab 9 — Bulk Exports and Imports
    • Exports
    • Imports
  • DBA 2 Lab 10 — Performance
    • Keeping an Eye on Performance
    • Dealing with Performance Issues
    • Backup Servers and Replication
    • Clustering
  • DBA 2 Lab 11 — Troubleshooting
    • Collecting Information
    • Getting More Information
    • Testing
    • Implementation
  • DBA 2 Lab 12 — Final Project
    • Create a Database
    • Add Users and Permissions
    • Index Tables
    • Optimize Tables
    • Backup the Database
    • Export the Database to a File