G'day,
I've got my SCMA tomorrow morning, and I thought i would post up my notes.
These notes are intended as a general tutorial/guide for MySQL.
It covers the following topics:
Section 1: Theory, Terminology and Concepts (10%)
- Client/Server Concepts
Section 2: Data Definition using SQL (25%)
- Databases
- Data Types
- Tables
- Constraints and Indexes
- Views
Section 3: Basic Data Manipulation using SQL (25%)
- 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%)
- SQL for Import/Export