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
SQL302Intermediate SQL Using Microsoft SQL Server535.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 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