Mô tả

Do you want to be a professional Oracle database administrator DBA but you do not know how to start?

I have been providing courses for Oracle DBAs since 2016. This training experience, combined with my more than 20 years of Oracle DBA experience, inspired me to create this thorough course for beginners who wish to learn Oracle database administration professionally.


Whatever degree of Oracle database knowledge you have, this course starts you from scratch and develops your abilities all the way to the professional level. It provides in-depth explanations of the principles while also placing a significant emphasis on their application in like-real-world situations. You'll create a virtual environment on your computer that resembles the real world systems. You will have a lot of practical expertise carrying out Oracle DBA duties on Linux and Windows platforms.


With all the practical exercises, students can download the step-by-step documents so that they can easily implement the exercises in their own environment. Furthermore, the practical lectures are supported by videos that demonstrate how to implement the practices. I will be available to support you and assist you in overcoming any challenges you may encounter if, for whatever reason, you had trouble implementing any practice.


By the end of this course, you should have the following skills:

  • Create Oracle databases,

  • Implement Oracle database backup and recovery plans,

  • Administer Oracle database storage,

  • Apply patches and upgrade Oracle databases,

  • Manage Oracle database multitenancy,

  • Troubleshoot Oracle database issues,

  • Deploy Oracle Restart configuration,

  • Perform fundamental Oracle database performance tunning tasks.

By getting into this course, you can be rest assured that the course is carefully developed. There are explanatory animations that describes all the difficult concepts and the videos include the latest versions of Oracle database.

Although the course practices is built on Oracle database 19c, the curriculum takes into considerations the major differences between the releases 11g, 12c R1, 12c R2, 18c, and 19c. In addition to that, you will experience upgrading the 19c database to release 21c.


Starting with introducing RDBMS in general and Oracle, this course will cover all the topics that you need in your journey to become a DBA, like the following:

  • Oracle Database installation and creation

  • Oracle database basic administration

  • Managing database users and security

  • Database connectivity

  • Managing Oracle database multitenancy

  • Backup and recovery

  • Patching and upgrade

  • Oracle automatic storage management (ASM)


Do not waste your time watching Youtube videos that just leave you confused or uncertain if you reach to your goal or not. Do not waste your money on attending pricey courses that will set you back a fortune. The content offered in this course are identical to, or even superior to, the courses offered for corporate.


Do not pass up this chance to enroll into this course if you want a solid learning route to become a skilled Oracle DBA!

Bạn sẽ học được gì

Create Oracle databases on Linux and Windows platforms

Perform fundamental DBA tasks on Oracle databases

Manage Oracle database files

Manage database storage structures

Manage database multitenancy

Implement backup and recovery plans

Apply patches and upgrade databases

Deploy Oracle Restart configuration

Troubleshoot Oracle database issues

Yêu cầu

  • PC with Windows 10 or 11 64-bit, 16 GB RAM, 110 GB free HDD space
  • No experience in Oracle database is needed, you will learn everything you need to know
  • I'll walk you through step-by-step to get Oracle database installed and set up in your PC

Nội dung khoá học

25 sections

Introduction

1 lectures
Introduction
03:30

Preparing Course Practice Environment

2 lectures
Practice - Preparing Course Practice Environment (part 1 of 2)
19:14
Practice - Preparing Course Practice Environment (part 2 of 2)
12:45

Introduction to RDBMS

7 lectures
Introducing the Section
00:53
Overview of RDBMS ( part 1 of 2)
08:20
Overview of RDBMS ( part 2 of 2)
11:19
Overview on Oracle Database ( part 1 of 2 )
09:56
Overview on Oracle Database ( part 2 of 2 )
09:09
Overview on Oracle Database Technologies
12:38
About Oracle Database Administrator (DBA)
10:11

Database Architecture

4 lectures
Introducing the Section
00:26
Introducing Oracle Database Architecture (part 1 of 2)
18:06
Introducing Oracle Database Architecture (part 2 of 2)
06:48
Introducing Database Tablespaces and Datafiles
07:33

Installing and Creating Oracle Databases

