Home » Training Courses » Programming & Networking Training » Oracle Database Administration Training

Oracle Database Administration Training

5 days - please call for a quote

Oracle Database Administration is a skill that has been growing in demand over recent years, despite the downturn in the global economy. This Oracle Database Administration training course builds on the SQL*Plus and PL/SQL skills from the perspective of a technician responsible for creating and administering physical and logical file structures in this powerful relational database product.

Oracle Database Administration Training Course Objectives

• This Oracle Database Administration training course is intended for technical staff who are becoming responsible for creating and administering Oracle databases.
• Development staff may also benefit from attending this Oracle Database Administration training course, to gain an overview of the work of a Database Administrator to aid in developing effective systems that will be based on Oracle.

Oracle Database Administration Training Course Content

Database Administration:

• Memory, process and disk structure
• instances and databases
• storage structures
• backup and recovery
• SQL and database tuning
• network resource management

Oracle Architecture:

• Disk structures
• parameter files
• control files
• data files
• redo log files
• password files
• segments, extents and blocks
• memory areas
• shared pool
• buffer cache
• redo log buffer
• processes
• database writer
• log writer
• system monitor
• process monitor
• archiver
• processing overview

Creating a Database:

• Configuring the operating system
• privileged account authentication
• creating a parameter file
• creating a database
• creation commands
• post creation actions
• data dictionary management

Starting and Stopping Oracle:

• Instance processing overview
• startup command
• startup stages
• command options
• shutdown commands and options
• checking instance status
• using the alert logs
• trace files

Tablespaces, Datafiles and Rollback Segments:

• Structure review
• tablespace types
• system tablespace
• non-system tablespaces
• inside a tablespace
• locally managed and dictionary managed tablespaces
• datafiles
• tablespace and datafile management
• segments, extents and blocks
• rollback segment operations
• creating and managing rollback segments

Tables and Indexes:

• Creating tables
• data types
• creation and management commands
• inside a table
• table management (alter, drop, move)
• partitioned tables
• indexes
• creating indexes and setting storage criteria
• index management

Database Integrity:

• Creating, altering and dropping constraints
• enabling and disabling constraints
• constraints and indexes
• more on index types
• index-organised tables
• bitmap indexes
• reverse key indexes

User and Resource Management:

• User accounts overview
• resource profiles
• system and password limits
• profile management
• authentication choices - password, operating system, database
• users and tablespaces
• privileges and roles
• creating and managing user account
• tablespace quotas; data dictionary information

Privileges:

• User and system privileges
• assigning privileges to users
• using roles
• stored code privileges
• invoker and definers rights

Oracle Best Practices:

• User and system privileges
• assigning privileges to users
• using roles
• stored code privileges

Oracle Database Administration Training Course Prerequisites

• A grounding in relational database concepts; familiarity with the use of graphical user interfaces.
• Some expertise with both SQL and PL/SQL in an Oracle environment is expected.

Oracle Database Administration Training Course Recommended Reading:-

Effective Oracle by Design (Oracle Press S.) - Thomas Kyte - buy from amazon

Download course outline as pdf.