future of dbas seminar ireland

8/4/2019 Future of DBAs Seminar Ireland

1/42

Joel GoodmanSenior Principal Trainer

Oracle 9i & 10g Certified Master

The Future Role of The DBA


2/42

About Me

Application Development and Support 1976 to 1982 Software Development and Consultancy 1983 to 1986

IT Training Mainframe Technology 1986 to 1993

Oracle Support 1994 to 1996

Oracle University 1997 to Present

OCP DBA 1997 to Present - Releases 7.3 to 10g Oracle 9i OCM DBA from 2002 10g from 2006

DBA Curriculum Delivery: Basic, Advanced, DSI

Technical Advisor to the OCP/OCM Quality Review Team

Member DBA Curriculum Quality Review Team

Member Oak Table Network

[email protected]


3/42

AGENDA

DBA, your job today and tomorrow

How to Maintain and Upgrade Your Skill Set

Why choose Oracle University?

Oracle9i

The solution to your expectations

Oracle10g

The solution to your expectations


4/42

Your job today and tomorrowDBA Oracle


5/42

DB Admin 10+ Years Ago

Your environment was Only a few databases

Some servers

Administration by command line

Data recovery of closed databases bythe OS

Passive end-user terminal/windows

Small number of users


6/42

DB Admin 5 to 10 Years ago

Your environment was

Many databases

Several servers, several OSs

Multiple administration tools Automated data recovery

Network of companies

Windows end-user terminal

Larger number of users

Linux

Windows

Unix


7/42

DB Admin going forward

Your environment is / was Large number of databases

Many servers

Higher volume of data to be managed

Partitioned databases

Clustered Architectures

Need for high availability

Centralised administration

Application servers

Ever Increasing numbers of users Secure networks and Firewalls

R AC


8/42

24 eStudies :

Spatial, Dataguard, Oracle Text, Stream, Backup andRecovery, Clustering, Security, Performance Management,Space Management

Oracle 10g : New training in 2006

The courses have been rewritten to take the release of Oracle10g R2 into account. Their production is progressive.

The courses for the next version (11) are already being preparedat the same time as the product

The product evolves, the training changes


9/42

Why chooseOracle

University?


10/42

Why Choose Oracle University

Learn Oracle from the experts All OU UK and Ireland DBA trainers are OCP Best range of advanced DBA curriculum Maintain your skill set across releases Obtain new skills needed in your environment One course required to attain OCP Two courses required to attain OCM


11/42

Oracle 9i


12/42

Database Administration 9i

SQLP (5 days)DBA-II(5 days)

EXAM

OCAEXAMOCP

DBA-I (5 days)Tuning(5 days)

-Seminar -Course -Certification exam

DB SECURITY(3 days)

EXAMOCM

RAC 9i(3 days)

DATA GUARD(3 days)

SQL TUNING(3 days)

STREAMS(5 days)

ADV BACKRMAN

(3 days)

STATSPACK(1 day)

RAC9i - LINUX(2 days)

ADV-TUNING(1 day)

ADM DWH

(3 days)

PARTITIONING

(2 days)

OEM 9i(4 days)


13/42

Oracle Administrator 9i

Your expectation: To know how toadminister a database

Our solution: the fundamental course

SQLP (5 days)DBA-II(5 days)

EXAMOCA

EXAMOCP

DBA-I (5 days)Tuning(5 days)


14/42

Oracle 9iAdministrator

DBA-I: Fundamentals 5-day DBA training- Part 1For all DBAs starting to administer Oracle databases on an 8i, 9ienvironment.

To identify the different components of the Oracle architecture

To create, start up and shut down a database, to keep the databaseoperational for users

To administer control files, log files, data files, table spaces

To administer database objects (tables, index) and annulationsegments

To administer the users, security and resources

This course is independent of the OS on which Oracle is installed

Oracle 9i Database Fundamentals I Course

4th September

4th December


15/42

