Oracle Database Administration for Absolute Beginners
4.3 (475 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.
4,375 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Oracle Database Administration for Absolute Beginners to your Wishlist.

Add to Wishlist

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.3 (475 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.
4,375 students enrolled
Created by Sam Dhanasekaran
Last updated 2/2016
English
Current price: $10 Original price: $125 Discount: 92% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 14 hours on-demand video
  • 9 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I 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)
View Curriculum
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.
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 :-(

Who 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.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
142 Lectures
13:54:00
+
Introduction to Database
1 Lecture 04:04

This lecture explains about Databases

Preview 04:04
+
Introduction to Database Objects
2 Lectures 13:54

This lecture explains about TABLES in a Database.

Preview 06:32

Explains more about a TABLE in a Database

Preview 07:22
+
Database Languages
4 Lectures 18:02

Explains about Data Definition Language or DDL

Preview 04:29

A quick recap of Data Definition Language

Data Definition Language - Recap
02:09

Explains about Data Manipulation Language

Data Manipulation Language
08:56

Explains about Data Control Language

Data Control Language
02:28
+
Database Objects - Index and View
2 Lectures 13:45

Explains about index.

What is an index?
09:39

Explains about the Views in a Database

What is a View?
04:06
+
Relational DBMS (RDBMS) - Introduction
5 Lectures 21:25

Explains about Foreign Keys

What is a Foreign Key?
06:26

Explains about RDBMS

What is a RDBMS?
04:44

Explains about Primary Keys

What is a Primary Key?
04:09

Explains about Unique Keys.

What is an Unique Key?
03:33

Compares the Primary Keys with the Unique Keys.

What is the difference between Primary Key and Unique Key?
02:33
+
Computers and Databases
3 Lectures 09:22

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

Computers and Databases
04:48

Availability of data to multiple concurrent users is Data Concurrency.

What is Data Concurrency?
01:49

This lecture explains about Data Consistency.

What is Data Consistency?
02:45
+
Installing Oracle 12c in Windows 10
4 Lectures 29:59

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.

Download and Install Oracle 12c in a Windows PC or Laptop
12:11

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

Preview 12:11

Using Oracle SQL Developer to connect to the Oracle Database.

Using Oracle SQL Developer
02:11

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

Troubleshooting Connection Issues
03:26
+
Concepts Illustrated
9 Lectures 44:44

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


Preview 06:58

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

Installation
02:36

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

Files
01:28

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

Starting a Database
02:46

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

Basics of Computing
05:32

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.

Client Server Architecture
08:45

This lecture illustrates the Program Global Area of an Oracle Database

PGA - Program Global Area
05:22

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

Dedicated Server Mode
01:51

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

Shared Server Mode
09:26
+
Oracle Storage Structures
7 Lectures 29:04
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
+
Oracle Parameter Files
3 Lectures 08:56
What is a Parameter file?
02:15

What is a SPFILE?
03:16

What is a PFILE?
03:25
18 More Sections
About the Instructor
Sam Dhanasekaran
4.4 Average rating
610 Reviews
5,644 Students
5 Courses
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.