Oracle DBA 11g

PDF OPEN FILE AS PDF DOCUMENT

 

What is Oracle DBA 11g?

Oracle Certified Associate (OCA) DBA 11g certification demonstrates fundamental knowledge in the Oracle 11g Database

 

Course Benefits:

  • Monitor performance
  • Describe Oracle Database Architecture
  • Install Oracle Grid Infrastructure
  • Install and configure Oracle Database 11g
  • Configure Oracle Net services
  • Monitor and administer undo date
  • Manage the database storage structures
  • Create and administer user accounts
  • Perform basic backup and recovery of a database
  • Manage data concurrency


Who Should Attend: no prerequisite

  • Database Administrator
  • Application Administrator
  • Application Developer
  • Technical Support
  • Technical Consultant
  • Project Manager

 

About the Instructor:

  • Mr. Lin (Oracle DBA) Over 15 years of extensive experience of Oracle database management on 7, 8, 8i, 9i, and 10g as lead DBA/Architect. Managing database administrating, development, performance tuning, capacity planning and trouble shooting in the large complex data center environment. Implementing enterprise monitoring systems, backup/recovery strategy, and HA/DR solutions. a SME in the DBA instruction, database architecting, performance tuning, backup/recovery, and consulting.

 

The Career Outlook

Various job titles

  • Oracle Database Administrator (DBA)  
    • Jr., Sr.
    • Principal, Lead
    • Development, Production
    • Backup/Recovery, Performance
  • Application DBA

    • Oracle ERP, Peoplesoft ERP, Siebel CRM, SAP ERP, …
  • Database Developer/Engineer

    • SQL, PL/SQL, …
  • Database Architect

    • Schema Design

 

Course Dates: 52 hours (13 sessions) (pls call for details)

 

Class Format:

  • lectures/presentations
  • demonstrations
  • reading materials
  • exercises


Course Content

  • SQL Fundamentals
    • DDL and Schema Objects
    • DML and Concurrency
    • Retrieving, Restricting, and Sorting Data Using SQL
    • Single-Row and Conversion Functions
    • Group Functions
    • SQL Joins
    • Subqueries and Set Operators
    • PL/SQL Basics
  • Database Architecture and Administration

    • Architectural overview
    • Installing and Creating a Database
    • Instance Management
    • Oracle Storage
    • Oracle Security
    • Globalization
  • Oracle Net

    • Oracle Networking
    • Manage Oracle Network
    • Oracle Shared Server
  • Database Backup and Recovery

    • Configuring the Database for Backup and Recovery
    • Back Up with RMAN
    • Restore and Recover with RMAN
    • Advanced RMAN Facilities
    • User-Managed Backup, Restore, and Recovery
    • Flashback
  • Database Monitoring and Performance Tuning

    • Moving and Re-Organizing Data
    • The AWR and the Alert System
    • Performance Tuning