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 DescriptionLength
SQL200SIntroduction to SQL Data Retrieval6.0 hrs
 Accelerated introduction to standard SQL programming with focus on retrieval and reporting: data retrieval, filtering data, calculations, summarization and grouping, etc. Same as first two modules of SQL200. Can be taught using MySQL, SQL Server or Oracle. Students will create their own SQL script library in this course which they can take with them. No prior knowledge of SQL is assumed, although students should have some exposure to programming and/or use of other query systems (including Access). The next class in sequence is SQL302s Intermediate SQL Queries Using SQL Server

 
Session 1Basic SQL Data Retrieval 
 
  • Relational database foundations
  • 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