Oracle Database 11g: Data Warehousing Fundamentals

Modules

Hide all

Introduction to Oracle Database 11g (3 topics)

• Relational database concepts
• Database administration tasks
• DBA responsibilities

Oracle Database 11g Architecture (7 topics)

• Oracle database architecture
• The Oracle instance
• Memory structures
• Background processes
• Server and client processes
• The Oracle database
• Overview of Oracle ASM architecture

Installation and Configuration of an Oracle Database (12 topics)

• System Hardware Requirements
• Optimal Flexible Architecture
• Authentication methods for a database
• Oracle environment variables
• Install Oracle software using the Oracle Universal Installer (OUI)
• Silent Install
• Use the database Configuration Assistant (DBCA)
• Create a database with DBCA
• Manage a database with DBCA
• Delete a database with DBCA
• Manage Templates using DBCA
• Upgrade a database using Database Upgrade Assistant (DBUA)

Administer a Database Instance (8 topics)

• Administrative tools available to a DBA
• Using SQL*Plus in Oracle to manage a database
• Administer the database using Enterprise Manager (EM)
• Start and stop the EM Database Console
• Access EM
• EM navigation
• Grant EM administrative privileges to a user
• Overview of Oracle Restart

Configure the Oracle Network Environment (14 topics)

• Overview of network configuration
• Oracle Net Listener configuration and management
• Oracle Net Naming methods
• Tools for configuring and managing the Oracle network
• Use Enterprise Manager to create and configure the Listener
• Configure client connections with Net Manager
• View listener configuration
• Start and stop the Oracle listener
• Enable Oracle Restart to monitor the listener
• Use TNSPING to test Oracle Net connectivity
• Connect to the database
• Configure Net Services with Enterprise Manager
• Overview of Shared Server architecture
• Identify when to use Shared Servers and when to use Dedicated Servers

Manage an Oracle Instance (10 topics)

• Access an Oracle database
• Database authentication methods
• Password file
• The Startup Process
• The Shutdown Process
• Initialization parameters
• Shutdown a database and instance using SQL
• Startup a database and instance using SQL
• View alert log and trace files
• View or modify initialization parameters with EM

Tablespace and Datafile Management (13 topics)

• Overview of tablespaces and datafiles
• Use EM to view the storage structure of the database
• Create and alter tablespace commands
• Locally managed tablespaces
• Dictionary managed tablespaces
• Bigfile tablespaces
• Temporary tablespaces
• Multiple temporary tablespaces
• Create tablespaces
• Manage tablespaces
• Use standard and non-standard block sizes
• Create and manage tablespaces using OMF
• Drop tablespace command

Manage Redo Logs (12 topics)

• Redo log overview
• Plan redo logs
• Redo log data dictionary tables
• Log switches and checkpoints
• Log file maintenance
• Add and drop log file members and groups
• Clear a log file
• Move or rename an online redo log file
• Multiplex redo log files
• Use EM to manage redo logs
• Manage online redo log files with OMF
• List redo log information

Manage Control Files (8 topics)

• The usage of the control file
• The contents of a control file
• Manage control files
• Replace a lost or damaged control file
• Mirror a control file
• Standby control file
• Manage control files with OMF
• List control file information

Manage Schema Objects (9 topics)

• Create a new table
• View the attributes and contents of a table
• Understand data integrity
• Define constraints
• Alter tables
• Create indexes
• View index attributes
• Create views
• Create and use sequences

Manage Users (10 topics)

• Database administration accounts
• User accounts
• Create a user account
• Operating system authentication
• Change a user's password
• Manage a user account
• Drop a user account
• Monitor user information
• Terminate user sessions
• Product user profiles

Manage Profiles and Resources (7 topics)

• Overview of user profiles
• Profile resource parameters
• Create profile command
• Manage passwords with profiles
• Control resource usage with profiles
• Maintain profiles
• Drop profiles

Managing Privileges (11 topics)

• Database access
• Oracle supplied roles
• System level privileges
• Object level privileges
• The grant and revoke commands
• Create roles
• Modify and drop roles
• Control the availability of roles
• Use predefined roles
• Synonyms
• Listing valid grants

Database Auditing (8 topics)

• Overview of database auditing
• Auditing SYS statements
• Auditing end user sessions
• Statement auditing
• Privilege auditing
• Auditing modifications made to database objects
• Audit table relocation
• Auditing from Enterprise Manager

Undo Management (11 topics)

• Undo data overview
• Monitor and administer undo
• Configure undo retention
• Switch undo tablespaces
• Specify the retention period
• Guarantee undo retention
• Retention period for flashback queries
• View undo space information
• Use the undo advisor
• Size the undo tablespace
• Manage undo with EM

Moving Data (15 topics)

• Create directory objects
• Data Pump Export and Import
• Data Pump architecture
• Data Pump data dictionary views
• Data Pump interactive mode
• Data Pump API
• Use Data Pump to export data
• Use Data Pump to import data
• SQL Loader
• Overview of SQL Loader
• Command line parameters