Template:Topic 105

From braindump
Jump to navigation Jump to search

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