LPIC-1 102 105.3 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.

Terms and Utilities

• insert
• update
• select
• delete
• from
• where
• group by
• order by
• join