13 lectures
Introducing the Section
00:34
Oracle DB Software Installation (part 1 of 2)
18:54
Oracle DB Software Installation (part 2 of 2)
08:43
Practice - Installing Oracle Database Software in Linux
16:19
Practice - Installing Oracle Database Software in Windows
07:37
Creating an Oracle Database (part 1 of 3)
08:06
Creating an Oracle Database (part 2 of 3)
23:06
Creating an Oracle Database (part 3 of 3)
11:18
Practice - Creating Oracle Databases (part 1 of 2)
16:52
Practice - Creating Oracle Databases (part 2 of 2)
11:20
Oracle Database Management Tools
17:09
Practice - Using SQL-Plus
16:05
Practice - Using SQL Developer
07:25

Oracle Database Basic Administration

10 lectures
Introducing the Section
00:30
Starting up and Shutting Down Database Instances
16:34
Practice - Starting up and Shutting Down DB Ins
06:52
Database Initialization Parameters (part 1 of 2)
18:06
Database Initialization Parameters (part 2 of 2)
07:33
Practice Managing Initialization Parameters, SPFILE, and PFILE
10:22
Introducing Data Dictionary
12:36
Practice - Querying Data Dictionary
04:40
Using Oracle Database Documentation (part 1 of 2)
08:58
Using Oracle Database Documentation (part 2 of 2)
12:23

Fundamentals of Oracle Database Multitenancy

9 lectures
Introducing the Section
00:41
Oracle Database Multitenant Architecture (part 1 of 2)
13:10
Oracle Database Multitenant Architecture (part 2 of 2)
13:07
Practice - Creating a CDB Database
11:23
Creating PDBs (part 1 of 2)
09:53
Creating PDBs (part 2 of 2)
09:23
Practice - Creating PDBs
10:10
Basic Multitenant Administration Tasks
15:27
Practice - Performing Basic CDB Admin Tasks
10:48

Managing Oracle Database Components

23 lectures
Introducing the Section
00:34
Database Memory Concepts (part 1 of 2)
07:50
Database Memory Concepts (part 2 of 2)
11:00
Managing Database Memory (part 1 of 2)
13:17
Managing Database Memory (part 2 of 2)
08:53
Practice - Managing Database Memory (part 1 of 2)
06:34
Practice - Managing Database Memory (part 2 of 2)
04:53
Database Storage Structures
09:05
Managing Tablespaces (part 1 of 4)
15:28
Managing Tablespaces (part 2 of 4)
09:13
Managing Tablespaces (part 2 of 4)
12:47
Managing Tablespaces (part 4 of 4)
08:53
Practice - Managing Tablespaces (part 1 of 2)
11:50
Practice - Managing Tablespaces (part 2 of 2)
05:14
Managing Data Files
08:56
Practice - Managing Data Files
11:50
Managing Resumable Space Allocation (part 1 of 2)
10:25
Managing Resumable Space Allocation (part 2 of 2)
07:58
Practice - Managing Resumable Space Allocation
04:43
Managing Undo Data (part 1 of 3)
15:09
Managing Undo Data (part 2 of 3)
10:10
Managing Undo Data (part 3 of 3)
10:07
Practice - Managing Undo Data
13:58

Managing Database Segments

9 lectures
Introducing the Section
00:41
Shrinking Segments (part 1 of 1)
10:09
Shrinking Segments (part 2 of 2)
09:44
Practice - Shrinking Segments
07:04
Using Deferred Segment Creation
05:08
Practice - Using Deferred Segment Creation
05:02
Using Table Compression (part 1 of 2)
08:18
Using Table Compression (part 2 of 2)
07:36
Practice - Using Table Compression
06:59

Managing Database Users and Security

21 lectures
Introducing the section
00:42
Managing Database Users (part 1 of 2)
11:25
Managing Database Users (part 2 of 2)
13:48
Managing User Privileges (part 1 of 2)
12:25
Managing User Privileges (part 1 of 2)
14:14
Managing Roles (part 1 of 2)
14:53
Managing Roles (part 2 of 2)
12:05
Managing User Profiles (part 1 of 2)
16:04
Managing User Profiles (part 2 of 2)
09:32
Practice Managing Users and User Security (part 1 of 2)
12:22
Practice Managing Users and User Security (part 2 of 2)
05:20
Managing Local and Common Users
13:32
Querying Container Data Objects
12:58
Practice - Managing Local and Common Users (part 1 of 2)
11:45
Practice - Managing Local and Common Users (part 2 of 2)
09:40
Applying the Principle of Least Privileges
05:58
Administrative Accounts and Privileges
16:24
Using OS Authentication ( Part 1 of 2 )
16:43
Using OS Authentication ( Part 2 of 2 )
08:20
Using Password File Authentication
14:07
Practice - Using Database Authentication Methods
12:42

