Oracle Database 19c gives enterprises multitenant architecture, unprecedented hardware and software efficiencies, and performance and manageability benefits, with fast and efficient Cloud provisioning. Oracle Database 19c Certifications help DBAs develop the full skill set needed to perform day-to-day administration; be certified to design and implement backup and recovery strategies, while consolidating operations with pluggable and multitenant container databases.
8 Weeks
- Familiarity with data processing concepts and techniques
- Data processing
At the end of this course, you will be able to:
- Run data manipulation statements (DML) in Oracle Database 19c
- Use scalar and correlated sub-queries
- Utilize views to display data
- Write SELECT statements that include queries
- Create reports of aggregated data
- Create reports of sorted and restricted data
- Create tables to store data
- Upgrade database to Oracle Database 19c
- Create a container database
- Install Oracle Grid Infrastructure for a Standalone Server
- Configure ASMLIB and create ASM disk groups
- Apply the latest patch set updates to the Grid Infrastructure software
- Install Oracle Database 19c Release 2 software
- Use Oracle Restart to manage components
- Prepare the Linux operating system for Oracle software installation
- Install Oracle Grid Infrastructure for an Independent Server
- Install Oracle Database 19c software
- Create an Oracle Database using DBCA
- Install the latest patch set updates to the Oracle database software
At the end of this course, you will be eligible to sit for the Oracle Database Administration I (1Z0-082) to achieve the Oracle Certified Associate (OCA) status.
Oracle Database 19c: Backup and Recovery
What to learn next?
