UrbanPro
true

Oracle Database Administration (Oracle DBA)

LIVE
1 review
Ongoing

Course offered by Md Sajjad

1 review

Target Audience:

  • Database Administrators who want to have real time administration training.
  • IT professionals who want to make their career in Oracle Database Admiration
  • Oracle Developers who want to make their career in Database Administration
  • Fresh Graduates who want to make their career in Database Administration.
  • IT Developers who want to have good understanding of Database as it is the backbone of any GUI application design and development.
  • Job seekers who are facing interviews. Around 40% of the interview questions are based on database understanding.

Pre-Requisites:

  • Basic Knowledge of Basic Oracle Database & SQL/PLSQL
  • Basic Knowledge of Windows/Linux

Course Duration: 3 Months

Course: Fee Rs.5000 (Discount Group)

Class Type: Class Room /Online Training

1. Introduction

  • An Overview to Oracle Database
  • Major Databases and Database Vendors
  • Oracle Database Editions
  • Understanding Database Release Version Numbers
  • Types of DBA based on Roles and Responsibilities
  • DBA Levels based on Roles and Responsibilities

2. Oracle Server Installation On Windows/Linux 

  • Understanding OFA (Optimal Flexible Architecture)
  • Pre-Requisites
  • Downloading Oracle Server
  • Installation Step by Step
  • Understanding Various Installation Types
  • Post installation Settings
  • Initialization Parameter setting
  • Oracle profile setting
  • Password policy setting
  • Deferred segment setting
  • Environment Variable Setting
  • Oracle Listener Creation using NETCA
  • Dropping and Re-Creating Oracle LISTENER
  • Demo user creation roles and privileges

3. Oracle Client Installation

  • Downloading Oracle Client Software
  • Understanding various Installation Types
  • Installation Step by Step
  • Post installation Settings
  • Environment Variable Setting
  • Creating Oracle Net Service Names using NETCA
  • Client Server Environment setup involved issues demonstration
  • Oracle Listener Error Real time Scenarios and resolution
  • Demo user creation

4. Oracle Database Creation methods

  • Using DBCA
  • Manual Creation
  • Catlog.sql and Catproc to Create/Recreate Database Internal Views/Procedures/Packages

5. Parameters & Parameter Files

  • Parameter Files Introduction
  • Difference between PFILE & SPFILE
  • Changing Parameter values
  • Getting the Currently used parameter file Type
  • Getting Parameter Settings
  • Creating PFILE from SPFILE
  • Creating SPFILE from PFILE
  • When to force Database to start with PFILE
  • Changing Values of SPFILE
  • Starting Database with PFILE
  • Starting database SPFILE
  • Parameter File Backup & Recovery.
  • 6. Starting & Stopping Database
  • Database Startup Methods
  • Database Startup Stages
  • Database Shutdown Methods
  • Database Shutdown Stages
  • Real time Troubleshoot with Database Shutdown & Startup Failure and Errors

7. Introduction to Oracle Database Objects

  • Tables
  • Indexes
  • Views
  • Materialized Views
  • Synonyms
  • Sequences
  • Procedures
  • Functions
  • Package (Body & Specs)
  • Triggers

About the Trainer

Md Sajjad picture

4 Avg Rating

1 Reviews

1 Students

2 Courses

Md Sajjad

MCA, B.Sc. (Electronics), PGDCA

14 Years of Experience

Currently working as Manager-Database Administration in a reputed CMM level 5 Company having Over 14 Years of Industry Experience in Oracle Database Administration and PLSQL Programming, Data Modeling, Performance Tuning, Database Backup and Recovery and Database Architecture.
Other area of expertise in RDMS:
1. MYSQL,
2. SQL Server and
3. ETL Tool like Pentaho and Golden Gate and Logi Analytics for Dashboard Analysis

Reviews (1)

4 out of 5 1 review

Md Sajjad https://p.urbanpro.com/tv-prod/member/photo/4468047-small.jpg Jamia Nagar
4.0051
Md Sajjad
S

Oracle Database Administration (Oracle DBA)

"Excellent Training skill. Friendly and more practical based teaching. Teaching method is scenario based and getting production like environment. "

View All
Have you attended any class with Md?

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

Different batches available for this Course

4 out of 5 1 review

Md Sajjad https://p.urbanpro.com/tv-prod/member/photo/4468047-small.jpg Jamia Nagar
4.0051
Md Sajjad
S

Oracle Database Administration (Oracle DBA)

"Excellent Training skill. Friendly and more practical based teaching. Teaching method is scenario based and getting production like environment. "

Have you attended any class with Md?

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

Oracle Database Administration (Oracle DBA) by Md Sajjad

Md Sajjad picture
LIVE
(1 reviews)

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

Oracle Database Administration (Oracle DBA) by Md Sajjad

Md Sajjad picture
LIVE
(1 reviews)

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