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
SQL202SAccelerated Introduction to SQL Queries using SQL Server195.00Student6.0 hrs
 Introduction to SQL queries using Microsoft SQL Server. This course is ideal for business analysts looking to acquire SQL skills. Intensive, hands-on SQL class focusing on SQL data retrieval. Same as first two modules of SQL202 which also covers modifying data and data structures.

 
Session 1Introduction & Basic SQL Data Retrieval 
 
  • Relational database foundations
  • Using the Query Analyzer or Management Studio
  • 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