Managing Database Connectivity

12 lectures
Introducing the Section
00:14
Configuring Oracle Network Environment (part 1 of 4)
13:08
Configuring Oracle Network Environment (part 2 of 4)
13:09
Configuring Oracle Network Environment (part 3 of 4)
07:30
Configuring Oracle Network Environment (part 4 of 4)
11:39
Practice - Configuring Oracle Network Environment (part 1 of 4)
11:23
Practice - Configuring Oracle Network Environment (part 2 or 4)
08:10
Practice - Configuring Oracle Network Environment (part 3 or 4)
06:24
Practice - Configuring Oracle Network Environment (part 4 or 4)
08:59
Using Database Links (part 1 of 2)
08:12
Using Database Links (part 2 of 2)
09:24
Practice - Using Database Links
06:05

Configuring Shared Server

5 lectures
Introducing the Section
00:24
Configuring Databases for Shared Server (part 1 of 3)
12:51
Configuring Databases for Shared Server (part 2 of 3)
15:07
Configuring Databases for Shared Server (part 3 of 3)
08:56
Practice - Configuring Databases for Shared Server
15:42

Managing Fast Recovery Area and Redo Log

10 lectures
Introducing the Section
00:34
Managing the Fast Recovery Area
10:45
Practice - Managing the Fast Recovery Area
05:02
Managing the Redo Log (part 1 of 4)
10:12
Managing the Redo Log (part 2 of 4)
09:12
Managing the Redo Log (part 3 of 4)
12:33
Managing the Redo Log (part 4 of 4)
05:18
Managing the Archived Redo Log Files (part 1 of 2)
11:18
Managing the Archived Redo Log Files (part 2 of 2)
10:03
Practice - Enabling the ARCHIVELOG Mode
05:52

Taking Backups in Oracle Databases

18 lectures
Introducing the Section
00:33
Introducing Backup and Recovery
12:40
Introduction to RMAN ( part 1 of 3 )
09:31
Introduction to RMAN ( part 2 of 3 )
07:47
Introduction to RMAN ( part 3 of 3 )
09:16
Practice - Introducing RMAN
09:22
Performing RMAN Full Backups - Part I ( 1 of 2 )
09:57
Performing RMAN Full Backups - Part I ( 2 of 2 )
09:37
Practice - Performing RMAN Full Backups - Part I ( 1 of 2 )
06:55
Practice - Performing RMAN Full Backups - Part I ( 2 of 2 )
07:46
Performing RMAN Full Backups - Part II ( 1 of 3 )
06:19
Performing RMAN Full Backups - Part II ( 2 of 3 )
08:39
Performing RMAN Full Backups - Part II ( 3 of 3 )
06:42
Practice - Performing RMAN Backups - Part II
08:44
Performing Incremental Backups ( 1 of 3 )
08:17
Performing Incremental Backups ( 2 of 3 )
09:07
Performing Incremental Backups ( 3 of 3 )
05:34
Practice - Performing Incremental Backups
13:09

Database Recovery

13 lectures
Introducing the Section
00:20
Configuring RMAN Persistent Settings (part 1 of 2)
08:24
Configuring RMAN Persistent Settings (part 2 of 2)
13:17
Practice - Configuring RMAN Persistent Settings
06:11
Introducing RESTORE and RECOVER Commands
13:07
Performing Recovery Part I - Performing Full Recovery
16:31
Practice - Performing Recovery Part I
12:14
Performing Recovery Part II - Switching Data Files and Performing PITR (1 of 2)
05:57
Performing Recovery Part II - Switching Data Files and Performing PITR (2 of 2)
11:19
Practice - Performing Recovery Part II
06:58
Automating RMAN Backup Jobs
08:30
Practice - Automating RMAN Backup Jobs (part 1 of 2)
10:49
Practice - Automating RMAN Backup Jobs (part 2 of 2)
05:48

