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

Previous Page

949-408-1350 (Office)
800-355-9855 (Toll free)
http://www.ocdatabases.com
Accelerated training for working professionals

Orange Coast Database Associates, Inc.
Course Catalog (All Modalities)

Item IDCourse Title and DescriptionPricePerLength
SQL201SAccelerated Introduction to SQL Queries using MySQL195.00Student6.0 hrs
 Introduction to SQL queries using MySQL. Intensive, hands-on SQL class focusing on SQL data retrieval. Same as first two modules of SQL201W Accelerated Introduction to SQL Using MYSQL which also includes modifying data and data structures.

 
Session 1Introduction & Basic SQL Data Retrieval 
 
  • Relational database foundations
  • Using the MySQL Workbench front end tool.
  • Basic SQL data retrieval operations, DML
  • SQL Select statement
  • SQL Predicates, SQL Where clause
  • Operators
  • Removing duplicates
  • Sorting
  • Limit by

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