Sun Certified MySQL Associate - Material

Question

tyson.crouch 6 Junior Poster

14 Years Ago

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

mysql

This attachment is potentially unsafe to open. It may be an executable that is capable of making changes to your file system, or it may require specific software to open. Use caution and only open this attachment if you are comfortable working with zip files.

MySQL_Notes.docx (60.08 KB)

5 Contributors
7 Replies
224 Views
2 Weeks Discussion Span
Latest Post 14 Years Ago Latest Post by rajarajan2017

nav33n 472 Purple hazed!

14 Years Ago

Thanks for the information. :)

Edited 14 Years Ago by nav33n because: Ah, nevermind.

johnmarshel 0 Newbie Poster

14 Years Ago

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.

Edited 14 Years Ago by johnmarshel because: n/a

Reply to this topic

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.

tyson.crouch 6 Junior Poster · Answer 1 · 2010-05-17T12:58:26+00:00

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

bigjoke 0 Light Poster · Answer 2 · 2010-06-02T14:49:50+00:00

bigjoke 0 Light Poster

14 Years Ago

nice!!

rajarajan2017 · Answer 3 · 2010-06-02T19:03:12+00:00

rajarajan2017

14 Years Ago

Thanks for you valuable notes!!

tyson.crouch 6 Junior Poster · Answer 4 · 2010-06-02T19:22:21+00:00

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

rajarajan2017 · Answer 5 · 2010-06-03T10:22:26+00:00

Thats Great! Waiting for your valuable notes!