Shells, Scripting and Data Management

Introduction

Welcome to the Shells, Scripting and Data Management Practice Lab. In this module you will be provided with the instructions and devices needed to develop your hands-on skills.

Learning Outcomes

In this module, you will complete the following exercises:

• Exercise 1 - Customize and Use the Shell Environment
• Exercise 2 - SQL Data Management

After completing this lab, you will be able to:

• Log into a Linux System
• List the profile scripts
• Set environment variables
• Write Bash functions
• Maintain skeleton directories for new user accounts
• Set the command search path with the proper directory
• Install MySQL

Exam Objectives

The following exam objectives are covered in this lab:

• LPI: 103.1 Work on the command line
• LPI: 105.1 Customize and use the shell environment
• CompTIA:** 5.1 Given a scenario, deploy and execute basic BASH scripts.

Lab Duration

It will take approximately 1 hour to complete this lab.

Exercise 1 - Customize and Use the Shell Environment

Shell environment in Linux is a collection of values given to various parameters accessed by programs and utilities. These values provide the default configuration information to the programs. The programs execute and interact with the environment based on these values. In this exercise, you will understand how to customize and use the shell environment.

Learning Outcomes

After completing this exercise, you will be able to:

• Log into a Linux System
• List the profile scripts
• Set environment variables
• Write Bash functions
• Maintain skeleton directories for new user accounts
• Set the command search path with the proper directory

Exercise 2 - SQL Data Management

SQL is the most common language to access and manage a relational database. You can use various SQL commands to perform basic tasks on a database. In this exercise, you will understand how to perform SQL data management.

Learning Outcomes

After completing this exercise, you will be able to:

• Install MySQL