Oracle Database 10g : Administration Workshop I SitesPower Training Institute
Price: TBC

    Course details

    Course Overview

    Please Note: Oracle Courses are only available for private, onsite training.

    What one will learn

    This course is one's first step towards success as an Oracle professional, designed to give them a firm foundation in basic database administration. In this class, they will learn how to install and maintain an Oracle database. Applicants will gain a conceptual understanding of the Oracle database architecture and how its components work and interact with one another. They will also learn how to create an operational database and properly manage the various structures in an effective and efficient manner including performance monitoring, database security, user management, and backup/recovery techniques. The lesson topics are reinforced with structured hands-on practices. This course is designed to prepare you for the corresponding Oracle Certified Associate exam, which is one of the two exams required for the OCP DBA 10g certification.

    Learn To: 

    • Install the Database 
    • Back up and Recover Data 
    • Administer Users 
    • Transport Data between Databases 
    • Manage Data 
    • Configure the Network

    Database Administrator, Database Designers, Project Manager, Support Engineer, Technical Consultant

    Working knowledge of SQL

    Course Objectives

    • Install Oracle Database 10g and configure a database
    • Manage the Oracle instance
    • Manage the Database storage structures
    • Create and administer user accounts
    • Perform backup and recovery of a database
    • Monitor, troubleshoot, and maintain a database
    • Configure Oracle Net services
    • Move data between databases and files

    Course Outline

    • Introduction (Database Architecture)
    • Installing the Oracle Database Software
    • Creating an Oracle Database
    • Managing the Oracle Instance
    • Managing Database Storage Structures
    • Administering User Security
    • Managing Schema Objects
    • Managing Data and Concurrency
    • Managing Undo Data
    • Implementing Oracle Database Security
    • Configuring the Oracle Network Environment
    • Proactive Maintenance 
    • Performance Management
    • Backup and Recovery Concepts
    • Performing Database Backups
    • Performing Database Recovery
    • Performing Flashback
    • Moving Data


    About SitesPower Training Institute

    About SitesPower

    Resulting from our proven track record of customer satisfaction, SitesPower has been granted numerous international, elite authorizations and achievements in the short time since launching in 2001, not to mention having our courses Accredited by the Ministry of Education.  As an independent training provider, rather than a franchisee, these are true accomplishments. Authorizations include PMI, ILM (UK), Microsoft, RedHat, EC-Council, ITIL (EXIN), City & Guilds, AutoDesk, Adobe & ICDL.

    See all SitesPower Training Institute courses

    IT, Computing and Technology Related Questions

    Contact information not available.

    Are you from SitesPower Training Institute ? Claim your course!
    Courses you can instantly connect with... ORACLE (Database Administration Track) Jurassic Institute of Management and Technology ORACLE (Application Development Track) Jurassic Institute of Management and Technology ORACLE DATABASE 11G ADMINISTRATOR CERTIFIED PROFESSIONAL Al Khawarizmi International College

    Is this the right course for you?

    Rate our content

    Didn't find what you were looking for ?