MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.


I'm not curious

Introduction to Oracle 11g Database Administration

Course Summary

Covering the Basic Architecture, Roles, and Processes of Being an Oracle Database Administrator


  • +

    Course Syllabus

    • Introduction
      • Introduction
    • Lesson 1: Introduction to Databases
      • Learning objectives
      • 1.1 Relational databases
      • 1.2 SQL
      • 1.3 Relationships
      • 1.4 Connections and sessions
    • Lesson 2: Installing Oracle Database
      • Learning objectives
      • 2.1 Installing Oracle
      • 2.2 Database configuration assistants
      • 2.3 Configuration tables
      • 2.4 Oracle Enterprise Manager (OEM)
    • Lesson 3: Instance Management
      • Learning objectives
      • 3.1 SQL*Plus
      • 3.2 SQL developer
      • 3.3 SGA
      • 3.4 Starting and stopping OEM
      • 3.5 Database parameters
      • 3.6 Memory Management
    • Lesson 4: Storage Management
      • Learning objectives
      • 4.1 Control files
      • 4.2 Redo log files
      • 4.3 Tablespace
      • 4.4 Undo data
    • Lesson 5: Managing Users and Security
      • Learning Objectives
      • 5.1 Users and tablespaces
      • 5.2 Privileges
      • 5.3 Roles and profiles
    • Lesson 6: Managing Schema Objects
      • Learning Objectives
      • 6.1 Schemas
      • 6.2 Creating tables
      • 6.3 Constraints
      • 6.4 Indexes, views, and stored programs
    • Lesson 7: Backup and Recovery
      • Learning Objectives
      • 7.1 Oracle database recovery features
      • 7.2 Types of recovery
      • 7.3 Backup policies for configuration
    • Lesson 8: Administration and Upgrade
      • Learning objectives
      • 8.1 OEM Advisors
      • 8.2 Configuring and using alerts and metrics
      • 8.3 Automatic Database Diagnostic Monitor (ADDM)
      • 8.4 Other Available Advisors
    • Summary
      • Summary


Course Fee:
USD 199

Course Type:

Self-Study

Course Status:

Active

Workload:

1 - 4 hours / week

This course is listed under Enterprise Applications and Data & Information Management Community

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
REDHERRING
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url

Back to Top