1.0 Understanding Oracle Database Architecture Weight not published

1.1Oracle Database: Administration Workshop
Understanding Oracle Database Instance Configurations; Understanding Oracle Database Memory and Process Structures; Understanding Logical and Physical Database Structures; Understanding Oracle Database Server Architecture

2.0 Managing Database Instances Weight not published

2.1Oracle Database: Administration Workshop
Starting Up Oracle Database Instances; Using Data Dictionary Views; Shutting Down Oracle Database Instances; Using Dynamic Performance Views; Using the Automatic Diagnostic Repository (ADR); Using the Alert Log and Trace Files; Managing Initialization Parameter Files

3.0 Managing Users, Roles and Privileges Weight not published

3.1Oracle Database: Administration Workshop
Assigning Quotas to Users; Applying the Principal of Least Privilege; Creating and Assigning Profiles; Administering User Authentication Methods; Managing Oracle Database Users, Privileges, and Roles

4.0 Managing Storage Weight not published

4.1Oracle Database: Administration Workshop
Managing Resumable Space Allocation; Shrinking Segments; Deferring Segment Creation; Using Space-Saving Features; Deploying Oracle Database Space Management Features; Managing Different Types of Segments; Using Table and Row Compression; Understanding Block Space Management

5.0 Moving Data Weight not published

5.1Oracle Database: Administration Workshop
Using External Tables; Using Oracle Data Pump; Using SQL*Loader

6.0 Accessing an Oracle Database with Oracle supplied Tools Weight not published

6.1Oracle Database: Administration Workshop
Using the Database Configuration Assistant (DBCA); Using Oracle Enterprise Manager Cloud Control; Using Oracle Enterprise Manager Database Express; Using SQL Developer; Using SQL Plus

7.0 Configuring Oracle Net Services Weight not published

7.1Oracle Database: Administration Workshop
Using Oracle Net Services Administration Tools; Configuring Communication Between Database Instances; Configuring the Oracle Net Listener; Connecting to an Oracle Database Instance; Comparing Dedicated and Shared Server Configurations; Administering Naming Methods

8.0 Managing Tablespaces and Datafiles Weight not published

8.1Oracle Database: Administration Workshop
Viewing Tablespace Information; Creating, Altering and Dropping Tablespaces; Managing Table Data Storage; Implementing Oracle Managed Files; Moving and Renaming Online Data Files

9.0 Managing Undo Weight not published

9.1Oracle Database: Administration Workshop
Understanding Transactions and Undo Data; Storing Undo Information; Configuring Undo Retention; Comparing Undo Data and Redo Data; Understanding Temporary Undo

10.0 Restricting and Sorting Data Weight not published

10.1Oracle Database: Introduction to SQL
Applying Rules of precedence for operators in an expression; Limiting Rows Returned in a SQL Statement; Using Substitution Variables; Using the DEFINE and VERIFY commands; Using Conversion Functions and Conditional Expressions

11.0 Displaying Data from Multiple Tables Using Joins Weight not published

11.1Oracle Database: Introduction to SQL
Using Self-joins; Using Various Types of Joins; Using Non equijoins; Using OUTER joins

12.0 Using SET Operators Weight not published

12.1Oracle Database: Introduction to SQL
Matching the SELECT statements; Using the ORDER BY clause in set operations; Using The INTERSECT operator; Using The MINUS operator; Using The UNION and UNION ALL operators

13.0 Understanding Data Definition Language Weight not published

14.0 Managing Views Weight not published

15.0 Managing Data in Different Time Zones Weight not published

15.1Oracle Database: Introduction to SQL
Working with CURRENT_DATE, CURRENT_TIMESTAMP, and LOCALTIMESTAMP; Working with INTERVAL data types

16.0 Retrieving Data using the SQL SELECT Statement Weight not published

16.1Oracle Database: Introduction to SQL
Using Column aliases; Using The DESCRIBE command; Using The SQL SELECT statement; Using concatenation operator, literal character strings, alternative quote operator, and the DISTINCT keyword; Using Arithmetic expressions and NULL values in the SELECT statement

17.0 Using Single-Row Functions to Customize Output Weight not published

17.1Oracle Database: Introduction to SQL
Manipulating strings with character functions in SQL SELECT and WHERE clauses; Performing arithmetic with date data; Manipulating numbers with the ROUND, TRUNC and MOD functions; Manipulating dates with the date function

18.0 Reporting Aggregated Data Using Group Functions Weight not published

18.1Oracle Database: Introduction to SQL
Restricting Group Results; Creating Groups of Data; Using Group Functions

19.0 Using Subqueries to Solve Queries Weight not published

19.1Oracle Database: Introduction to SQL
Using Single Row Subqueries; Using Multiple Row Subqueries

20.0 Managing Tables using DML statements Weight not published

20.1Oracle Database: Introduction to SQL
Managing Database Transactions; Using Data Manipulation Language; Controlling transactions

21.0 Managing Sequences, Synonyms, Indexes Weight not published

21.1Oracle Database: Introduction to SQL
Managing Indexes; Managing Synonyms; Managing Sequences

22.0 Managing Schema Objects Weight not published

22.1Oracle Database: Introduction to SQL
Creating and using temporary tables; Managing constraints

Oracle Database Administration I (1Z0-082) (1Z0-082) Exam Blueprint