Oracle Database 12c Administration Workshop ED 2 | MSP Training

ABOUT THE PROGRAM

It is a must for every organisation that it maintains its data for more than just the current running period. For this, it is necessary to store that data in a database. Being installed on a computer, a database has many reasons for a crash to occur. Saving data in such situations becomes the responsibility of database professional. Such a professional is the Database Administrator often referred to as the DBA. Database Administrators are well equipped with the database procedures skills using which they can make data available at all times. This course helps the delegates in managing an Oracle Database.

At MSP Training we ensure the delegates get both the knowledge about skills as well data availability. Procedural knowledge helps in designing, debugging and implementing procedures whereas data availability ensures that data is available at all times.

Learn to Create an Oracle 12c Database
Know how to Startup and Shutdown a 12C Database in Various Modes
Know about the Oracle Cloud and It’s Services
Learn about Backup and Recovery Features
Understand the Job of The Oracle Scheduler
Get Certified from Oracle Certified Trainers

WHAT'S INCLUDED ?

Find out what's included in the training programme.

Key Learning Points

Clear and concise objectives to guide delegates through the course.

Tutor Support

A dedicated tutor will be at your disposal throughout the training to guide you through any issues.

Certificate

Delegates will get certification of completion at the end of the course.

PREREQUISITES

This course does not have prerequisites. The knowledge of SQL is recommended.

TARGET AUDIENCE

The course is intended for the following experts:

Support Engineers
Technical Supervisors
Database Designers
Database Managers
Data Warehouse Managers

WHAT WILL YOU LEARN?

The objective of this course provides you knowledge about:

Understand how to manage database instances
Storage Structures and Their Management
Setup and Configure the Oracle Network Environment
Monitoring and managing Oracle databases
Observing database performance
Executing Backup and Recovery Tasks
Implementing database auditing
Know about the Oracle Cloud and It’s Services

Enquire Program

Fill in the form below & we'd get back to you.

PROGRAM OVERVIEW

The Oracle Database 12c: Administration Workshop ED 2 course imparts the knowledge to the delegates regarding the architecture of the Oracle Database. It helps the delegate learn about creating instances, configuring the Oracle Network Environment and maintain the Oracle Database as well. The delegates will be introduced to the new concept of Oracle Cloud.

PROGRAM CONTENT

An Overview of Database Administration
- Types of Database users
- DBA Roles
- An Overview of SQL statements
- Oracle 12c software release
- Define data utilities
Creating Oracle Database
- Database creation with DBCA
- Creating Statement
- Initializing parameters
- An Overview of Database services
How to start and Shut Database
- Modes of Startup
- Database Shutdown Modes
- Suspending and Resuming An Oracle Database
Oracle Database Architecture – A Review
- An overview of Oracle architecture
- Process Structures, Architecture, and Startup System
Process Management in Oracle
- Dedicated and shared server processes – An Overview
- Managing Database with shared servers
- Ordering processes for parallel SQL execution
- Ordering processes for external methods
- Dismissing sessions
Managing Control Files
- Summary of control file
- Creating control files
- Improving and backing up control file
- Dropping a control file
- Creating views in data dictionary
Managing Database Instance
- Creation of views and multiple tables
- Analysing tables, clusters and indexes
- Use of triggers
- The Enterprise Manager Management Framework of Oracle
- Define Enterprise Manager Database Express Home, Page
- The Enterprise Manager Cloud Control – A Summary
- Integrity Constraints
- Renaming schema objects
- Object dependencies
Configuring Oracle Network Environment
- Summary of Oracle Net Services and Net Listener
- Oracle Network Connections
- Tools of Oracle Network
- Listener Control Utility, Oracle Net Manager and Enterprise Manager Cloud Control
Managing Database Storage Structures
- Management of Tablespace Alerts
- Presuming space allocation
- Retrieval of free space
- Display data for space usage data type
- Create a New Tablespace
- Oracle Managed Files
Managing User Security
- Producing user profiles
- Using Authentication
- Describing Roles and privileges
Handling Data Concurrency
- What is the need of Locks?
- Using Locking Mechanism
- Describing DML Locks
- An overview of Concurrency of data
- Lock Conflicts
Managing Undo and Redo Log
- A Summary of Undo Data
- Transactions and Store Undo Material
- Matching undo Data and Redo Data
- Handling Undo
- An Introduction to Redo Log
- Producing Redo groups
- Renaming log members
- Confirming Redo block files
Applying Oracle Database Auditing
- An Overview of auditing
- Securing Database
- Compliance Monitoring and Regular Database Auditing
- Unified Audit Data Trail
- Parting of Duties for Audit Administration
- Configuring Audit trail
- Audit Options Specification
Database Maintenance Implementation
- An Overview of Database Maintenance
- Detecting the Alert History
- Summary of Automatic Workload Repository (AWR) and Statistic Levels
- Automatic Database Diagnostic Monitor (ADDM)
Managing Performance
- Observing Performance
- Using Tuning Actions
- Instances Tuning
- Performance Tuning Method and Tuning Data
- Performance Monitoring Presentation
- Managing Memory
Tuning SQL
- SQL Tuning and Oracle Optimizer: An Overview
- SQL Advisors
- SQL Plan Commands and Adaptive Execution Plans
- Automatic SQL Tuning Results
- Automatic Tuning Situations
Handling Resources by Using Database Resource Manager
- Database Resource Manager
- Resource Manager Workflow
- Maintenance Resource Manager Plan
Running Tasks Using Oracle Scheduler
- Define Oracle Scheduler
- Understanding Scheduler objects
- Architecture of a scheduler
- Learning to Perform a Simple Job, and Understand Core Components and basics of Work Flow
- Various Types of Schedules
- Generating schedules
Backup and Recovery Concepts
- Failures Groups and Flashback Technology
- Instance Recovery
- Stages of Instance Recovery
- Instance Recovery Alteration
- MTTR Advisor
Data Movement
- Oracle Data Pump and SQL*Loader
- Oracle Support
- Enterprise Manager and Support Workbench
- Oracle Support and incorporation
- Issue Investigation
- Logging Service Requests and managing patches

