Oracle Database 12c: Administration Workshop ED 2

Organise and manage the Oracle Database

Proposed for DBA and Data Warehouse Administration
Guaranteed best price in the industry
Gain skills regarding Oracle Database Architecture
Offers tutor support
Study how to protect database to meet business necessities

The IT organisations require database administration skills to organise and manage the database. The database administrators (DBA) are the ones who have procedural skills as well as ensures data availability. You should gain the expertise for the same to create, organise and manage the database.

Our Pentagon Training’s Oracle 12c: Administration Workshop ED 2 course provides expert level knowledge in database administration. This workshop is inspired by the successful IT environments. You should start with gaining the following skills of professional DBAs:

They have procedural skills: The professional DBA has procedural skills to help design, debug and implement the procedures.
They ensure data availability: The 24*7 availability of data is a must. You should be knowledgeable to ensure availability of data.

Who should take this course

The course is designed for the following professionals:

Support Engineers
Technical Supervisors
Database Designers
Database Managers
Data Warehouse Managers

Prerequisites

There is no prerequisite for this course but basic knowledge of SQL and Linux operating system is recommended.

What Will You Learn

The delegates will be able:

To gain knowledge of configuration of the Database Instances
To define Oracle Database Design
To monitor and manage the Database
To implement Database Auditing

Key Learning Points

Tutor Support

Certificate

Course Overview

Database administration is the function of handling and maintaining database management systems (DBMS) software. The Oracle Database 12c: Administration Workshop ED 2 course provides skills regarding generating database instances. You will learn about the storage structures, monitoring database and workbench. By undergoing this Oracle 12c training, you will be a successful database administrator.

Course Content

An Introduction to Database Administration

Types of Database users
Roles of DBA
An Introduction to SQL statements
Defining the Oracle 12c software release
What are data utilities?

Create Oracle Database

Database creation with DBCA
Statement Creation
Initialization parameters
An Introduction to Database services

Starting and Shutting Database

How to start Database?
The shutting of Database
The Suspending and Recommencing of Database

An Introduction to Oracle Database Architecture

An introduction to Oracle architecture
Process Structures, Architecture, and Startup System

Managing Processes

An Introduction to dedicated and shared server processes
Handling Database with shared servers
Arranging processes for parallel SQL execution
Arranging processes for external methods
Terminating sessions

Managing Control Files

An Overview of control file
Creating control files
Recovering 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
An Overview of Enterprise Manager Management Framework
What is Enterprise Manager Database Express Home Page?
An Overview of Enterprise Manager Cloud Control
Relating Integrity Constraints
Renaming schema objects
Study of object dependencies

Configuration of the Oracle Network Environment

An overview to Oracle Net Services and Net Listener
Understanding Oracle Network Connections and tools for the Oracle Network
Understanding the Listener Control Utility, Oracle Net Manager and Enterprise Manager Cloud Control

Management of Database Storage Structures

Managing the Tablespace Alerts
Presumable space allocation
Regaining free space
Displaying data for space usage data type
Creating a New Table space
Understanding Oracle Managed Files

Handling User Security

Generating user profiles
Using Authentication
Defining Roles and privileges

Managing Data Concurrency

What is the need of Locks?
Using Locking Mechanism
Describing DML Locks
An overview of Concurrency of data
Lock Conflicts

Handling Undo and Redo Log

A Summary of Undo Data
Transactions and Store Undo Material
Matching undo Data and Redo Data
Handling Undo
An Overview of Redo Log
Generating Redo groups
Renaming log members
Confirmation of Redo block files

Applying Oracle Database Auditing

An Introduction to auditing
Using Security of Database
Compliance Monitoring and Regular Database Auditing
Unified Audit Data Trail
Parting of Duties for Audit Administration
Audit trail configuration
Specifying Audit Options

Implementing Database Maintenance

An Introduction to Database Maintenance
Detecting the Alert History
An Overview of Automatic Workload Repository (AWR) and Statistic Levels
An Introduction to Automatic Database Diagnostic Monitor (ADDM)

Handling Performance

Observing Performance
Using Tuning Actions
Instances Tuning
Performance Tuning Method and Tuning Data
Performance Monitoring Presentation
Management of Memory

Handling Performance: SQL Tuning

An Introduction to SQL Tuning and Oracle Optimizer
Recognising SQL Plan Commands and Adaptive Execution Plans
SQL Advisors
Automatic SQL Tuning Results
Applying Automatic Tuning Situations

Managing Resources by Using Database Resource Manager

A summary of Database Resource Manager
Basics of Database Resource Manager
Describing Maintenance Resource Manager Plan
Defining Resource Manager Workflow

Powering Tasks by Using Oracle Scheduler

