Oracle Database 12c: Administration Workshop ED 2

Knowing The  Oracle Architecture

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.

Includes

Key Learning Points

Clear and concise objectives to guide delegates through the course.

Includes

Tutor Support

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

Includes

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 Liverpool

Liverpool city is located in northwest region of England. As per the last population counting of city, It stands nearly 4, 80,000. It is also acknowledged as one of the largest metropolitan cities of England. Liverpool city council is looking after the development work of the city. It is also a highly populated district within the area of the metropolitan county of Merseyside. As far as population is concerned, It is the most populated region of the United Kingdom. Nearly 1880, It transformed into the city from the borough. After 9 years as a city, it became county borough and got totally separated from Lancashire. The growth of the city did happen during the industrial revolution. Industrial revolution embarked on various other industries in the region.

It ultimately helped in the creation of job opportunities. During the 19th century, Most of the emigrants of the United Kingdom including Ireland used this major Liverpool Port to move in the United States. There have been a lot of fan following of The Beatles (the English rock band) and other rock bands from Mersey beat era which further brings a lot of tourists in the city. It helps in boosts of the tourism sector of the country. Liverpool F.C and Everton are two famous football club of the region. The locals are very enthusiast while cheering their local football club in different leagues. All the entertainment programs are being held at Mathew street.

History

The letter patent issued during the beginning of 12th century announced the real foundation of the Borough of Liverpool. By the mid 16 century, the population of the town was 500. King John designed street plan for Liverpool. The history of Liverpool commenced since 16th century Tudor building and modern day architecture styles. The English Heritage site described the richness of architecture in the city. In 18th century, The Liverpool railway commenced its services for locals. The number of Irish migrants were migrated during the famine of 1840 from the region. Great Britain was a major market for cotton to the whole world. In 2014, An International festival was organized under the supervision of Prime Minister Leadership. It was acknowledged as world’s biggest business event

Economy

The location of the city gives her all the advantages. Being situated in the Centre, Liverpool get access from all the nearby cities as they set up their infrastructure there. This is the reason for strong economy of the city. The Liverpool city has one of the largest economies, per capita incomes, GDP’s in the Great Britain. Since 1995, the economy of the Liverpool was strong with GVA 72% from 1995 to 2006. The employment rate rose to 13% between 1998 and 2006. Both the private and public sector grew well in Liverpool region. Near about 60% people engaged in services or tertiary sector such as public administration, banking, finance, health, insurance, and education sectors. Among them banking, finance, and insurance did well and developed more.

Government

Liverpool city administration works on dual system of Mayor and Cabinet. Joe Anderson and Roz Gladden are the present Mayor and Lord Mayor of the region respectively.  They are also looking after the administration work in the Liverpool city region combined authority, The National government unitary authority, the European Parliament when functions of Merseyside county council was put off and it rose to district borough level . Departments such as Fire Brigade, Police, and rescue services manages at the country level.

Sports

Liverpool city is the most successful city in terms of the Football talent and championship. Both the clubs Liverpool F.C and Everton F.C have won several titles and championship. Wayne Rooney is the most followed football player of the Liverpool F.C. the other prominent sport of the region is boxing. The World’s most famous Steeplechase is being held at Aintree. It held in the month of April every year. Golf and Greyhound racing also played with same zeal in the region.

 

Oracle - The Database

The Oracle Databas...