|
|
|
|
|
|
Tuition: $295 per student |
Length: 1 and 1/2 days |
|
|
Synopsis:
This fast-paced SQL training course introduces the standard (ANSI)
SQL programming language used by all SQL Databases. It includes data
manipulation, queries, data modification, construction of tables,
indexes and views, constraints and more. May be taught using MS
Accesss, SQL Server, MySQL or Oracle. (However, Open Enrollment
classes are generally based on SQL Server). |
|
Formats:
Custom group at your facility or ours, private training, and open
enrollment in San Juan Capistrano. Classes begin at 9:00AM unless
otherwise arranged. |
|
References:
We will supply each attendee with a copy of SQL in 10 Minutes
by Ben Forta for reference use. Please see our SQL
Book List for additional books you may want to have available
and/or peruse in advance of your class. None are required, per se. |
|
Group
Discounts:
Yes - see FAQ's. |
Group
Registration:
$50 |
|
|
|
- Module
I:
Basic
SQL Data Retrieval.
- Relational
database foundations
- Basic
SQL data retrieval operations, DML
- SQL
Select statement
- SQL
Predicates, SQL Where clause
- Operators
- Sorting
- Calculated
fields, Concatenation
-
|
3 hours |
- Module
II:
SQL
Functions, Multi-table Retrieval.
- String
Manipulation
- Date
Functions, Etc.
- SQL
Aggregate functions (SUM, AVG, etc.)
- Group
by
- Having
- Inner
join, outer joins, self join
- Single
and multi-valued subqueries
- Correlated
subqueries
- Unions
-
|
3 hours |
- Module
III:
SQL
Data Modification.
- Action
queries (MS Access)
- Modifying
data, Insert, Update, Delete
- Creating
tables and constraints, DDL
- Modifying
table design , ALTER
- Creating
Views and Indexes
-
|
3 hours |
Prerequisites: Familiarity
with Windows, Relational Database Concepts and some programming background.
|
|
Materials:
Students will be provided a copy of all SQL scripts. They will also
receive a binder with a printout of the slides used in class. In
addition, they will be provided a free copy of the short, but
excellent reference Teach Yourself SQL in 10 Minutes by Ben Forta.
|
|
Scheduling:
Each session above may be customized and scheduled as desired for
each custom group class or private training session. Open enrollment
classes run regularly in San Juan Capistrano.
|
|
Location:
Group classes are normally taught at your facilities. We do,
however, offer a wide range of alternatives, including our own
training rooms. Please see FAQ's
for details. We also travel beyond Southern California.
Open
enrollment classes are taught in our facilities in San Juan
Capistrano, Orange County, close to shopping, fine dining and local attractions.
|
|
Check our calendar of Open Enrollment Classes. (Note: custom group
classes and private training are scheduled by arrangement. If you
don't see the SQL Class you want at a convenient time, just contact us!).
|
Related Services |
|
Need help with
SQL? We can also provide SQL
programming and consulting services covering the above material
for an hourly rate. Please contact programming for
more information. |
|
|
|
