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

Previous Page

949-489-1472 (Office)
800-355-9855 (Toll free)

Accelerated training for working professionals

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

Item IDCourse Title and DescriptionPricePerLength
SQL302Intermediate SQL Using Microsoft SQL Server290.00Student9.0 hrs
 Intermediate SQL class. Covers intermediate level joins, subqueries, with clause, common table expressions, window (row) functions, delete and update from. Students should have taken the full SQL202 Introduction to SQL or have equivalent experience.

Session 1Joins, Case 
  • Relational database foundations
  • Using the Query Analyzer or Management Studio
  • Advanced wildcard searches
  • Case, cast, convert,
  • Single valued subqueries and subselects
  • Correlated subqueries
  • WITH
  • Derived tables and common table expressions

Session 2Subqueries and window functions 
  • Rollup, cube
  • Self joins
  • Outer joins, negative outer join
  • Partially matched outer joins
  • Theta joins
  • Set operations: unions, intersect, except
  • SQL sliding window (row) functions (SUM, AVG, etc.)
  • Group by, having
Session 3Modifying Data 
  • transactions
  • Select into
  • Table valued constructors
  • Update from, Delete from
  • Creating tables and constraints, DDL
  • Modifying table design , ALTER
  • Synonyms
  • More about views