2

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
5
Contributors
7
Replies
8
Views
7 Years
Discussion Span
Last Post by rajarajan07
0

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

0

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 by johnmarshel: n/a

0

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

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.