Sun Certified MySQL Associate - Material

[tyson.crouch]

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

[tyson.crouch]

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

[nav33n]

Thanks for the information. :)

[bigjoke]

nice!!

[johnmarshel]

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.

[rajarajan07]

Thanks for you valuable notes!!

[tyson.crouch]

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

[rajarajan07]

Thats Great! Waiting for your valuable notes!