Oracle Database 11g: Administration Workshop I Release 2

Duration: 5 Days


What you will learn


This course is your first step towards success as an Oracle professional, designed to give you a firm foundation in basic database administration. In this class, you'll learn how to install and maintain an Oracle database. You will gain a conceptual understanding of the Oracle database architecture and how its components work and interact with one another. You 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.

Learn To:


  • Install Oracle Grid Infrastructure
  • Create and manage users
  • Install and Configure Oracle Database
  • Create and manage storage structures
  • Administer the Oracle Database
  • Backup and Recovery

This course fulfills the training requirement for an Oracle Certification Path. Only instructor-led online (LVC, LWC), in-class (ILT), or Training On Demand courses will fulfill the requirement. Self-study CD-ROM and Knowledge Center courses do not fulfill the training requirement.

Audience


Database Administrators
Java Developer
Support Engineer
Technical Administrator
Technical Consultant

Related Training


Required Prerequisites
Taken Oracle Introduction to SQL course or equivalent experience
Taken Oracle PL/SQL course or equivalent experience

Suggested Prerequisites
Oracle Database: Introduction to SQL
Oracle Database: PL/SQL Fundamentals

Course Objectives


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

Course Topics


  • Exploring the Oracle Database Architecture
  • Installing your Oracle Software
  • Creating an Oracle Database
  • Managing the Oracle Database Instance
  • Manage the ASM Instance
  • Configuring the Oracle Network Environment
  • Managing Database Storage Structures
  • Administering User Security
  • Managing Data Concurrency
  • Managing Undo Data
  • Implementing Oracle Database Auditing
  • Database Maintenance
  • Performance Management
  • Backup and Recovery Concepts
  • Performing Database Backups
  • Performing Database Recovery
  • Moving Data
  • Working with Support
Entre em contato conosco, clique!
#COMPARTILHE nossos cursos

Rua Emiliano Perneta, 680 - 9º Andar
Centro - Curitiba - Paraná - 80420-080
Fones: Curitiba - 3204-1999
Demais localidades - 4007-2186