UrbanPro
true

Best Oracle DBA OCA Course

LIVE
70 Hours

Course offered by Vss Sasidhar

40 reviews

Course Content:

Course Description: This course is targeted at novice to the technology. This course is intended to provide Oracle training with real time project.


Fundamental -I 

DAY - 1 Essential Unix and Linux from DBA perspective 

DAY â?? 2-4 Oracle Architecture

DAY â?? 5-6 Installing Oracle Software/ DB creation /Startup Shutdown modes

Installing the Oracle Database Software Plan an Oracle installation Install software with the Oracle Universal Installer (OUI) Creating an Oracle Database Create a database with the Database Configuration Assistant (DBCA) Create a database manually Managing the Oracle Instance Start and stop the Oracle database and components Access a database with SQL*Plus and iSQL*Plus Modify database initialization parameters Understand the stages of database startup View the Alert log Use the Data Dictionary


DAY â?? 7 Connectivity and Networking and Using SQL * PLUS

Oracle Networking and Database Connectivity Networking Concepts : How Oracle Networking works Establishing Oracle Connectivity Listener Configuration TNS Configuration Troubleshooting Starting a SQL *Plus Session Exiting SQL *Plus SQL * PLUS and SQL Commands iSQL *Plus 

DAY - 8 Managing Database Storage Structures

Define the purpose of tablespaces and data files Understand and utilize Oracle Managed Files (OMF) Create and manage tablespaces Obtain tablespace information Describe the main concepts and functionality of Automatic Storage Management 

DAY â?? 9-10 Schema Management

Types of SQL Statement Oracle Schemas Oracle tables Oracle Indexes Constraints Using Views Using Materialized Views Using Synonyms Using Sequences Using Triggers Viewing Object Information DAY â?? 11-12 User Management and Database Security

Create and manage database user accounts Authenticate users Assign default storage areas (tablespaces) Grant and revoke privileges Create and manage roles Create and manage profiles Implement standard password security features Control resource usage by users Enable standard database auditing Specify audit options, Review audit information Maintain the audit trail.


Fundamental -II:

DAY â?? 13-14 Loading and Transforming Data-

Describe available ways for moving data Use SQL*Loader to load data from a non-Oracle database (or user files) Using External tables to load data. Transforming Data


DAY â?? 15-18 Using Data pump Export and import-

Introduction to the Data pump technology Performing Data pump export Performing Data pump import Monitoring Data pump job Transportable tablespace How to take export into ASM diskgroup How to do ftp dumpfile from ASM diskgroup. How to refresh environment from other enviornment. DAY â?? 19-22 Backing UP database Configuring Recovery Manager Recovery Manager Features and Components Using a Flash Recovery Area with RMAN Configuring RMAN,Control File Autobackups Retention Policies and Channel Allocation Using Recovery Manager to connect to a target database in default NOCATALOG Displaying the current RMAN configuration settings Altering the backup retention policy for a database 

DAY â?? 22-24 Using Recovery Manager RMAN Command Overview Parallelization of Backup Sets Compressed Backups Image Copy Whole Database and Incremental Backups LIST and REPORT commands Enable ARCHIVELOG mode for the database Use Recovery Manager User Managed Backups Database Corruption Detection.


DAY -24-25 Database Recovery-

Performing Recovery with RMAN Cloning a database Recover from loss of a control file Recover from loss of a redo log file Perform complete recovery following the loss of a data file Recover tablespace Repairing database corruption 

DAY â?? 25-26 Managing and Monitoring the Operational Database

Generate AWR reports Generate ADDM report Generate ASH reports Managing Database links Using the Oracle Schduler 

DAY â?? 27-28 Improving Database Performance - SQL Query Optimization

Writing Efficient SQL SQL Performance tuning tools Using Explain plan SQL tuning Advisor 

DAY â?? 28-30 Performance Tuning : Tuning the Instance

Tuning oracle Memory PGA Management Troubleshooting and Tuning Views High Lights

- Trainer is a Real Time Oracle Certified working professional.

- Focus on Hands-on sessions.

- 100% satisfactory job oriented real time training

- Real-time projects.

Gallery (1)

About the Trainer

Nanjesh picture

4.9 Avg Rating

40 Reviews

80 Students

21 Courses

Vss Sasidhar

IT

6 Years of Experience

Trainer Has 8+ years of experience in IT
Trained 4000+ professionals in DEVOPS
Covering Practically all classes
Realtime project
Mock interviews

Students also enrolled in these courses

LIVE
2 Hours

Course offered by Ni Analytics India

10 reviews
LIVE
1 review

Course offered by Real time trainers

28 reviews
LIVE
2 Hours

Course offered by Mr. Jyoti Ranjan Mishra

0 review

Tutor has not setup batch timings yet. Book a Demo to talk to the Tutor.

Different batches available for this Course

No Reviews yet!

Reply to 's review

Enter your reply*

1500/1500

Please enter your reply

Your reply should contain a minimum of 10 characters

Your reply has been successfully submitted.

Certified

The Certified badge indicates that the Tutor has received good amount of positive feedback from Students.

Different batches available for this Course

tickYou have successfully registered

Best Oracle DBA OCA Course by Vss Sasidhar

Nanjesh picture
LIVE

Class
starts in

01

Hour

01

Min

01

Sec

Select One

Register Now

Do you want to Register for this Free class?

Yes, Register No, not right now

Tell us a little more about yourself

Best Oracle DBA OCA Course by Vss Sasidhar

Nanjesh picture
LIVE

Class
starts in

01

Hour

01

Min

01

Sec

Please enter Student name

Please enter your email address.

Please enter phone number.

Verify Your Mobile Number

Please verify your Mobile Number to book this free class.

Update

Please enter 10 digit phone number.

Please enter your phone number.

Please Enter a valid Mobile Number

This number is already in use.

Resend

Please enter OTP.

Or, give a missed call and get your number verified

080-66-0844-42

This website uses cookies

We use cookies to improve user experience. Choose what cookies you allow us to use. You can read more about our Cookie Policy in our Privacy Policy

Accept All
Decline All

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 55 lakh students rely on UrbanPro.com, to fulfill their learning requirements across 1,000+ categories. Using UrbanPro.com, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 7.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on UrbanPro.com. Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more