| 1 |
Understanding Oracle Database Architecture |
Instance and database components, memory structures, background processes, storage basics |
5% |
| 2 |
Managing Database Instances |
Starting and stopping instances, startup modes, initialization parameters, instance monitoring |
5% |
| 3 |
Managing Users, Roles and Privileges |
User creation, roles, system privileges, object privileges |
5% |
| 4 |
Managing Storage |
Storage structures, segments, extents, tablespace usage |
5% |
| 5 |
Moving Data |
Import and export concepts, data loading basics, data movement utilities |
4% |
| 6 |
Accessing an Oracle Database with Oracle supplied Tools |
SQL Developer, SQL*Plus concepts, connection methods, basic tool usage |
4% |
| 7 |
Configuring Oracle Net Services |
Network naming, listener basics, service names, connection configuration |
5% |
| 8 |
Managing Tablespaces and Datafiles |
Creating tablespaces, adding datafiles, resizing files, managing availability |
5% |
| 9 |
Managing Undo |
Undo concepts, undo tablespaces, retention, transaction recovery support |
4% |
| 10 |
Restricting and Sorting Data |
WHERE clause logic, ORDER BY, row filtering, query refinement |
5% |
| 11 |
Using Conversion Functions and Conditional Expressions |
Data type conversion, CASE expressions, NULL handling, conditional logic |
5% |
| 12 |
Displaying Data from Multiple Tables Using Joins |
Inner joins, outer joins, join conditions, self-join basics |
6% |
| 13 |
Using SET Operators |
UNION, UNION ALL, INTERSECT, MINUS operations |
4% |
| 14 |
Understanding Data Definition Language |
CREATE, ALTER, DROP statements, object definitions, constraints basics |
5% |
| 15 |
Managing Views |
Creating views, modifying views, read-only views, view usage rules |
4% |
| 16 |
Managing Data in Different Time Zones |
DATE and TIMESTAMP types, time zone awareness, conversions, formatting |
4% |
| 17 |
Retrieving Data using the SQL SELECT Statement |
SELECT syntax, column aliases, DISTINCT, row selection basics |
6% |
| 18 |
Using Single-Row Functions to Customize Output |
Character functions, numeric functions, date functions, formatting output |
5% |
| 19 |
Reporting Aggregated Data Using Group Functions |
COUNT, SUM, AVG, GROUP BY, HAVING clauses |
5% |
| 20 |
Using Subqueries to Solve Queries |
Nested queries, correlated subqueries, multiple-row subqueries, filtering results |
5% |
| 21 |
Managing Tables using DML statements |
INSERT, UPDATE, DELETE, transaction basics, row changes |
6% |
| 22 |
Managing Sequences, Synonyms, Indexes |
Sequence creation, synonym usage, index concepts, object access support |
4% |
| 23 |
Managing Schema Objects |
Tables, constraints, object relationships, schema-level object management |
5% |
