Oracle 10g Administration

Training Provided by Software Training Academy, Inc Comprehensive, hands-on class focusing on the day-to-day tasks a DBA will perform to create, maintain and manage an Oracle 10g Database such as security, creating and managing users, creating and managing database objects (tablespaces, tables, indexes, etc.), running utilities, configuring Oracle networking, and simple backup and recovery techniques. Provides an overview of the Oracle Data Dictionary and Oracle 10g architecture; Administrative Users; Instances; Initialization Parameter Files; creating and managing Users; Password management; Auditing; Security; creating & managing Tablespaces, Heap Tables and Constraints; B-Tree Tables; managing Undo, Redo Logs and Control Files; backup and recovery with Oracle RMAN; SQL*Loader; an introduction to Oracle Networking and a comprehensive overview of creating an Oracle 10g database. Time-permitting, optional topics include Automatic Storage Management (ASM), Partitioning, other Table types, and Logical Backups with Original Export/Import Utilities. This training course has been completely updated for Oracle10g. This includes training on Data Pump, Server-Generated Alerts, Advisors, Automatic Statistics Collection and Auditing Enhancements. Working examples are included throughout the course. Students have access to electronic versions of all examples, sample scripts and lab solutions. Approximately 50 of class time is spent on hands-on exercises. LEARNING OBJECTIVES Describe the major architectural components of Oracle10g, including the SGA, background processes and files that make up the physical database. Use the Oracle data dictionary to to determine the structure and status of the database. This includes gaining a solid understanding of the purpose and content of many V$ and DBA-level views. Create administrative users, including granting and using the SYSDBA privilege. Understand the purpose of Oracle supplied users SYS and SYSTEM. Connect to the Oracle database as SYSDBA, both from a host server or - via the use of password files - over a network. Start and stop an Oracle database, including the use of various shutdown modes such as IMMEDIATE, TRANSACTIONAL and ABORT. View and alter initialization parameter values, create and startup with secondary parameter files. This includes training on the use of the Server Parameter File, introduced with Oracle9i. Create new Oracle users, provide tablespace quota and grant them the system or object privileges necessary to perform their work, including the use of roles. Secure the default users provided with database installation. Implement the Oracle user password management features such as password expiration, account locking, password reuse prevention and password complexity enforcement. Implement Oracle database auditing to track SYSDBA activity and general user activity. Also, code simple triggers to audit table data changes. Create and manage locally managed tablespaces including monitoring space usage and adding space Implement Automatic Segment Space Management to efficiently manage free and used space within extents. Using the Oracle Managed Files feature to control placement of and name the underlying datafiles. Manage storage for Oracle objects with disk striping and buffer pool assignment. Use Automatic Storage Management (ASM) to control file allocation, placement, striping and mirroring (this is an optional lesson) Describe the different types and typical uses of Oracle tables, including heap, index-organized and clustered tables. Create and manage heap-tables, including managing concurrency with the INITTRANS and MAXTRANS parameters, moving tables, using DBMS_STATS to collect statistics and increasing and measuring the performance benefits of NOLOGGING and table compression. Describe the different types of Oracle indexes including B-tree, bitmap and reverse key. Create simple B-Tree indexes on tables. This includes understanding the fundamental rules for when and where to create and when to avoid using indexes. Also implement index options such as NOLOGGING. Create constraints on tables including the use of options such as NOVALIDATE to allow existing legacy data with constraint violations. Describe the techniques for managing undo, including the Oracle9i Automatic Undo Management feature. Implement Automatic Undo Management including creating and enabling new undo tablespaces and monitoring for space-related problems. Use the Oracle10g Undo Advisor to assist with undo management. Manage the database redo logs including archiving, multiplexing and adding additional logs. Also, ensure that the database is recoverable by checking the archive log status of the database. Use the Oracle10g Redo Log Advisor to obtain log size advice. Understand the role and importance of control files. Add additional control files. Backup and recreate control files. Use the basic features of Recovery Manager to perform simple backup and recovery operations in the event of a lost or corrupted datafile. Use the 10g Data Pump utility perform logical backups or move or copy objects. Use the SQL*Loader utility to load data into the database. Configure Oracle Net (SQL*Net) to connect to and listen for connections. Manage the database listener with the listener control utility. Create a new database with the Database Configuration Assistant. Optional lessons include: Introduction to Partitioning, Other Table Types and Original Import / Export Utility Course Duration: 5 days. This training course contains a lot of information, sometimes too much for 5 days. The pre-existing knowledge of the student(s) will dictate how many days of instructor-led training are required. For example, if the students have no prior administration experience with a relational database, we recommend either allocating 8 days, or deleting some lessons from the lesson plan. However, if the students are veteran DB2 or Sybase administrator's, it is quite possible that all topics can be covered in 5 days. Prerequisites: You must have experience working with Oracle to successfully master the information in this course. Specifically, you must have solid Oracle SQL experience and familiarity with SQL*Plus and PL/SQL. You can obtain this training in STA's classes Introduction Oracle 10g SQL and Introduction to Oracle10g PL /SQL. Audience: Database administrators and System Administrators

Oracle 10g Administration 1. A DBA's Introduction to the Oracle Data Dictionary

2. Oracle10g Architecture, Part I

3. Oracle10g Architecture, Part II

4. Oracle10g Architecture, Part III

5. Oracle10g Administrative Users

6. Starting and Stopping an Oracle Instance

7. Oracle10g Initialization Parameter Files

8. Creating and Managing Users

9. Oracle10g Password Management

10. Introduction to Oracle10g Auditing

11. Managing Security in Oracle10g

12. Creating and Managing Oracle10g Tablespaces

13. Proactive Maintenance with Server-Generated Alerts (10g)

14. Creating and Managing Oracle10g Heap Tables

15. B-Tree Indexes

16. Creating and Managing Constraints

17. Managing Undo in Oracle10g

18. Managing Redo Logs

19. Managing Control Files

20. Oracle10g Backup and Recovery Basics - to RMAN

21. Importing and Exporting with DataPump (10g)

22. SQL*Loader

23. Introduction to Oracle Networking

24. Creating a new Oracle Database

25. Optional: Automatic Storage Management (10g)

26. Optional: to Oracle Partitioning

27. Optional: to Other Table Types

28. Optional : Logical Backups with Original Export/Import Utilities

About The Training Provider: Software Training Academy, Inc

More ORACLE Training from Software Training Academy, Inc

• Oracle 10g - Advanced SQL
• Oracle 10g - Introduction to SQL
• Oracle 10g PL SQL Programming