|
Get Started
The Autumn 2009 program is no longer accepting applications
Next Programs Starts: Autumn 2010
|
Prerequisites: See the admission requirements on the How to Apply page.
Autumn Course
Concepts, Architecture, and Administrative Essentials
Students will learn basic RDBMS and SQL concepts and how they relate to Oracle's database product. Students should be able to identify major database components and explain their function; if asked to trace the lifecycle of a SQL statement, a student should be able to explain the role of each component. Additionally, students will create a database and perform basic management functions. They should be able to quickly find and understand the content of major database logs and should be able to monitor the database for failure conditions.
Topics
- Concepts - Normalization and RDBMS concepts, SQL review, transactions, data integrity, Commit, rollback, checkpoint, and undo
- Oracle Architecture
- Blocks, extents, and segments
- Tablespaces, datafiles, and controlfiles
- Redo and archive logs
- Schemas and objects
- Memory architecture
- Process architecture
- Application architecture
- Oracle Net Services
- Administrative Essentials
- OFA and database layout
- Log files
- Database creation
- Database startup and shutdown modes
- Monitoring database resource usage
- SQL*Plus scripting
Winter Course
Application Development and Administration
Students should understand the basics of Oracle user, system, and object security and will be exposed to some additional available security features. Students will also be introduced to PL/SQL programming and related concepts; they should be able to write a basic program unit capable of performing simple functions.
Students will also be exposed to backup and recovery concepts. Drawing from the fundamentals learned in the first class, they will not only understand the available backup tools, but they should be able to design a backup process appropriate for any recovery requirement.
Finally, students will learn additional system management techniques for managing Oracle software within the context of the UNIX or Linux operating system.
Topics:
- Security (Users, roles, and profiles, System and object privileges, Authentication, Auditing, Network security, OS security)
- PL/SQL
- Data types
- PL/SQL fundamentals
- Cursors and variables
- Control structures
- Packages, procedures, and functions
- Triggers
- Exception handling and pragmas
- Transactional control
- Backup and Recovery (Archive modes, LOGGING and NOLOGGING, Flash recovery and flashback database, RMAN: Backup, recovery and the RMAN catalog, Data Pump)
- System Management
- OS housekeeping (Log rotation, file system cleanup, etc.)
- Oracle Inventory and Software Patching
- Automated startup and shutdown
During this course, students will have limited, free use of Amazon.com's Elastic Computing Cloud. The Oracle Certificate program uses Amazon EC2 as an enterprise-class platform for in-class exercises and extended project work. With EC2, each student maintains an independent Linux-based Oracle environment that remains available both in and out of class for the duration of the program.
Spring Course
Troubleshooting, and Performance Tuning
This class will be beneficial to both developers and DBAs. Students should be able to include common Oracle utilities in their scripts and PL/SQL. Key to any successful implementation is the need to be able to troubleshoot common Oracle problems and quickly determine the potential root cause. Additionally, students will be exposed to Oracle internals, tracing utilities, and performance tuning basics. Developers and DBAs will be able to use these tools to identify and fix many common performance issues and should gain enough understanding of performance tuning methodology to effectively research more difficult problems without guessing.
Topics:
- Utilities
- Directories and UTL_FILE
- DBMS_OUTPUT
- SQL*Loader and external tables
- Advanced SQL
- Dynamic SQL
- Troubleshooting
- Logical root cause identification
- Tracing and logging
- Reading the alert logs and listener logs
- Diagnostic utilities
- Performance Tuning
- Optimizer overview
- Generating and reading explain plans using SQL and TKPROF
- Statistics, indexes, and histograms
- Operating system statistics
- Wait events
- Automatic Workload Repository
- Active Session History
During this course, students will have limited, free use of Amazon.com's Elastic Computing Cloud. The Oracle Certificate program uses Amazon EC2 as an enterprise-class platform for in-class exercises and extended project work. With EC2, each student maintains an independent Linux-based Oracle environment that remains available both in and out of class for the duration of the program.
