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.ocdatabases.com

Accelerated training for working professionals

Orange Coast Database Associates, Inc.
Course Catalog

Item IDCourse Title and DescriptionLength
SQL201WAccelerated Introduction to SQL Using MySQL9.0 hrs
 Intensive 1 and 1/2 day, hands-on introduction to SQL programming using MySQL. Covers data manipulation, queries, data modification, tables, indexes, views constraints, etc. No prior knowledge of SQL is assumed, although students should have some exposure to programming and/or use of other query systems (including Access).

 
Session 1Introduction & Basic SQL Data Retrieval 
 
  • Relational database foundations
  • Using a MySQL front end tool.
  • Basic SQL data retrieval operations, DML
  • SQL Select statement
  • SQL Predicates, SQL Where clause
  • Operators
  • Sorting
  • Calculated fields, Concatenation

 
Session 2SQL Functions, Multi-table Retrieval 
 
  • String Manipulation
  • Date Functions, Etc.
  • Inner join, outer joins, self join
  • Single and multi-valued subqueries
  • A look at correlated subqueries
  • Unions
  • SQL Aggregate functions (SUM, AVG, etc.)
  • Group by
  • Having

 
Session 3SQL Data Modification 
 
  • Modifying data, Insert, Update, Delete
  • Creating tables and constraints, DDL
  • Modifying table design , ALTER
  • Creating Views and Indexes
  • A look at security