Oracle Database 19c: Administration

40 HRS

• Familiarity with data processing concepts and techniques 
• Data processing 

You will learn how to: 

• Identify the major structural components of the Oracle Database 12c 

• Manage objects with data dictionary views 
• Manage schema objects 
• Retrieve row and column data from tables 
• Run data manipulation statements (DML) in Oracle Database 12c 
• Use scalar and correlated sub-queries 

• Utilize views to display data 
• Write SELECT statements that include queries 
• Write multiple-column sub-queries 
• Control database access to specific objects 
• Create reports of aggregated data 

• Create reports of sorted and restricted data 
• Create tables to store data 
• Display data from multiple tables using the ANSI SQL 99 JOIN syntax 
• Employ SQL functions to retrieve customized data 

• Introduction 
• Working with Oracle Cloud Exadata Express Cloud Service 
• Retrieving Data using the SQL SELECT Statement 
• Restricting and Sorting Data 
• Using the DEFINE and VERIFY command 

• Using Conversion Functions and Conditional Expressions 
• Reporting Aggregated Data Using the Group Functions 
• Displaying Data from Multiple Tables Using Joins 
• Using Subqueries to Solve Queries 
• Using the SET Operators 

• Managing Tables using DML statements 
• Introduction to Data Dictionary Views 
• Introduction to Data Dictionary 
• Creating Sequences, Synonyms, Indexes 
• Creating Views 

• Managing Schema Objects 
• Retrieving Data by Using Subqueries 
• Manipulating Data by Using Subqueries 
• Controlling User Access 
• Manipulating Data 

• Managing Data in Different Time Zones 

This course prepares you for the following certifications: 

• Oracle Certified Associate (OCA) – (Database Admin)