Oracle 9iAdministratorDBA-II: Fundamentals 5-day DBA training Part 2

For all DBAs who want to continue their training by implementingdata recovery and managing the network

To configure the network to allow access to the database

To understand the architecture of the database related to backup and

recovery operations To list and apply backup methods and recovery operations that can

be used to resolve database failure

To understand and use RMAN

To use the import and export utilities

This course is independent of the OS on which Oracle is installed

A complete workshop will let you resolve practical examples

Oracle 9i Database Fundamentals II Course in Dublin

18th September, 11th December


16/42


TUNING:Fundamentals 5-day DBA training Part 3For all DBAs who wish to use the Oracle database in an optimumway by means of adapted performance management

To identify and resolve current problems linked to performance

Supervising and optimising the management of memory

To use Oracle tools, such as Enterprise Manager, Statspack to setyour Oracle database in order to optimise performance

To identify performance problems linked to requests. To pullstatistics with DBMS_STATS

To optimise the choice of storing structures for the database

objects

Oracle 9i Database: Performance Tuning Course

20th November, 12th February in Dublin


17/42


Your expectations:

To implement specific

solutions

To simplify recurring and

complex situations

Our solution:

Expert courses

BD SECURITE(3 days)

EXAMOCM

RAC 9i(3 days)

DATA GUARD(3 days)

SQL TUNING(3 days)

STREAMS(5 days)

ADV BACKRMAN

(3 days)

STATSPACK(1 day)

RAC9i - LINUX(2 days)

ADV-TUNING(1 day)

ADM DWH(3 days)

PARTITIONING(2 days)

OEM 9i(4 days)


18/42


To implement specific solutionsWhat good practices have to be implemented to

efficiently administer a data warehouse or highvolumes of data (VLDB)?

The PARTITIONING and DWDBA (Data WarehouseAdministration) courses describe the functionalitiesand rules associated with optimum management of

these data bases

Datawarehousing Fundamentals

7th September, 16th October in Dublin


19/42


To simplify recurring and complex situations Im already an Oracle DBA but I havent had the

chance to implement RMAN so far.How can I train myself on this tool?

The ADVANCED RMAN course (Advanced Backupand Recovery with RMAN 3 days) will let youacquire all useful information and practicalexperience for easy management of RMAN (Recovery

Manager)

Oracle 9i Database: Advanced Back up & Recovery Using RMAN

1st November in Dublin


20/42

Oracle10g


21/42

Database Administration 10g

-Course -Certification exam -Under construction/validation

New Features forAdministratorsDBA8i-9i(5 days)

DB10G ADMIN I (5 days)DB10GADMIN II5 days)

EXAMOCA

EXAMOCP

New Features forOracle8i DBA

(5 days)

2-Day

DBA

SMB toEnterprise

DBA3 daysOrac

le

Database10g:

DBA

OBE

Migrate From SQL Server

Migrate From Sybase

DB SECURITY(3 days)

EXAM

OCM

RAC 10G(5 days)

DATA-GUARD

(3 days)

SQL TUNING(3 days)

STREAMS(5 days)

DB10G TUNING

(4 days)

Database Vault

Backup

& Recovery

OEMGRID CONTROL

(5 days)

SPATIAL(3 days)

SPATIAL ADV(2 days)

DHWImplementation

& Administration


22/42

Oracle 10gAdministrator

Your expectation: To know how to administer thedatabase.

Our solution: The fundamental course

DB10G ADMIN I (5 days) EXAMOCA

EXAMOCP

DB10G ADMIN II (5 days)


23/42


DB10G ADMIN I:To manage a 10g database in 5 daysFor all people who start administering Oracle databases in a 10genvironment.

Concepts and architecture of a 10g database

Installation of Oracle 10g, creation and management of a database,

management of users and security, network configuration,proactive maintenance, operating in Archivelog, approach ofdifferent types of backup and data recovery, description of simplecases of loading and unloading data

