Oracle 11g Database Associate
Who should attend | Prerequisites | Content | Sample Notes | Next Class | Printer Friendly 
Class Summary
Oracle 11g is the latest release of the acclaimed relational database
product from the Oracle Corporation. By implementing this innovative
product, organisations can benefit from advanced features including
Real Application Testing, advanced compression and automatic "hands-off"
management. This class utilises the graphical management tools introduced
with Oracle 11g to familiarise delegates with creating and administering
physical and logical file structures in this powerful relational
database product. The class has been newly
updated for 2008.
By completing this class, and with some further hands-on practice,
delegates will be prepared to undertake the Oracle Database 11g
Administrator Certified Associate (OCA) Exam (code 1Z0-052). Please
note that candidates who wish to obtain the more advanced Oracle
Database 11g Certified Professional (OCP) credential must attend
one Oracle authorised instructor-led class or instructor-led online
class. Further information can be obtained from the Oracle
Education website. This Oracle policy may change in the future
and you are advised to contact
us for up-to-date information. Oracle's 11g
certification is in beta only as at the beginning of 2008.
The class consists of a mixture of lecture and hands on lab exercises.
Who Should Attend This class is intended for technical staff who are becoming responsible for creating and administering Oracle databases. Development staff may also benefit from attending this class, to gain an overview of the work of a Database Administrator to aid in developing effective software systems that will be based on Oracle.
For experienced DBA's cross training from other RDBMS products or earlier versions of Oracle, this class can be run in a shortened three day format.
Prerequisites
A grounding in relational database concepts; familiarity with the use of graphical user interfaces and either Windows or Linux operating systems.
Some expertise with both SQL and PL/SQL in an Oracle environment is beneficial, although basic concepts of both languages are covered briefly in this class.
Each delegate will require exclusive use of a suitably equipped
PC, together with a single CD containing Oracle 11g Release 1 for
Windows or Linux as appropriate. Please consult the Oracle
TechNet website to review the Installation Notes Hardware Requirements
for Windows
or Linux
- free registration is required to view this website.
Content
- Oracle 10g Architecture: Memory, process and disk structure; instances and databases; storage structures; processing for queries, updates and transactions.
- Installing Oracle 10g: Making installation decisions, installing Oracle 10g software, using the DBCA to configure a starter database, installing sample schemas, examining installed files, resolving installation problems.
- Creating a Database: Configuring the operating system; privileged account authentication; creating a parameter file; creating a database; creation commands; post creation actions; data dictionary management.
- Database Interfaces: Using SQL*Plus and iSQL*Plus; accessing data and structure; using query, manipulation and transaction commands; creating, altering and dropping database information.
- Starting and Stopping Oracle: Starting processes - dbconsole, listener, isqlplus, database instance; startup modes; parameter file; alert log; shutdown operations.
- Tablespaces and Datafiles: Purpose and use of tablespaces and datafiles; create, manage, drop tablespaces; system tablespaces and user tablespaces; retrieving status information for tablespaces and datafiles.
- Schema Objects: Creating and modifying tables; selecting appropriate data types; constraints; viewing table contents; creating and managing indexes and views; creating and using sequences.
- Undo Management: Undo/rollback concepts; configure and size undo features; using the Undo Advisor; undo tablespaces; undo for transactions and rollback/recovery.
- Data Administration: Moving data using DML; Data Pump for export and import; SQL Loader for importing external data; administering Oracle directories.
- PL/SQL for DBA's: PL/SQL Overview; anonymous blocks; procedures, functions, packages; triggers; supplied procedures.
- User Administration: Creating and managing user accounts; profiles, roles, privileges and user assignment; user resource management.
- Database Security: Security principles; default user accounts; password management features; auditing database actions.
- Network Administration: Managing Oracle listener; Net services; connect time failover; using Net Manager to configure resolution methods, database connectivity; configuring and administering shared servers.
- Backup and Recovery Concepts: Overview of backup and recovery; failure point identification; configuring checkpoints, redo logs, archiving; configure database for recovery; RMAN overview; flash recovery area.
- Database Backups: Cold and hot datafile/tablespace backups; automated backups; incremental backups; image copies; multiplexed archive logs; control file backups; spfile/password file backups.
- Database Recoveries: Restore and recovery overview; non-critical datafile recovery; critical file recovery; recovering damaged archive logs; recovering control files.
- Lock Management: Overview; detecting locking issues; transactions and locking; configuring optimum lock strategies; resolving potential deadlocks.
- Performance Guidelines: Performance issues; SQL optimiser statistics; gathering performance metrics; Enterprise Manager performance features.
- Diagnostics and Tuning: Setting automated alerts; collecting baseline metrics; using advisors; Automatic Database Diagnostic Monitor; Automated Workload Repository; responding to server alerts.
- Q&A: Where to now?; suggested reading list; further training.
Sample notes
In preparation
Suggested next class Oracle 10g Professional
|
 |
|
