Oracle Database 10g: Administration I Professional Training Solutions Ltd

Price: EUR 2,195

Location: Westland Square Pearse St Dublin 2 Ireland
Duration: 5 Days

Course details

The overall objective of this course is to allow the participant to gain the skills necessary for basic day-to-day administration of an Oracle10g database. This course is the starting for Oracle database administrators and also sets the foundation for advanced administrator training and certification.

Prerequisites:

Mandatory prerequisites for this course: ORACLE DATABASE 10G: INTRODUCTION TO SQL – COMPLETE LIBRARY,ORACLE DATABASE 10G: PROGRAM WITH PL/SQL – PART II

INSTALLING ORACLE 10G DATABASE SOFTWARE :

Identify database system requirements
The optimal flexible architecture (ofa)
Configure the installation environment
Installation using the universal installer
More about enterprise manager

EXPLORING THE ORACLE DATABASE ARCHITECTURE :

General database architecture
Database instance memory architecture

DATABASE INSTANCE PROCESS ARCHITECTURE :

About the instance process architecture
Instance background processes
Sql execution processes

CREATING AN ORACLE DATABASE :

Create a database
Configure & drop a database
Manage dbca templates
Manually creating a database

CONTROLLING THE DATABASE ENVIRONMENT :

Starting & stopping database control
Starting & stopping isql*plus
Starting & stopping the database listener
Starting & stopping the database
More about the database files
Handling parameter files & parameter settings

STORAGE STRUCTURES: TABLESPACES :

About tablespaces
Tablespace management

STORAGE STRUCTURES: ADVANCED TABLESPACES :

More about temporary tablespaces
About temporary tablespace groups
More about permanent tablespaces
More about bigfile tablespaces
More about the sysaux tablespace

STORAGE STRUCTURES: DATA FILES & TEMP FILES :

Managing data files
Managing temp files
About oracle-managed files (omf)

UNDO MANAGEMENT :

About undo space management
Configure undo management
Guarantee undo retention
Monitor undo space
Use the undo advisor

DATABASE SECURITY :

Database system privileges
Database object privileges
Audit database activity
Register for security updates

ADMINISTERING USERS :

Create & manage database accounts
Grant & revoke database privileges
Resource limits via profiles
Password management via profiles
About role-based security

MANAGING DATA: LOADING DATA WITH SQL LOADER :

About the database utilities
Using the loader
Understanding the loader process
Control file options • direct path loads

MANAGING DATA: EXPORTING & IMPORTING DATA :

Create directory objects
Expdp
Impdp oracle net services
What is oracle net services?
Oracle net manager
Listener configuration
Listener administration
Lsnrctl commands
Configuring client parameters
Isolating the problem
Oracle trace assistant
Network troubleshooting utilities

ORACLE SHARED SERVERS :

Shared servers architecture
Configuration of shared server mode

MONITORING & RESOLVING LOCK CONFLICTS :

About latches & locks
More about latches
More about locks

BACKUP & RECOVERY CONCEPTS :

About database backup & recovery
About redo data
Redo log file maintenance
Managing the archive options
More about the control file

Updated on 08 November, 2015

Course Location

Show map Location Westland Square Pearse St Dublin 2 Ireland

About Professional Training Solutions Ltd

Professional Training is a group of experienced specialists providing specific training and consultancy solutions, within Management Skills, I.T. systems, Human Restheirce Development, Credit Management, Sales, Finance and Engineering.

they believe in using a combination of tailored, flexible approaches and real-life business knowledge to develop and provide techniques and solutions for immediate implementation.

their recent projects include supporting major initiatives for clients in utilities, telecoms, manufacturing and software, covering:

restructuring for competitiveness

productivity improvements through updating work processes to match new technology

managing outstheircing

strategic financial planning and engineering

their methodology is to:

Work closely with clients to understand and help them prioritise their needs

Design and deliver the best mix of training activities and consultancy to establish the competencies required

Provide ongoing coaching to sustain the improved practices and processes

they create relevant, targeted, enjoyable, and interactive, training sessions which are designed to improve the retention of information by participants and create a clear link from the training to the workplace. This creates a planned, visible improvement in key business indicators such as productivity, motivation, loyalty, employee retention, and ultimately, profit.

their collaborative approach builds long-term relationships with clients. Together, they can deal effectively with the inevitable challenges all businesses face.

See all Professional Training Solutions Ltd courses

View more Virtual classroom training for Oracle online courses See all Oracle Courses

See all current Administration and Secretarial jobs in Ireland

Are you from Professional Training Solutions Ltd ? Claim your course!

Courses you can instantly connect with... Do an online course on Oracle starting now.