Want to boost enrolments? Login and promote your courses
Searching for courses? Login or register
courses The smart course guide
Courses    
  Most popular search | Share this page  
open My list: 0 courses
diploma in business administration   database administrator course   business administration courses   database administrator courses   administration course in london   business administration courses in london   administration courses   business administration courses london   administration courses london   changes in business administration
Homepage › IT, Computing, Telecommunications Courses › Database Administration Courses › Oracle Courses

Oracle 10g Database Administration

in PTR Associates Ltd (England)

Classes Course

Place:

Wokingham

Price:

£1,475 + VAT

Duration:

5 Days

Start:

07/12/2008 calendar
See course programme

Requirements:

Introduction to Oracle9i, Introduction to Oracle10g, or at least six months working in an Oracle technical ... see more

Request free information

Course objectives:

Develop the key fundamental skills necessary to be an Oracle DBA. Delegates will design and create a server using the Optimal Flexible Architecture (OFA), configure logical and physical structures, set up database and user security, add and administer users, and monitor and tune main server areas. Each student will create a toolkit of administratio...

More courses Subject area
Place
 

Request information

Contact directly and with no obligation with
PTR Associates Ltd
You must complete all fields on this form in order for us to send it to the course provider.
We have highlighted incomplete/ incorrect details in red.
* Compulsory fields
By clicking "Email request / Telephone" you registering and accepting the Terms of Use and privacy policy of Emagister.
I wish to receive the personalised newsletter (during a maximum period of 15 days)

Availability?
How do I enrol?
Where can I get more information?

The person in charge of this course will receive your information request instantly.

Response time:
:| :) ;)
Average Fast Very fast
 

Course details

Type Course Duration 5 Days
Method / place Contact course provider Classes in Wokingham where
Course objectives Develop the key fundamental skills necessary to be an Oracle DBA. Delegates will design and create a server using the Optimal Flexible Architecture (OFA), configure logical and physical structures, set up database and user security, add and administer users, and monitor and tune main server areas. Each student will create a toolkit of administratio...
Requirements
Introduction to Oracle9i, Introduction to Oracle10g, or at least six months working in an Oracle technical environment. An understanding of relational database concepts, SQL, and PL/SQL programming skills are required. A solid understanding of Oracle schema is recommended.
Price £1,475 + VAT
Get direct information on how to enrol, venues and availability...

Oracle courses (from other course providers)

 
Oracle 10g Database Administration II 1ZO-043
We Teach You
Distance - £50 + VAT
 
Oracle Series
Sales 101 Ltd
Online - £75 + VAT
Compare the selected courses
+ oracle Courses + Oracle Courses in Berkshire + Courses in Berkshire + PTR Associates Ltd Courses

Course programme

Oracle 10g Database Administration
Course objectives:
Develop the key fundamental skills necessary to be an Oracle DBA. Delegates will design and create a server using the Optimal Flexible Architecture (OFA), configure logical and physical structures, set up database and user security, add and administer users, and monitor and tune main server areas. Each student will create a toolkit of administration scripts for database management and tuning by the end of this class. This class will also address issues for DBAs having to support Oracle8i and Oracle9i databases.

Suitable for non-Oracle database administrators, application developers, and system administrators.

