CIW Database Specialist Part 3: Database Interaction and JDBC ...res of updating a value in a relation.
Match simple SQL keywords with their functions.
Match basic queries for filtering with their functions.
Match special predicates with their functions.
Identify features of the ORDER BY clause.
Identify functions of the GRANT statement.
Identify functions of the REVOKE statement.
Unit 2: Relational Algebra
Identify the fundamental operations more...
CIW Database Specialist Part 2: Logical and Physical Design ...entify guidelines for creating base relations.
Identify keywords used in data definition language (DDL).
Topics Include
Unit 1: Normalization
Identify features of normalization.
Identify features of functional dependency.
Identify features of 1NF.
Identify features of second normal form (2NF).
Identify features of third normal form (3NF).
Identify features of Boyce-Codd normal more...