Orange Coast Database Associates Training and Programming Home Page

Database Training Catalog

What's new at Orange Coast Database Associates
News

Catalog

Group Training

Individual Training

Scheduled Classes

Programming and Consulting

What's New!

FAQ's

Site Map

Free Catalogs

Special Offers

Request Information or Quote

Order a Class

Sales: 800-355-9855

Home

About Us

Calendar

Contact Us

Main Catalog Page

Orange Coast Database Associates Software Training

Microsoft Access | SQL | Database & Business Intelligence | Microsoft Office | Project Management | Programming & Coding | Discounts & Passports | Miscellaneous Fees & Services

Format this document with prices for printing Limit print to this category

Database Development
Click on the course title for a full description with price.

BackTop

Introduction to Relational Databases
2 day course on the basics of relational database design including tables, fields, keys, indexes, views, normalization, entity relationship diagrams, and SQL. Students will construct a simple ERD using Visio or another modeling tool. Accelerated Database Design is s shorter version of this course.

2 days

Accelerated Relational Database Design
Slightly shorter (1 day) version of DBD200 with minimal SQL. Ideal as a complement to one of the SQL courses. Students will construct, in Visio or another modeling tool, an Entity Relationship Diagram that applies to their application(s) during this course. The price for this course is reduced to $195 if taken in conjunction with an SQL course or a Microsoft Access course.

1 day

Introduction to Oracle
Introduction to features and functions of Oracle databases. Also covers SQL and PL/SQL. This course is designed for those who need a quick survey of the Oracle architecture and capabilities. Students taking this course should be familiar with relational databases and have some acquaintance with SQL. It would be a good complement to our Oracle SQL class which covers SQL in more depth. When taken in conjunction with an Oracle SQL class the price is only $125.

1 day

Relational Database Design - A Practical Approach
In this course students will learn the general principles involved in designing a database that complies with the relational database model. The conceptual content of this course is not specific to any software application but Microsoft Access will be used to perform the tasks in the lessons pertaining to queries. Visio or an equivalent modeling tool will be used for diagramming exercises.

Lesson objectives help students become comfortable with the course, and also provide a means to evaluate learning. Upon successful completion of this course, students will be able to:

  • Be conversant with the terminology used in reference to relational databases and be familiar with the design process.
  • Identify data as fields, group fields into tables, select key fields, and identify table relationships.
  • Identify data problems and apply data normalization techniques to solve them.
  • Use referential integrity and other data integrity techniques to support the accuracy of data in the database.
  • Use criteria and operators and perform appropriate table joins in queries.
  • Understand basic SQL queries and techniques for improving the performance of queries.
Students should have some familiarity with data tables and basic knowledge of how to create queries in Microsoft Access or equivalent.

1 day

Relational Database Design with MySQL
In this course, you will plan, design, and create a functional and efficient relational database. You can create effective database designs by applying the relational database design techniques taught in this course. MySQL will be used for implementation and is the basis for the manual. However, another database can be substituted upon request. Visio or equivalent design tools may be used for design. Students should have some familiarity with data tables and basic knowledge of how to create queries in Microsoft Access or equivalent.

1 day

Basic Crystal Reports
Hands-on course covering the fundamental features and functions of Crystal Reports, a leading report writing program. Students will explore the program environment, and learn how to open, navigate, create, modify, and save reports. They will learn the basics of formatting report objects, of sorting and selecting records, and creating groups and summaries. They will also learn how to create simple formulas and functions. Finally, students will work with Crystal Reports experts and wizards, and learn how to export reports to various file formats. Students should take Advanced Crystal Reports next.

2 days

Advanced Crystal Reports
This hands-on course builds on the skills and concepts taught in Crystal Reports Basic. Students will learn how to create and use parameter fields, advanced formulas using variables, and advanced functions. They will also learn how to create and customize charts and maps, apply advanced formatting options to report elements, and create alerts and subreports. Finally, students will work with the Business Objects Enterprise Repository and the Workbench, and they will learn advanced data access techniques including ODBC data sources and SQL query-building. Students should have taken Basic Crystal Reports or have equivalent knowledge.

2 days

Database courses are offered in three formats: 1) on-site at your location in the Greater Los Angeles and San Diego areas, 2) Private one-one-training as arranged, and 3) scheduled classes in San Juan Capistrano, Orange County. See calendar...

Calendar of Scheduled Classes in San Juan Capistrano

Receive course announcements and news. Sign Up Today!





Email Marketing by VerticalResponse

(Final prices will reflect tuition, materials, registration, applicable discounts and charges.)

 

Orange Coast Database Associates Page Footer


Privacy Statement | Programming & Consulting | CorkBoard | Reservation Calendar | Inquiries & Quotes | Orders | Enroll | Referral Program | Contact Information | FAQ'sSite Map | BackHome | Top