Oracle training course
Oracle Database Administration training - 5 days - please call for a quote

Oracle training uk

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.
HOME
PROGRAMMING COURSES
BOOKING FORM
DATES
BESPOKE TRAINING
download Oracle training course outline as PDF
WIN A COURSE
Oracle Database Administration training uk

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
    invoker and definers rights

Oracle Database Administration 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 Recommended Reading:-

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

home book this course resources 01273 622272            info@siliconbeachtraining.co.uk

upProgramming Training

ADO.net Training
Analysis & Design Techiniques Training
ASP.net Training
ASP.net 2 Training
ASP Training
ASP with SQL Training
Business Analysis Essentials Training
Business Organisation Training
C++ Training
C# Training
Capturing & Engineering Requirements Training
Cisco Training
Citrix Training
Citrix Update Training
Coldfusion Training
Computer Security Training
Data Conversions Training

Data Modelling Training
DHTML Training

Disaster Recovery Management Training
Information & Communications Technology Training
Informix SQL Training
Java Training
JavaScript Training
JSP Training
Linux Training
MySQL Training
.NET Training
Object Oriented Modelling Training
Oracle Administration Training
PHP Training
PHP & MySQL Training
Relational Database Design Training
Requirements Engineering Training

Software Package Selection Training
Software Testing Training
Structured Query Language (SQL) Training
SQL Server Training
Systems Analysis Design Training
Systems Design Training
TCP/IP Training
Unix Training
VBA for Access Training
VBA for Excel Training
VB.net Training
VB.net Upgrade Training
Visual Basic Training
VBScript Training
XML Training
XSLT Training

upProgramming Training UK

ADO.net Training
Analysis & Design Techiniques Training
ASP.net Training
ASP.net 2 Training
ASP Training
ASP with SQL Training
Business Analysis Essentials Training
Business Organisation Training
C++ Training
C# Training
Capturing & Engineering Requirements Training
Cisco Training
Citrix Training
Citrix Update Training
Coldfusion Training
Computer Security Training
Data Conversions Training

Data Modelling Training
DHTML Training
Disaster Recovery Management Training
Information & Communications Technology Training
Informix SQL Training
Java Training
JavaScript Training
JSP Training
Linux Training
MySQL Training
.NET Training
Object Oriented Modelling Training
Oracle Administration Training
PHP Training
PHP & MySQL Training
Relational Database Design Training

Requirements Engineering Training
Software Package Selection Training

Software Testing Training
Structured Query Language (SQL) Training
SQL Server Training
Systems Design Training
TCP/IP Training
Unix Training
Visual Basic Training
VBA for Access Training
VBA for Excel Training
VB.net Training

VBScript Training
XML Training
XSLT Training

home | about us | bespoke training courses | course dates | course offers | training resources | contact | clients | book course

systems development training | six sigma training | training courses | business analysis & design training | programming training | image print & dtp training | office & business applications training | web design & internet training | video games & 3D training | business skills training | coaching mentoring training | human resources training | management leadership training | project management training | sales training | heather buckley photography |

assertiveness resource | photoshop resource | time management resource | leadership resource
train the trainer | management resource | PRINCE2 resource | six sigma resource