Email: it@huph.edu.vn

Udemy - Oracle Database Administration from Zero to Hero 2023-2

0 students Last updated Feb 2024

About the course

Course content

Sections: 18

•

Activities: 0

•

Resources: 177

1. Introduction

1. Practice - Preparing Course Practice Environment (part 1 of 2)
2. Practice - Preparing Course Practice Environment (part 2 of 2)

1. Introducing the Section
2. Overview of RDBMS ( part 1 of 2)
3. Overview of RDBMS ( part 2 of 2)
4. Overview on Oracle Database ( part 1 of 2 )
5. Overview on Oracle Database ( part 2 of 2 )
6. Overview on Oracle Database Technologies
7. About Oracle Database Administrator (DBA)

1. Introducing the Section
2. Introducing Oracle Database Architecture (part 1 of 2)
3. Introducing Oracle Database Architecture (part 2 of 2)
. Introducing Database Tablespaces and Datafiles

1. Introducing the Section
2. Oracle DB Software Installation (part 1 of 2)
3. Oracle DB Software Installation (part 2 of 2)
4. Practice - Installing Oracle Database Software in Linux
5. Practice - Installing Oracle Database Software in Windows
6. Creating an Oracle Database (part 1 of 3)
7. Creating an Oracle Database (part 2 of 3)
8. Creating an Oracle Database (part 3 of 3)
9. Practice - Creating Oracle Databases (part 1 of 2)
10. Practice - Creating Oracle Databases (part 2 of 2)
11. Oracle Database Management Tools
12. Practice - Using SQL-Plus
13. Practice - Using SQL Developer

1. Introducing the Section
2. Starting up and Shutting Down Database Instances
3. Practice - Starting up and Shutting Down DB Ins
4. Database Initialization Parameters (part 1 of 2)
5. Database Initialization Parameters (part 2 of 2)
6. Practice Managing Initialization Parameters, SPFILE, and PFILE
7. Introducing Data Dictionary
8. Practice - Querying Data Dictionary
9. Using Oracle Database Documentation (part 1 of 2)
10. Using Oracle Database Documentation (part 2 of 2)

1. Introducing the Section
2. Oracle Database Multitenant Architecture (part 1 of 2)
3. Oracle Database Multitenant Architecture (part 2 of 2)
4. Practice - Creating a CDB Database
5. Creating PDBs (part 1 of 2)
6. Creating PDBs (part 2 of 2)
7. Practice - Creating PDBs
8. Basic Multitenant Administration Tasks
9. Practice - Performing Basic CDB Admin Tasks

