|
|
|
Tuition: $435.00 per student |
Length: 1 and 1/2 days
| |
Synopsis: Intensive
hands-on introduction to standard SQL programming. Data
manipulation, queries, data modification. Construction of
tables, indexes and views. Constraints, etc. Can be taught
using most major SQL platforms. No prior knowledge of SQL is
assumed, although students should have some exposure to
programming and/or use of other query systems (including
Access).
Vendor-specific versions of this class are available. See
SQL202 for Microsoft SQL Server, SQL201W for MySQL and SQL212
for Oracle. |
Formats: Corporate groups
(min. 2 students) at your facility or ours in San Juan
Capistrano, Orange County, California. Single individuals may
take a regularly scheduled class or arrange a private one.
|
Scheduling: Flexible. Group and
private training can be scheduled to suit your
needs. See calendar for scheduled classes.
|
Group
Discounts: 2-4 students
25%, 5-8 35%, >8 quote |
|
|
|
Session
1 |
Basic SQL Data
Retrieval |
3.0 Hours |
|
- Relational database foundations
- Basic SQL data retrieval operations, DML
- SQL Select statement
- SQL Predicates, SQL Where clause
- Operators
- Sorting
- Calculated fields, Concatenation
|
|
Session
2 |
SQL Functions,
Multi-table Retrieval |
3.0 Hours |
|
- 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
|
|
Session
3 |
SQL Data
Modification |
3.0 Hours |
|
- Action queries (MS Access)
- Modifying data, Insert, Update, Delete
- Creating tables and constraints, DDL
- Modifying table design , ALTER
- Creating Views and Indexes
|
|
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. We will supply each
attendee with a copy of SQL in 10 Minutes by Ben
Forta for reference use.
|
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.
| |
| |