Sun Certified MySQL Associate - Material

For those who may be skeptical about these notes.
I did pass the SCMA exam, so these notes are somewhat reliable

Thanks for the information. :)

nice!!

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

This is really a helpful for all,related topic SQL database,all are good and this is helpful to prepare in exam that give a whole idea about SQL,in SQL one time connection you done,and easily you work.important for all.

Thanks for you valuable notes!!

I have yet to update these notes to include some important points.
I will hopefully have these updated with full examples for each section this time next week

Thats Great! Waiting for your valuable notes!