Concentrika poppy

About us

 

Oracle Academy

 

About the course
The course is intended for those who need to understand database technology and in particular, that offered by Oracle Corp. The objective is to offer the delegate a flavour for the various skills required in an Oracle support and development environment.


On the course you will learn the features of a RDBMS and Oracles’ management interfaces, both the GUI and the command line options. The course seeks to show delegates where everything is and how the components fit together. The course also serves as a high level introduction to SQL*PLUS, Oracle database administration and Oracle’s programming language PL/SQL.

Anyone wishing to progress towards full training in Oracle SQL or Oracle Database Administration or PL/SQL will find this training a useful launch-pad.
The training is very much hands on. Expect to leave the course with demonstrable, useful, practical skills.

Prerequisites
Delegates should have a general familiarity with IT and feel confident inputting commands into a computer, navigating GUI menus and accessing files on the filing system. Some of the overviews are fairly technical and an understanding of how IT fits together in general would be helpful. You should have some aptitude for computer programming.

Audience

  • IT specialists new to database technology
  • IT specialists migrating their existing skills to Oracle
  • Auditors and security staff who require a broad based technical overview of Oracle
  • Team leaders and managers on Oracle projects
  • Acquiring a basis of understanding for further specialist training in Oracle
  • Those seeking a career change, with a view to entering employment requiring Oracle skills
  • Front line or second line support
  • Developers who need a wider view of Oracle

Duration 5 days

Section 1
Understanding the need for databases		  
Designing systems
 Logical data modelling
Steps leading from design to implementation
Data design workshop
The SQL*PLUS client Oracle’s graphical user interface
Working within SQL*PLUS
The data dictionary
Oracle objects A introductory review of objects
Tables, views and indexes
Other schema objects
System objects
Workshop – implementing your system design
Section 2
The Oracle database product		  
The Oracle software family Database technology overview
The Oracle 8I family
Application development features
Data movement
Performance features
Management features
Oracle architecture

Instances and databases
Components of an Oracle database


Logfiles
Datafiles
Init.ora
Alert and trace logs
Controlfile
Networking Oracle (Net8) The Net 8 connectivity vision
TCP/IP architecture and Net 8
Oracle and the internet
3 tier architecture
Web enabling features
Oracle security Users and passwords
Permissions and privilege
Database roles
The audit subsystem
Section 3
An introduction to Oracle SQL		  
Why SQL? Where SQL is used
Select statement Structure of an SELECT statement
The WHERE clause
Column and table aliasing
Handling duplicates
Order by clause
IN lists
Predicates
Performing calculations
SQL functions MAX, MIN, AVG, SUM, COUNT
Character functions
Date functions
Conversion functions
Table joins and complex queries Simple joins
Inner and outer joins
Self joins
Data manipulation language (DML) INSERT
UPDATE
DELETE
Writing a trigger  
Section 4
Oracle database administration - overview		  
Introducing database administration Responsibilities of a DBA
Instance management Startup and shutdown using svrmgr
System parameters
Alter system, alter database, alter session
Tablespaces ORACLE Optimal Flexible Architecture (OFA)
Storage strategies
Managing the tablespace system object
Moving a tablespace
Monitoring tablespace growth
Internal organisation of datafiles Rollback Segments
Calculating storage requirements
Problems with data storage
In-block fragmentation
Chained rows
Bulk loading and unloading of data SQL*LOADER
EXPORT/IMPORT
Performance management Analyze table command
Query optimisation
Explain plan
   

 
Courses
schedule
Contact us