Section 1: Theory, Terminology and Concepts (10%) Client/Server Concepts
Database and Database Objects
Section 2: Data Definition using SQL (25%) Databases
Data Types
Tables
Constraints and Indexes
Views
Section 3: Basic Data Manipulation using SQL (25%) Recurring SQL Constructs
Adding data
Modifying data
Removing data
Searching data
Section 4: Advanced Data Manipulation using SQL (20%) Expressions
Grouping and Aggregate Functions
Joining Tables
Section 5: Transactions (10%) Transaction Concepts
SQL for working with Transaction
Section 6: Import/Export (10%) Tools for Import/Export
SQL for Import/Export