Chapter 1 Introduction to the Oracle Server Technologies

Position the Oracle Product Family
The Oracle Database - SQL, PL/SQL, Java
The Oracle Application Server
The Oracle Enterprise Manager - Database Control, Application Server Control, Grid Control

The Oracle Developer Suite - Forms, Reports, XML Publisher, Discoverer

Oracle E-Business Suite - accounting engine
accounting, human resources, manufacturing, customer relationship management, etc

Oracle Collaboration Suite - office automation tools
email, diary management, voicemail, fax, web conferencing, file serving

Explain Relational Structures
Normalization
Table (Relation, Entity)
Row (Record, Tuple)
Column (Attribute, Field) - Data Type (Numeric, Date-Time, Character), Fixed Length (CHAR), Variable Length (VARCHAR2)
Primary Key (Composite Key)
Foreign Key
Many-to-one relationship (Parent-child relationship)
Entity-Relationship Diagram (ERD)

Understand the SQL Language - set-oriented language
DML: SELECT, INSERT, UPDATE, DELETE, MERGE
DDL: CREATE, ALTER, DROP, RENAME, TRUNCATE, COMMENT
DCL: GRANT, REVOKE
TCL: COMMIT, ROLLBACK, SAVEPOINT

Appreciate the DBA's Role
Sizing application and server hardware
Oracle software installation and maintenance
Database physical design
Monitoring and tuning performance
Assisting developers with application design and tuning SQL
Laising with vendors, end users, developers, senior managment, and other support groups
Backup, restore, and recovery
User and security management