Using RMAN in Multitenant Databases

10 lectures
Introducing the Section
00:24
Using RMAN in Oracle Multitenant Databases
12:50
Practice - Using RMAN in Oracle Multitenant Databases ( part 1 of 2 )
07:41
Practice - Using RMAN in Oracle Multitenant Databases ( part 2 of 2 )
08:58
Duplicating a Database using RMAN - Part I (1 of 3)
06:29
Duplicating a Database using RMAN - Part I (2 of 3)
04:56
Duplicating a Database using RMAN - Part I (3 of 3)
10:20
Duplicating a Database using RMAN - Part II (1 of 2)
07:28
Duplicating a Database using RMAN - Part II (2 of 2)
14:21
Practice - Duplicating Databases and PDBs using RMAN
10:58

More about using RMAN

7 lectures
Using RMAN Recovery Catalog ( part 1 of 3 )
07:06
Using RMAN Recovery Catalog ( part 2 of 3 )
07:45
Using RMAN Recovery Catalog ( part 3 of 2 )
11:19
Practice - Using RMAN Recovery Catalog
09:29
Using Data Recovery Advisor ( part 1 of 2 )
07:15
Using Data Recovery Advisor ( part 2 of 2 )
12:05
Practice Using Data Recovery Advisor
03:21

Flashback Database

3 lectures
Introducing the Section
00:25
Flashback Database
18:13
Practice - Performing Flashback Database
07:15

Using Oracle Database Utilities

12 lectures
Introducing the Section
00:22
Using Oracle Data Pump ( part 1 of 3 )
14:16
Using Oracle Data Pump ( part 2 of 3 )
18:00
Using Oracle Data Pump ( part 3 of 3 )
20:06
Practice - Using Oracle Data Pump
17:15
Using SQL Loader ( part 1 of 4 )
12:09
Using SQL Loader ( part 2 of 4 )
12:18
Using SQL Loader ( part 3 of 4 )
11:56
Using SQL Loader ( part 4 of 4 )
15:10
Practice - Using SQL Loader
18:49
Using External Tables
12:13
Practice - Using External Tables
12:06

Using the Scheduler

2 lectures
Automating Tasks with the Scheduler
22:36
Practice - Automating Tasks with the Scheduler
10:08

Using ADR Command Interpreter

3 lectures
Introducing the Section
00:28
Using ADR Command Interpreter
28:18
Practice - Using ADR Command Interpreter
14:08

Applying Patches on Oracle Databases

5 lectures
Introducing the Section
00:36
Patching Oracle Databases ( 1 of 3 )
13:08
Patching Oracle Databases ( 2 of 3 )
11:35
Patching Oracle Databases ( 3 of 3 )
21:49
Practice - Applying RU Patches on Oracle Databases
19:30

Automatic Storage Management (ASM)

9 lectures
Introducing the Section
00:31
Introducing Automatic Storage Management (part 1 of 3)
10:05
Introducing Automatic Storage Management (part 2 of 3)
16:35
Introducing Automatic Storage Management (part 3 of 3)
22:00
Practice - Creating Oracle Database with ASM (part 1 of 4)
10:08
Practice - Creating Oracle Database with ASM (part 2 of 4)
11:14
Practice - Creating Oracle Database with ASM (part 2 of 4)
08:47
Practice - Creating Oracle Database with ASM (part 4 of 4)
13:36
Practice - Applying RU Patches on Oracle Restart
11:15

Upgrading Oracle Databases

5 lectures
Introducing the Section
00:46
Upgrading Oracle Databases (part 1 of 2)
18:06
Upgrading Oracle Databases (part 2 of 2)
15:06
Practice - Upgrading Oracle Database
18:37
Practice - Upgrading Oracle Grid Infrastructure
08:38

Bonus Section

1 lectures
Bonus Lecture
01:42

Đánh giá của học viên

Chưa có đánh giá
Course Rating
5
0%
4
0%
3
0%
2
0%
1
0%

Bình luận khách hàng

Viết Bình Luận

Bạn đánh giá khoá học này thế nào?

image

Đăng ký get khoá học Udemy - Unica - Gitiho giá chỉ 50k!

Get khoá học giá rẻ ngay trước khi bị fix.