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.
Please feel free to email me any constructive criticism you have with the site as any additional Oracle knowledge or mistakes that i have made would be most welcomed.
CheatsheetCheatsheet |
Relational Databases (Introduction) | |
Normalization (Forms, ER Modeling) |
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) |
Transaction Management | |
Locking and Concurrency (Isolation, Lock Types, Multicurrent versioning) |
Redo | |
Undo (AUM) | |
Flashback architecture | |
Resumable space allocation |
Installing Oracle | |
Creating a Database (Manually, DCBA) | |
Upgrading a Database (Manually, DBCA) |
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's (types, creating, altering, dropping) |
Schema Management | |
Users (creating, altering, dropping, quotas, profiles) | |
Data Access (system privileges, object privleges, roles |
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) |
Views | |
Materialized Views | |
Sequences | |
Synonyms | |
Triggers (DDL, DML, Compound, Instead-of, System Triggers) |
Networking and Connectivity architecture (dedicated, shared server) | |
Listener |
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) |
Extraction, Transformation and Loading (introduction) | |
SQL Loader | |
External Tables | |
Transforming Data |
|
Oracle Streams | |
Data Pump Export and Import | |
Transportable Tablespace's |
RMAN backups | |
Database Recovery (non-critical/critical files, incomplete recovery, user errors, flash recovery) | |
Database Corruption (block corruption) |
Performance Statistics | |
Automatic Workload Repository (AWR) | |
Server Alerts (ADDM) | |
Active Session History (ASH) | |
Management Advisory Framework (Oracle Advisors) | |
Managing Database Links | |
Oracle Scheduler |
SQL Optimization | |
Join Methods (Natural, Inner and Outer) | |
Tuning the Instance | |
Performance Tuning Tools |
Oracle Data Dictionary | |
Oracle PL/SQL Supplied Packages |
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) |
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). |