Orange Coast Database Associates
P.O. Box 6142
Laguna Niguel, CA 92607

Previous Page

949-489-1472 (Office)
800-355-9855 (Toll free)
http://www.d2associates.com
Accelerated training for working professionals

Microsoft Access and Relational Database Training
Course Catalog

Item IDCourse Title and DescriptionLength
SQL201WAccelerated Introduction to SQL Using MySQL on Windows9.0 hrs
 1 and 1/2 day version of SQL200 specifically for MySQL users. Includes coverage of MySQL specifics. Taught using Windows. Unix/Linux version under development. No prior knowledge of MySQL is assumed, although students should have some exposure to programming and/or use of other query systems such as ANSI standard SQL or Access.

 
Session 1MySQL Data Modification 
 
  • Relational database foundations
  • Creating tables and constraints, DDL
  • Modifying table design , ALTER
  • Creating Views and Indexes
  • Modifying data, Insert, Update, Delete, Replace

 
Session 2Basic MySQL Data Retrieval 
 
  • Basic SQL data retrieval operations
  • SQL Select statement
  • SQL Predicates, SQL Where clause
  • Operators
  • Sorting
  • Calculated fields, Concatenation

 
Session 3MySQL Functions, Multi-table Retrieval 
 
  • String Manipulation
  • Date Functions, Etc.
  • SQL Aggregate functions (SUM, AVG, etc.)
  • Group by
  • Having
  • Inner join, left outer join, self join
  • Simulating subqueries with joins
  • Effecting a Union with temporary tables