I’ve decided that while my wife is studying for her upcoming GMATs, I’m going to study for my Oracle 11g Certified Associate credential (after all, it is a recommended certification). For those of you following along, I’ve changed from 10g to 11g. Might as well get the most recent credential.
So begins a series of posts that will serve as a reference for me, while I study over the next month, in the hopes of taking the first of two exams sometime in February ’09.
Structured Query Language (SQL)
Three separate languages in one form:
Data Definition Language (DDL) – create/maintain database objects
Data Control Language (DCL) – create/maintain users and permissions
Data Modification Language (DML) – add/update/delete data
Oracle Database Objects
Besides the most common objects (e.g., table, row, column, cell, constraint, etc.), here are a few that I’ll need to reference in the future:
Index-organized Table –Similar to a table, except the data is stored based on the index definition, as opposed to randomly (or on a heap)
Cluster – A storage-mechanism object that must be preallocated. Helps to organize multiple, related tables in the same block to reduce the amount of database reads.
User-defined datatype – Can be used to create consistency and apply methods as part of the definition.
Oracle Data Dictionary
Base tables, owned by SYS, contain the meta data for user-defined database objects. Use views to access base tables, as base table names are purposefully cryptic.
USER_ views – Objects owned by schema user.
ALL_ views – Objects owned by the schema user or objects to which the schema user has privileges.
DBA_ views – Privileges required. All objects and utilized by DBAs.
Beyond the obvious ones (to me anyway!), here’s some others:
Sizing and evaluating server hardware,
Planning and designing the database structure
Posted via Woodland Blog (http://dramse01.blogspot.com)