SQL Curriculum Suggestions

Back

Price List/Catalog

Approach

Our SQL curriculum is custom designed to assist working professionals in getting up to speed on SQL. It is assumed students are looking to acquire skills readily applied in the workplace.

Courses are not geared towards certification tests, although they do provide a good background for many topics. They are also excellent "starter" courses as preparation for a series of certification classes from traditional certification training companies.

We have found many of our clients are geared towards querying and data analytics, not updating data. Our curriculum includes shorter "read-only" courses.

Prerequisites

Students should have some background with query systems, such as Microsoft Access. Our AIN102 would provide an excellent background.

If you or members of your group do not have this background check with us for recommendations.

Passports

Students can purchase a combo passport which enables them to take multiple days of Access, SQL and database training at a large discount.

Entry Points

Most clients should start with SQL202, SQL212 OR SQL201W. If you already know SQL you may want to just take SQL302. Most classes cover roughly the same material but give you a choice of environments: Microsoft SQL Server, Oracle, or MySQL. We even have a class, SQL200A. oriented towards MS Access users.

Database Design

Those expecting to design their own database for departmental or company use should consider taking a Database Design course first. The rest of your application will then be much easier to build.

On the other hand, if you will be working exclusively with small personal databases, or an existing database you can probably pick up what you need to know from our regular courses and some reading along the way.

SQL Course Suggestions

1) SQL200 - Basic introduction to the standard SQL programming language. Take this for a complete introduction to querying and updating data. SQL202 is taught in a SQL Server environment; SQL212 in an Oracle environment and SQL201W in MySQL. (All are 1 and 1/2 days.)

2) SQL202S/SQL212S - Shorter, read-only versions of above. Save yourself a little time if your focus is strictly retrieving data. (1 day)

2) SQL302 and 302S - Intermediate SQL  (1 and 1/2 days). 302S is the shorter, 1 day, read-only version. Currently taught on SQL Server only, Oracle by custom order. Take this class to learn how to use some of the newer SQL functions such as table expressions and window functions not often taught elsewhere.

4) SQL204 - Introduction to Transact SQL programming extensions. Take this if interested in Microsoft SQL Server extensions to standard SQL. (1/2 day)

5) SQL214 - Introduction to Oracle SQL (PL/SQL) programming extensions. (1/2 day)

SQL Courses for Programmers

Currently, most of our SQL courses are geared more towards power users and analysts rather than programmers. The exceptions are SQL204 and SQL214 which introduce much more advanced material (triggers, cursors, etc.)


Copyright 2017 D.H.D'Urso & Associates
P.O. Box 6142, Laguna Niguel, CA 92607
Serving: Orange, Los Angeles, San Diego, Riverside, San Bernardino, Imperial and Ventura counties and beyond

Privacy Statement | Back | Home | Top