Oracle Database Administration from Zero to Hero [Video]
Video
Video
$109.99
Subscription
$15.99
$10 p/m for three months
What do you get with a Packt Subscription?
This book & 7000+ ebooks & video courses on 1000+ technologies
60+ curated reading lists for various learning paths
50+ new titles added every month on new and emerging tech
Early Access to eBooks as they are being written
Personalised content suggestions
Customised display settings for better reading experience
50+ new titles added every month on new and emerging tech
Playlists, Notes and Bookmarks to easily manage your learning
Mobile App with offline access
What do you get with a Packt Subscription?
This book & 6500+ ebooks & video courses on 1000+ technologies
60+ curated reading lists for various learning paths
50+ new titles added every month on new and emerging tech
Early Access to eBooks as they are being written
Personalised content suggestions
Customised display settings for better reading experience
50+ new titles added every month on new and emerging tech
Playlists, Notes and Bookmarks to easily manage your learning
Mobile App with offline access
What do you get with Video + Subscription?
Download this video in MP4 format, plus a monthly download credit
This book & 6500+ ebooks & video courses on 1000+ technologies
60+ curated reading lists for various learning paths
50+ new titles added every month on new and emerging tech
Early Access to eBooks as they are being written
Personalised content suggestions
Customised display settings for better reading experience
50+ new titles added every month on new and emerging tech
Playlists, Notes and Bookmarks to easily manage your learning
Mobile App with offline access
What do you get with a Packt Subscription?
This book & 6500+ ebooks & video courses on 1000+ technologies
60+ curated reading lists for various learning paths
50+ new titles added every month on new and emerging tech
Early Access to eBooks as they are being written
Personalised content suggestions
Customised display settings for better reading experience
50+ new titles added every month on new and emerging tech
Playlists, Notes and Bookmarks to easily manage your learning
Mobile App with offline access
What do you get with eBook?
What do I get with Print?
Get a paperback copy of the book delivered to your specified Address*
Download this book in EPUB and PDF formats
Access this title in our online reader
DRM FREE - Read whenever, wherever and however you want
Online reader with customised display settings for better reading experience
What do I get with Print?
What do you get with video?
What do you get with video?
What do you get with Audiobook?
What do you get with Exam Trainer?
Video
$109.99
Subscription
$15.99
$10 p/m for three months
What do you get with a Packt Subscription?
This book & 7000+ ebooks & video courses on 1000+ technologies
60+ curated reading lists for various learning paths
50+ new titles added every month on new and emerging tech
Early Access to eBooks as they are being written
Personalised content suggestions
Customised display settings for better reading experience
50+ new titles added every month on new and emerging tech
Playlists, Notes and Bookmarks to easily manage your learning
Mobile App with offline access
What do you get with a Packt Subscription?
This book & 6500+ ebooks & video courses on 1000+ technologies
60+ curated reading lists for various learning paths
50+ new titles added every month on new and emerging tech
Early Access to eBooks as they are being written
Personalised content suggestions
Customised display settings for better reading experience
50+ new titles added every month on new and emerging tech
Playlists, Notes and Bookmarks to easily manage your learning
Mobile App with offline access
What do you get with Video + Subscription?
Download this video in MP4 format, plus a monthly download credit
This book & 6500+ ebooks & video courses on 1000+ technologies
60+ curated reading lists for various learning paths
50+ new titles added every month on new and emerging tech
Early Access to eBooks as they are being written
Personalised content suggestions
Customised display settings for better reading experience
50+ new titles added every month on new and emerging tech
Playlists, Notes and Bookmarks to easily manage your learning
Mobile App with offline access
What do you get with a Packt Subscription?
This book & 6500+ ebooks & video courses on 1000+ technologies
60+ curated reading lists for various learning paths
50+ new titles added every month on new and emerging tech
Early Access to eBooks as they are being written
Personalised content suggestions
Customised display settings for better reading experience
50+ new titles added every month on new and emerging tech
Playlists, Notes and Bookmarks to easily manage your learning
Mobile App with offline access
What do you get with eBook?
Download this book in EPUB and PDF formats
Access this title in our online reader
DRM FREE - Read whenever, wherever and however you want
Online reader with customised display settings for better reading experience
What do I get with Print?
Get a paperback copy of the book delivered to your specified Address*
Download this book in EPUB and PDF formats
Access this title in our online reader
DRM FREE - Read whenever, wherever and however you want
Online reader with customised display settings for better reading experience
What do I get with Print?
Get a paperback copy of the book delivered to your specified Address*
Access this title in our online reader
Online reader with customised display settings for better reading experience
What do you get with video?
Download this video in MP4 format
Access this title in our online reader
DRM FREE - Watch whenever, wherever and however you want
Online reader with customised display settings for better learning experience
What do you get with video?
Stream this video
Access this title in our online reader
DRM FREE - Watch whenever, wherever and however you want
Online reader with customised display settings for better learning experience
What do you get with Audiobook?
Download a zip folder consisting of audio files (in MP3 Format) along with supplementary PDF
What do you get with Exam Trainer?
Flashcards, Mock exams, Exam Tips, Practice Questions
Access these resources with our interactive certification platform
Mobile compatible-Practice whenever, wherever, however you want
-
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