1. Introducing the Section
2. Database Memory Concepts (part 1 of 2
3. Database Memory Concepts (part 2 of 2)
4. Managing Database Memory (part 1 of 2)
5. Managing Database Memory (part 2 of 2)
6. Practice - Managing Database Memory (part 1 of 2)
7. Practice - Managing Database Memory (part 2 of 2)
8. Database Storage Structures
9. Managing Tablespaces (part 1 of 4)
10. Managing Tablespaces (part 2 of 4)
11. Managing Tablespaces (part 3 of 4
12. Managing Tablespaces (part 4 of 4)
13. Practice - Managing Tablespaces (part 1 of 2)
14. Practice - Managing Tablespaces (part 2 of 2)
15. Managing Data Files
16. Practice - Managing Data Files
17. Managing Resumable Space Allocation (part 1 of 2)
18. Managing Resumable Space Allocation (part 2 of 2)
19. Practice - Managing Resumable Space Allocation
20. Managing Undo Data (part 1 of 3)
21. Managing Undo Data (part 2 of 3)
22. Managing Undo Data (part 3 of 3)
23. Practice - Managing Undo Data

1. Introducing the Section
2. Shrinking Segments (part 1 of 1)
3. Shrinking Segments (part 2 of 2)
4. Practice - Shrinking Segments
5. Using Deferred Segment Creation
6. Practice - Using Deferred Segment Creation
7. Using Table Compression (part 1 of 2)
8. Using Table Compression (part 2 of 2)
9. Practice - Using Table Compression

1. Introducing the section
2. Managing Database Users (part 1 of 2)
3. Managing Database Users (part 2 of 2)
4. Managing User Privileges (part 1 of 2)
5. Managing User Privileges (part 1 of 2)
6. Managing Roles (part 1 of 2)
7. Managing Roles (part 2 of 2)
8. Managing User Profiles (part 1 of 2)
9. Managing User Profiles (part 2 of 2)
10. Practice Managing Users and User Security (part 1 of 2)
11. Practice Managing Users and User Security (part 2 of 2)
12. Managing Local and Common Users
13. Querying Container Data Objects
14. Practice - Managing Local and Common Users (part 1 of 2)
15. Practice - Managing Local and Common Users (part 2 of 2)
16. Applying the Principle of Least Privileges
17. Administrative Accounts and Privileges
18. Using OS Authentication
19. Using Password File Authentication
20. Practice - Using Database Authentication Methods

1. Introducing the Section
2. Configuring Oracle Network Environment (part 1 of 4)
3. Configuring Oracle Network Environment (part 2 of 4)
4. Configuring Oracle Network Environment (part 3 of 4)
5. Configuring Oracle Network Environment (part 4 of 4)
6. Practice - Configuring Oracle Network Environment (part 1 of 4)
7. Practice - Configuring Oracle Network Environment (part 2 or 4)
8. Practice - Configuring Oracle Network Environment (part 3 or 4)
9. Practice - Configuring Oracle Network Environment (part 4 or 4)
10. Using Database Links (part 1 of 2
11. Using Database Links (part 2 of 2)
12. Practice - Using Database Link

1. Introducing the Section
2. Configuring Databases for Shared Server (part 1 of 3)
3. Configuring Databases for Shared Server (part 2 of 3)
4. Configuring Databases for Shared Server (part 3 of 3)
5. Practice - Configuring Databases for Shared Server

1. Introducing the Section
2. Managing the Fast Recovery Area
3. Practice - Managing the Fast Recovery Area
4. Managing the Redo Log (part 1 of 4)
5. Managing the Redo Log (part 2 of 4)
6. Managing the Redo Log (part 3 of 4)
7. Managing the Redo Log (part 4 of 4)
8. Managing the Archived Redo Log Files (part 1 of 2)
9. Managing the Archived Redo Log Files (part 2 of 2)
10. Practice - Enabling the ARCHIVELOG Mode

1. Introducing the Section
2. Introducing Backup and Recovery
3. Introduction to RMAN ( part 1 of 3 )
4. Introduction to RMAN ( part 2 of 3 )
5. Introduction to RMAN ( part 3 of 3 )
6. Practice - Introducing RMAN
7. Performing RMAN Full Backups - Part I ( 1 of 2 )
8. Performing RMAN Full Backups - Part I ( 2 of 2 )
9. Practice - Performing RMAN Full Backups - Part I ( 1 of 2 )
10. Practice - Performing RMAN Full Backups - Part I ( 2 of 2
11. Performing RMAN Full Backups - Part II ( 1 of 3 )
12. Performing RMAN Full Backups - Part II ( 2 of 3 )
13. Performing RMAN Full Backups - Part II ( 3 of 3 )
14. Practice - Performing RMAN Backups - Part II
15. Performing Incremental Backups ( 1 of 3 )
16. Performing Incremental Backups ( 2 of 3 )
17. Performing Incremental Backups ( 3 of 3 )
18. Practice - Performing Incremental Backups

1. Introducing the Section
2. Configuring RMAN Persistent Settings (part 1 of 2)
3. Configuring RMAN Persistent Settings (part 2 of 2)
4. Practice - Configuring RMAN Persistent Settings
5. Introducing RESTORE and RECOVER Commands
6. Performing Recovery Part I - Performing Full Recovery
7. Practice - Performing Recovery Part I
8. Performing Recovery Part II - Switching Data Files and Performing PITR (1 of 2)
9. Performing Recovery Part II - Switching Data Files and Performing PITR (2 of 2)
10. Practice - Performing Recovery Part II.
11. Automating RMAN Backup Jobs
12. Practice - Automating RMAN Backup Jobs (part 1 of 2)
13. Practice - Automating RMAN Backup Jobs (part 2 of 2)

1. Introducing the Section
2. Using RMAN in Oracle Multitenant Databases
3. Practice - Using RMAN in Oracle Multitenant Databases ( part 1 of 2 )
4. Practice - Using RMAN in Oracle Multitenant Databases ( part 2 of 2 )
4.1 B-prc-rman-multi
5. Duplicating a Database using RMAN - Part I (1 of 3)
6. Duplicating a Database using RMAN - Part I (2 of 3)
7. Duplicating a Database using RMAN - Part I (3 of 3)
8. Duplicating a Database using RMAN - Part II (1 of 2)
9. Duplicating a Database using RMAN - Part II (2 of 2)
10. Practice - Duplicating Databases and PDBs using RMAN

1. Using RMAN Recovery Catalog ( part 1 of 3 )
2. Using RMAN Recovery Catalog ( part 2 of 3 )
3. Using RMAN Recovery Catalog ( part 3 of 2 )
4. Practice - Using RMAN Recovery Catalog
5. Using Data Recovery Advisor ( part 1 of 2 )
6. Using Data Recovery Advisor ( part 2 of 2
7. Practice Using Data Recovery Advisor

1. Introducing the Section
2. Flashback Database
3. Practice - Performing Flashback Database

Instructors

Enrolment options

Udemy - Oracle Database Administration from Zero to Hero 2023-2

Udemy - Oracle Database Administration from Zero to Hero 2023-2

Course modified date: 9 Feb 2024

Enrolled students: There are no students enrolled in this course.

Guests cannot access this course. Please log in.