Detailed information
| Type: | Training |
|---|---|
| Method: | In a classroom |
| Accreditation: | N/A |
| Prepares for: | This course prepares delegates to use this product in their everyday work environment |
| Geared towards: | This Oracle Overview Seminar is designed to give delegates an understanding of the concepts of an Oracle database, its capabilities and features. A product overview will cover the basic features of the Oracle database such as Oracle architecture, database objects, transaction processing and security. By the end of this seminar delegates will be able to:- • identify the main features that are available with an Oracle database • understand the architecture of an Oracle database and to identify the Oracle data types and database structures |
| Requirements: | Delegates should be familiar with Information Technology concepts and computer terms and have a basic understanding of Relational Database systems. This can be obtained on the pre-requisite course. |
| Internship: | None |
| Students per class: | 10 |
Do you need further information?
Contact the person in charge , free and at no obligation, for information on how to enroll, enrollment limit/availability and more.
Course program
Skills Gained
The delegate will gain an understanding of:
• Relational Database concepts
• Grid Computing
• Oracle Database Server
• Oracle Application Server
• Oracle Applications
• Oracle Support Services
• Oracle Database Interfaces
• Oracle Database Objects
• Oracle Architecture
• Real Application Clusters
• Data Guard and Standby Databases
• Automatic Storage Management
• Flashback
• Data Recovery Advisor
• Proactive Health Checks
• Tool Sets for Administering and configuring an Oracle database
• Backup and recovery concepts
• Database optimization
Who will the Seminar Benefit?
This Oracle Overview Seminar is designed for decision makers, managers, project managers, system analysts and people with some technical background who want an overview of the capabilities of the Oracle database.
Course Contents - DAY 1
Course Introduction
• Administration and Course Materials
• Course Structure and Agenda
• Delegate and Trainer Introductions
Session 1: DATABASE CONCEPTS
• Database Management Systems
• Relational Database Structures
• The Data Dictionary
• Supported Data Types
Session 2: ORACLE PRODUCT OVERVIEW
• Oracle Product Overview
• Grid Computing
• Oracle Database Server
• Oracle Application Server
• Oracle Applications 11i/R12
• Oracle Support Services
Session 3: DATABASE INTERFACES
• Interacting with an Oracle Database
• Structured Query Language
• Access a Database using SQL*Plus
• Access a Database using SQL Developer
• PL/SQL Objects
• Web Based Management and Development Tools
• Java
• Extensible Markup Language (XML)
• Oracle Programming Interfaces
• Database Utilities
• Oracle Connectivity Products
Session 4: ORACLE DATABASE OBJECTS
• Logical Database Structure
• Tablespaces and Datafiles
• Tables
• Views
• Indexes
• Sequences
Session 5: ORACLE DATABASE 10G AND 11G ARCHITECTURE
• Oracle Architecture
• Oracle Instance
• Memory Structures
• Parameter Initialization Files
• Oracle Background Processes
• Server and Client Processes
• The Oracle Database
Session 6: HIGH AVAILIBILITY
• Real Application Clustering
• Data Guard and Standby Databases
• Automatic Storage Management
• Flashback
• Data Recovery Advisor
• Proactive Health Checks
Session 7: DATABASE SECURITY
• Users and Schemas
• Privileges and Roles
• Synonyms and Links
• Password Management
• Auditing
• Virtual Private Databases
• Oracle Label Security
• Database Resource Manager
• Fined Grained Auditing
• Transparent Tablespace Encryption
Session 8: ADMINISTERING AND CONFIGURING A DATABASE
• Administrative Tools available to a DBA
• Using Oracle Enterprise Manager to manage a database
• Create a Database with DBCA
• Backup and Recovery Concepts
• Database Templates
• Overview of Backup, Restore and Recover
• Tuning Information Sources
The delegate will gain an understanding of:
• Relational Database concepts
• Grid Computing
• Oracle Database Server
• Oracle Application Server
• Oracle Applications
• Oracle Support Services
• Oracle Database Interfaces
• Oracle Database Objects
• Oracle Architecture
• Real Application Clusters
• Data Guard and Standby Databases
• Automatic Storage Management
• Flashback
• Data Recovery Advisor
• Proactive Health Checks
• Tool Sets for Administering and configuring an Oracle database
• Backup and recovery concepts
• Database optimization
Who will the Seminar Benefit?
This Oracle Overview Seminar is designed for decision makers, managers, project managers, system analysts and people with some technical background who want an overview of the capabilities of the Oracle database.
Course Contents - DAY 1
Course Introduction
• Administration and Course Materials
• Course Structure and Agenda
• Delegate and Trainer Introductions
Session 1: DATABASE CONCEPTS
• Database Management Systems
• Relational Database Structures
• The Data Dictionary
• Supported Data Types
Session 2: ORACLE PRODUCT OVERVIEW
• Oracle Product Overview
• Grid Computing
• Oracle Database Server
• Oracle Application Server
• Oracle Applications 11i/R12
• Oracle Support Services
Session 3: DATABASE INTERFACES
• Interacting with an Oracle Database
• Structured Query Language
• Access a Database using SQL*Plus
• Access a Database using SQL Developer
• PL/SQL Objects
• Web Based Management and Development Tools
• Java
• Extensible Markup Language (XML)
• Oracle Programming Interfaces
• Database Utilities
• Oracle Connectivity Products
Session 4: ORACLE DATABASE OBJECTS
• Logical Database Structure
• Tablespaces and Datafiles
• Tables
• Views
• Indexes
• Sequences
Session 5: ORACLE DATABASE 10G AND 11G ARCHITECTURE
• Oracle Architecture
• Oracle Instance
• Memory Structures
• Parameter Initialization Files
• Oracle Background Processes
• Server and Client Processes
• The Oracle Database
Session 6: HIGH AVAILIBILITY
• Real Application Clustering
• Data Guard and Standby Databases
• Automatic Storage Management
• Flashback
• Data Recovery Advisor
• Proactive Health Checks
Session 7: DATABASE SECURITY
• Users and Schemas
• Privileges and Roles
• Synonyms and Links
• Password Management
• Auditing
• Virtual Private Databases
• Oracle Label Security
• Database Resource Manager
• Fined Grained Auditing
• Transparent Tablespace Encryption
Session 8: ADMINISTERING AND CONFIGURING A DATABASE
• Administrative Tools available to a DBA
• Using Oracle Enterprise Manager to manage a database
• Create a Database with DBCA
• Backup and Recovery Concepts
• Database Templates
• Overview of Backup, Restore and Recover
• Tuning Information Sources
Do you need clarification regarding the course program?
Contact the person in charge , free and at no obligation, for information on how to enroll, enrollment limit/availability and more.
Course location
- c/o YSES, The Enterprise Suite, 9th Floor Centre City Tower, 5-7 Hill Street, Birmingham B5 4UA - B5 4UACity and Borough of Birmingham (England)
- c/o ComputerWorld, Apex House, Westerleigh Business Park, Turner Drive, Yate, Bristol, BS37 5YX - BS37 5YCity of Bristol (England)
- 16 St Mary's Street, Edinburgh, EH1 1SU - EH1 1SUCity of Edinburgh (Scotland)
- Halsbury House, Chancellor Court, 21 The Calls, Leeds, LS2 7EH - LS2 7EHCity and Borough of Leeds (England)
- c/o YSES, St James Court, 30 Brown Street, Manchester, M2 1DH - M2 1DHCity and Borough of Manchester (England)
StayAhead Training
StayAhead Training established 1992, centres throughout the UK...... with a team of full time dedicated professional training consultants......
StayAhead Training has been established since 1992 and is one of the UK's leading independent providers of Oracle, Unix, Linux, MySQL, Java, PHP Web Deveopment, ITIL & Business Analysis training.
Scheduled courses are available in 6 centres throughout the UK including London, Birmingham, Manchester, Bristol, Leeds and Edinburgh. We also provide training on our client's premises, this training can be tailored to the specific needs of the client.
Our courses have been designed to ensure that people can fulfil their job role and also help prepare delegates for certification in Oracle, Red Hat, Solaris, MySQL, Linux, SUSE Linux, Java, ITIL, Business Analysis and HP-UX .
Working in association with both the Oracle (OUG) and Hewlett Packard (HPUG) User Groups, StayAhead Training have a reputation of providing high quality value for money training at a cost effective price.
Our quality is assured by a team of dedicated professional training consultants who work full time for StayAhead Training and who blend their training skills with a wealth of hands-on experience.
StayAhead Training has been established since 1992 and is one of the UK's leading independent providers of Oracle, Unix, Linux, MySQL, Java, PHP Web Deveopment, ITIL & Business Analysis training.
Scheduled courses are available in 6 centres throughout the UK including London, Birmingham, Manchester, Bristol, Leeds and Edinburgh. We also provide training on our client's premises, this training can be tailored to the specific needs of the client.
Our courses have been designed to ensure that people can fulfil their job role and also help prepare delegates for certification in Oracle, Red Hat, Solaris, MySQL, Linux, SUSE Linux, Java, ITIL, Business Analysis and HP-UX .
Working in association with both the Oracle (OUG) and Hewlett Packard (HPUG) User Groups, StayAhead Training have a reputation of providing high quality value for money training at a cost effective price.
Our quality is assured by a team of dedicated professional training consultants who work full time for StayAhead Training and who blend their training skills with a wealth of hands-on experience.