CAAP 4603: Oracle 10g: Database Administration I

Description

Students access recorded, multi-media formatted video sessions of each class lecture. These versatile, multi-media classes show the instructor, any program that is displayed on the instructor’s computer, the instructor’s notes and real-time digital markups, and sound all together in a single presentation!

Students can access the class sessions by streaming on the Internet as often as they like and have the ability to pause, rewind and forward to key sections of interest.

The instructor will be constantly monitoring the class portal and available to answer questions, provide feedback, and other guidance via the portal, community message board, internet chat, and internal class email system. The instructor will post video lectures on a weekly basis for the students to view and perform lab and homework activities. The instructor will host live office hours each week via conference call, chat, and/or video conference.

Registration is on an open, rolling basis; register when you want up to two weeks before the end date. The course requirements must be completed by the end date.

Topics Covered:

Database Objects
PL/SQL
Oracle Architecture
Understanding the Oracle Instance
Managing Table Spaces and Data Files
Managing Tables and Indexes
Managing Undo Data
Managing the Online Redo Log and the Control File
Managing Users and Security

Benefits

The University of Colorado at Boulder has partnered with Oracle Corporation to bring you the very best in training and development. This unique partnership combines the exemplary education program of the University of Colorado with the hands-on expertise of Oracle Corporation. Some of the benefits of taking an Oracle course with our program include:

Students will learn material that help prepare them for the Oracle certification exam
Students receive exclusive supplementary Oracle University training workbooks
Students receive a 50% discount on selected Oracle certification exam practice test software
Students receive a 25% discount on Oracle certification exams
Free membership to the Oracle Technology Network: The definitive source for Oracle technical information when developing for the Internet. An online community with access to free software, OTN-sponsored Internet developer conferences, and discussion group

As an Oracle certified education partner, the University of Colorado is able to offer these exclusive benefits to students at a very reasonable price.

Prerequisites

Oracle 10g: PL/SQL

Education Officer (EO)

Not Required

Hardware & Software

CU is providing web-based access to an Oracle database. On this database, students will have access to all required data for the course and be able to perform all Oracle SQL coding activities. Students will need a PC with Internet access (preferably broadband). Minimum system requirements: Pentium III with 256MB of RAM.

To view the lectures online, you will need at least Internet Explorer 7, or FireFox 2, or Google Reader at http://google.com/reader.

Interact

Courses