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
