Offer ends in:
What you'll get
- 25+ Hours
- 3 Courses
- Course Completion Certificates
- One year access
- Self-paced Courses
- Technical Support
- Mobile App Access
- Case Studies
Synopsis
- 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
Content
-
MODULE 1: Oracle DBA 21c
Courses No. of Hours Certificates Details Oracle DBA 21c 58m ✔ -
MODULE 2: Oracle DBA 1 and 2
Courses No. of Hours Certificates Details Oracle DBA 1 9h 27m ✔ Oracle DBA 2 15h 9m ✔
Description
About Oracle DBA 21c
This course is about Oracle 21c DBA. Oracle 21c is the latest database software from Oracle and it’s a innovation release which means it has shorter support life span. Oracle 21 c is the first release of oracle database with CDB only option. You can not create a non-CBD database in Oracle 21c.
Oracle Database 21c is the latest innovation release of world's most popular database. Oracle Database 21c is now available on Oracle cloud and on-premises for linux including Exadata. You can directly upgrade to Oracle Database 21c from the following releases:
- Oracle Database 19c
- Oracle Database 18c
- Oracle Database 12c Release 2 (12.2)
Top New features in Oracle Database 21c:
- Blockchain Tables
- Immutable Tables
- Oracle Machine Learning- Native JSON Datatype- SQL Macros- In database JavaScript execution- Compare explain plans / cursors
We all should be aware that Innovation Releases have shorter support windows than Long Term Releases such as Oracle Database 19c. Oracle Database Innovation Releases include many enhancements and new capabilities which will be included in the next Long Term Release. Oracle Database Innovation Releases does not have extended support. As Oracle Database 21c is also an innovation release, which means it will only have 2 years of premium support. Oracle Database Long Term Releases usually have 5 years of Premier Support followed by 3 years of Extended Support. Personally I would not like to upgrade my production servers to an innovation release (Oracle Database 21c). I would like to upgrade (or stay with my Oracle Database Server with Oracle Database 19c which has Premier Support till April 30, 2024 and after that Extended Support will start for Oracle Database 19c.
Requirements
- Enthusiasm and determination to make your mark on the world!
Target Audience
- Oracle DBAs (Database Administrators)
- Database Developers
- Beginners & newbies aspiring for a career in Oracle Database Administration
- Cloud Database Architects
- Oracle Cloud Infrastructure Engineers
- Oracle DBA - Oracle 10G, 11G, 12C, 19C
- Platform Architects
- Software Developers & Administrators
- Application Developers
- Oracle Cloud Specialists
- Senior Database Administrators (PostgreSQL, Oracle)
Offer ends in:
Training 5 or more people?
Get your team access to 5,000+ top courses, learning paths, mock tests anytime, anywhere.
Drop an email at: [email protected]
