Oracle DBA Basics For Beginners Training Course

Course Description

oracle-database-administration-essentials-tutorial-course

The Oracle dba system administration training course helps you to discover the oracle admin tool used by database administrators in enterprise database deployments and how dba database administration is done on a day to day basis. Learn the every day job of a Oracle database admin (DBA) in this training course. Those who are preparing for a oracle certified professional dba or certified oracle dba will find this course useful. Although this course doesn't focus on oracle certification exam preparation it does equip you with knowledge that helps you become a good oracle database administrator because we conduct this hands on and provide deep understanding of the concepts to help you on the job, which is more important step after your certification. The trainer is very experienced Oracle admin DBA who has managed oracle RAC clusters and work on database performance turning projects.
Most oracle dba training center would focus on the exam, our training institute focuses on you learning database administration skills for life, so that you become a good oracle database admin. Those preparing for data certification also will find this beneficial because we run our training on CentOS linux, which is a redhat linux community distribution. This course is for the System administrators and users who already have basic exposure to Linux or another Unix operating system. The course provides Linux system administrators with all the tools and concepts needed to efficiently build and manage a production Linux infrastructure. If you are looking for best linux classes or hands on best linux training institute, you have found the right one.
This course prepares you to be a OracleTM DBA System Administrator.

Free Career Guidance

Fee Details

Course Code Course Name Duration Course Fees (SGD)
193

Oracle DBA Basics For Beginners

5 Days
(40 Hrs)
$ 4197
Registration & Material Fees of $S 50 Applies.
Register your interest by filling the form below
Email Me Full Details Course Content Related Courses Funding Options Corporate Clients

 

Get All Details About This Course Now!

Course Content

Click Here To View Fee Details
Module 1: Exploring the OracleTM Database Architecture
OracleTM Database Architecture Overview
OracleTM ASM Architecture Overview
Process Architecture
Memory structrues
Logical and physical storage structures
ASM storage components
Module 2: Installing your OracleTM Software
Tasks of an OracleTM Database Administrator
Tools Used to Administer an Oracle Database
Installation: System Requirements
OracleTM Universal Installer (OUI)
Installing OracleTM Grid Infrastructure
Installing OracleTM Database Software
Silent Install
Module 3: Creating an OracleTM Database
Planning the Database
Using the DBCA to Create a Database
Password Management
Creating a Database Design Template
Using the DBCA to Delete a Database
Module 4: Managing the OracleTM Database Instance
Start and stop the OracleTM database and components
Use OracleTM Enterprise Manager
Access a database with SQLPlus
Modify database installation parameters
Describe the stages of database startup
Describe database shutdown options
View the alert log
Access dynamic performance views
Module 5: Manage the ASM Instance
Set up initialization parameter files for ASM instance
Start up and shut down ASM instances
Administer ASM disk groups
Module 6: Configuring the OracleTM Network Environment
Use Enterprise Manager to create and configure the       Listener
Enable OracleTM Restart to monitor the listener
Use tnsping to test Oracle Net connectivity
Identify when to use shared servers and when to
      use dedicated servers
Module 7: Managing Database Storage Structures
Storage Structures
How Table Data Is Stored
Anatomy of a Database Block
Space Management in Tablespaces
Tablespaces in the Preconfigured Database
Actions with Tablespaces
OracleTM Managed Files (OMF)
Module 8: Administering User Security
Database User Accounts
Predefined Administrative Accounts
Benefits of Roles
Predefined Roles
Implementing Profiles
Module 9: Managing Data Concurrency
Data Concurrency
Enqueue Mechanism
Resolving Lock Conflicts
Deadlocks
Module 10: Managing Undo Data
Data Manipulation
Transactions and Undo Data
Undo Data Versus Redo Data
Configuring Undo Retention
Module 11: Implementing OracleTM Database Auditing
Describe DBA responsibilities for security
Enable standard database auditing
Specify audit options
Review audit information
Maintain the audit trail
Module 12: Database Maintenance
Manage optimizer statistics
Manage the Automatic Workload Repository       (AWR)
Use the Automatic Database Diagnostic Monitor       (ADDM)
Describe and use the advisory framework
Set alert thresholds
Use server-generated alerts
Use automated tasks
Module 13: Performance Management
Performance Monitoring
Managing Memory Components
Enabling Automatic Memory Management       (AMM)
Automatic Shared Memory Advisor
Using Memory Advisors
Dynamic Performance Statistics
Troubleshooting and Tuning Views
Invalid and Unusable Objects
Module 14: Backup and Recovery Concepts
Part of Your Job
Statement Failure
User Error
Understanding Instance Recovery
Phases of Instance Recovery
Using the MTTR Advisor
Media Failure
Archive Log Files
Module 15: Performing Database Backups
Backup Solutions: Overview
OracleTM Secure Backup
User-Managed Backup
Terminology
Recovery Manager (RMAN)
Configuring Backup Settings
Backing Up the Control File to a Trace File
Monitoring the Flash Recovery Area
Module 16: Performing Database Recovery
Opening a Database
Data Recovery Advisor
Loss of a Control File
Loss of a Redo Log File
Data Recovery Advisor
Data Failures
Listing Data Failures
Data Recovery Advisor Views
Module 17: Moving Data
Describe ways to move data
Create and use directory objects
Use SQL*Loader to move data
Use external tables to move data
General architecture of OracleTM Data Pump
Use Data Pump export and import to move data
Module 18: Working with Support
Use the Enterprise Manager Support Workbench
Work with OracleTM Support
Log service requests (SR)
Manage patches

 

Pre-Requisite

This course straight away dives into DBA concepts and everyday work, hence particiants must have basic database architecture knowledge and experience on SQL basics.

Funding For This Course

Click the course name below to get full details.

OracleTM Database PL/SQL Advanced OracleTM Database SQL/PLSQL Basics For Beginners
Unix Linux Beginners Tutorial


Audience For This Course

Those who are interested to make a career as Oracle DBA, should take the below modules progressively and this will help them be successful on their career path as a DBA.

This course covers everyday job of a DBA, ideal for first timers or individuals who wish to gain insight into this valuable domain. It is 80% hands-on where participants will be configuring the OS and database to achieve everyday tasks of a DBA.

This course prepares the participants to confidently handle database administration and towards the end of the course introduces certain advanced concepts in DBA to prepare the participants for the next level - database clustering (RAC or Dataguard) and performance tuning, which are then taught as seperate courses.

Training Duration

Full-Time : 9.30am to 6.30pm

Part-Time : Weekdays - 10.00am - 1.00pm (or) 2.00pm - 5.00pm

Part-Time : Weekends (Saturday & Sunday) - 10.00am - 1.00pm (or) 2.00pm - 5.00pm

Training Methodology & Materials

  1. 100% hands-on Practical Job Oriented Training
  2. Well designed exercises/sessions
  3. Discussion on real life situations / problems faced on the job and their solutions
  4. Indepth Project work with each course to enhance learning and give the participant a feel of difficulty, thus ensuring they apply in realtime everything they have learnt.
  5. Task based teaching methodology where students are given tasks to do in class, as required in the real world.
  6. Assessments at the end of the course help gauge student progress and learning.

Certificate Of Attendance

Certificate Of Attendance will be awarded to participants completing the course achieving minimum 85% attendance.



View All Testimonials
View Hand-Written Feedback Forms


* Oracle is a registered trademark of Oracle Corporation and it is used here only for listing of the course; we own no rights on the Oracle trademark.