EDUZZA

Become an Oracle DBA (Database Administrator) Curriculum

Section 1: Exploring the Oracle Database Architecture
Explain the Memory Structures
Describe the Process Structures 
Overview of Storage Structures
Section 2: Preparing the Database Environment
Identify the tools for Administering an Oracle Database
Plan an Oracle Database installation 
Install the Oracle software by using Oracle Universal Installer (OUI)
Section 3: Creating an Oracle Database
Create a database by using the Database Configuration Assistant (DBCA)
Section 4: Managing the Oracle Instance
Setting database initialization parameters
Describe the stages of database startup and shutdown
Using alert log and trace files
Using data dictionary and dynamic performance views
Section 5: Configuring the Oracle Network Environment
Configure and Manage the Oracle Network
Using the Oracle Shared Server architecture
Section 6: Managing Database Storage Structures
Overview of table space and data files
Create and manage table spaces
Space management in table spaces
Section 7: Administering User Security
Create and manage database user accounts
Grant and revoke privileges
Create and manage roles
Create and manage profiles
Section 8: Managing Undo Data
Overview of Undo
Transactions and undo data
Managing undo
Section 9: Implementing Oracle Database Security
Database Security and Principle of Least Privilege
Work with Standard Database Auditing
Section 10: Database Maintenance
Use and manage optimizer statistics
Use and manage Automatic Workload Repository (AWR)
Use advisory framework
Manage Alerts and Thresholds
Section 11: Performance Management
Use Automatic Memory Management
Use Memory Advisors
Troubleshoot invalid and unusable objects
Section 11: Backup and Recovery Concepts
Identify the types of failure that can occur in an Oracle database
Describe ways to tune instance recovery 
Identify the importance of checkpoints, redo log files, and archived log files 
Overview of flash recovery area 
Configure ARCHIVELOG mode
Section 12: Performing Database Backups
Create consistent database backups
Back up your database without shutting it down 
Create incremental backups 
Automate database backups 
Manage backups, view backup reports and monitor the flash recovery area
Section 13: Performing Database Recovery
Overview of Data Recovery Advisor
Use Data Recovery Advisor to Perform recovery (Control file, Redo log file and Data file)
Section 14: Moving Data
Describe and use methods to move data (Directory objects, SQL*Loader, External Tables)
Explain the general architecture of Oracle Data Pump 
Use Data Pump Export and Import to move data between Oracle databases
Section 15: Configuring for Recoverability
Configure multiple archive log file destinations to increase availability
Define, apply and use a retention policy 
Configure the Flash Recovery Area 
Use Flash Recovery Area
Section 16: Using the RMAN Recovery Catalog
Identify situations that require RMAN recovery catalog
Create and configure a recovery catalog 
Synchronize the recovery catalog  
Create and Use RMAN stored scripts 
Back up the recovery catalog 
Create and use a virtual private catalog
Section 17: Configuring Backup Specifications
Configure backup settings
Allocate channels to use in backing up  
Configure backup optimization 
Section 18: Using RMAN to Create Backups
Create image file backups
Create a whole database backup  
Enable fast incremental backup  
Create duplex backup and back up backup sets 
Create an archival backup for long-term retention  
Create a multisection, compressed and encrypted backup  
Report on and maintain backups 
Section 19: Using RMAN to Perform Recovery
Perform complete recovery from a critical or noncritical data file loss using RMAN
Perform incomplete recovery using RMAN  
Recover using incrementally updated backups  
Switch to image copies for fast recovery 
TAKE THIS COURSE
  • $799.00
  • 40 Days
  • Course Certificate

REVIEWS / TESTIMONIALS

  • Took the Salesforce dot com (SFDC) LIVE online course with Eduzza. Course instructor was very knowledgeable, and handled the class very well in terms...Read more

    Abhishek Kumar

    Business Analyst

  • My association with Eduzza began when I enrolled for the Oracle HFM (Hyperion Financial Management) course. Since I am a Business Analyst, I was a...Read more

    Gomesh Desai

    Business Analyst

  • I had a very good experience with the UI Web Development course which I took with Eduzza. Instructor paced the training according to my grasping of...Read more

    Israt Ali

    UI/UX Professional

  • I took the Business Analyst (BA) course from Eduzza. The best part about the course is that, variety of problems with real world use cases were...Read more

    Rakesh P

    Business Analyst

  • I had attended a couple of demo sessions in Advance Web Development with other training companies before joining EDUZZA. With EDUZZA's first demo...Read more

    Suvarna G

    Web Developer

  • First I will like to thank you for the C#.Net classes I'm currently taking; the instructor is wonderful, very easy to follow and understand. I feel...Read more

    Guisselle

    Software Developer

  • I was looking for a practical Business Analyst course and went through many other IT online training portals just when a friend of mine recommended...Read more

    Cong Nie

    Business Analyst

  • EDUZZA's Business Analyst Certification Training was indeed very good. The training sessions were very informative and clear. The trainer's own...Read more

    Deepali Pandit

    BA

  • Initially I was not sure about completing the Hadoop EcoSystem course in 30 hours but now I can say that EDUZZA's instructor Sitaram gave complete...Read more

    Chenna Manukonda

    Hadoop Developer

  • One of the best things about EDUZZA's "QA Training – Software Testing Course" online training is that it covers the practical aspects of the...Read more

    Paulomi Parekh

    QA Analyst

DISCOVER COURSES

Popular Courses