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
SQL202Accelerated Introduction to SQL Using Microsoft SQL Server I435.00Student9.0 hrs
 Intensive 1 and 1/2 day, hands-on introduction to SQL programming using Microsoft SQL Server (Transact SQL). Covers data manipulation, queries, data modification, tables, indexes, views constraints, etc. 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 SQL302 Intermediate SQL Using SQL Server

 
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.
  • Inner join, outer joins, self join
  • Single and multi-valued subqueries
  • A look at correlated subqueries
  • Unions
  • SQL Aggregate functions (SUM, AVG, etc.)
  • Group by
  • Having

 
Session 3SQL Data Modification 
 
  • Modifying data, Insert, Update, Delete
  • Creating tables and constraints, DDL
  • Modifying table design , ALTER
  • Creating Views and Indexes
  • A look at security