Oracle Database 12c: Administration Workshop ED 2 Enquiry

Enquire Now

----- OR -------

Reach us at 0121 368 7851 or info@msptraining.com for more information.

ABOUT Heathrow

In London, Heathrow airport is a major international airport. Heathrow airport is the world’s second busiest airport by International passenger traffic. In 2016, Heathrow airport has a 75.7 million passengers travelling record. Heathrow airport renders scheduled services which is one of the six airports along with Gatwick, Luton, London City, Stansted and Southend. Heathrow airport is located 23 km west of Central London. This airport has two parallel east-west runways and four operational terminals that cover 4.74 sq. mi. From Heathrow airport, above 80 airlines fly to 180 locations (approx.) worldwide carrying more than 72 million travellers and 1.4 million tonnes of cargo every year. Heathrow airport is enclosed by the Hillingdon, Longford, Cranford and Harmondsworth from the north side and by Hatton and Hounslow from the east side. Heathrow airport offers many facilities such as for business, handicapped travellers and children. Heathrow airport has a splendid rail and road links to London and other cities of the country. From Heathrow airport, there are many public means of transport such as coaches, taxis, trains and Heathrow express, ease the passengers to travel to the main city.

History

Heathrow airports in its started life are known by the name of Great-West Aerodrome and occasionally known as Heathrow Aerodrome. It is originated in 1946 as London Airport for commercial air travel and renamed as Heathrow airport in 1966. Sir Frederick Gibberd has designed the Heathrow airport. He has designed the original terminals and buildings. In the 1980s and 90s Heathrow develop into a major employer with 70,000 staff.

Security

At the Heathrow airport, full body scanners are used which exhibits a cartoon-style figure of passengers’ body and exhibits all the items on the screen which are restricted to carry while travelling. Aviation security which is the unit of Metropolitan Police holds the responsibility of airport police. It also has armoured vehicles of Household Cavalry, which has been sporadically deployed during the time of heightened security.

TRAINING AVAILABILITY

Aberdeen

Bath

Bedford

Belfast

Birmingham

Bolton

Bournemouth

Bracknell

Brighton

Bristol

Bromley

Burton Upon Trent

Buxton

Cambridge

Canterbury

Cardiff

Carlisle

Chatham

Chelmsford

Chester

Chichester

Chorley

Cirencester

Colchester

Corby

Coventry

Crewe

Darlington

Derby

Dereham

Doncaster

Dublin

Dundee

Dunfermline

Eastleigh

Edinburgh

Exeter

Fleet

Gatwick

Glasgow

Gloucester

Guildford

Harrogate

High Wycombe

Hinckley

Inverness

Ipswich

Jersey

Kingston upon Hull

Leeds

Leicester

Lincoln

Liverpool

London

Luton

Maidstone

Manchester

Middlesbrough

Milton Keynes

Newcastle

Northampton

Norwich

Nottingham

Oxford

Peterborough

Plymouth

Poole

Portsmouth

Preston

Reading

Sheffield

Slough

Solihull

Southampton

Stoke-on-Trent

Sunderland

Swansea

Swindon

Teesside

Tonbridge

Tredegar

Wakefield

Warrington

Warwick

Watford

Windsor Town

Wokingham

Wolverhampton

Worcester

Wrexham

York

Oracle - The Database

The Oracle Databas...