• +27 (0)21 418 4874

2KO International proudly offers Oracle 11g admin courses in Cape Town, South Africa for database administration.  2KO presents Oracle courses in Cape Town by means of full time instructor-led training; as well as internet-accessible online training, which are aimed at International IT Certification exams. 2KO International delivers computer courses from beginner level to advanced, and is also a leading supplier of of online IT training courses, enabling 2KO students the opportunity to study courses online world-wide, to ensure the best training possible.

5 Days

The Oracle Database 11g: Administration course will prepare you to become certified as an Oracle Database 11g Administrator Certified Associate as well as laying the foundation for the Oracle Database 11g Administrator Certified Professional certification. This course will cover some of the more in-depth database administration topics, such as configuration, security, backups, and recovery. These topics, along with a strong emphasis on database management, will prepare you for the exam.

Target Audience
This course is for anyone who is preparing for the Oracle Database 11g Administration I (1Z0-052) exam.

Database administrators, developers with data management responsibilities and others involved in the management or deployment of Oracle 11g databases. Oracle Database 11g basics, or equivalent experience will be of advantage.

Course Outline
Overview of Oracle 11g Administration

Your responsibilities as an Oracle 11g DBA
Configuring the instance and database
Maintaining security
Balancing user requirements and resources
Ensuring database availability

The Oracle 11g Architecture
Processing transactions with the server
Identifying types of Oracle 11g processes and memory structures
Determining database file structure
Archiving redo log information
Sizing the Result Cache for optimising repeated queries

Building an Oracle 11g Database
Creating the database
Setting the initialisation parameters
Simplifying memory allocation with memory targets
Establishing network connectivity
Converting from text-based to server parameter files
Configuring control files and redo log files

Starting and stopping the Database
Mounting and opening the database with SQL*Plus
Authenticating connections having SYSDBA privilege
Closing the database and shutting down the instance

Automating Database Management
The Oracle Enterprise Manager architecture
Navigating the graphical interface
Comparing command-line and graphical techniques

Administering with Database Control
Equipping Database Control to manage additional databases
Setting thresholds and generating alerts
Verifying changes in the data dictionary
Performing privilege management

Performing Flashback Operations
Managing space for rollback and read consistency
Configuring UNDO tablespaces
Monitoring expansion of rollback segments
Swapping to an alternative UNDO tablespace

Resetting Data to recent points in time with Flashback
Tracking changes to data values with row history
Obtaining transaction history with Flashback Transaction
Performing efficient recovery of data with Flashback Table
Retrieving dropped tables and dependent objects from the recycle bin

Securing the Database
Establishing user accounts
Authenticating users with sophisticated password checking
Allocating space quotas for user schemas
Limiting resource usage through profiles

Enforcing Security
Granting and revoking system and object privileges
Simplifying privilege management with roles
Preventing changes to read-only tables

Controlling Database Storage
Defining logical and physical structures
Creating, altering, and dropping tablespaces
Handling sort data efficiently with temporary tablespaces
Comparing traditionally managed and Oracle-managed files

Configuring Storage Patterns for Database Objects
Structuring data and index segments
Sizing database objects by defining extents and block occupancy
Eliminating row migration with PCTFREE and Data Pump
Compressing table data to conserve storage
Shrinking tables and indexes online to regain space

Partitioning to Support Administration and Availability
Creating table partitions and subpartitions
Selecting partitioning methods: range, list, hash, interval
Partitioning tables based on virtual columns
Setting up automatic partition allocation
Referencing the partitioning method in child tables
Administering partitions with merge, split, add and drop

Maintaining Index Partitions
Maximising performance with local and global indexes
Monitoring index partition usage
Rebuilding unusable indexes