LPIC-1 102 Linux certification - Linux shells, scripting, and databases (1 of 6)
Course introduction

This course covers three rather distinct topics, though properly understanding each is critically important for managing Linux systems:

  • Managing shell session environments
  • Working with Linux scripts
  • Working with Linux databases (MySQL)
  • Migrating a MySQL database to Amazon's Relational Database Service

Explore the entire Linux certification series.

If you have thoughts or suggestions for this course, please contact Cloud Academy at


With this sixth course in Cloud Academy's Linux Certification Series we're going to encounter the first content that's part of the LPIC-1 102 exam. The 102 is the second and final exam you'll need to pass in order to earn your LPIC certification. But it's also a terrific way to make sure that you've covered all the skills that you'll need to be an effective system administrator, or as the LPIC calls Server Professional.

Specifically, in this course we'll learn how to closely manage shell sessions to leverage the full range of Linux system features. We'll dive head first into scripting, the task automation platform which lets you apply
the logic and versatility of programming languages to the immediacy and high level control of the command line. And we'll learn how to create and administer simple database installations using MySQL.

Finally we'll learn how to connect to an Amazon RDS MySQL instance in the cloud and then my grade A local MySQL database into our cloud instance. This last topic may not be required for the LPIC exam, but you'll be amazed how easily it can be done and it's fun.

About the Author
Learning Paths

David taught high school for twenty years, worked as a Linux system administrator for five years, and has been writing since he could hold a crayon between his fingers. His childhood bedroom wall has since been repainted.

Having worked directly with all kinds of technology, David derives great pleasure from completing projects that draw on as many tools from his toolkit as possible.

Besides being a Linux system administrator with a strong focus on virtualization and security tools, David writes technical documentation and user guides, and creates technology training videos.

His favorite technology tool is the one that should be just about ready for release tomorrow. Or Thursday.

Covered Topics