Oracle Database 11g: Using SQL to Query Your Database
Using SQL in Oracle Database 11g
Retrieving, Restricting and Sorting Data
Using Single-Row Functions
Oracle Database 11g: Conversion Functions, Group Functions, and Joins
Conversion Functions and Conditional Expressions
Group Functions and Joins
Oracle Database 11g: Subqueries, Set Operators, and Data Manipulation
Using Subqueries and Set Operators
Oracle Database 11g: Using DDL, Views, Sequences, Indexes, and Synonyms
Using DDL Statements to Create and Manage Tables
Creating Other Schema Objects
Control privileges at the object and system level.
Use group operations to create reports.
Manage schema objects.
Search data using advanced subqueries.
Retrieve hierarchical data.
Manipulate data with subqueries.
Understand regular expression support.
Diagnose and repair data failures with Flashback technology.
Manage space to optimize database storage so you can respond to growing space requirements.
Monitor and manage major database components, including memory, performance and resources.
Secure the availability of your database through appropriate backup and recovery strategies.
Automate DBA tasks with the Scheduler.
Install Oracle Grid Infrastructure.
Create and manage users.
Install and configure an Oracle Database.
Create and manage storage structures.
Administer the Oracle Database.
Understand the Oracle database architecture and how its components work and interact with one another.
Perform backup and recovery.