|
|
|
|
|
|
SQL200A: Access SQL & Query Design Training
|
Book List |
Course Links
|
|
|
|
Tuition: $195.00 per student |
Length: 1 day |
|
|
Synopsis:
Introductory Access SQL Programming course using MS Access. Also covers using the MS Access Query Designer. Students will gain a thorough introduction to designing and implementing MS Access queries using JET SQL in this unique course. Can also be taught with SQL Server, MySQL or Oracle as the back-end. A basic knowledge of MS Access and query concepts is assumed.
|
|
Formats:
Small groups onsite at your facility or online. Single individuals may arrange a private online session.
|
|
Scheduling:
Flexible. Both onsite and online classes are custom scheduled to suit.
|
|
Group
Discounts:
2-4 students 20%, 5-8 30%, >8 quote
|
|
|
|
| Session 1 | Basic MS Access SQL Data Retrieval, Functions | 3.0 Hours | | |
- Relational database foundations
- Basic data retrieval operations, DML
- SQL Select statement
- SQL Predicates, SQL Where clause (filters)
- Operators
- Sorting
- Calculated fields, Concatenation
- SQL Date Functions, Etc.
| | | Session 2 | MS Access SQL Grouping, Data Manipulation | 3.0 Hours | | |
- String Manipulation
- SQL Aggregate functions (SUM, AVG, etc.)
- SQL Group by
- Having
- Inner join, outer join, self join
- Single and multi-valued subqueries
- Queries built from queries
- Unions
- Modifying data: Insert, Update, Delete, Select...Into
- Parameter queries
| |
|
|
Materials:
Manual with PowerPoint slide and training certificate.
|
|
Location:
Classes are normally taught on-site at your facilities or at our studio in San Juan Capistrano, Orange County, California. We may also be able to host the class in a rented university classroom near you. Please see FAQs if interested.
|
|
Related Services |
|
Need
help with a project? We may also provide programming
and consulting services covering the above material. See
Programming and Consulting for more information.
|
|
|
|
