Oracle DBA Instructor-led Training
Free server access, Class recordings, Certification guidance, Job & Interview assistance, Course Completion Certificate
Uplatz
Summary
- Uplatz Certificate of Completion - Free
- Tutor is available to students
Add to basket or enquire
Overview
Course Description
Oracle Database administration course program will let the participants gain complete proficiency to access the database solution.
The Oracle database administration online course is ideally developed for network administrators and database users who can have single oracle database administrator for various functional uses.
In the Oracle database administration course, Uplatz provides an in-depth training for the participants or learners to make them understand the experience of developing core skills to gear up with oracle database solution and services.
The Oracle database technology is useful in transforming the way of handling, managing and storing data.
With the help of Oracle database administration online course, the learners can:
Handled by a group of expert specialists
Able to work on grid-based architecture
Suitable for enterprise grid computing
Uplatz provides an in-depth training to the learners to accelerate their knowledge and skill set required for Database administrator job.
---------------------------------------------------------------
Course Objective
The Oracle database administrator training is intended for the individuals who seek to implement their knowledge, skills and expand their career as database administrator. The dedicated mentors make sure the learners to cover all topics under Oracle database administration curriculum which will be useful for their career growth. Uplatz offers Oracle database administration training to become a skilled database administrator job.
---------------------------------------------------------------
Target audience
The Oracle Database administrator course is intended for the below mentioned target audience, still if you are a newbie and want to make a career as a database administrator, then the Oracle database administrator course is the best option you can choose.
Security officers
Network administrators
Application Developers
Application administrators
Database users
Course media
Resources
- Oracle DBA tutor led live Course Syllabus - download
Description
Introduction to Linux
- History of Linux
- Components of Linux
- Linux Basic Commands
- File permission to users
Introduction to DBMS
- What is a database?
- History of Oracle database
- Role of a Database Administrator
Basic SQL
- What are DML, DDL and DCL Statement
- Examples on DML, DDL and DCL
- Creation of Table, Views, Sequence, Synonyms & Index
Oracle Database Architecture
- Detail explanation on components of an Oracle database architecture
- Oracle database memory and process architecture
Installing Oracle database software (11g R2)
- Pre-requisites for a successful Oracle software installation
- Installation of oracle software using GUI and Manual Method
- Installation of Oracle 11g R2 database software
Oracle Database Creation
- Introduction
- Planning for an Oracle database creation
- Creating an Oracle database using the MANUAL method
- Creating an Oracle database using the GUI Tool (DBCA)
- Startup and Shutdown Methods
- Best practices using OFA for database creation
Database Storage Management
- Introduction
- Tablespaces creation methods
- Datafiles creation methods
- How to resize/rename the tablespace/datafiles
- How to Change the location of datafiles
- Redolog file architecture and best practices
- How to resize/rename the redolog file
- Benefits of Archiving, how to enable/disable Archivelog mode for a database
- Temporary tablespaces and temporary tablespace groups
Oracle Networking
- Oracle listener & TNS configuration using NETMGR
- Managing & Distributing by using DB-link concept
- Oracle database connections from other systems
- Oracle Shared server Dispatcher & Architecture
User Administration and Security
- Create database users
- Database resource management (User’s Profile and Role)
- Locking/unlocking a user account
- User’s password management
User Managed Backup and Recovery
- Introduction: Backup and Recovery Strategy for user managed backup
- How to backup an Oracle database using COLD BACKUP
- How to backup an Oracle database using HOT BACKUP
- Recovery scenarios using User managed backup
RMAN Backup and Recovery
- RMAN backup of Database, controlfile,Archivelogfiles
- Database backup using RMAN with normal and compressed mode
- Database backup using catalog and no-catalog and virtual catalog
- Querying the backup details using Catalog database
- Benefits of Fast Recovery Area using RMAN backup for storage
- How to backup incremental database
- Recovery scenarios using RMAN
- Tablespace Point in time recovery (TSPITR)
Oracle Datapump {Logical backup & Restore}
- Introduction on Datapump(Expdp,Impdp) Utilities
- Benefits of Logical backup & Physical backup
- Exporting/Importing Tables, Schema Tablespace
- database and Transportable tablespace
- Backup methods using datapump
Flashback Feature
- Types of flashback and their benefits
- Flashback Query, Flashback Table to past time
- Flash back of Recovering Drop tables
- Flashback Archive
Oracle Enterprise Manager (grid Control)
- Introduction
- How to install and configure
- Monitor databases and performance of the databases
Cloning
- Cloning database using RMAN from Active Database
- Cloning database using same datafile storage locations and different datafile
- storage locations
Logminer and SQL Loader
- Reading/Extracting the content of Redologs (Online/Archived)
Oracle Dbase Patching/Patch Management
- Downloading/Applying Interim & Patchset patches using Opatch
- Applying cpu and psu patches
- Oracle DBase Upgradation and Migration
- Upgrating database from 11g to 12c version
Oracle Data Guard
- Oracle Dataguard Architecture
- Creation of physical standby database using RMAN and Manual Method
- How to configure Active standby database and snapshot standby database
- Data guard Modes and Switchover/Failover
- Scenarios on restore and recovery
Who is this course for?
Everyone
Requirements
None
Career path
Oracle Database administrator
Database administrator
Questions and answers
Currently there are no Q&As for this course. Be the first to ask a question.
Certificates
Uplatz Certificate of Completion
Digital certificate - Included
Course Completion Certificate by Uplatz
Reviews
Currently there are no reviews for this course. Be the first to leave a review.
Legal information
This course is advertised on reed.co.uk by the Course Provider, whose terms and conditions apply. Purchases are made directly from the Course Provider, and as such, content and materials are supplied by the Course Provider directly. Reed is acting as agent and not reseller in relation to this course. Reed's only responsibility is to facilitate your payment for the course. It is your responsibility to review and agree to the Course Provider's terms and conditions and satisfy yourself as to the suitability of the course you intend to purchase. Reed will not have any responsibility for the content of the course and/or associated materials.