|
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, 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.
Entry
Points
Clients
may take any course in the curriculum to start. The more vendor
specific courses (SQL201W - MySQL, SQL202 - Transact SQL, SQL212 -
Oracle SQL) all include the basic material from SQL200. |
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.
Course
Suggestions
1)
SQL200 - Basic introduction to the standard SQL programming
language. Take this for a complete introduction to querying and
updating data.
2)
SQL200S - Shorter, read-only version of above. Save yourself a
little time if your focus is strictly retrieving data.
3)
SQL201W - Introduction to MySQL. Includes material from SQL200.
4)
SQL202 - Introduction to Transact SQL. Take this if interested in
SQL Server extensions to standard SQL. Includes the material from SQL200.
5)
SQL212 - Introduction to Oracle SQL (PL/SQL). Includes material from SQL200.
Courses
for Programmers
Currently
our SQL courses are all geared more towards power users than programmers. |