| Section | Objectives |
| Topic 1: Retrieving Data using the SQL SELECT Statement | - Use scalar and correlated subqueries
- Use the ORDER BY clause
- Execute a basic SELECT statement
- List the capabilities of SQL SELECT statements
- Use SQL row functions (character, number, date, conversion, general)
- Describe how schema objects work
|
| Topic 2: Understanding Oracle Database Architecture - Oracle Database Instance | - Describe the background processes
- Explain the memory structures (SGA, PGA)
- Understand Oracle Database instance management
|
| Topic 3: Managing Data in Different Time Zones | - Explain the concepts of time zones and daylight savings
- Use various datetime data types (DATE, TIMESTAMP, INTERVAL)
- Describe the use of datetime functions (CURRENT_DATE, EXTRACT, LOCALTIMESTAMP)
|
| Topic 4: Using Subqueries to Solve Queries | - Use multiple-row subqueries with multiple-row operators (IN, ANY, ALL)
- Use scalar subqueries in SQL
- Define subqueries
- Use single-row subqueries with single-row and multiple-row operators
- Use subqueries in the WHERE clause and HAVING clause
- Describe the types of subqueries (single-row, multi-row, multiple-column)
|
| Topic 5: Managing Oracle Database Instances | - Start up and shut down an Oracle Database instance
- View the alert log and access dynamic performance views
- Use the Automatic Diagnostic Repository (ADR)
- Manage initialization parameter files (SPFILE, PFILE)
|
| Topic 6: Introduction to Oracle Database | - Describe Oracle Database instance and memory structures
- Describe Oracle Database architecture
- Describe Oracle processes (PMON, SMON, DBWn, LGWR, CKPT, others)
- Explain database storage structures (data blocks, segments, tablespaces, data files)
- Explain Oracle Database server architecture
- Describe Oracle Database Cloud Service (DBCS) architecture and features
|
| Topic 7: Managing Schema Objects | - Manage constraints (NOT NULL, UNIQUE, PRIMARY KEY, FOREIGN KEY, CHECK)
- Create indexes and views
- Manage sequences and synonyms
- Create and modify tables
|
| Topic 8: Working with Oracle Cloud Exadata Express Cloud Service | - Describe the features and benefits of Exadata Express Cloud Service
- Navigate the Exadata Express Cloud Service console
- Identify the prerequisites for Exadata Express Cloud Service
- Provision and manage an Exadata Express Cloud Service instance
|
| Topic 9: Managing Users, Roles, and Privileges | - Create and manage database user accounts
- Create and manage roles
- Differentiate system privileges and object privileges
- Grant and revoke privileges
|
| Topic 10: Restricting and Sorting Data | - Use the LIKE and IN operators
- Use the WHERE clause to limit retrieved rows
- Sort data using the ORDER BY clause
- Use the BETWEEN comparator
- Use the NULL operators (IS NULL, IS NOT NULL)
- Use comparison operators and logical operators (AND, OR, NOT)
|
| Topic 11: Understanding Oracle Database Architecture - Database Storage Structures | - Describe tablespaces and data files
- Manage space in tablespaces
- Describe the logical and physical database structures
- Create and manage tablespaces
|
| Topic 12: Reporting Aggregated Data Using the Group Functions | - Describe group functions (AVG, SUM, MIN, MAX, COUNT)
- Use the HAVING clause to filter grouped data
- Use the GROUP BY clause to group data
|
| Topic 13: Using Single-Row Functions to Customize Output | - Use CASE and DECODE for conditional expressions
- Describe the use of conversion functions (TO_CHAR, TO_NUMBER, TO_DATE)
- Use character, number, and date functions in SELECT statements
- Describe various types of functions available in SQL
|
| Topic 14: Using Conversion Functions and Conditional Expressions | - Apply the NVL, NULLIF, and COALESCE functions
- Use the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions
- Use the CAST function for data type conversion
- Use nested functions
|
| Topic 15: Using the Set Operators | - Describe set operators (UNION, UNION ALL, INTERSECT, MINUS)
- Use set operators to combine multiple queries into a single query
|
| Topic 16: Displaying Data from Multiple Tables Using Joins | - Join a table to itself using self-join
- Use OUTER joins (LEFT, RIGHT, FULL)
- Describe different types of joins and their features
- Use Equijoins and Non-equijoins
- Use CROSS joins
|