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.0 (242 ratings) Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
3,156 students enrolled
$125
Take This Course
  • Lectures 142
  • Contents Video: 14 hours
  • Skill Level Beginner Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 4/2013 English

Course Description

(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 :-(

What are the requirements?

  • Basic understanding of Technology Concepts
  • Just a determination to learn about Database and RDBMS concepts
  • (Optional) A PC/Laptop that meets the requirements to install Oracle Database Software as specified in Oracle's download page. This is for those who would like to do hands-on practice.

What am I going to get from this course?

  • 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)

What is the target audience?

  • 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.
  • IT Organizations to have their Developers learn about Database fundamentals so that they can write better codes.

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Introduction to Database
04:04

This lecture explains about Databases

Section 2: Introduction to Database Objects
06:32

This lecture explains about TABLES in a Database.

07:22

Explains more about a TABLE in a Database

Section 3: Database Languages
04:29

Explains about Data Definition Language or DDL

02:09

A quick recap of Data Definition Language

08:56

Explains about Data Manipulation Language

02:28

Explains about Data Control Language

Section 4: Database Objects - Index and View
09:39

Explains about index.

04:06

Explains about the Views in a Database

Section 5: Relational DBMS (RDBMS) - Introduction
06:26

Explains about Foreign Keys

04:44

Explains about RDBMS

04:09

Explains about Primary Keys

03:33

Explains about Unique Keys.

02:33

Compares the Primary Keys with the Unique Keys.

Section 6: Computers and Databases
04:48

Explains about the role of computers in the world of databases.

01:49

Availability of data to multiple concurrent users is Data Concurrency.

02:45

This lecture explains about Data Consistency.

Section 7: Installing Oracle 12c in Windows 10
12:11

Download and Install Oracle 12c in a Windows PC. We do not use Multitenant mode to keep things simple and easy for beginner to understand. If you want, you may follow the next video to install Oracle in Multitenant mode.

12:11

This lecture is optional - It explains about downloading Oracle Software from Oracle's website and installing it in Multitenant mode.

02:11

Using Oracle SQL Developer to connect to the Oracle Database.

03:26

If you are unable to connect to the database, use this lecture for troubleshooting.

Section 8: Concepts Illustrated
06:58

The students will be able to understand the difference between an Oracle Instance and Database.


02:36

This lecture explains about the basic concept of Oracle Database installation.

01:28

This lecture explains about the file structure of an Oracle Database, as seen by the Operating System

02:46

In this lecture, the students will learn about the different stages involved during the startup of an Oracle Database.

05:32

This lecture explains about shared memory and inter-process communication mechanism used by Operating Systems.

08:45

The students will be able to understand the Client Server Architecture implementation of an Oracle Database. This also explains about the shared memory usage by the oracle processes.

05:22

This lecture illustrates the Program Global Area of an Oracle Database

01:51

This lecture explains about the running the database in Dedicated Server Mode.

09:26

This lecture explains about running the database in Shared Server Mode.

Section 9: Oracle Storage Structures
Oracle Physical Storage Structures
04:54
Oracle Logical Data Structures
02:26
Where can the Oracle Physical Structure files be stored?
03:59
What is a Raw Device?
04:40
What is a File System?
04:23
What is an Oracle ASM?
03:35
What is a Cluster File System?
05:07
Section 10: Oracle Parameter Files
What is a Parameter file?
02:15
What is a SPFILE?
03:16
What is a PFILE?
03:25
Section 11: Connecting to an Oracle Database
How to connect to a Oracle Database?
12:36
How does an Oracle database start?
12:38
Demo of various starting methods of an Oracle database
22:21
How to log in to an Oracle Database?
04:19
Oracle Database Dictionary
08:12
How to log in to an Oracle Database? - Answer Video
04:25
Section 12: Basics of Oracle Database Internals and Security
Basics of Oracle Internal Structure
10:25
What is a Database Control?
09:23
How to create an user in Oracle Database?
07:51
Default Tablespace and Temporary Tablespace for a new Oracle Database user
05:37
Oracle Roles and Privileges
07:35
Oracle System Privileges
06:59
Section 13: Basic Oracle Database Operations
How to verify the Oracle Database Name?
04:33
How to find the version of the Oracle Database?
02:53
04:02

To see all the users:

select * from dba_users;

To a particular user (for example, SCOTT):

select * from dba_users where username='SCOTT';

How to use DBA view in SQL Developer?
02:56
How to find the tablespaces in an Oracle Database?
05:09
Oracle Tablespaces
07:55
What is an Oracle User?
06:55
What is an Oracle Schema?
10:47
Difference between an Oracle user and schema
04:44
General user architecture of a database
05:51
Section 14: Structured Query Language (SQL)
SQL Structured Query Language
01:19
SQL CTAS method
05:15
SQL SELECT Statement
06:27
SQL INSERT Statement
04:31
SQL DELETE Statement
02:02
SQL UPDATE Statement
02:51
Section 15: Oracle Memory and Background Processes
Oracle Background Processes
13:45
Dedicated Server vs Shared Server
10:06
SGA System Global Area of an Oracle Database
08:00
PGA Program Global Area of an Oracle Database
02:34
UGA User Global Area of an Oracle Database
04:01
Section 16: SGA and Database Buffer
SGA Database Buffer Part 1
09:05
SGA Database Buffer Part 2
08:09
SGA Database Buffer Part 3
04:37
SGA Database Buffer Part 4
12:59
SGA Database Buffer Part 5
10:50
SGA Database Buffer Part 6
05:14
SGA Database Buffer Part 7
14:54
SGA Database Buffer Part 8
05:40
SGA Database Buffer Part 9
04:57
SGA Database Buffer Part 10
03:17
SGA Database Buffer Part 11
08:36

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Sam Dhanasekaran, Experienced IT Support and Database Specialist

Around 20 years of IT and Database Support experience.


* Expert in Systems Administration, Database Administration, Systems Integration, IT Operations Mgmt, Business Management, IT Consulting and Business Development.

* Hobbies include Social Networking, Music Composition, Reading and Writing.

Specialties:IT Support, Client Support, Client Management, Database Support. Infrastructure Management, Project Management, Business Development, IT Solutions Management, Team Management and Customer Care.

Ready to start learning?
Take This Course