Database Administration: Creating and Managing Databases

Database Administration: Creating and Managing Databases

  • Last updated 6/2024
  • English
  • Published 2025-04-24
  • Location Online
  • Duration 1h 10m
What you'll learn

You'll use MySQL Server on an Ubuntu 22.04 desktop and pre-prepared data to create a functioning database and apply configurations to learn how you can fine tune that way your data is managed.

This course includes:

Table of Contents

  1. Challenge

    Getting Started in the Lab Environment

    Here are the initial instructions and explanation of the lab environment. Read this while your environment is busy creating itself from nothing. Yes, this violates physics; we know. How fun!

  2. Challenge

    Introduction to MySQL

    Be familiar with the basic MySQL tools, including showing assets and creating and using databases

  3. Challenge

    Configuring a Database for Multilingual Text

    Learn how to choose the right character set and collation for your data processing needs

  4. Challenge

    Configuring a Database for Fast, Read-only Access

    Learn to select and apply non-default storage engines.

  5. Challenge

    The Last Challenge

    Welcome to the final challenge! This is your last chance to experiment in the environment. Clicking Finish Lab will end this little world that flittered into existence just for you.