Orange Coast Database Associates Database Training, Design and Programming Course Listing Page

SQL Training

What's new at Orange Coast Database Associates

 Home-->Courses-->sql200a

Map of Laguna Niguel and San Juan Capistrano area

Click links below for related database course offered by D. H. D'Urso & Associates

Other SQL Courses

Relational Database Training

FAQ's

Links

Site Map

Free Catalogs

Request Information or Quote

Sales: 800-355-9855

Home

About Us

Price List/Catalog

Glossary

Books

Contact Us

SQL200A: Access SQL & Query Design

Book List | Course Links

Tuition: $295.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 thourough introduction to designing and implementing MS Access queries using Access's JET SQL in this unique course. Can be taught with SQL Server, MySQL or Oracle as the back-end. A basic knowledge of MS Access and query concepts is assumed.

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.

 

Format this document for printing

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
 

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. Although, none are required per se, we highly recommend purchase of Learning SQL Step by Step Using Access which you may

 

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.


Copyright(2001-2009) D.H.D'Urso & Associates

Contact Information | FAQ's | Site Map | Back | Home | Top