|
Oracle One-day Overview
This course gives a technical overview of
ORACLE and of SQL, the Structured Query Language used to access a
Relational Database It is based on the ORACLE 8i relational database
but the principles learnt may be applied to databases as diverse as
Microsoft SQL Server, Access and DB2..
Select here for related courses |
Select here for a list of all courses |
OBJECTIVES OF THE COURSE
To take students with minimal or no
database or SQL knowkedge up to level which will allow them to
understand the functions of a database and databse query language.
| COURSE CODE |
OV1 |
TUTORS |
Ken
Marr email |
| DURATION |
1 day |
VENUE |
Harwell Training Centre ** |
| PRICE |
£350 plus VAT * |
BOOKING CONTACT |
Mick
Hosegood email |
| EXPERIENCE LEVEL |
Beginner |
TECHNICAL CONTACT |
Mick
Hosegood email |
*see note at bottom for special savings!
for pricing for a course run especially for your organisation, please
use our worksheet **Also available on your site for groups of four to
ten.
COURSE DATES:
|
Scheduled on demand
and on-site
|
|
Call for dates
|
INTENSITY: About 40% of the course is
practicals, and 60% lectures.
RESOURCE: Each student will have
exclusive use of a computer workstation for the duration of the course.
Each student will be provided with a full set of training notes
relating to the course.
PREREQUISITES: Computer Literacy
would be an advantage, but no previous experience is assumed.
FOLLOW UPS: First Alternative offer a
variety of Oracle courses: Oracle PL/SQL - Oracle SQL*PLUS, PL/SQL course - Oracle PL/SQL Oracle Database
Administration - Oracle Database
Administration, Oracle Backup and Recovery Workshop - Oracle Backup and Recovery Workshop
PRACTICALS / TAKEAWAYS: Each student
leaves the course with his own set of training notes for the material
covered.
SOFTWARE VERSIONS: This course is
based on Oracle 8.
TOPICS COVERED ON THE COURSE
Introduction
Objectives, Course Schedule, Course
Introductions, Pre-requisites, Bibliography, Delegate
Responsibilities, Course Content, Relational Databases Objectives, What
is a Database? What is a Relational Database? Types of
Relationship, Tables, Rows and Columns, Primary Key, Secondary
Indexes, Foreign Key, Referential Integrity, What is ORACLE 8, 8i, 9i,
The ORDERS Tables, Entity Models, Course Tables Handout
Components of Oracle
Objectives, ORACLE System Architecture, How
Oracle Works, What is an RDBMS?, Structured Query Language, Why Use
SQL? Tools Available, Designer/2000 and Developer/2000, Enterprise
Manager, Personal Edition, Third Party Tools, What is SQL*Plus?,
Starting SQL*Plus, The Oracle Technology Network, Accessing the Oracle
Documentation
Using SQL
Objectives, Select Statement, SQL*Plus
Commands, Where Clause, Datatypes, Nulls, Using Dates, Order By
Clause, IN Operator, BETWEEN Operator, LIKE Operator, Common Errors,
IS NULL Operator, Comments, Create Table, Create Index, Drop, Insert,
Update, Commit, Rollback, Delete, Calculations, Rounding, Column Alias,
Cartesian Product, Table Join, Selecting the Join Column, Views,
Functions, Sub Selects
PL/SQL
Objectives, What is PL/SQL?, Why Use
PL/SQL?, Block Structure, Sample Code, Accepting User Input,
Variables, SELECT Statement
Utilities
Objectives, What is a Utility?, Export,
Import, Loading Data, Appending Data
Networking
Objectives, What is Client/Server?, What is
Oracle Net8?, What is ODBC?, How Net8 Works, Naming Resolution, Client
Configuration, Server Configuration, The Lsnrctl Utility
DBA Tasks
Objectives, Database Management Tasks, What
Tools are Available?, What is Server Manager?, Logging On the DBA,
Starting Server Manager, Connecting to the Database, Starting Up the
Database, Shutdown, Using SQL*Plus in Oracle 8i, What is a User?, What
is a Privilege?, What is a Role?, What is a Profile?, Creating a User,
Granting Privileges, Creating a Role, Creating a Profile, Giving a
Profile to a User, Changing the Password
Backup and Recovery
Objectives, What is a Backup?, What is
Recovery?, Backup and Recovery Management Tasks, The Backup Process -
Choosing a Method, Operating System Backup Without Archiving,
Advantages and Disadvantages of Off-line Backup, Operating System Backup
With Archiving, Advantages and Disadvantages of Online Backup,
Recovery Manager
|
Home 