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-->ora301

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

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

 

Format this document for printing

Session 1Oracle Fundamentals & SQL2.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 2Advanced SQL, PL/SQL & Administration2.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.


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

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