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 DescriptionLength
SQL204Accelerated Introduction to SQL Using Microsoft SQL Server II3.0 hrs
 Introduction to Transact SQL specic constructs used in Microsoft SQL Server environments. Covers triggers, functions, variables, etc. Expansion to full day under development. Students should have taken the full Introduction to SQL or have equivalent experience.

 
Session 1Transact-SQL Features & Programming Objects 
 
  • Control flow (if, while, case)
  • Variables
  • Transact-SQL Functions
    • User defined
    • System supplied
  • Stored procedures
  • Triggers
  • Cursors
  • A look at security