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

Open Enrollment

What's New!

FAQ's

Links

Site Map

Free Catalogs

 

 

 

 

Request Information or Quote

Order a Class

Sales: 800-355-9855

Home

About Us

Calendar

Resources

Contact Us

Main Catalog Page

D. H. D'Urso and Associates MS Access Training

Microsoft Access | SQL | Database | Crystal Reports  | Microsoft Office | Web | VBA | Programming Languages | Adobe | Custom Classes | Discounts & Passports | Miscellaneous Fees

Format this document with prices for printing

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

BackTop

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

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

SQL202 Accelerated Introduction to SQL Using Microsoft SQL Server I
Introduction to the SQL programming language used in Microsoft SQL Server and Sybase. 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 detailed MySQL course description

SQL201W Accelerated Introduction to SQL Using MySQL on Windows
Hands-on introduction to MySQL. Version of SQL200 for MySQL users. Covers MySQL programming specifics.

1 and 1/2 days

SQL212 Accelerated Introduction to SQL Using Oracle I
Introduction to the SQL programming language as used in Oracle database systems. Similar course to SQL202. Covers SQL select, insert, update, delete, create and alter statements.

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

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

aClick 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

Combo Training Passport
4 full days of training at a large discount from list. Take any regularly scheduled Microsoft Access, SQL, Database Design or Microsoft Project class in San Juan Capistrano. All classes must be different. Valid for six months from date of purchase. Additional days can be purchased. Passports are refundable (with limitations). See the FAQs page for more details.

Passport discounts may be combined with the above multi-student volume discounts for even further savings.

Students may apply the amount paid for one class(1 day) to upgrade to a Passport with 3 days remaining.

See price list

Referral Payment
Know someone else who would profit from one of our classes? Earn cash with your referral. Learn more...

 

learn more

SQL training courses are offered in three modalities: 1) on-site at your location in the Greater Los Angeles and San Diego areas (or elsewhere in the U.S. including our offices in San Juan Capistrano, Orange County, California), 2) private one-on-one SQL training as arranged and 3) regularly scheduled SQL classes at our facility (most offered every week or two). 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.)

D. H. D'Urso and Associates MS Access Training


Privacy Statement | Programming & Consulting | Instructors | CorkBoard | Reservation Calendar | Inquiries & Quotes | Orders | Enroll | Forums | Contact Information | FAQ'sSite Map | BackHome | Top

Copyright(2001-2009) D.H.D'Urso & Associates; SJC Bus. License #: 05-72185 | Member Better Business Bureau