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). Students pursuing Oracle certifications should check the Oracle Education Website to obtain up-to-date information on current certification requirements. The class consists of a mixture of lecture and hands on lab exercises. AUDIENCE:   This class is intended for technical staff who are becoming responsible for creating and administering Oracle 11g 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. 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. Virtual machine images can also be provided by prior arrangement, simplifying the setup for this class if delivered in your offices. DURATION:   5 days APPROACH:   This class is delivered as an instructor-led class, either in a classroom or remotely. Courseware and lab files (and solutions) are provided. OBJECTIVES:   At the end of this course, delegates will be able to: Understand the concepts of a modern relational database management system Install and configure an Oracle 11g Enterprise Edition product Tune and optimise a running Oracle 11g system Create basic backups of an organisation’s critical data resources COURSE CONTENT:   Oracle 11g Architecture:   Overview of databases and instances;   Logical storage structures;   Logical database structures;   Physical storage structures;   Backup & Recovery features;   Security features;   Real Application Clusters;   Oracle Streams;   Oracle Enterprise Manager. Installing Oracle 11g:   Making installation decisions;   Installing Oracle 11g software;   Using the DBCA to configure a starter database;   Installing sample schemas;   Examining installed files;   Resolving installation problems;   Upgrading from earlier releases. Creating a Database:   Configuring the operating system;   Privileged account authentication;   Creating a parameter file;   Basic and advanced initialisation parameters;   Creating a database;   Creation commands;   Post-creation actions;   Data dictionary concepts. 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;   Quiescing and suspending operations. Physical storage management:   Tablespaces and datafiles;   Create, manage, drop tablespaces;   System tablespaces and user tablespaces;   Retrieving status information for tablespaces and datafiles;   Bigfile tablespaces;   Automatic storage management. Monitoring space usage:   Typical issues;   Segments, extents and blocks;   Locally managed tablespaces;   SYSAUX considerations;   Flash recovery area considerations;   Resumable space;   Automatic diagnostic repository. 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;   Flashback operations. 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. 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:   Setting automated alerts;   Collecting baseline metrics;   Using advisors;   Automatic Database Diagnostic Monitor;   Automated Workload Repository;   Responding to server alerts. Tuning:   Application design;   SQL;   Memory usage;   Data access;   Data manipulation;   Physical storage;   Network traffic. Database Security:   Security principles;   Authentication methods;   Authorisation methods;   Default user accounts;   Password management features;   Auditing overview;   Fine-grained auditing;   Enhanced auditing;   Encryption features. Advanced features and options:   Oracle Data Guard;   Oracle Streams;   Distributed databases;   Very Large Databases. Q&A:   Where to now?   Suggested reading list;   Further training. JR/08