Updated on Apr, 2024
Language - English
your explanation is very good and i am very excited to learn new.
Oracle Database Administration from Zero to Hero
Unlock the full potential of Oracle database administration with our comprehensive course and become a skilled DBA in no time!
Lectures -216
Resources -127
Duration -36 hours
30-days Money-Back Guarantee
Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.
Course Description
Are you interested in becoming a professional Oracle database administrator (DBA), but don't know where to start?
Look no further than this comprehensive course, developed by an experienced Oracle DBA with over 20 years of experience and a track record of successful training since 2016.
Whether you are a beginner or have some existing Oracle database knowledge, this course will start you from scratch and take you all the way to the professional level. With a focus on practical applications and real-world situations, you will create a virtual environment on your computer to simulate real-world systems and gain hands-on experience with Oracle DBA duties on Linux and Windows platforms.
Throughout the course, you will have access to step-by-step documents and supporting videos, as well as personal support from the instructor. By the end of the course, you'll have gained skills in creating Oracle databases, implementing backup and recovery plans, administering database storage, applying patches and upgrades, managing multitenancy, troubleshooting issues, and deploying Oracle Restart configuration.
This course is carefully developed, with explanatory animations and the latest versions of Oracle database. While the course practices are based on Oracle database 19c, the curriculum takes into consideration the major differences between releases 11g, 12c R1, 12c R2, 18c, and 19c. You'll also experience upgrading the 19c database to release 21c.
Starting with an introduction to RDBMS and Oracle, this course covers all the topics you need to become a skilled Oracle DBA, including installation and creation, basic administration, managing users and security, connectivity, multitenancy, backup and recovery, patching and upgrade, and automatic storage management (ASM).
Don't waste your time with confusing Youtube videos or expensive courses that offer less than what you'll get here. The content offered in this course is identical to, or even superior to, courses offered for corporate clients.
Goals
What will you learn in this course:
By end of this course, you will be able to perform the following:
- Create Oracle databases on Linux and Windows platforms
- Perform fundamental DBA tasks on Oracle databases
- Manage Oracle database users, privileges, and profiles
- Configure connections to Oracle database
- Manage Oracle database files
- Managing database storage structures
- Manage database multitenancy
- Implement backup and recovery plans
- Apply patches and upgrade databases
- Deploy Oracle Restart configuration
- Troubleshoot Oracle database issues
Prerequisites
What are the prerequisites for this course?
PC with Windows 10 or 11 64-bit, 16 GB RAM, 110 GB free HDD space.
I'll walk you through step-by-step to get Oracle database installed and set up in your PC
No experience in Oracle database is needed, you will learn everything you need to know
Curriculum
Check out the detailed breakdown of what’s inside the course
Introduction
4 Lectures
-
Course Promo Video
02:42
02:42
-
Introducing the Course
03:30
03:30
-
Practice - Preparing Course Practice Environment (part 1 of 2)
19:14
19:14
-
Practice - Preparing Course Practice Environment (part 2 of 2)
12:45
12:45
Introduction to RDBMS
7 Lectures
Database Architecture
4 Lectures
Installing and Creating Oracle Databases
13 Lectures
Oracle Database Basic Administration
11 Lectures
Fundamentals of Oracle Database Multitenancy
9 Lectures
Managing Oracle Database Components
23 Lectures
Managing Database Segments
9 Lectures
Managing Database Users and Security
21 Lectures
Managing Database Connectivity
12 Lectures
Configuring Shared Server
5 Lectures
Managing Fast Recovery Area and Redo Log
10 Lectures
Taking Backups in Oracle Databases
18 Lectures
Database Recovery
13 Lectures
Using RMAN in Multitenant Databases
10 Lectures
More about using RMAN
7 Lectures
Flashback Database
3 Lectures
Using Oracle Database Utilities
12 Lectures
Using the Scheduler
3 Lectures
Using ADR Command Interpreter
3 Lectures
Applying Patches on Oracle Databases
5 Lectures
Automatic Storage Management
9 Lectures
Upgrading Oracle Databases
5 Lectures
Instructor Details
Ahmed Baraka
eCourse Certificate
Use your certificate to make a career change or to advance in your current career.
Our students work
with the Best
Feedbacks
Related Video Courses
View MoreAnnual Membership
Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses
Subscribe now
Online Certifications
Master prominent technologies at full length and become a valued certified professional.
Explore Now