Oracle Admin I Training
ROICIANS
Course Information
| Level | Intermediate |
|---|---|
| Batch Availability | Weekdays, Weekend |
| Mode of Class | Classroom, Online |
| Duration | 39 hours |
Key Features
Hands-on Learning Program
Get trained from working professional
Get trained as per market Trend
work on live projects
Training on all latest tools and skill
Continuous Interview preparation
Complete job assistance (Canada only)
Mock interview session from working QA professionals
Course Overview
- Anyone who wants to switch into IT field
- Anyone with No or minimal IT knowledge
- Anyone who want to gain skills to extract and analyze data from database
- Anyone who wants explore their interest in databases.
- Anyone who wants to extract more than average salary
- Anyone who does not like coding
- Admin- I covers DBA level of commands which includes db creation and security
- One can learn managing and taking backup of databases
- With this one can learn managing database over the network
- With this one can appear for OCA Certification
- Get Trained on Latest Versions in production
As we provide job oriented trainings, our focus is always training on the versions which are being used in market neither obsolete one nor on the version which is not launched in market yet.
- Training from Working Senior DBA’s
Database handling requires lots of expertise, that’s why one must get trained from someone who understands all in and outs of database. Mostly database has run time scenarios which cannot be taught without expertise. We always make sure that we provide best experienced Trainer.
- Certification Preparation
Our training cover all practical and theoretical concepts database. After completing the training, one can easily appear for certification exam.
- Complete Job Assistance
This is job oriented training in which we make sure that you get 100% industry exposure.We prepare student for interviews from day one. Our experts are technical recruiters who evaluate you according to market trends.
Course Curriculum
Installation
- Architecture – Overview
- OS installation
- Oracle Software installation
- Oracle network and database installation
DP Activities
- Table refreshes – multiple possibilities
- Backup Options and best methods – Various scenarios
- Schema restore to same database – multiple possibilities
- Schema refreshes – Scenarios
- Monitoring DP jobs and resolve the issues
- EXCLUDE options and its needs
- Transportable tablespaces activities
Listener activities
- Adding service to listener
- Changing service names at TNS
- Check connection from which service
- configuring password to listener
- IP based access restriction to the database
Activities 1
- Control file backups
- Handling LOCKS, BLOCKS and DEADLOCKS
- Cleaning up sessions in Oracle
- Monitor and analyze a session activity
- Password file issues and management
- SPFILE – Static and Dynamic
- PFILE – Static and Dynamic
- Archivelog mode and Seting FRA
DB rename
- Using NID
- Using Control file
RMAN Activities
- Monitor backup details.
- Methods of backing up database.
- Options in backing up database.
- Optimize backup size.
- Optimize backup time.
- Configure, Administer and Maintain Recovery catalog.
- Block change tracking issues and handling.
- Handling block and datafile corruptions.
- Restoration scenarios
- Recovery scenarios
- Cloning a database – Partial
Cloning activities
- Migrate database from one server to another
- RMAN Duplication from backups NO Target connection
- RMAN Duplication from backups with Target connection
- RMAN Duplication from active database same database
- RMAN Duplication from active database remote database
- Clone ORACLE HOME same server
- RMAN duplication to fresh remote server
- Clone ORACLE HOME different server
Course Schedule
| Start Date | Weekend/ Weekdays | Timing | Location | Action |
|---|---|---|---|---|
| Weekdays, Weekends | 11:00 - 3:00 PM | Brampton, ON | Enroll Now |
Other Courses
Oracle Admin II
Batch Availability: Weekdays, Weekends
Mode of Class: In-Classroom, Online
Duration: 39 hours
Data Guard
Batch Availability: Weekdays, Weekends
Mode of Class: In-Classroom, Online
Duration: 30 hours
RAC
Level: Advance
Batch Availability: Weekdays, Weekends
Mode of Class: In-Classroom, Online
Duration: 39 hours
We can help you
Just call at +1-(289)-499-4040 for more details