Course content:
Overview of Oracle Database
  • ORACLE_HOME and ORACLE_SID
  • The Oracle Database vs. The Oracle Instance
  • Instance Memory Structures
  • Background Processes
  • Server Processes
  • Datafiles
  • Blocks, Extents, and Segments
  • Control Files
  • Redo Logs
  • The Oracle Architecture
  • SYS and SYSTEM Users
    Starting and Shutting Down an Oracle Database
  • SYSDBA and SYSOPER System Privileges
  • Oracle Database Startup
  • Oracle Database Shutdown
  • Altering Database Availability
  • Suspending and Resuming a Database
  • Quiescing a Database
  • Tracking Database Activity - The Alert Log
  • Data Dictionary Views for Startup and Shutdown
    Using The Oracle Data Dictionary
  • Introducing the Data Dictionary
  • DBA, ALL, and USER Data Dictionary Views
  • V$ Dynamic Performance Views
  • Using Oracle Documentation to Locate Data Dictionary Views
  • Combining Data Dictionary Views
    Oracle Database Users and Schemas
  • Users and Schemas
  • Oracle Default Database Users
  • Oracle Sample Schemas
  • Creating Users
  • Altering and Dropping Users
  • Data Dictionary Views For Users
    Oracle System Privileges
  • Overview of System Privileges
  • Granting and Revoking System Privileges
  • Data Dictionary Views for System Privileges
  • Roles
  • Creating and Removing Roles
  • Data Dictionary Views for Roles
  • Pre-defined Roles
  • User Group PUBLIC
    Parameter Files
  • Oracle Database Parameters
  • The Parameter File (PFILE) and the Server Parameter File (SPFILE)
  • Dynamic vs. Static Parameters
  • Determining Current Parameter Settings
  • Benefits of SPFILEs over PFILEs
  • Creating an SPFILE from a PFILE and Back Again
  • Understanding Scope
  • Session-Level Parameters
  • Data Dictionary Views for Parameters
    Datafiles and Tablespaces
  • Datafiles Overview
  • Tablespaces Overview
  • SYSTEM and SYSAUX Tablespaces
  • Creating Tablespaces
  • Dictionary- and Locally-Managed Tablespaces
  • Locally-Managed Tablespace Extent Allocation
  • Temporary Tablespaces
  • Temporary Tablespace Groups
  • Default Tablespaces
  • Tablespace Quotas
  • Dropping and Altering a Tablespace
  • Renaming a Tablespace
  • Renaming or Relocating Datafiles
  • Bigfile Tablespaces
  • Data Dictionary Views for Datafiles and Tablespaces
    Control Files
  • Control Files Overview
  • Database Parameters for Control Files
  • Backing Up Control Files
  • Restoring Control Files from Multiplexed Copies
  • Restoring Control Files from Backups
  • Moving Control Files
  • Data Dictionary Views for Control Files
    Oracle Physical Structures - Online Redo Logs
  • Redo
  • Redo Log Files
  • Database Parameters for Redo
  • Sizing the Redo Log Files
  • How Many Redo Log Groups?
  • Creating Redo Logs
  • Removing Redo Logs
  • Renaming Redo Log Files
  • Forcing Log Switches
  • Archiving Redo Logs
  • Configuring Archive Log Mode
  • Database Parameters for Archiving
  • Data Dictionary Views for Redo Logs
    Oracle Physical Structures - Undo Segments
  • Undo Overview
  • Database Parameters for Undo
  • Creating Undo Tablespaces
  • Altering and Dropping Undo Tablespaces
  • Switching Undo Tablespaces
  • Undo Advisor
  • Data Dictionary Views for Undo
    Segment Space Management
  • Blocks, Extents and Segments
  • Fragmentation
  • Coalescing Fragmented Space
  • Manual Segment Space Usage
  • Automatic Segment Space Management
  • Data Dictionary Views for Physical Objects
    Tables
  • Tables Overview
  • Physical Properties of Tables
  • Row Chaining and Row Migration
  • Creating Tables
  • Table Storage and Logging
  • Altering Tables
  • Dropping Tables
  • The Recycle Bin
  • The TRUNCATE COMMAND
  • Temporary Tables
  • Clustered Tables
  • Indexed-Organized Tables
  • Creating an IOT
  • Data Dictionary Views for Tables
    Indexes
  • Indexes
  • B-tree Indexes
  • NULL Values and Indexes
  • NULL Values and Unique Indexes
  • Creating Indexes
  • Monitoring Index Usage
  • Dropping Indexes
  • Rebuilding and Moving Indexes
  • Coalescing Indexes
  • Bitmap Indexes
  • Special Index Types
  • Index Key Compression
  • Data Dictionary Views for Indexes
    Constraints
  • Integrity Constraints
  • Constraint Names and Syntax
  • Constraint Checking
  • Managing Primary Key Constraints
  • Managing NOT NULL Constraints
  • Managing Check Constraints
  • Managing Foreign Key Constraints
  • Data Dictionary Views for Constraints
    Views
  • Views
  • Creating and Replacing Views
  • Data Dictionary Views for Views
  • Security Through Views
  • Altering and Dropping Views
  • Dependencies and Views
  • Updating Data Through Views
    Object Privileges
  • Object Privileges
  • Granting and Revoking Object Privileges
  • Using WITH GRANT OPTION
  • Revoking and the GRANT OPTION
  • Data Dictionary Views for Object Privileges
    Synonyms
  • Synonyms
  • Private and Public Synonyms
  • Creating and Dropping Synonyms
  • Security through Synonyms
  • Object Precedence
    The Optimizer and Statistics
  • Optimizer Overview
  • Optimizer Statistics
  • Data Dictionary Views and Statistics
  • Collecting Statistics
  • Removing Statistics
  • Automated Statistics Collection
    Oracle Net Services
  • Oracle Networking Explained
  • The Net Configuration Assistant
  • Configuring the Listener - GUI
  • Configuring the Listener - Manually
  • Configuring the Client - GUI
  • Configuring the Client - Manually
    Data Pump
  • Oracle Data Pump Architecture
  • Configuring for Data Pump
  • Command-Line Utilities
  • Exporting With expdp
  • Importing With impdp
  • Interactive Mode
  • Attaching to a Running Job
  • Parallel Data Pump
  • Data Dictionary Views for Data Pump
    SQL Loader and External Tables
  • SQL Loader
  • SQL Loader Control File
  • Loading Data with SQL Loader
  • Conventional vs. Direct Path Loads
  • External Tables Overview
  • Creating an External Table
  • Creating a Writable External Table
    Backup Your Database
  • Physical Backups vs. Logical Backups
  • Offline Backup Basics
  • Oracle Offline Backup Steps
  • Other Backup Considerations
  • Advanced Backup Concepts
  • RMAN
    Recover Your Database
  • Offline Recovery Basics
  • Restoration Using Offline Backups for a NOARCHIVE Database
  • Restoring Other Files
  • Other Recovery Considerations
    Oracle Enterprise Manager
  • Introducing Oracle Enterprise Manager
  • OEM Architecture and Physical Structure
  • Installing OEM When Using DBCA
  • Using EMCA to Install OEM
  • Managing OEM
  • Removing OEM
  • Troubleshooting OEM
  • Securing OEM
  • Starting OEM
  • Introducing the OEM Home Pages
  • Using OEM - Managing the Job Scheduler
  • Using OEM - Using Metrics, Alerts, and Thresholds
  • Automatic Workload Repository
  • The Automatic Database Diagnostic Monitor - ADDM
  • OEM and Advisors
  • The SQL Access Advisor
    Appendix A - Installing Oracle Software
  • Optimal Flexible Architecture
  • OFA Directory Layouts
  • The Oracle Universal Installer
  • OUI Installation Modes
  • Preparing To Install Software
  • Starter Database
  • Installing the Oracle Software
  • Deinstalling Oracle Software
    Appendix B - Creating a Database Using the DBCA
  • The DBCA
  • Select a Database Template
  • Specify the Database Name
  • Set System Account Passwords
  • Specify File Locations
  • Install Sample Schemas
  • Specify Storage Parameters
  • Create Your Oracle Database
  • Oracle Net Configuration Assistant
  • Configure the Listener
  • Set TCP Parameters
  • Removing a Database with the DBCA
    Appendix C - Manual Database Creation
  • Manual Database Creation
  • Prepare the System
  • Creating the Parameter File
  • The CREATE DATABASE Statement
  • Manually Create the Datbase
  • Finalizing the Creation
  • SQL.BSQ File
  • Creating the Service on Windows
    Appendix D - Auditing the Database
  • Auditing Explained
  • Data Dictionary Views for Auditing
  • Audit Trail, OS, and DB
  • Statement Auditing
  • Privilege Auditing
  • Object Auditing
    • see the full course programme

    on request

    get more information on the programme directly from PTR Associates Ltd.

    Request information for free
    Get direct information on how to enrol, venues and availability...
     

    Venues and dates



    Where Wokingham, 21a Peach Street see map
    When Start: 07/12/2008 Finish: 11/12/2008 See calendar
     
    Get direct information on how to enrol, venues and availability...
     

    Ex-students

     
    Opinions
     
    Have you attended this course?

    Voice your opinion and help thousands of other users

    opinions

    from users who have attended
    this course.
    Get direct information on how to enrol, venues and availability...
     

    On PTR Associates Ltd

    Provider description
    PTR specialises in technical training, particularly in the areas of data communications & networking, internet/intranet, operating systems, programming languages and relational databases. Company specific courses are available for organisations that have several employees who all need training at the same time or who have a requirement for a tailored course. Closed courses typically provide cost benefits when there are at least four employees who need training simultaneously. Courses can be run at PTR's Training Centre or on-site if suitable facilities exist. Benefit from substantial discounts on technical training with our SAVE IT Scheme. If you, or your organisation has a training requirement of 10+ days then our Save IT Scheme may provide additional savings on your training.
    Advantages of studying with PTR Associates Ltd
    Vendor-independent & Generic Training - unbiased independent knowledge Small Class Sizes - increased interaction with lecturer Hands-on - increased learning efficiency Training Environment - modern, air-conditioned classrooms Course Notes - up-to-date, plain English, excellent reference material Training Experience - friendly, personal service
    Refreshments - morning and afternoon breaks with lunch arrangements second to none, at one of the many local restuarants ROI - our prices and quality mean an excellent Return on Investment   Lecturer Expertise - vendor certified with real-world product experience
    Course provider history
    PTR Associates Ltd was established in 1989.
    Specialises in
    Applications Programming Databases Operating Systems Data Communications and Networking Internet Scripting

    All courses

    by PTR Associates Ltd on emagister.

    See list of courses

    Get direct information on how to enrol, venues and availability...
     

    Most searched for in Oracle

    Courses IT, Computing, Telecommunications | Courses Database Administration | Courses Oracle | Courses Oracle 10g | Courses Oracle database 10g
    International sites Spain  |  Italy  |  France  |  Mexico  |  Germany  |  UK  |  Japan  |  Argentina
    Words related to the courses viewed: oracle warehouse builder 10g database design database architecture
    emagister.com complies with the 15/1999 Organic Law dated 13th December (Spain), the Data Protection Law and holds the inscription code 2002010053 on the General Register of the Data Protection Agency. Copyright 1999/2000 - Grupo Intercom - All rights