Home

About Us

Catalog Main Catalog Microsoft Access Courses Database Development Courses Discounts and Passports Miscellaneous Fees & Services SQL Courses

Contact Us

ORA301: Introduction to Oracle Book List | Course Links
Tuition: $270.00 per student Length: 1 day
Synopsis: 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.
Formats: Lecture/demo with extensive hands-on practice. Available as a scheduled, public class only.
Scheduling: See calendar. Classes end at 3:00PM, an hour earlier than our standard time.
Group Discounts: 2-4 students 20%, 5-8 30%, >8 quote

Session 1	Oracle Fundamentals & SQL	2.5 Hours
	Lesson 1: Fundamentals of Oracle Database Topic 1A: Overview of Basic Database Concepts Topic 1B: Explore Oracle Database Lesson 2: Overview of the Oracle Architecture Topic 2A: Examine Memory Structures Topic 2B: Examine Logical Storage Structures Topic 2C: Examine Physical Storage Structures Topic 2D: Examine Backup and Recovery Processes Lesson 3: Using SQL Commands to Work with Tables Topic 3A: Use Data Definition Language (DDL) Commands Topic 3B: Use Data Manipulation Language (DML) Commands Topic 3C: Use Transaction Control Language (TCL) Commands
Session 2	Advanced SQL, PL/SQL & Administration	2.5 Hours
	Lesson 4: Creating Other Database Objects Topic 4A: Create Indexes Topic 4B: Apply Sequences Topic 4C: Use Views Topic 4D: Use Synonyms Lesson 5: Using PL/SQL Commands to Manipulate Data Topic 5A: Use PL/SQL Blocks Topic 5B: Work with Packages Topic 5C: Create Triggers Topic 5D: Use Object Relational Databases Lesson 6: Administering a Database Topic 6A: Create a Database Topic 6B: Manage Database Memory Topic 6C: Manage Database Processes Topic 6D: Work with Tablespaces Topic 6E: Managing Users and Permissions

Materials: Course workbook and training certificate.   Location: San Juan Capistrano training studio. 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.