An Introduction to Oracle Scheduler
Understanding Scheduler objects
Defining scheduler architecture
Understanding a Simple Job, Core Components and basics of Work Flow
Various Types of Schedules
Creating schedules

Backup and Recovery Concepts

Failures Groups and Flashback Technology
An Overview of Instance Recovery
Stages of Instance Recovery
Alteration of Instance Recovery
Using the MTTR Advisor

Data Movement

Oracle Data Pump and SQL*Loader
Oracle Support
Using the Enterprise Manager and Support Workbench
Oracle Support and incorporation
Investigating an Issue
Logging Service Requests and Handling Patches

Working with Oracle Support

Support Workbench and Enterprise Manager
Oracle Support
My Oracle Support Addition
Issue Investigation
Categorization of Service Requests
Managing Patches
Connecting a Patch Release

SQL

What is SQL?

Structured Query Language (SQL) is a domain-specific language used in programming and proposed for handling data in a relational database management system (RDBMS), or for stream execution in an RDSMS.

Formerly based upon relational algebra and tuple relational calculus, SQL involves of a data definition language (DDL), data manipulation language (DML), and data control language (DCL). The constraint of SQL includes data insert, query, update and delete, schema formation and alteration, and data access control. Though SQL is often labelled as, and to a great degree is, a declarative language (4GL), it also comprises procedural components.

SQL was one of the first profitable languages. In spite of not completely following the relational model as labelled by Codd, it developed the most extensively used database language.

About Glasgow

Glasgow

Glasgow is largest city located in Scotland and third largest in the United Kingdom. Earlier, it was a part of Lanark shire which is now one of the 32 council areas of Scotland. Glasgow is located on River Clyde in country’s west central lowlands. People of Glasgow are referred as Glaswegians. Glasgow developed from a small rural settlement on River Clyde. Glasgow had become largest seaport in Britain. In the 18th century, it became a major centre of Scottish Enlightenment. From the 18th century, Glasgow has grown as one of the Great Britain’s central hub of trade including West Indies and North America. Glasgow focused on its heritage to attract tourists from various countries. Tourism is also a source of employment in Glasgow. In 1980, Hunter Ian Art Gallery was opened. In 1983, Collection of Burrel went on display in a museum in Pollock House grounds. In 1985, Scottish Exhibition and Conference centre was built. Clyde Auditorium was also added in 1997.

In the period of 1980’s and 1990’s, traditional manufacturing industries of Glasgow dropped. Service industries grew in Glasgow like retail, tourism and finance. In 1990 Glasgow School Museum of Education was opened. St Mungo's Museum of Religious Life and Art was opened in the year 1993. In 1999, Buchanan Galleries Shopping centre and Clyde Maritime centre was opened. In early 21st century, Glasgow thrived. IMAX cinema was opened in 2000 and Clyde Arc Bridge in 2006. At present, the population of Glasgow is 588,000.

Education

Glasgow has four universities within 1.5km area of city centre. These universities are a major centre of academic and higher research. Name of the Universities are:

University of Glasgow

University of Strathclyde

Glasgow Caledonian University

The University of West of Scotland

Saltire centre located at Glasgow Caledonian University is one of the busiest university libraries in the UK. Three further education colleges are there in the city that includes Royal Conservatoire of Scotland, Glasgow School of Art and Teacher training courses. In 2011 Glasgow had around 53,470 students which is higher than any other town in Scotland. Many live away from home in Dennistoun, Shawlands and West End of City. City council handles 29 secondary schools, 149 primary schools and three special schools. Special schools including Glasgow Gaelic school, Glasgow school of sport and Dance school of Scotland. Glasgow has various independent schools like Hutchesons Grammar School which was founded in 1639. Hutchesons Grammar School is one of the oldest school institutions in Britain. The oldest school in Scotland are Glasgow Academy, Kelvinside Academy, High School of Glasgow, Fernhill School and Craigholme School.

Economy

Glasgow has the largest economy in Scotland and third highest GDP per capita of any city in the UK. The city itself provides 410,000 jobs in over 12000 companies. Between 2000 and 2005 around 153,000 jobs were created and growth rate reached 32%. The annual economic growth rate of Glasgow is 4.4% and is now second to London. Dominant industries like shipbuilding, heavy engineering gradually got replaced. Major manufacturing industries in the city are Clyde Blowers, Linn Products, William Grant and Sons, Aggreko, Weir Group, Whyle and Mackay, Albion Motors, British Polar Engines and Edrington Group. Glasgow was once a most important city in the UK for manufacturing which generated great wealth for the city. Glasgow is now the second most popular foreign tourist destination in Scotland. In the 21st century, some call centres in Glasgow grew substantially. City’s primary manufacturing industries include engineering, construction, shipbuilding, brewing and distilling, printing and publishing, chemicals, textiles and new growth sectors like software development, biotechnology and optoelectronics.