Oracle 11g Administrator Class
Oracle 11g Administrator Courses in Cape Town
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 consulting services, in the IT and Business space, as well as being a training provider for IT certification and user level courses. Training can be any blend of bespoke, classroom and online learning, enabling 2KO students the opportunity to study courses online world-wide, to ensure students have access to the best training possible.
Overview
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.
Pre-requisites:
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
Duration:
5 Days