Oracle Database Administration

Silicon Beach Training Ltd.
Brighton, East Sussex, United Kingdom

Course Format: Classroom | E-learning | Virtual Class | Online/Live | On-site/In-house | Blended | Self-paced

Course Description:

'' 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 ...''

Elements of this syllabus are subject to change.

Phone:+44 (0)1273 622272

School Address/Venue(s):

86 Gloucester Road
Brighton
East Sussex
BN1 4AP
UK

Jobs & Resumes: Brighton
Houses & Roommates: Brighton

Search other schools for Oracle Database Administration training resources.

XML
C++
C# & .NET
ColdFusion
Java
Javascript
Computer Security
Disaster Recovery Management
Linux
Unix
TCP/IP
Visual Basic
3D Studio Max
Vectorworks
Premiere
After Effects
Avid
Director

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Tips: ASKEDU jobs and talents message board can help you find jobs related to your experience in a specific city, or hire somebody in place with particular knowledges.