|
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 except the extension
courses SQL204 and SQL214. Most classes cover roughly the same
material but give you a choice of environments: Transact SQL for
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.
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. (1 and 1/2 days)
2)
SQL200S - Shorter, read-only version of above. Save yourself a
little time if your focus is strictly retrieving data. (1 day)
3)
SQL201W - Introduction to MySQL. Includes material from SQL200. (1
and 1/2 days)
4)
SQL204 - Introduction to Transact SQL programming extensions. Take
this if interested in SQL Server extensions to standard SQL. (1/2 day)
5)
SQL214 - Introduction to Oracle SQL (PL/SQL) programming extensions.
(1/2 day)
Courses
for Programmers
Currently,
most of our SQL courses are geared more towards power users and
analysts rather than programmers. SQL204 and SQL214 introduce much
more advanced material (triggers, cursors, etc.) |