Intensive use of graphical tool of db administration (DB CONSOLE)

This course can be taken regardless of the OS on which Oracle isinstalled.

Oracle Database 10g Admin Workshop 1 Course, Dublin

4th September, 4th December, 5th February


24/42

Oracle 10gAdministratorDB10G ADMIN II:To overcome all administration issues in 5 days

To use RMAN in order to manage all types of backup

To attain all types of data recovery

To put a proactive maintenance infrastructure in place for 10gspecifically

To manage and control performance with help of the new 10g tools

To manage memory and define priorities in the consumption ofresources

To use ASM (Automatic Storage Management)

To automate administration tasks

To manage the adaptation of the database to different languages,

characters and time zones This course can be taken regardless of OS on which Oracle is installed

Oracle Database 10g Admin Workshop 2 Course, Dublin 11th September, 11th December, 26th February


25/42


Your expectation:To changeversion or

database. Our solution:

upgrade courses

New Features forOracle8i DBA

(5 days)

DB10GADMIN II5 days)

EXAMOCA

EXAMOCP

New Features forAdministrators

DBA8i-9i(5 days)

Migrate From SQL Server

Migrate From Sybase

ADMINISTRAToROracle 8i

or Oracle9i

OCP 8ior OCP 9i


26/42


DBA 8i-10g: An intensive programme that allows you to change directly from

8i to 10g in 5 days and trains you on all new tools andfunctionalities to fully benefit from 10g without missing anything!

Oracle Database 10g: New Features for 8i DBAs Course 9th October in Dublin

DBA 9i-10g: A presentation and in-depth practice of all functionalities and

tools of 10g, to use version 10g in an optimum way and to beready to anticipate the changes of tomorrow.

Oracle Database 10g New Features for Administrators 16th October, 5th February in Dublin


27/42


Your expectation: To implement specific solutions

To simplify recurring and complexsituations

-Course -Certification exam -Under construction/ validation

Our solution:

Expert courses

DB SECURITY(3 days)

EXAMOCM

RAC 10G(5 days)

DATA-GUARD

(3 days)

SQL TUNING(3 days)

STREAMS(5 days)

DB10G TUNING

(4 days)

Database Vault

Backup

& Recovery

OEMGRID CONTROL(5 days)

SPATIAL(3 days)

SPATIAL ADV(2 days)

DHWImplementation

& Administration

O l 10 Ad i i


28/42


To resolve recurring and complex situations Most performance problems that you refer to Oracle Support

originate from lack of skill or knowledge.

Often best practice rules have not been implemented to allow aquick resolution of performance problems (Source : Oracle Support).

The SQL TUNING course (SQL Tuning workshop) offers you the

necessary mechanisms and best practice rules in the field ofoptimisation of requests, to allow you to react in a proactive andreactive way rather than to react to the problems of optimisation ofrequests.

Version 10g offers a high number of tools to allow you to save timedetecting and resolving performance problems especially in optimising

your user requests. Come and discover them in the SQL Tuning andDB10g Tuning courses !

Oracle Database 10g SQL Tuning Workshop, Dublin,- 4th September, 18th December


29/42


To implement specific solutions:

I want to replicate all or part of my data from one database toanother, with filtering and transformations regardless of the typeof OS.

Im looking for a technology that allows me to do a selective

extraction from my data and to supply it to a Data Warehouse

The STREAMS 10g 5-day course offers you training in theOracle technology permitting you to solve these problems.

This recent technology is based on Advance Queuing andLogminer technology, new way to respond to very generalproblems on data replication.


30/42


I hear a lot of talk about high availability, which will bepart of my production objectives in the future.

I would like to reduce mean time between failuresregardless of what caused it, hardware failure or

application error, RAC or DataGuard.

To implement specific solutions:

DB1OG-RAC

(5 days)

DATAGUARD

(3 days)

DB10G RAC + DATAGUARD

RAC: 10g course on 6th November, 9i course on 18th December

10g Dataguard Administration: 27th November


