Oracle Admin II 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
Candidate must have working knowledge of SQL & ADMIN I.
- 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
- If you want to learn complete DBA Activities this course is must
- One can appear for OCP certification with this course
- Every sector of industry is using database for storage, so job scope is very broad
- It does not require any prior expertise.
- Database Administrator is highest paid job in IT Sector
- Database is the most consistent domain, no frequent changes
- We Train on all the Latest Tools which are required in Market.
We consistently update our Course Curriculum according to Latest Market Demand and Train on all Latest/add on tools.
- Training on Live Projects.
We make you to work as and with working experts so that you gain real working exposure and eventually you can speak in interview with confidence as you will be saying what you actually did.
- Free Interview and communication skills session
We prepare our students for Interviews from day one. On every topic you covered, you will be interviewed by our recruiters on it and complete guidance will be provided by them.
- Complete Job Assistance
You got our back for everything you need for job Assistance from resume building to marketing your profile and eventually facing interviews, we will provide 100% assistance.
- Mock Interview sessions from working professionals
Working Professionals will conduct your interviews to make sure that you are ready for market. They will provide their constructive Feedback to you.
- Dedicated Training Plan for every Student
We believe all students are different and they need individual plan according to their Strengths and weaknesses.
So our team gives individual attention to everyone.
Course Curriculum
Tablespace management
- Check tablespace utilizations
- Understand AUTOEXTEND option
- Understand difference between SMALLFILE AND BIGFILE datafile
- Moving datafile to different mount point
- Check and action on TEMP tablespace
- TEMP datafile errors
- OMF/ NON OMF datafiles
- Check UNDO utilization and appropriate actions
- Create and insert huge data into table and delete all rows.
- Datafile fragmentation and defragmentation methods
- ORA 01555 error on UNDO and reasons
User Management
- Check user default tablespace
- Give Quota to different TBS
- Check profiles
- Check SYSTEM/ROLE/TABLE privileges
- Password management of a user
- User privileges on TBS
Patching Activities
- Introduction to Patches
- Apply bug fixes to database
- Apply CPU/PSU patch to the database
- Apply PSU patch
Performance tuning Activities
- Generate explain plan and analyze
- Explain plan with index
- Explain plan with data deletion
- Explain plan and statistics
- Options in DBMS_STATS.GATHER_table_stats
- Schema stats and does it make any difference
- Rebuilding indexes
- Gathering Index stats
- Generate AWR report and analyze
- Generate ADDM report and analyze
- Generate ASH report and analyze
- Run SQL tuning advisor and analyze
Flashback activities
- Flashback query
- Flashback to original table
- Flashback to new table
- Flashback database
- Flashback database to restore point
Tablespace point in time recovery
- TBSPITR to same existing database
- RMAN Duplication for PITR of a tablespace
- To AUXIL instance
Triggers
- Create startup trigger
- Create shutdown trigger
- Create logon trigger
- Create trigger on oracle error
Log miner
- Configure dictionary file
- Add archivelog file to log miner
- Start logminer, Analyse and stop log miner
Activities 2
- Oracle database DB Links
- Configure
- Usage
- SQL Loader
- Create control file
- Data in text file
- Load data to table
- Enable compression on table
- Table partitioning
- Use External table
- use of V$resource_limit
Scheduling jobs
- Create program
- Run RMAN script via DBMS_SCHEDULER
- Create JOB
- Create job to run a procedure
- drop a job, program
AUDITING
- Concepts
- Fine grain auditing
- Standard auditing
- Select table
Silent Installation
- Deinstall oracle DB, Oracle SW
- Detach oracle home from inventory
- Silent installation of Software
- Silent installation of Network/Listener
- Silent installation of database
Scripting
- COPY tables in SQLPLUS
- Scripting and CRONTAB
- RMAN backup example
- Gathering stats example
- Housekeeping example
Upgradations
- Upgrade database from 11.1.0.6 to 11.2.0.3
- Upgrade database from 10.2.0.1 to 10.2.0.4
- Upgrade database from 10.2.0.4 to 11.1.0.6
- Upgrade database from 11.1.0.6 to 11.2.0.1
- Upgrade database from 11.2.0.1 to 11.2.0.3
DBA daily activities summary
Course Schedule
| Start Date | Weekend/ Weekdays | Timing | Location | Action |
|---|---|---|---|---|
| Weekdays, Weekends | 11:00 - 3:00 PM | Brampton, ON | Enroll Now |
Other Courses
Oracle Admin I
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