Template:Module 105.3

From braindump
Jump to navigation Jump to search

{{#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