Oracle Database Administration for Absolute Beginners

Learn to become an Oracle Database Administrator in a month. It is one of the stable and 'high in demand' IT jobs.

4.25 (1235 reviews)

Udemy

platform

English

language

Oracle

What you will learn

Common Goal: To get a job as an Oracle Database Administrator (Oracle DBA)

For New Graduates: To get a job as an Oracle Database Administrator (Oracle DBA)

For College Students: To understand the basics of Database and RDBMS concepts

For those with some IT experience: To get into Oracle Database Administration (Oracle DBA)

For Information Technology Managers: To understand the basics of RDBMS so that they efficiently manage a DBA team

For others: To understand the Database and RDBMS concepts

To understand the fundamentals of Oracle Database (including Oracle 12c and Oracle 11g)

Why take this course?

(Update on 18-Nov-2015 : Added additional lectures to keep this course updated with Oracle 12c Release 2. Also, if you just want to start with some basic theory before doing any hands-on lessons in here, please checkout the Section 'Concepts Illustrated' first.)

'Oracle Database Administration for Absolute Beginners' course explains about the basic concepts of Relational Database Management Systems (RDBMS). It will help you to become an Oracle Database Administrator(Oracle DBA).

Database Administrator is one of the highly sought after jobs in the IT industry. It is also one of the highly stable jobs as DATA is a vital part of every organization and they need that to be in the capable hands of a good DBA team.

This course is absolutely for beginners. This is applicable for those who would want to learn Oracle Database 12c as well as Oracle Database 11g.

This would be ideal for..

those who are already in IT and would like to jump into the world of Database Administration.
college students who would like to learn about Database concepts so that they can achieve high grades in their RDBMS related curriculum.
college students who would like to get into Oracle Database Administration as soon as they finish their college.
fresh graduates who are looking for a job in the IT industry.
anyone with the determination of getting into IT in order to have a better career.

This course is mainly based on video lectures. However it also has theoretical sections for reference and LAB exercises for hands-on practice.

The course has been structured to start with videos explaining basic database concepts. They provide simplified real world examples.

Then it introduces Oracle Database Architecture. After that, it provides 'hands-on' video lectures about 'How to install Oracle Database 11g in your desktop or Laptop'. (In the bottom, there is also a section about 'How to install Oracle Database 12c' which is the newest version from Oracle as of now, which is Aug 2013).

It then explains about various Oracle Internals such as Storage Structures, Memory Structures, Database Objects etc.

Then it goes into operational aspects such as creating USERS, granting access, creating objects such as tables etc.

After that it explains about Backup/Recovery concepts and Dianostic Data.

Finally, there is a section of extensive video lectures about LAB sessions with examples. You can use those for hands-on practice, using the Database software that you would have installed (as explained in this course) in your PC/Laptop.

I would like to thank you sincerely for reading this and wishing you all the best..!

Sam Dhanasekaran
p.s: This started as YouTube video series. I experimented having my own background music initially. Later I removed the music, based on user feedback. So pardon the background music please :-(

Screenshots

Oracle Database Administration for Absolute Beginners - Screenshot_01

Oracle Database Administration for Absolute Beginners - Screenshot_02

Oracle Database Administration for Absolute Beginners - Screenshot_03

Oracle Database Administration for Absolute Beginners - Screenshot_04

Reviews

Owen

May 7, 2022

This course greatly assisted me in understanding the basic concept. Truly appreciate the explanation and illustrations.

Tuba

February 28, 2022

Please provide the ppt, every time one can't see the lectures to revise or to repeat when not understood.

Ankit

January 25, 2022

Thank you for giving a details informative Video, I dont have any coding background but its very interesting

Pankti

September 28, 2021

GOOD FOR BASIC KNOWLADGE BUT SOME TIME IT GET CONFUSING WHILE PRACTICE. IT TAKE REPEATED LEARNING FOR MORE CLEARITY.

Desh

December 24, 2018

This course is just an outer line definition on each topics, no details of any topic. No real problems or practical. Unbelievable !!!

Teidra

November 23, 2018

Just started the course. Sam does a really great job of breaking down the course with simple concepts and visuals.

William

April 17, 2018

these video do well inform you of the basic structure, i only wish he wouldn't about thing he isnt going to explain in that video... remember when you are learning from the ground up this is all about understanding and definition.... now i have a name of a definition, which is "Null" lol, until he gives me his definition so as i am writing i have to leave unknown amount of spaces for the definition... other than that, this video is structured very well for someone with now experience...

Andrew

March 13, 2018

Amazing instructor. He is very thorough and explains in good detail in ways that make sense and lessons are built on each other in an order that follows each other.

Anthony

February 20, 2018

The course provides a breakdown of an oracle enterprise single instance installations and explains how the software interacts with the OS and database files. The arrangement of the topics could be better and the videos are unnecessarily long as the same thing is repeated over and over again (mostly due to the instructor's limited English vocabulary)

Asulema

January 24, 2018

The instructor / teacher is very knowledgeable, and his method of teaching is easy to follow. I very much appreciate his sense of humor. I have see his videos on YouTube , this is where I came to listen to his courses which I find very good. Thank you.

Oluokun

January 23, 2018

Very detailed lecture on oracle architecture, absolutely for beginner, The lecturer did justice to the course and i recommend for everyone that wish to learn internal operation of oracle database.

Milkesa

January 2, 2018

I hate to comment negative things but since I paid my money for this course, I have to point out some things. I hate the music at the beginning of every videos. It makes me not to continue to watch the videos. He tells you that his name is Sam Dhanasekaran in every video. Too slow to explain the topics. He tells you that he will be talking about this and that later but he will not explain anything later.

Summer

December 6, 2017

it's going over something that is so basic, freshmen in high school should know. It's extremely slow and boring. if you know anything about excel you will sleep through this course.

Zainab

November 17, 2017

The course is comprehensive and explains the basics in details and in simplified way. Thanks for the instructor.

Tamuka

November 10, 2017

The instructor uses good examples to make you understand, I really like the way he explained "index".

Charts

Price

Rating

Enrollment distribution

Oracle Database Administration for Absolute Beginners - Distribution chart