31/42


To simplify recurring and complex situations

How to meet the needs of centralised management of allapplication components?

I have all types of OS, 8i, 9i and 10g databases, applicationservers. I want to manage the tools and be able to automateand centralise administration. How to know, install and

control the Grid control?

The OEM1Og GRID CONTROL 5-day course will train you onwhat is important in the job of the 10g DBA of today andtomorrow.

Architecture, Installation, parameterisation, setting upagents, task automation, monitoring of targets, and securitymanagement.


32/42


Your expectation: How to assure the newtasks link to the set up of the application server andunderstand its interaction with the database.

Our solution:The (AS10g-ADMIN-I) Application Server 10g: Administration Icourse will enable you to understand and control:

Installation and management of the application server.

Deployment of applications and services that interact with the

database.

A complete course allows you to control all aspects of this newarchitecture and function.

Oracle 10g Application Server, Admin I Course: 8th January


33/42


Our solution: Database Security (3 days) and EIM (5 days)

DB-SECURITY (3 days) Basic security functionalities of databases Security network via Oracle Net

Connection Manager as firewall Virtual Private Database Audit of database

Oracle 10g Database: Security Course on 31st October

AS10G-EIM (5 days)

Management of LDAP Oracle directory Management of application accounts for connection to SI

Encryption network for Internet access (SSL) Management of digital certificates

Oracle AS10g:Enterprise Identity Management Course on 23rd October

Your expectation: To manage security


34/42


Your expectation: To improve response times

To guarantee a high level of efficiency of your servers

To accelerate replication of your data

To put real time application in place

Our solution: Oracle 10g integrates new products: TimesTen

To allow you to understand and master this technology asquickly as possible:

Oracle TimesTen : Core Concepts and Administration (3 days)

Oracle TimesTen : Replication (1 day)

Oracle TimesTen: Administering Database Buffer (1 day)


35/42

Your partners inOracle University


36/42

2-day Optimising Oracle Seminar Cost Based Optimisation Indexing Strategies Explain Plan

Date: 2nd - 3rd October Location: Oracles East Point Office, Dublin 3

To Register Call: 01-803 9162

Email: [email protected]

Exclusive 2-day Seminar withTop SQL Guru Jonathan Lewis


37/42

The Team in Oracle University

Expert Trainers

Ireland Country Manager

Pat McGuire ([email protected], 01 8039170)

Education Sales Representatives Sinead Connolly ([email protected], 01 8838112)

Corina Nicolescu ([email protected])

Our Reservation Centre for training courses

Tel: 01-803 9162

Email: [email protected]
mailto:[email protected]:[email protected]:[email protected]:[email protected]:[email protected]:[email protected]


38/42

Choose your training courses

Find your training courses on the Education website www.oracle.com/ie/education

Train yourself on line with Oracle University

Knowledge Center More than 1700 Oracle, PeopleSoft, JD Edwards courses

http://www.oracle.com/education/oukc/ou_online_home.html

Other educational resources (OBE) on the OTNwebsite

http://www.oracle.com/technology/index.html
http://www.oracle.com/ie/educationhttp://www.oracle.com/education/oukc/ou_online_home.htmlhttp://www.oracle.com/technology/index.htmlhttp://www.oracle.com/technology/index.htmlhttp://www.oracle.com/education/oukc/ou_online_home.htmlhttp://www.oracle.com/ie/education


39/42

Our Logistics means

Training in 60 countries

Benefit from 400 training centres in the world

17 in the UK and Ireland

Ireland site: Dublin

Complete course support always provided


40/42

And to really

benefitfrom the

courses


41/42

some hints and tips from the

instructors

Avoid phone calls on your mobile if possibleduring a course

Consolidate your new knowledge with the labs

Review material each day and ask questionsthe next day if required

Re-read, and review the course as quickly as

possible after the course Try to explain it to someone else


42/42

Questions

future of dbas seminar ireland

Documents