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.6 (8 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.
82 students enrolled
Instructed by Dexter Kwan IT & Software / Other
$19
$20
5% 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

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

What 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.

Curriculum

Section 1: Oracle Architecture
Oracle Architecture and basic definitions
Preview
2 pages
Section 2: Software Install and DB creation
Hardware Requirements
1 page
Installing Oracle software part 1
Preview
00:26
Installing Oracle software part 2
Preview
00:07
Installing Oracle software part 3
Preview
00:33
Section 3: Connect thru sqlplus
Connecting to the database
Preview
01:04
Section 4: SQL Fundamentals
SQL
1 page
Understanding the Basics of executing a SQL
Preview
04:04
Section 5: Data Dictionary Views
DBA Views part 1
Preview
03:58
DBA Views part 2
03:10
DBA Views part 3
02:41
DBA Views notes
2 pages
Section 6: Creating Tablespace Users Tables and Indexes
Commands Used
1 page
Create a Tablespace
01:54
Create a User
01:48
Create a Table and an Index
01:55
Section 7: Bounce a database
Shutdown a Database
01:13
Startup a Database
00:53
Section 8: Convert a database from noarchivelog to archivelog
Convert a database to archive log mode
02:32
Section 9: Backing up a database
RMAN parameters
2 pages
Backing up a database thru RMAN
03:49

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