About Course
Oracle DBA Course Description
Oracle DBA 12c/11g Training: Expertise at Oracle DBA Multi-Model Database Management | On-Demand Webinar | Life-Time Video Access | 24*7 Support. ... Self-Paced e-learning and/or instructor-led Live online training options; Learning Management System access. Learn ORACLE DBA Online Training course In USA, CANADA, UK, AUSTRALIA, HYDERABAD, BANGALORE, INDIA….. ATTEND FREE DEMO
Course Name: Oracle DBA
faculty:Real time Experience
Frequently Asked Questions
- You will never miss a class at Suntrainings! You can choose either of the two options:
- 1. You can go through the recorded session of the missed class and the class presentation that are available for online viewing through the LMS.
- 2. You can attend the missed session, in any other live batch. Please note, access to the course material will be available for lifetime once you have enrolled into the course.
- Sun Trainings is committed to provide you an awesome learning experience through world-class content and best-in-class instructors.
- We will create an ecosystem through this training, that will enable you to convert opportunities into job offers by presenting your skills at the time of an interview. We can assist you in resume building and also share important interview questions once you are done with the training. However, please understand that we are not into job placements.
- We have limited number of participants in a live session to maintain the Quality Standards. So, unfortunately participation in a live class without enrolment is not possible. However, you can go through the sample class recording and it would give you a clear insight about how are the classes conducted, quality of instructors and the level of interaction in the class.
- All instructors at Sun Trainings are senior industry practitioners with minimum 10 - 12 years of relevant IT experience. They are subject matter experts who trained by Sun Trainings to provide impeccable learning experience to all our global users.
- You can Call us at +91 9642434362 OR Email us at contact@suntrainings.com. We shall be glad to assist you.
Oracle DBA Course Curriculum
- Explain the Memory Structures
- Describe the Process Structures
- Overview of Storage Structures
- Identify the tools for Administering an Oracle Database
- Plan an Oracle Database installation
- Install the Oracle software by using Oracle Universal Installer (OUI)
- Create a database by using the Database Configuration Assistant (DBCA)
- 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
- Configure and Manage the Oracle Network
- Using the Oracle Shared Server architecture
- Overview of table space and data files
- Create and manage table spaces
- Space management in table spaces
- Create and manage database user accounts
- Grant and revoke privileges
- Create and manage roles
- Create and manage profiles
- Overview of Undo
- Transactions and undo data
- Managing undo
- Database Security and Principle of Least Privilege
- Work with Standard Database Auditing
- Use and manage optimizer statistics
- Use and manage Automatic Workload Repository (AWR)
- Use advisory framework
- Manage Alerts and Thresholds
- Use Automatic Memory Management
- Use Memory Advisors
- Troubleshoot invalid and unusable objects
- 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
- 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
- Overview of Data Recovery Advisor
- Use Data Recovery Advisor to Perform recovery (Control file, Redo log file and Data file)
- 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
- 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
- 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
- Configure backup settings
- Allocate channels to use in backing up
- Configure backup optimization
- 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
- 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
Trainer Information
- Trainer has 15+ years of experience in IT industry.
