Orange Coast Database Associates Training and Programming Home Page

SQL Courses Training Catalog

What's new at Orange Coast Database Associates
News

Catalog

Group Training

Individual Training

Scheduled Classes

Programming and Consulting

What's New!

FAQ's

Site Map

Free Catalogs

Special Offers

 

 

 

 

Request Information or Quote

Order a Class

Sales: 800-355-9855

Home

About Us

Calendar

Contact Us

Main Catalog Page

Orange Coast Database Associates Software Training

Microsoft Access | SQL | Database & Business Intelligence | Microsoft Office | Project Management | Programming & Coding | Discounts & Passports | Miscellaneous Fees & Services

Format this document with prices for printing

SQL (Curriculum Suggestions...)
Click on the course number or title for a full description with price.

BackTop

Combo Training Passport
Multiple days of training at a large discount from list. Good for six months. Costs less than three days of most upper division classes at list price.

Multiple days

SQL202 Accelerated Introduction to SQL Using Microsoft SQL Server I
Introduction to the SQL programming language using Microsoft SQL Server. Hands-on class featuring data manipulation, queries, joins, subqueries, unions, grouping and aggregates. Second day covers data modification, construction of tables, indexes, views. and constraints.

1 and 1/2 days

SQL204 Accelerated Introduction to SQL Using Microsoft SQL Server II
Brief introduction to the Transact SQL programming language used in Microsoft SQL Server. Adds Transact SQL specifics such as variables, control statements, cursors, stored procedures, etc.

1/2 day

Go to SQL Server queries course description

SQL202S Accelerated Introduction to SQL Queries Using Microsoft SQL Server
Introduction to SQL queries using SQL Server. Intensive, hands-on SQL class focusing on SQL data retrieval. Same as first two modules (first day) of SQL202.

1 day

Go to Intermediate SQL course description

SQL302 Intermediate SQL Using Microsoft SQL Server
Intermediate SQL class. Covers intermediate level joins, natural joins, subqueries, with clause, common table expressions, window (row) functions, unions, delete and update from.

1 and 1/2 days

Go to Intermediate SQL course description

SQL302S Intermediate SQL Queries Using Microsoft SQL Server
Intermediate SQL class. Covers intermediate level joins, natural joins, subqueries, with clause, common table expressions, window (row) functions, unions. Same as first two modules (first day) of SQL302.

1 day

Go to detailed MySQL course description

SQL201W Accelerated Introduction to SQL Using MySQL on Windows
Introduction to the SQL programming language using MySQL. Hands-on class featuring data manipulation, queries, joins, subqueries, unions, grouping and aggregates. Second day covers data modification, construction of tables, indexes, views. and constraints.

1 and 1/2 days

Go to detailed MySQL course description

SQL201S Accelerated Introduction to SQL Queries Using MySQL on Windows
Introduction to the SQL programming language using MySQL. Hands-on class featuring data manipulation, queries, joins, subqueries, unions, grouping and aggregates. Same as first two modules (first day) of SQL201W.

1 day

SQL212 Accelerated Introduction to SQL Using Oracle I
ntroduction to the SQL programming language using Oracle. Hands-on class featuring data manipulation, queries, joins, subqueries, unions, grouping and aggregates. Second day covers data modification, construction of tables, indexes, views. and constraints.

1 and 1/2 days

SQL214 Accelerated Introduction to SQL Using Oracle II
Brief introduction to the PL/SQL SQL programming language used in Oracle database systems. Adds PL/SQL specifics such as variables, cursors, procedures, etc. [under development]

1/2 day

Go to Oracle SQL queries course description

SQL212S Accelerated Introduction to SQL Queries Using Oracle
Introduction to SQL queries using Oracle. Intensive, hands-on SQL class focusing on SQL data retrieval. Same as first two modules (first day) of SQL212.

1 day

ORA301 Introduction to Oracle
Introduction to the features and functions of the Oracle database. Covers architecture, SQL, and PL/SQL. Cross-listed with Database curriculum.

1 day

SQL200A Introduction to Microsoft Access SQL
Slightly shorter version of SQL200 SQL course specifically for MS Access users. Hands-on class focusing on SQL data retrieval. (Advanced version of AIN102).

1 day

SQL200 Accelerated Introduction to SQL
Introduction to ANSI standard SQL. Intensive, hands-on SQL class featuring data manipulation, queries, data modification, construction of tables, indexes, views. and constraints, etc. This class has been been phased out in favor of SQL202, 212 and 201W, all of which cover the same content.

1 and 1/2 days

SQL200S Introduction to SQL Queries
Introduction to standard SQL queries. Intensive, hands-on SQL class focusing on SQL data retrieval. Same as first two modules of SQL200. This class has also been phased out in favor of SQL202S, 212S and 201WS.

1 day

SQL Private 1-on-1 Training
One-on-one Private Training or tutoring by the hour. Can be taken at your office or ours in San Juan Capistrano. Sign up for a standard class or design your own. 2 hour minimum.

free quote

Custom Courses

BackTop

Custom Class
Do your SQL training needs differ from the standard courses above? Let us custom develop a class for you. For example, we could run a series of evening classes, university style. Or perhaps you would like to use your own database such as Sybase or PostGres.

 

free quote

Discounts and Offers

Discount Programs
We have programs to help you save: training passports for individuals, discounts for groups, etc.

learn more

Click to see special offers (updated regularly)

Special Offers
Special offers are made available from time to time. 1/2 off on classes, special discounts, free seminars, etc. Check back to see what's new.

 

learn more

SQL training courses are offered in three modalities: 1) on-site groups at your facility in the Greater Los Angeles and San Diego areas or our studio, 2) private one on one SQL training as arranged and 3) regularly scheduled SQL classes at our studio in San Juan Capistrano, Orange County, CA. See calendar...

Calendar of Scheduled Classes in San Juan Capistrano

Receive course announcements and news. Sign Up Today!





Email Marketing by VerticalResponse

(Final prices will reflect tuition, materials, registration, applicable discounts and charges.)

Orange Coast Database Associates Page Footer


Programming & Consulting | Inquiries & Quotes | Orders | Enroll | Referral Program | Privacy Statement | Contact Information | FAQ'sSite Map | BackHome | Top