Database Administration: Creating and Managing Databases
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.
Challenge
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!
Challenge
Be familiar with the basic MySQL tools, including showing assets and creating and using databases
Challenge
Learn how to choose the right character set and collation for your data processing needs
Challenge
Learn to select and apply non-default storage engines.
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.