Orange Coast Database Associates Course Catalog

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 ID	Course Title and Description	Price	Per	Length
SQL302	Intermediate SQL Using Microsoft SQL Server	290.00	Student	9.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 1	Joins, 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 2	Subqueries 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 3	Modifying Data
	transactions Select into Table valued constructors Update from, Delete from Creating tables and constraints, DDL Modifying table design , ALTER Synonyms More about views