Oracle Database Administration Workshop ( 12c and Higher)
4.5 (485 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
3,019 students enrolled

Oracle Database Administration Workshop ( 12c and Higher)

Very helpful course for exam 1Z0-072 or 1Z0-082 ,more than 27 Hours that Prepare You to be a good DBA
Bestseller
4.5 (485 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
3,019 students enrolled
Created by Khaled Alkhudari
Last updated 1/2020
English
Current price: $119.99 Original price: $199.99 Discount: 40% off
2 days left at this price!
30-Day Money-Back Guarantee
This course includes
  • 27 hours on-demand video
  • 1 article
  • 94 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Covers the Agenda Oracle Database Administration Certified Associate 1Z0-072.
  • A very Strong Introduction and foundations for Oracle Database.
  • Download & installing Oracle Database 12c/18c on Linux in details.
  • Basic Linux commands that you need to manage Oracle Database.
  • Database Startup,shutdown and connections .
  • Helpful queries to explore Oracle DB architecture.
  • Managing Database Instance.
  • Creating PDBs in details.
  • Configuring the Oracle Network Environment.
  • Administering User Security.
  • Creating and managing tablespaces.
  • Managing Storage Space.
  • Managing UNDO Data.
  • Moving Data.
  • Backup and Recovery Concepts.
  • Many real examples and very big amount number of exercises .
Course content
Expand all 203 lectures 27:06:00
+ Introduction and foundations
14 lectures 01:30:36
Brief History of Oracle Database
Processing..
Oracle DB editions
04:31
sever processes and the PGA
07:04
System Global Area Part 1
09:48
System Global Area Part 2
07:21
Background Processes
06:25
Database Files
09:23
Logical Storage Structure
04:30
Default tablespaces
07:03
Multitenant Database 12c /18c
05:51
DBA Tasks and tools
05:53
Installation Methods and OS
04:09
+ Download & installing + Basic Linux commands
14 lectures 01:40:22
Overview about installation steps
05:17
Downloading and installing Oracle Vbox
02:19
Downloading oracle Linux image
04:41
Creating our virtual machine for this course
05:28
Installing oracle Linux
12:22
Installing gust additions
06:37
Creating shared folder
03:29
Basic Linux commands part 1
09:35
Basic Linux commands part 2
05:24
Basic Linux commands part 3
10:17
Prerequisites for installing oracle DB 18c
11:04
Valuable information about the installation Prerequisites
02:54
OS configurations for oracle user
09:26
Downloading and installing oracle DB 18c
11:29
+ Database Startup,shutdown and connections
18 lectures 02:08:54
Database Startup part 1
08:25
Database Startup part 2
07:12
Shutdown database part 1
11:04
Shutdown database part 2
08:43
Understanding oracle listener and Listener.ora
06:19
Understanding service name
05:13
Understanding tnsnames.ora
04:11
How client connections work
03:16
Installing Putty and so connections
07:01
Installing winSCP and so connections
04:46
Installing Oracle SQL developer (client side)
04:58
Connecting sys user in many methods
03:35
Moving from container to pluggable
07:23
Starting and stopping the listener
15:06
Easy connect method
10:10
connecting using tnsnames
10:05
unlock the hr schema in the pluggable database
05:39
saving and runing scripts
05:48
+ Helpful queries to explore Oracle DB architecture
13 lectures 01:21:39
Common uses VS local users part 1
04:18
Common uses VS local users part 2
07:35
Understanding Dynamic Performance Views
08:09
cdb_ & dba_ when you are inside a pluggable
05:16
query the data files
07:34
query the temps files
05:06
V$DATABASE / v$version / v$instance
04:24
V$CONTAINERS / cdb_PDBS
04:41
V$DATAFILE
05:22
cdb_tablespaces / V$TABLESPACE
05:04
v$logfile / V$CONTROLFILE
05:40
Pluggable Database Save state
06:12
+ Managing Database Instance
26 lectures 02:57:22
Initialization Parameters & Parameters Files
05:45
Search order for a parameter file
03:45
Uses of Initialization Parameters
03:28
Types of Initialization Parameters
10:50
About Modifying Initialization Parameters
04:53
Alter session example
08:12
v$parameter VS v$parameter2
06:48
v$system_parameter VS v$system_parameter2
07:39
example: Search order for a parameter file and creating pfile
07:11
Understanding the parameter spfile
03:27
creating non default name for pfile and startup
09:46
alter system example ( memory )
07:12
alter system example ( spfile )
04:21
alter system example ( both )
04:31
Default scope in alter statement part 1
02:11
Default scope in alter statement part 2
08:48
CONTAINER clause in alter system & Inheritance 1
04:50
CONTAINER clause in alter system & Inheritance 2
10:32
About Automatic Diagnostic Repository
05:55
The alert log Part 1
06:44
The alert log Part 2
06:29
View alert log using ADRCI
08:31
Trace files and Purging Part 1
06:47
Trace files and Purging Part 2
15:29
Enable DDL logging
06:40
V$SPPARAMETER
06:38
+ Creating PDBs
12 lectures 01:30:48
About creating PDBs
04:22
Creating PDB from seed part 1
05:13
Connecting to the new PDB
09:19
Creating PDB from seed (DBCA)
06:26
Dropping pluggable using SQL
04:02
Dropping pluggable using DBCA
01:46
Cloning PDBs part 1
04:30
Cloning PDBs part 2
14:47
Unplugging and plugging in PDBs part 1
05:46
Unplugging and plugging in PDBs part 2
13:59
Unplugging and plugging in PDBs part 3
05:59
+ Configuring the Oracle Network Environment
11 lectures 01:38:02
Establishing a connection and session
04:13
The default listener
10:40
The default listener exercise
08:31
Using non-default port
07:52
creating dynamic listener example
08:07
creating static listener example
15:03
Oracle net configuration assistant (netca)
11:35
Oracle Net Manager (netmgr )
06:33
CREATE DATABASE LINK
06:01
CREATE DATABASE LINK example part 1
06:16
CREATE DATABASE LINK example part 2
13:11
+ Administering User Security
22 lectures 02:58:41
basic knowledge for controlling user access
11:35
System and objects privileges part 1
08:17
System and objects privileges part 2
14:25
Creating private roles examples
10:52
common users and common privileges
10:49
common roles
10:33
More About Users accounts
04:17
Oracle- supplied administrator accounts
05:23
Special system privileges for administrators
04:16
Oracle –supplied roles
04:32
Best practice to create user like SYS
13:06
Best practice to create pluggable admin
05:40
Role granted to another role
07:31
Understanding the role PDB_DBA (DBCA method)
09:42
system privileges with admin option
04:12
About user profile
05:44
Password Parameters
07:21
Oracle-supplied password verification functions
05:01
Resource parameters
04:37
Creating common profile example
13:16
Creating local profile example
05:02
Password verification full example
12:30
+ Creating and managing tablespaces
13 lectures 01:53:42
Review tablespaces basic information
08:14
How table data is stored
04:34
Database block content
02:38
About creating tablespace part 1
04:00
About creating tablespace part 2
08:06
About creating tablespace part 3
04:29
Creating new PDB for practice
10:22
Helpful queries for tablespaces
17:54
Create permanent tablespace example
13:51
managing tablespace using SQL developer wizard
14:19
Alter tablespace and datafile
14:46
Moving and Renaming Online Data Files
07:59
last tips for this chapter
02:30
+ Managing Storage Space
17 lectures 02:35:34
Space can be automatically managed by Oracle
07:43
Segments,Extents & blocks using SQL 1
15:28
Segments,Extents & blocks using SQL 2
06:01
Availability and Optimization of Free Space in a Data Block
07:15
Row Chaining and Migrating
04:01
Types of Segments
10:06
Controlling Deferred Segment Creation
07:24
Space-Saving Features (UNUSABLE index)
08:27
basic compression part 1
13:04
basic compression part 2
07:00
Advanced row compression
08:22
Monitoring Tablespace Space Usage
09:24
DBMS_SERVER_ALERT.SET_THRESHOLD example
11:03
Reclaiming Wasted Space
07:09
Segment Advisor
06:20
Segment Advisor and shrink exercise
13:50
Managing Resumable Space Allocation
12:57
Requirements
  • You should know Oracle SQL very well.
  • PL/SQL will be added value for this course, but it is not mandatory.
  • Windows Operating system is preferred , but it is not mandatory.
  • Minimum 50 GB free space in order to install oracle and doing backup exercises .
  • Minimum 8 GB RAM
  • Oracle virtual box , Oracle Database and Linux installation will be covered in details.
  • Note that Oracle SQL exam 1Z0-071 should be taken first before applying 1Z0-072.
Description

This Course is one of the best courses ever in Oracle Administration (12c, 18c, 19c ).

Be ready to become very good Oracle DBA after finishing this course .


The course is more than 27 Hours of HD videos.

Very helpful course for exam 1Z0-072 or 1Z0-082.

All the presentations , PDFS and scripts are available for download.

my courses are the best seller and the highest rated in udemy, i do not create content that you find it easily in free websites and YouTube.

The course start from zero knowledge in Oracle Administration , but remember that SQL is a must.

simply this course is the best.


Who this course is for:
  • Students who wants to be expert in oracle database administration.
  • Students who wants to be certified in oracle database administration from Oracle University.
  • Students and programmers who know SQL, but they like to be in database administration career.
  • Students and programmers who know SQL, but they did not find them selves in programming and developments.
  • Fresh and junior DBAs who need to find better jobs by gaining oracle certification.