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

Course Description

News and special offers from Orange Coast Database Associates
News

 Home-->Courses-->sql200a

Related Courses

Group Training

Individual Training

Scheduled Classes

What's New!

FAQ's

Site Map

Free Catalogs

Special Offers

Request Information or Quote

Sales: 800-355-9855

Home

About Us

Catalog

Calendar

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: 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 for only $360.

Scheduling: Flexible. Group and private training can be scheduled to suit your needs. See calendar for scheduled classes.

Group Discounts: 2-4 students 20%, 5-8 30%, >8 quote

 

Format this document for printing

Session 1Basic MS Access SQL Data Retrieval, Functions3.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 2MS Access SQL Grouping, Data Manipulation3.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 slides, text book, 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.


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

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