Oracle Database Administration I (1Z0-082)

01

Module 1: Understanding Oracle Database Architecture

02

Module 2: Managing Database Instances

03

Module 3: Managing Users, Roles and Privileges

04

Module 4: Managing Storage

05

Module 5: Moving Data

06

Module 6: Accessing an Oracle Database with Oracle supplied Tools

07

Module 7: Configuring Oracle Net Service

08

Module 8: Managing Tablespaces and Datafiles

09

Module 9: Managing Undo

10

Module 10: Restricting and Sorting Data

11

Module 11: Using Conversion Functions and Conditional Expressions

12

Module 12: Displaying Data from Multiple Tables Using Joins

13

Module 13: Using SET Operators

14

Module 14: Understanding Data Definition Language

15

Module 15: Managing Views

16

Module 16: Managing Data in Different Time Zones

17

Module 17: Retrieving Data using the SQL SELECT Statement

18

Module 18: Using Single-Row Functions to Customize Output

19

Module 19: Reporting Aggregated Data Using Group Functions

20

Module 20: Using Subqueries to Solve Queries

21

Module 21: Managing Tables using DML statements

22

Module 22: Managing Sequences, Synonyms, Indexes

23

Module 23: Managing Schema Objects