A Quick Glance

  • black-arrow

    Proposed for DBA and Data Warehouse Administration

  • black-arrow

    Guaranteed best price in the industry

  • black-arrow

    Gain skills regarding Oracle Database Architecture

  • black-arrow

    Offers tutor support

  • black-arrow

    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
More

Prerequisites

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

More

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
More

What's included

  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.

More

  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
More

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.

 



Oracle Database 12c: Administration Workshop ED 2 Enquiry

 

Enquire Now


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

Reach us at +44 1344 961530 or info@pentagonit.co.uk for more information.

About Carlisle

Carlisle, a city in Cumbria, is also the managerial centre of the City of Carlisle region in North West England. It is the main settlement in the county of Cumbria and helps as the managerial centre for both Carlisle City Council and Cumbria County Council. At the time of the 2001 survey, the population of Carlisle was 71,773. In 2011, the city's population had increased to 75,306, with 107,524 in the wider city.

The early history of Carlisle is noticeable as a Roman payment, recognised to serve the forts on Hadrian's Wall. In the Middle Ages, because of its nearness to the Realm of Scotland, Carlisle industrialised meaningfully. The armed stranglehold, Carlisle Castle, was built in 1092 by William Rufus, and once added as a custodial for Mary, Queen of Scots. The castle now relatives the Duke of Lancaster's Regiment and the Border Regiment Museum. In the 12th century, Henry I allowed the building of a priory in Carlisle. The town produced the rank of a city when its diocese was formed in 1133, and the cloister industrialised Carlisle Cathedral.

Governance:

Carlisle has detained city status since the Middle Ages. Also, it kept its status as an area constituency or governmental borough for centuries, at one time returning two MPs. In 1835 it became a municipal borough and was later upgraded to a  borough status in 1914. The city's boundaries have changed several times since 1835 the final time in 1974. 

The municipal area surrounded many parts of parishes which were combined into a single civil parish of Carlisle in 1904. The currently present urban area is considered as an unparished area. Carlisle had in 2002 made an unsuccessful attempt to grow to a Lord Mayoralty. An iconic building that stands tallest in Carlisle may be demolished, and the area nearby to it rehabilitated.

Climate:

Carlisle practices an oceanic climate. In January 2005 Carlisle was hit by strong wind storms and torrential rains. On Saturday 8 January 2005 all roads into Carlisle were shut owed to severe flooding, the worst since 1822, which produced three deaths. Less severe but still significant flooding occurred in 2009, but due to Storm Desmond. Carlisle experienced even worse flooding than 2005 between Friday 4 and Sunday 6 December 2015. During this time, nearly 36 hours of nonstop precipitation broke flood defences. This left several areas submerged including Bitts Park, Hardwicke Circus and Warwick Road. This left the famous Sands Centre, stranded from the rest of the city. As several other areas of Cumbria were also severely pretentious, all trains to Scotland were postponed forever. The trains on the West Coast Principal went no further than Preston. Prime Minister David Cameron stayed the city on 7 December 2015 to measure the damage.

More