Complete Oracle Database Administration course (19C,21C)
Complete Oracle Database Administration course (19C,21C)
Oracle Database Administration course /Multitenancy/ Oracle Database Backup&Recovery/Data Guard/Patching & Upgrade
This Complete Oracle Database Administration course is designed to make you a confident Database Administrator and will be ready to jump-start your career. It covers Oracle Database Administration course /Multitenancy/ Oracle Database Backup & Recovery/Data Guard/Patching & Upgrade and has over 8,345 students enrolled.
The Complete Oracle Database Administration course (19C,21C) provides 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). The course goes the extra mile and implements different backup strategies, performs numerous restore operations in the Oracle Database Backup&Recovery section of the course. The course also covers Patching operations, which are required to comply with information security policies.
The Complete Oracle Database Administration course covers a wide range of topics, including Oracle Database Architecture, Physical files of the DB, Memory Structures, Memory Management, Background Processes, and much more. You will learn how to install Oracle Database Software on the server without GUI and access Oracle Database via sqlplus, sqlcl and SQL Developer. You will also learn how to manage database instances: Starting and Shutting down DB, working with initialization parameters, diagnosing problems, working with Data Dictionary.
The Complete Oracle Database course also covers administering User Access, Privileges & Roles, Resource Limitation Multitenancy: Creating PDBs from SEED, Cloning PDBs, creating Refreshable Clones, Unplug/Plug PDBs Transparent Data Encryption (TDE), creating and managing Tablespaces, managing UNDO Data. You will practice different Backup and Recovery scenarios via RMAN and learn how to move data: Data Pump, SQL Loader Data Guard configuration Applying the latest Database Patch Database Upgrade from 19c to 21c.
By the end of this course, you will be able to recognize database terms better and use the most appropriate one for performance. You will also be able to compare BAD vs GOOD queries with hands-on examples and learn how to prioritize your SQL tuning efforts.
What you’ll learn in Complete Oracle Database Administration course
- 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
Recommended Course you must take
