Oracle Certified Professional (OCP) 12C /19C Database Administration

 About Oracle Database: Introduction to SQL(10 Hours)

Objectives of Oracle Database: Introduction to SQL

• Identify the major structural components of the Oracle Database 12c
• Create reports of aggregated data
• Write SELECT statements that include queries
• Retrieve row and column data from tables
• Run data manipulation statements (DML) in Oracle Database 12c
• Create tables to store data
• Utilize views to display data
• Control database access to specific objects
• Manage schema objects
• Display data from multiple tables using the ANSI SQL 99 JOIN syntax
• Manage objects with data dictionary views
• Write multiple-column sub-queries
• Employ SQL functions to retrieve customized data
• Use scalar and correlated sub-queries
• Create reports of sorted and restricted data

About Oracle Database 19c: Administration(20 Hours)

Objectives of Oracle Database 19C: Administration

• To understand and manage the Oracle Database Architecture
• To be able to manage and monitor to running of an Oracle Database 12C/19C  instance To understand how to manage network connections, security, and privileges on an Oracle Database 12C database
• To understand how to use manage tablespaces and undo data
• To understand how data concurrency and auditing is managed and implemented in Oracle Database 12C/19C
• To understand how to prepare for and perform data backup and recovery tasks in Oracle Database 12C/19C
• To understand the importance of proactive database maintenance, and how to implement it