Become an Oracle DBA from scratch in a flash

Learn to be able to quickly manage the daily basic operation of a live production oracle database
3.8 (9 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.
87 students enrolled
Instructed by Dexter Kwan IT & Software / Other
25% off
Take This Course
  • Lectures 21
  • Length 39 mins
  • Skill Level All Levels
  • 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


Find online courses made by experts from around the world.


Take your courses with you and learn anywhere, anytime.


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

About This Course

Published 12/2014 English

Course Description

This course will give you a basic understanding of the fundamentals of database administration and will concentrate on the "administration" part, and will give you a solid understanding of the database internals which will put you in the right path to being a successful database administrator. And I will immediately dive into the hands-on part after every lecture.

I will primarily use oracle's 11g version but the concepts and techniques apply to past and future versions of Oracle. I will try to use less GUI interface(except in the install) as possible since in the real world, database issues doesn't pop up when your in the office sipping coffee at 2pm, it usually pops up when you are sleeping soundly at 3am, waking up then remotely connecting to your work VPN, where speed is key, you will not be using a GUI to troubleshoot.

I will also share my scripts that I use daily in my 10 years as a production DBA.

What are the requirements?

  • Download oracle installer, will provide the path on where to get the copy, but don't install it, we will cover this in chapter 2.

What am I going to get from this course?

  • To perform basic administration tasks that can be used in "real life" work immediately

Who is the target audience?

  • This course is meant for fresh graduates or IT professionals that wants to shift to database administration
  • IT professionals who was "given" a database to manage

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.


Section 1: Oracle Architecture
Oracle Architecture and basic definitions
2 pages
Section 2: Software Install and DB creation
Hardware Requirements
1 page
Installing Oracle software part 1
Installing Oracle software part 2
Installing Oracle software part 3
Section 3: Connect thru sqlplus
Connecting to the database
Section 4: SQL Fundamentals
1 page
Understanding the Basics of executing a SQL
Section 5: Data Dictionary Views
DBA Views part 1
DBA Views part 2
DBA Views part 3
DBA Views notes
2 pages
Section 6: Creating Tablespace Users Tables and Indexes
Commands Used
1 page
Create a Tablespace
Create a User
Create a Table and an Index
Section 7: Bounce a database
Shutdown a Database
Startup a Database
Section 8: Convert a database from noarchivelog to archivelog
Convert a database to archive log mode
Section 9: Backing up a database
RMAN parameters
2 pages
Backing up a database thru RMAN

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Dexter Kwan, Oracle, SQL Server, DB2 database administrator

Dexter is a seasoned Oracle DBA and has been working with Oracle database since 2004 handling mission critical database of multinational telecommunications and banking sector. Aside from oracle he also handles Microsoft SQL Server and IBM DB2 databases. He has handled multi terabyte OLTP and data warehouse database based in the states and Asia. He has the following certifications: Oracle Certified Professional(9i, 10g, 11g), MCP, MCITP:Database Administrator 2005, IBM DB2 9 Associate. He holds a bachelor degree in computer science.

Dexter likes to develop iOS apps for personal use and dabble in VMware/VirtualBox during his free time.

Ready to start learning?
Take This Course