Oracle 10g

Oracle

As I have only just started my journey into the Oracle 10g DBA world, I wanted a site that covers the basics in order for me to gain my OCP and help me in remembering the vast information that comes with learning Oracle. As my journey continues the site will hopefully become more advanced and have more specialized areas such Data Guard, Oracle RAC, etc. I plan on creating cheat sheets that cuts out all the fluff for each area were appropriate but in the mean time a very good site can be located here.

The site has been comprised of reading the following books and real world experience, if you are new to Oracle I highly recommend that you should purchase these books as they contain far more information than this web site contains and of course the Oracle web site contains all the documentation you will ever need.

Data Modeling

	Relational Databases (Introduction)
	Normalization (Forms, ER Modeling)

Architecture

	Database Physical Structure (Data Blocks, Extents, Segments, Tablespace's)
	Oracle Processes (background processes)
	Database Memory Structure (SGA, PGA)
	Oracle Files (Control file, Redo log, pfile, spfile, password, alert log, trace files)
	Oracle OEM (Enterprise Manager)

Transactions Management, Locking and Concurrency

	Transaction Management
	Locking and Concurrency (Isolation, Lock Types, Multicurrent versioning)

Undo and Transaction Management

	Redo
	Undo (AUM)
	Flashback architecture
	Resumable space allocation

Installing, Creating and Upgrading databases

	Installing Oracle
	Creating a Database (Manually, DCBA)
	Upgrading a Database (Manually, DBCA)

Controlling Oracle

	Starting and Stopping Oracle (startup, shutdown)
	Operation Modes (restrict,quiesce)
	Obtaining Database information (database/instance info, version, etc)
	Oracle Default Port Numbers
	Database Control Agents

Tablespace Management

Tablespace's (types, creating, altering, dropping)

Schema and User Management

	Schema Management
	Users (creating, altering, dropping, quotas, profiles)
	Data Access (system privileges, object privleges, roles

Tables and Indexes

	Oracle Data Types (char, number, datatime, etc)
	Tables (heap-organized)
	Special Tables (temporary, IOT, clustered, partitioned)
	Indexes (bitmap, reverse-key, function-based, partitioned)
	Integrity Constraints (primary key, not null, check, unique, referential integrity)

View, Materialized Views, Sequences, Synonyms and Triggers

	Views
	Materialized Views
	Sequences
	Synonyms
	Triggers (DDL, DML, Compound, Instead-of, System Triggers)

Connectivity

	Networking and Connectivity architecture (dedicated, shared server)
	Listener

Users

	User Management
	Accessing Data (system privileges, object privileges, roles)
	Resource Management (resource plans, resource consumer groups)
	Fine-Grained Data Access (VPD)
	Auditing the Database (standard, FGA)

Data Loading

	Extraction, Transformation and Loading (introduction)
	SQL Loader
	External Tables
	Transforming Data
	Oracle Streams
	Data Pump Export and Import
	Transportable Tablespace's

Backups and Data Recovery

	RMAN backups
	Database Recovery (non-critical/critical files, incomplete recovery, user errors, flash recovery)
	Database Corruption (block corruption)

Operational Management

	Automatic Database Diagnostic Monitor (ADDM)
	Automatic Shared Memory Management (ASMM - SGA)
	Automatic Optimizer Statistics
	Automatic Storage Management (ASM)
	Automatic Segment Space Management (ASSM)

Managing and Monitoring the Database

	Performance Statistics
	Automatic Workload Repository (AWR)
	Server Alerts (ADDM)
	Active Session History (ASH)
	Management Advisory Framework (Oracle Advisors)
	Managing Database Links
	Oracle Scheduler

Performance Tuning

	SQL Optimization
	Join Methods (Natural, Inner and Outer)
	Tuning the Instance
	Performance Tuning Tools

Data Dictionary, Dynamic Views and Supplied Packages

	Oracle Data Dictionary
	Oracle PL/SQL Supplied Packages

SQL and PL/SQL

	Oracle Data Types (char, number, datetime, etc)
	Object Types (basics, getters and setters, static member methods, comparing objects, inheritance and polymorphism)
	SQL Primer (DDL, DQL, DML and DCL)
	PL/SQL Code Basics (Procedures, Functions, Exceptions, Bind Variables, Variable Types, Variable Scope, Conditional Logic)
	PL/SQL and SQL (Cursors)
	PL/SQL Packages (Variables, scope, definer v invoker rights)
	PL/SQL Advanced Programming (Dynamic SQL - NDS, DBMS_SQL Package)
	Collections (varrays, nested tables, associative arrays, bulk collect, forall)
	Large Objects (CLOB, NCLOB, BLOB and BFILES)
	Intersession Communications (dbms_pipe, dbms_alert)
	External Procedures (C and Java)
	Oracle Regular Expressions (REGEXP_COUNT, REGEXP_INSTR, REGEXP_LIKE, REGEXP_REPLACE, REGEXP_SUBSTR)

Books

OCA & OCP Exam Books
Sybex OCP Oracle 10g Admin I/II	Nice easy reading and good books to get you through the exams
Osbourne OCP Certification all-in-one exam guide	I always like two books on the same subject, so this book compliments the one above.
Advanced Oracle Books
Oracle Database 11g PL/SQL Programming - Michael McLaughlin	This book is more on the development side, it includes lots of the new 11g features and is one of the best books i have read, it explains things clearly without to much waffle (straight to the point).
Apress Expert Oracle Database 10G Administration - Sam.R.Alapati	This book is from the view of a Oracle DBA admin, although a heavy going book, I highly recommend it.
Apress Expert Oracle Database Architecture 9i and 10g programming techniques and solutions - Thomas Kyte	This book is more from the developer side and compliments the above book, this book is the next version of the excellent 'Expert one-to-one' series.
Osbourne Oracle 10g The Complete Reference - Kevin Loney	For a Oracle junior DBA this book is a good book to have on your desktop
Osbourne Oracle database 10g performance tuning Tips and Techniques - Richard Niemiec	This is an excellent book for tuning the database, has a excellent chapter on the mysterious x$ tables (advanced Oracle stuff).