Become an Oracle DBA from scratch in a flash
3.8 (10 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.
91 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Become an Oracle DBA from scratch in a flash to your Wishlist.

Add to Wishlist

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 (10 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.
91 students enrolled
Created by Dexter Kwan
Last updated 12/2014
English
Current price: $10 Original price: $20 Discount: 50% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 30 mins on-demand video
  • 6 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • To perform basic administration tasks that can be used in "real life" work immediately
View Curriculum
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.
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.

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
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 21 Lectures Collapse All 21 Lectures 39:07
+
Oracle Architecture
1 Lecture 00:00
+
Software Install and DB creation
4 Lectures 01:06
+
Connect thru sqlplus
1 Lecture 01:04
+
SQL Fundamentals
2 Lectures 04:04
+
Data Dictionary Views
4 Lectures 09:49

DBA Views part 2
03:10

DBA Views part 3
02:41

DBA Views notes
2 pages
+
Creating Tablespace Users Tables and Indexes
4 Lectures 05:37
Commands Used
1 page

Create a Tablespace
01:54

Create a User
01:48

Create a Table and an Index
01:55
+
Bounce a database
2 Lectures 02:06
Shutdown a Database
01:13

Startup a Database
00:53
+
Convert a database from noarchivelog to archivelog
1 Lecture 02:32
Convert a database to archive log mode
02:32
+
Backing up a database
2 Lectures 03:49
RMAN parameters
2 pages

Backing up a database thru RMAN
03:49
About the Instructor
Dexter Kwan
3.8 Average rating
10 Reviews
91 Students
1 Course
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.