Overview of basic concepts of Oracle

In This Guide:

01 - An Introduction to Databases and Oracle

A background on data storage and management

02 - Database Installation and the OEM Console

Finding the appropriate version of Oracle for the specific data management needs

03 - Database Creation and Initialization

The Oracle Database Configuration Assistant (DBCA) as a GUI used to configure and create databases

04 - Oracle DBA - Tablespaces, Datafiles, and the Data Dictionary

Creating tablespaces, datafiles and data dictionary

05 - Oracle DBA - Users, Backup, and Export

How to manage users, backups and export in the Oracle DBA

06 - Normalization and Sample Schema Creation

Complying with certain guidelines in the database design process

07 - Basic Queries and Data Modification

Answering to basic queries and learning how to modify data

08 - Complex Queries, Views, and Synonyms

Learning how to work with complex queries, views, and synonyms

09 - Advanced Programming - PL/SQL

Writing structured programs in Oracle

10 - Oracle Reports and Forms through XE

Creating reports and forms through the Oracle Developer and Designer