![Oracle Database Administration from Zero to Hero [Video]](https://content.packt.com/V21089/cover_image_small.jpg)
Oracle Database Administration from Zero to Hero [Video]
Subscription
FREE
Video + Subscription
€14.99
Video
€82.99
What do you get with a Packt Subscription?
What do you get with a Packt Subscription?
What do you get with Video + Subscription?
What do you get with a Packt Subscription?
What do you get with eBook?
What do I get with Print?
What do you get with video?
What do you get with Audiobook?
Subscription
FREE
Video + Subscription
€14.99
Video
€82.99
What do you get with a Packt Subscription?
What do you get with a Packt Subscription?
What do you get with Video + Subscription?
What do you get with a Packt Subscription?
What do you get with eBook?
What do I get with Print?
What do you get with video?
What do you get with Audiobook?
-
Free ChapterIntroduction
-
Preparing Course Practice Environment
-
Introduction to RDBMS
-
Database Architecture
-
Installing and Creating Oracle Databases
- Introducing the Section
- Oracle DB Software Installation (Part 1 of 2)
- Oracle DB Software Installation (Part 2 of 2)
- Practice - Installing Oracle Database Software in Linux
- Practice - Installing Oracle Database Software in Windows
- Creating an Oracle Database (Part 1 of 3)
- Creating an Oracle Database (Part 2 of 3)
- Creating an Oracle Database (Part 3 of 3)
- Practice - Creating Oracle Databases (Part 1 of 2)
- Practice - Creating Oracle Databases (Part 2 of 2)
- Oracle Database Management Tools
- Practice - Using SQLPlus
- Practice - Using SQL Developer
-
Oracle Database Basic Administration
- Introducing the Section
- Starting Up and Shutting Down Database Instances
- Practice - Starting Up and Shutting Down DB Instances
- Database Initialization Parameters (Part 1 of 2)
- Database Initialization Parameters (Part 2 of 2)
- Practice - Managing Initialization Parameters, SPFILE, and PFILE
- Introducing Data Dictionary
- Practice - Querying Data Dictionary
- Using Oracle Database Documentation (Part 1 of 2)
- Using Oracle Database Documentation (Part 2 of 2)
-
Fundamentals of Oracle Database Multitenancy
- Introducing the Section
- Oracle Database Multitenant Architecture (part 1 of 2)
- Oracle Database Multitenant Architecture (Part 2 of 2)
- Practice - Creating a CDB Database
- Creating PDBs (Part 1 of 2)
- Creating PDBs (Part 2 of 2)
- Practice - Creating PDBs
- Basic Multitenant Administration Tasks
- Practice - Performing Basic CDB Admin Tasks
-
Managing Oracle Database Components
- Introducing the Section
- Database Memory Concepts (Part 1 of 2)
- Database Memory Concepts (Part 2 of 2)
- Managing Database Memory (Part 1 of 2)
- Managing Database Memory (Part 2 of 2)
- Practice - Managing Database Memory (Part 1 of 2)
- Practice - Managing Database Memory (Part 2 of 2)
- Database Storage Structures
- Managing Tablespaces (Part 1 of 4)
- Managing Tablespaces (Part 2 of 4)
- Managing Tablespaces (Part 3 of 4)
- Managing Tablespaces (Part 4 of 4)
- Practice - Managing Tablespaces (Part 1 of 2)
- Practice - Managing Tablespaces (Part 2 of 2)
- Managing Data Files
- Practice - Managing Data Files
- Managing Resumable Space Allocation (Part 1 of 2)
- Managing Resumable Space Allocation (Part 2 of 2)
- Practice - Managing Resumable Space Allocation
- Managing Undo Data (Part 1 of 3)
- Managing Undo Data (Part 2 of 3)
- Managing Undo Data (Part 3 of 3)
- Practice - Managing Undo Data
-
Managing Database Segments
- Introducing the Section
- Shrinking Segments (Part 1 of 2)
- Shrinking Segments (Part 2 of 2)
- Practice - Shrinking Segments
- Using Deferred Segment Creation
- Practice - Using Deferred Segment Creation
- Using Table Compression (Part 1 of 2)
- Using Table Compression (Part 2 of 2)
- Practice - Using Table Compression
-
Managing Database Users and Security
- Introducing the Section
- Managing Database Users (Part 1 of 2)
- Managing Database Users (Part 2 of 2)
- Managing User Privileges (Part 1 of 2)
- Managing User Privileges (Part 2 of 2)
- Managing Roles (Part 1 of 2)
- Managing Roles (Part 2 of 2)
- Managing User Profiles (Part 1 of 2)
- Managing User Profiles (Part 2 of 2)
- Practice - Managing Users and User Security (Part 1 of 2)
- Practice - Managing Users and User Security (Part 2 of 2)
- Managing Local and Common Users
- Querying Container Data Objects
- Practice - Managing Local and Common Users (Part 1 of 2)
- Practice - Managing Local and Common Users (Part 2 of 2)
- Applying the Principle of Least Privileges
- Administrative Accounts and Privileges
- Using OS Authentication (Part 1 of 2)
- Using OS Authentication (Part 2 of 2)
- Using Password File Authentication
- Practice - Using Database Authentication Methods
-
Managing Database Connectivity
- Introducing the Section
- Configuring Oracle Network Environment (Part 1 of 4)
- Configuring Oracle Network Environment (Part 2 of 4)
- Configuring Oracle Network Environment (Part 3 of 4)
- Configuring Oracle Network Environment (Part 4 of 4)
- Practice - Configuring Oracle Network Environment (Part 1 of 4)
- Practice - Configuring Oracle Network Environment (Part 2 of 4)
- Practice - Configuring Oracle Network Environment (Part 3 of 4)
- Practice - Configuring Oracle Network Environment (Part 4 of 4)
- Using Database Links (Part 1 of 2)
- Using Database Links (Part 2 of 2)
- Practice - Using Database Links
-
Configuring Shared Server
-
Managing Fast Recovery Area and Redo Log
- Introducing the Section
- Managing the Fast Recovery Area
- Practice - Managing the Fast Recovery Area
- Managing the Redo Log (Part 1 of 4)
- Managing the Redo Log (Part 2 of 4)
- Managing the Redo Log (Part 3 of 4)
- Managing the Redo Log (Part 4 of 4)
- Managing the Archived Redo Log Files (Part 1 of 2)
- Managing the Archived Redo Log Files (Part 2 of 2)
- Practice - Enabling the ARCHIVELOG Mode
-
Taking Backups in Oracle Databases
- Introducing the Section
- Introducing Backup and Recovery
- Introduction to RMAN (Part 1 of 3)
- Introduction to RMAN (Part 2 of 3)
- Introduction to RMAN (Part 3 of 3)
- Practice - Introducing RMAN
- Performing RMAN Backups - Part I (1 of 2)
- Performing RMAN Backups - Part I (2 of 2)
- Practice - Performing RMAN Backups - Part I (1 of 2)
- Practice - Performing RMAN Backups - Part I (2 of 2)
- Performing RMAN Backups - Part II (1 of 3)
- Performing RMAN Backups - Part II (2 of 3)
- Performing RMAN Backups - Part II (3 of 3)
- Practice - Performing RMAN Backups - Part II
- Performing Incremental Backups (1 of 3)
- Performing Incremental Backups (2 of 3)
- Performing Incremental Backups (3 of 3)
- Practice - Performing Incremental Backups
-
Database Recovery
- Introducing the Section
- Configuring RMAN Persistent Settings (Part 1 of 2)
- Configuring RMAN Persistent Settings (Part 2 of 2)
- Practice - Configuring RMAN Persistent Settings
- Introducing RESTORE and RECOVER Commands
- Performing Recovery Part I - Performing Full Recovery
- Practice - Performing Recovery Part I
- Performing Recovery Part II - Switching Data Files and Performing PITR (1 of 2)
- Performing Recovery Part II - Switching Data Files and Performing PITR (2 of 2)
- Practice - Performing Recovery Part II
- Automating RMAN Backup Jobs
- Practice - Automating RMAN Backup Jobs (Part 1 of 2)
- Practice - Automating RMAN Backup Jobs (Part 2 of 2)
-
Using RMAN in Multitenant Databases
- Introducing the Section
- Using RMAN in Oracle Multitenant Databases
- Practice - Using RMAN in Oracle Multitenant Databases (Part 1 of 2)
- Practice - Using RMAN in Oracle Multitenant Databases (Part 2 of 2)
- Duplicating a Database Using RMAN - Part I (1 of 3)
- Duplicating a Database Using RMAN - Part I (2 of 3)
- Duplicating a Database Using RMAN - Part I (3 of 3)
- Duplicating a Database Using RMAN - Part II (1 of 2)
- Duplicating a Database Using RMAN - Part II (2 of 2)
- Practice - Duplicating Databases and PDBs Using RMAN
-
More about Using RMAN
-
Flashback Database
-
Using Oracle Database Utilities
- Introducing the Section
- Using Oracle Data Pump (Part 1 of 3)
- Using Oracle Data Pump (Part 2 of 3)
- Using Oracle Data Pump (Part 3 of 3)
- Practice - Using Oracle Data Pump
- Using SQL Loader (Part 1 of 4)
- Using SQL Loader (Part 2 of 4)
- Using SQL Loader (Part 3 of 4)
- Using SQL Loader (Part 4 of 4)
- Practice - Using SQL Loader
- Using External Tables
- Practice - Using External Tables
-
Using the Scheduler
-
Using ADR Command Interpreter
-
Applying Patches on Oracle Databases
-
Automatic Storage Management (ASM)
- Introducing the Section
- Introducing Automatic Storage Management (Part 1 of 3)
- Introducing Automatic Storage Management (Part 2 of 3)
- Introducing Automatic Storage Management (Part 3 of 3)
- Practice - Creating Oracle Database with ASM (Part 1 of 4)
- Practice - Creating Oracle Database with ASM (Part 2 of 4)
- Practice - Creating Oracle Database with ASM (Part 3 of 4)
- Practice - Creating Oracle Database with ASM (Part 4 of 4)
- Practice - Applying RU Patches on Oracle Restart
-
Upgrading Oracle Databases
About this video
In this course, we cover a wide range of topics to ensure you have a solid understanding of Oracle database administration. Starting with an introduction to Oracle databases, you will learn how to create databases on both Linux and Windows platforms. We will guide you through fundamental DBA tasks, including managing database files, storage structures, and users.
As you progress, you will delve into more advanced topics such as managing database multitenancy, implementing backup and recovery plans, and applying patches and upgrades. We will also provide in-depth coverage of Oracle’s Automatic Storage Management (ASM) and Oracle Restart configuration, giving you a comprehensive understanding of these critical components.
Practical exercises form an integral part of the course, allowing you to apply your knowledge in real-world scenarios. You will gain hands-on experience with tasks such as creating a tablespace in ASM, installing Oracle database software, and performing database upgrades. Step-by-step instructions and downloadable resources ensure a seamless learning experience.
By the end of this course, you will have the skills to confidently manage Oracle databases, troubleshoot issues, and optimize performance.
- Publication date:
- June 2023
- Publisher
- Packt
- Duration
- 36 hours 1 minutes
- ISBN
- 9781805123996