After completing this Complete Oracle Database Administration course (19C,21C) course you will become a confident Database Administrator and will be ready to jump start your career.
You get hands-on experience in the most common administration tasks. You will create and configure Oracle Database Server for the real world production scenario ( in 99% there is no GUI on production servers ). We will go the extra mile and implement different backup strategies, perform numerous restore operations in the Oracle Database Backup&Recovery section of the course. We don’t forget about Patching operations. Because these operations are required to comply with information security policies. And we will have many more interesting assignments.
What you’ll learn
-
Oracle Database Administration
-
Oracle Database Architecture, Physical files of the DB, Memory Structures, Memory Management, Background Processes
-
How to install Oracle Database Software on the server without GUI
-
How to access Oracle Database via sqlplus, sqlcl and SQL Developer
-
Managing Database Instance: Starting and Shutting down DB, working with initialization parameters, Diagnosing problems, working with Data Dictionary
-
Oracle Net Services
-
Administering User Access, Privileges & Roles, Resource Limitation
-
Multitenancy: Creating PDBs from SEED, Clonning PDBs, creating Refreshable Clones, Unplug/Plug PDBs
-
Transparent Data Encryption (TDE)
-
Creating and Managing Tablespaces
-
Managing UNDO Data
-
Practicing different Backup and Recovery scenarious via RMAN
-
Moving Data: Data Pump, SQL Loader
-
Data Guard configuration
-
Applying the latest Database Patch
-
Database Upgrade from 19c to 21c
Course Content:
Module1: Introduction
- Describe the differences in Oracle Database editions, options, and packs
- List the database offerings in Oracle Cloud
- Explain the sample database that will be used in the course practices
Module2 : Oracle Database Architecture
- List the major architectural components of Oracle Database
- Explain memory structures
- Describe background processes
- Correlate logical and physical storage structures
- Describe multitenant architecture
Module3: Accessing an Oracle Database
- Connect to an Oracle Database
- Describe the tools used to access an Oracle Database
- Describe the Oracle-supplied user accounts for Oracle Database
- Query the data dictionary in an Oracle Database
Module4 Managing Database Instances
- Describe initialization parameter files and initialization parameters
- View and modify initialization parameters in SQL*Plus
- Start up and shut down Oracle databases
- Open and close PDBs
- Work with the Automatic Diagnostic Repository (ADR)
- Query dynamic performance views
Module5: Oracle Net Services
- Describe Oracle Net Services
- Explain how listeners work
- Configure listeners for dynamic or static service registration
- Configure local naming for database connections
- Test Oracle Net connectivity with tnsping
- Configure communication between databases by creating database links
- Explain the difference between dedicated and shared server configurations
Module6: Administering User Security
- Create database users
- Grant privileges to database users
- Create and grant roles to users or other roles
- Revoke privileges and roles from users and other roles
- Create and assign profiles to users
- Explain the various authentication options for users
- Assign quota to users
- Apply the principle of least privilege
Module7: Creating PDBs
- Describe the methods and tools used to create PDBs
- Create PDBs from seed by using SQL*Plus
- Clone PDBs by using SQL*Plus
- Unplug and plug in PDBs by using SQL*Plus
- Drop PDBs by using SQL*Plus
Module8:Creating Database Backups
- Create consistent database backups
- Back up your database without shutting it down
- Create incremental backups
Module9: Manage Database Instance
- Initialization Parameters
- Starting DB Instance
- Diagnostic Repository05:16
- Data Dictionary
- Shutting Down an DB Instance
Oracle Job Interview Preparation
- Oracle DBA Interview Question and Answer
- Oracle Fusion Cloud Technical Interview Question
- Oracle Fusion Cloud Techno Functional Interview Question
- Oracle Fusion Financials Cloud Interview Questions
International Student Fee: 1000$
Job Interview Preparation (Soft Skills Questions & Answers)
- Tough Open-Ended Job Interview Questions
- What to Wear for Best Job Interview Attire
- Job Interview Question- What are You Passionate About?
- How to Prepare for a Job Promotion Interview
🎥 Your FREE eLEARNING Courses (Click Here)
Internships, Freelance and Full-Time Work opportunities
Flexible Class Options
- Week End Classes For Professionals SAT | SUN
- Corporate Group Trainings Available
- Online Classes – Live Virtual Class (L.V.C), Online Training
Related Courses
Oracle Database 19c: Data Guard Administration
Oracle Database Administration – OCP/OCA
ORACLE DATA GUARD ADMINISTRATION
Oracle Database 12C Data Guard Administration Course
Oracle Database 11g – Data Guard Administration
Oracle Database 19c Administration (DBA Complete Course)
Oracle Database Admin – I
Oracle Database Admin – II
KEY FEATURES
Register Now
KEY FEATURES
Register Now
