Template:Topic 105

Shells, Scripting and Data Management

Module 105.1

Customize and use the shell environment

Weight	4
Description	Candidates should be able to customize shell environments to meet users' needs. Candidates should be able to modify global and user profiles.
Key Knowledge Areas	Set environment variables (e.g. PATH) at login or when spawning a new shell. Write BASH functions for frequently used sequences of commands. Maintain skeleton directories for new user accounts. Set command search path with the proper directory.

The following is a partial list of the used files, terms and utilities:

Configuration::/etc/profile

Command::env

Command::export

Command::set

Command::unset

Configuration::~/.bash_profile

Configuration::~/.bash_login

Configuration::~/.profile

Configuration::~/.bashrc

Configuration::~/.bash_logout

function

Command::alias

lists

Module 105.2

Customize or write simple scripts

Weight	4
Description	Candidates should be able to customize existing scripts, or write simple new BASH scripts.
Key Knowledge Areas	Use standard sh syntax (loops, tests). Use command substitution. Test return values for success or failure or other information provided by a command. Perform conditional mailing to the superuser. Correctly select the script interpreter through the shebang (#!) line. Manage the location, ownership, execution and suid-rights of scripts.

The following is a partial list of the used files, terms and utilities:

for

while

test

if

read

seq

{{#set:

 Shell keyword=for |
 Shell keyword=while |
 Shell keyword=if |
 Shell builtin=test |
 Shell builtin=read |
 Shell builtin=read |
 Command=seq |
 Command=test

}}

Module 105.3

{{#set: ModuleTitle = SQL data management | ModuleWeight = 2 | ModuleDescription = Candidates should be able to query databases and manipulate data using basic SQL commands. This objective includes performing queries involving joining of 2 tables and/or subselects. }} SQL data management

Weight	2
Description	Candidates should be able to query databases and manipulate data using basic SQL commands. This objective includes performing queries involving joining of 2 tables and/or subselects.
Key Knowledge Areas	Use of basic SQL commands. Perform basic data manipulation.

The following is a partial list of the used files, terms and utilities:

SQL command::INSERT

SQL command::UPDATE

SQL command::SELECT

SQL command::DELETE

SQL command::FROM

SQL command::WHERE

SQL command::GROUP BY

SQL command::ORDER BY

SQL command::JOIN