|
|
|
|
|
|
SQL204: Intermediate SQL Using Microsoft SQL Server
|
Book List |
Course Links
|
|
|
|
Tuition: $195.00 per student |
Length: 1/2 Day |
|
|
Synopsis:
Introduction to Transact SQL specic constructs used in Microsoft SQL Server environments. Covers triggers, functions, variables, etc. Expansion to full day under development.
|
|
Formats: Private
1-on-1 training and custom groups (min. 2 students) at
your facility or ours in Orange County, California.
|
|
Scheduling:
Flexible.
Group and private training can be scheduled to suit your
needs.
|
|
Group
Discounts:
Yes - see FAQ's.
|
|
|
|
| Session 1 | Transact-SQL Features & Programming Objects | 3.0 Hours | | |
- Control flow (if, while, case)
- Variables
- Transact-SQL Functions
- User defined
- System supplied
- Stored procedures
- Triggers
- Cursors
- Automating tasks with the GUI interface
|   |
|
|
References:
Please
see the
book list for references you may want to have available. We
are an Amazon.com affiliate and you may purchase
your SQL books through this site.
|
|
Materials:
Students will receive a notebook with a printout
of the slides used in their class, a copy of the
book SQL in 10 Minutes by Ben Forta, and
a training certificate.
|
|
Location:
Classes are normally taught on-site at your facilities
or at our location in San Juan Capistrano, Orange
County. We do, however, offer a wide range of alternatives.
Please see FAQ's
if interested. We also travel beyond Southern California.
|
|
Related Services |
|
Need
help with an SQL project? We can also provide SQL
services covering the above material. See
Programming and Consulting for more information.
|
|
|
|