Welcome to Premier

Your people are your most precious asset. Whether you are an existing Premier client, or a new customer looking to experience our services for the first time, welcome

ORACLE ARCHITECTURAL COMPONENTS
Defining an Oracle Database, the Oracle server, and the Oracle Instance
Establishing a connection and creating a session
Understanding the physical structure
Understanding the memory structure
Understanding the process structure
Understanding the logical structure
Outlining the stages of an SQL statement

GETTING STARTED WITH THE ORACLE SERVER
Identifying database administrative tools

IDENTIFYING THE FEATURES OF THE UNIVERSAL INSTALLER

DEFINING THE OPTIMAL FLEXIBLE ARCHITECTURE

CREATING A DATABSE DURING INSTALLATION

CREATING A NEW DATABASE

IDENTIFYING DATABASE ADMINISTRATIVE USERS
Understanding operating system and password file authentication SQL*Plus
Enterprise Manager

MANAGING AN ORACLE INSTANCE
Creating, managing, and using initialization files: PFILE and SPFILE
Identifying the various states of starting an instance
Identifying the various options available to shutdown an instance Monitoring Alert and Trace files

CREATING A DATABASE
Using the Database Configuration Assistant to create a database
Creating a database manually

USING THE DATA DICTIONARY
Identifying the uses and contents of the data dictionary
Using the data dictionary to retrieve information about the database

MAINTAINING THE CONTROL FILE
Explaining the uses of the control file
Listing the contents of the control file
Multiplexing the control file
Managing control file with Oracle Managed Files (OMF)
Obtaining control file information

MAINTAINING REDO LOG FILES
Explaining the purpose of and how online redo log files work
Control log switches and checkpoint
Maintaining online redo log files
Managing online redo log files using OMF
Multiplexing and maintaining online redo log files
Archiving online redo log files
Obtaining online and archived redo log file information

MANAGING TABLESPACES AND DATAFILES

STORAGE HIERACHY

4 Ravey Street
London EC2A 4QP
t: +44(0)20 7729 1811
f:+44(0)20 7729 9412
information@premiercs.co.uk

Premier's London Training Centre
42 New Broad Street, EC2

How to find us

Premier's most popular courses:

Excel VBA Training
Microsoft Project Training
Prince2 Practitioner
Excel Advanced Training
Sharepoint Designer
Visio Flowcharting