Scripting & Administrative Tasks

Linux    |    Intermediate
  • 17 videos | 1h 19m 18s
  • Earns a Badge
Likes 110 Likes 110
The shell, and shell scripting, provides an incredible interface to maintaining a Linux system. Explore how to use and configure the shell environment, write and customize shell scripts, and manipulate SQL data.

WHAT YOU WILL LEARN

  • configure environment variables so they are set when a user logs in or spawns a new shell
    create BASH functions that can automate frequently used sequences of commands
    describe how to use and maintain the Skeleton directories for new user accounts
    configure the command search path for the system and/or user account
    create shell scripts that can test using the if statement before carrying out a set of actions
    create shell scripts that can repeat a set of actions using the for statement
    create shell scripts that can repeat a task until a condition has been met using the while statement
    use command substitution in a shell script
    use script conditionals and test to test return results for success and failure or other returned values provided by a command
  • perform conditional mailing to the superuser in a shell script
    describe how to use and how to select the correct script interpreter using the Shebang (#!)
    describe how to manage the location, ownership, execution, and suid-rights of shell scripts
    use SQL to query a database and return results using the select statement
    use the SQL insert, update, and delete statements to modify data in a table
    apply a join to database tables to return a result set across multiple tables
    use the SQL order by statement to return a sorted result set
    use the SQL group by statement to aggregrate data in a result set

IN THIS COURSE

  • Playable
    1.  Setting Environment Variables
    6m 22s
    In this video, you will learn how to configure environment variables so they are set when a user logs in or starts a new shell. FREE ACCESS
  • Playable
    2.  Writing BASH Functions for Frequently Used Commands
    5m 34s
    In this video, you will learn how to create BASH functions to automate frequently used sequences of commands. FREE ACCESS
  • Locked
    3.  Maintaining Skeleton Directories for New User Accounts
    2m 23s
    Upon completion of this video, you will be able to describe how to use and maintain the Skeleton directories for new user accounts. FREE ACCESS
  • Locked
    4.  Setting the Command Search Path
    4m 9s
    During this video, you will learn how to configure the command search path for the system and/or user account. FREE ACCESS
  • Locked
    5.  Writing Shell Scripts Using If Statements
    4m 33s
    In this video, find out how to create shell scripts that can test using the if statement before carrying out a set of actions. FREE ACCESS
  • Locked
    6.  Writing Shell Scripts Using For Loops
    7m 55s
    In this video, learn how to create shell scripts that can repeat a set of actions using the for loop. FREE ACCESS
  • Locked
    7.  Writing Shell Scripts Using While Loops
    4m 51s
    In this video, find out how to create shell scripts that can repeat a task using the while statement until a condition has been met. FREE ACCESS
  • Locked
    8.  Writing Shell Scripts Using Command Substitution
    5m 43s
    In this video, find out how to use command substitution in a shell script. FREE ACCESS
  • Locked
    9.  Shell Script Return Values
    4m 37s
    In this video, you will learn how to use script conditionals and test to test return results for success and failure or other returned values provided by a command. FREE ACCESS
  • Locked
    10.  Performing Conditional Mailing to the Superuser
    6m 3s
    In this video, you will learn how to perform conditional mailing to the superuser in a shell script. FREE ACCESS
  • Locked
    11.  Selecting the Correct Script Interpreter
    5m 13s
    After completing this video, you will be able to describe how to use and select the correct script interpreter using the Shebang (#!). FREE ACCESS
  • Locked
    12.  Managing the Permissions and suid-Rights of Scripts
    5m 39s
    Upon completion of this video, you will be able to describe how to manage the location, ownership, execution, and suid-rights of shell scripts. FREE ACCESS
  • Locked
    13.  Introducing SQL and the select Statement
    2m 50s
    Learn how to use SQL to query a database and return results using the SELECT statement. FREE ACCESS
  • Locked
    14.  Inserting, Updating, and Deleting Data with SQL
    4m 10s
    In this video, you will learn how to use the SQL insert, update, and delete statements to modify data in a table. FREE ACCESS
  • Locked
    15.  Selecting Data by Joining Two or More Tables
    3m 19s
    During this video, you will learn how to apply a join to database tables to return a result set from multiple tables. FREE ACCESS
  • Locked
    16.  Sorting Data Returned from a select Statement
    3m 23s
    During this video, you will learn how to use the SQL ORDER BY statement to return a sorted result set. FREE ACCESS
  • Locked
    17.  Advanced Grouping of SQL Select Results
    2m 32s
    Find out how to use the SQL group by statement to aggregate data in a result set. FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Channel PowerShell
Likes 553 Likes 553  
Book PowerShell for Sysadmins: Workflow Automation Made Easy
Book Introducing MySQL Shell: Administration Made Easy with Python

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Installation
Likes 89 Likes 89  
Course Introduction to Bash Scripting
Likes 476 Likes 476  
Course Advanced GNU & Unix Commands
Likes 66 Likes 66