Difference between revisions of "Template:Module 105.3"

From braindump
Jump to navigation Jump to search
(Created page with "SQL data management {| |- valign="top" | Weight | 2 |- valign="top" | Description | Candidates should be able to query databases and manipulate data using basic SQL commands. Th...")
 
 
Line 1: Line 1:
{{Module 105.3 objectives}}
SQL data management
{{Module 105.3 terms}}

{|
|- valign="top"
| Weight
| 2
|- valign="top"
| 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.

|- valign="top"
| Key Knowledge Areas
|
* Use of basic SQL commands.
* Perform basic data manipulation.
|}

Latest revision as of 03:23, 19 January 2011

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