|
|
|
|
|
|
SQL201W: Accelerated Introduction to SQL Using MySQL on Windows
|
Book List |
Course Links
|
|
|
|
Tuition: $435.00 per student |
Length: 1 and 1/2 days |
|
|
Synopsis:
1 and 1/2 day version of SQL200 specifically for MySQL users. Includes coverage of MySQL specifics. Taught using Windows. Unix/Linux version under development. No prior knowledge of MySQL is assumed, although students should have some exposure to programming and/or use of other query systems such as ANSI standard SQL or Access.
|
|
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 | MySQL Data Modification | 3.0 Hours | | |
- Relational database foundations
- Creating tables and constraints, DDL
- Modifying table design , ALTER
- Creating Views and Indexes
- Modifying data, Insert, Update, Delete, Replace
| | | Session 2 | Basic MySQL Data Retrieval | 3.0 Hours | | |
- Basic SQL data retrieval operations
- SQL Select statement
- SQL Predicates, SQL Where clause
- Operators
- Sorting
- Calculated fields, Concatenation
| | | Session 3 | MySQL Functions, Multi-table Retrieval | 3.0 Hours | | |
- String Manipulation
- Date Functions, Etc.
- SQL Aggregate functions (SUM, AVG, etc.)
- Group by
- Having
- Inner join, left outer join, self join
- Simulating subqueries with joins
- Effecting a Union with temporary tables
| |
|
|
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.
|
|
|
|
