Signup as a Tutor

As a tutor you can connect with more than a million students and grow your network.

Oracle Database Administration (Oracle DBA)

No Reviews Yet

Jamia Nagar, Delhi

Course ID: 42563

Jamia Nagar, Delhi

Students Interested 0 (Seats Left 0)

No Reviews Yet

About the Course

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

Date and Time

Not decided yet.

About the Trainer

Md Sajjad picture

Avg Rating

0 Reviews

0 Students

1 Courses

Md Sajjad

MCA, B.Sc. (Electronics), PGDCA

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

No reviews currently Be the First to Review

Discussions

Students Interested 0 (Seats Left 0)

Post your requirement and let us connect you with best possible matches for Database Training classes Post your requirement now

Enquire

Submit your enquiry for Oracle Database Administration (Oracle DBA)

Please enter valid question or comment

Please enter your name.

Please enter valid Phone Number

Please enter the Pin Code.

Please check the fields again.

By submitting, you agree to our Terms of use and Privacy Policy

Connect With Md

You have reached a limit!

We only allow 20 Tutor contacts under a category. Please send us an email at support@urbanpro.com for contacting more Tutors.

You Already have an UrbanPro Account

Please Login to continue

Please Enter valid Email or Phone Number

Please Enter your Password

Please enter the OTP sent to your registered mobile number.

Please Enter valid Password or OTP

Forgot Password? Resend OTP OTP Sent

Sorry, we were not able to find a user with that username and password.

We have sent you an OTP to your register email address and registered number. Please enter OTP as Password to continue

Further Information Received

Thank you for providing more information about your requirement. You will hear back soon from the trainer

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 25 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 6.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