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 (All Modalities)

Item IDCourse Title and DescriptionPricePerLength
SQL212SIntroduction to SQL Queries using Oracle295.00Student6.0 hrs
 Introduction to SQL queries using Oracle. Intensive, hands-on SQL class focusing on SQL data retrieval. Same as first two modules of SQL212. This course is ideal for business analysts looking to acquire SQL skills.

 
Session 1Introduction to SQL 
 
  • Relational database foundations
  • Using Oracle SQL Developer
  • 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.
  • SQL Aggregate functions (SUM, AVG, etc.)
  • Group by
  • Having
  • Inner join, outer joins, self join
  • Single and multi-valued subqueries
  • Correlated subqueries
  • Unions