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.
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.
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.
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.
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.
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.
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.
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...
(Final prices will reflect tuition, materials,
registration, applicable discounts and charges.)