Oracle Database 11g Administration Workshop I Release 2

Learning the Oracle Architecture

ABOUT THE PROGRAM

In earlier times, the data storage was being handled by DBMS packages such as FoxPro and Access. As technology is growing and the social media is also becoming an important aspect of the IT industry so need to handle data in bulk. The database giants such as DB2 and Oracle come into the market. Oracle is as of now an ORDBMS which is being used to store character data to Large Objects. Besides simply storing data, Oracle has now been providing options to manage the database as well. Today almost every organisation has a profile called the DBA (Database Administrators).

An Oracle 11g Database Administrator provides storage, backup and recovery solutions for the organisation. Oracle provides various tools such as the Enterprise Manager, Recovery Manager (RMAN) etc. that help the administrator to manage the database. At MSP Training, the delegates learn how to use these various tools and also about the architecture of Oracle 11g Database. They also learn how the various components of the database interact with each other to execute a task or query.

  • Learn to perform Database Administration

  • Understand the differences between Logical and Physical Architecture of the Oracle 11g Database

  • Start up and shutdown the database in different modes

  • Understand the use of various system files such as init.ora , spfile and pfile in Oracle

  • Training imparted by Oracle Certified Instructors

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

Courseware

Courseware will also be provided to the delegates so that they can revise the course after the training.

PREREQUISITES

Oracle SQL and PL/SQL knowledge is must for the candidates sitting for this course.

TARGET AUDIENCE

The following professionals should attend this course:

  • Database Administrators
  • Java Developers
  • Technical Administrator
  • Support Engineer
  • Technical Consultant

WHAT WILL YOU LEARN?

  • Setting up the Oracle Grid for use
  • Oracle 11g Database - Installation and Configuration
  • Establish Connectivity by using the Oracle Net services
  • Understand the concept of Oracle Undo Data and know how to manage Undo
  • Understand and Setup Oracle’s Physical and Logical Storage Configurations
  • Manage Accounts and Accounting Policies
  • Performing Basic Backups and Database Recovery
  • Managing data concurrency
  • Performance Monitoring
  • Database Architecture of Oracle 

Enquire Program

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

PROGRAM OVERVIEW

The Oracle Database 11g  Administration Workshop 1 Release 2 training trains the delegates to a point that beyond SQL and PL/SQL. The course introduces the delegates to the Oracle 11g Architecture and goes on to teach the use of advanced tools such as the Enterprise Manager by the end of the course.

Examination

The delegates are required to have a working knowledge of SQL and PL/SQL before sitting for the course. To get through the certification they need to score a minimum 66% marks in the exam.


PROGRAM CONTENT

  •  Oracle Database Architecture
    • An Overview
    • An Insight into the Oracle ASM Architecture
    • Understand Process Architecture
    • Memory structures
    • Functioning of the Logical Components of Oracle Database
    • Working of Physical Components
    • ASM storage components
  • Install Oracle Software
    • Chores of an Oracle DBA
    • Tools Used by an Oracle DBA
    • System Requirements for the Installation
    • Oracle Universal Installer
    • Seting Up The Oracle Grid Infrastructure
    • Installing Oracle Database Software
    • Silent Install
  • The Oracle Database Creation
    • Planning the Database
    • Using the DBCA to Create a Database
    • Password Management
    • Creating a Database Design Template
    • Using the DBCA to Delete a Database
  •  Oracle Database Instance Management
    • Start and stop the Oracle database and components
    • Making Use of the Oracle Enterprise Manager
    • Access a database with SQLPlus
    • Modify database installation parameters
    • Describe the stages of database startup
    • Ways to Shutdown The Database
    • The Alert Log – Viewing Its Contents
    • What Are Dynamic Performance Views and How Are They Accessed?
  • The ASM Instance
    • Setting up pfile and spfile
    • Starting up and shutting down the ASM
    • ASM Disk Group Management
  • The Oracle Network
    • Creating and configuring Listeners with the Enterprise Manager
    • Monitoring the listener by Enabling Oracle Restart
    • Testing Oracle Net connectivity with tnsping
    • Shared and Dedicated Servers
  • Database Storage Structure Management
    • Storage Structures
    • How Table Data Is Stored
    • Anatomy of a Database Block
    • Space Management in Tablespaces
    • Tablespaces in the Preconfigured Database
    • Actions with Tablespaces
    • Oracle Managed Files (OMF)
  •  Administering User Security
    • Database User Accounts
    • Predefined Administrative Accounts
    • Benefits of Roles
    • Predefined Roles
    • Implementing Profiles
  •  Managing Data Concurrency
    • Data Concurrency
    • Enqueue Mechanism
    • Resolving Lock Conflicts
    • Deadlocks
  • Managing Undo Data
    • Data Manipulation
    • Transactions and Undo Data
    • Undo Data Versus Redo Data
    • Configuring Undo Retention
  • Implementing Oracle Database Auditing
    • Describe DBA responsibilities for security
    • Enable standard database auditing
    • Specify audit options
    • Review audit information
    • Maintain the audit trail
  • Database Maintenance
    • Manage optimizer statistics
    • Manage the Automatic Workload Repository (AWR)
    • Use the Automatic Database Diagnostic Monitor (ADDM)
    • Describe and use the advisory framework
    • Set alert thresholds
    • Use server-generated alerts
    • Use automated tasks
  • Performance Management
    • Performance Monitoring
    • Managing Memory Components
    • Enabling Automatic Memory Management (AMM)
    • Automatic Shared Memory Advisor
    • Using Memory Advisors
    • Dynamic Performance Statistics
    • Troubleshooting and Tuning Views
    • Invalid and Unusable Objects
  • Backup and Recovery Concepts
    • Part of Your Job
    • Statement Failure
    • User Error
    • Understanding Instance Recovery
    • Phases of Instance Recovery
    • Using the MTTR Advisor
    • Media Failure
    • Archive Log Files
  • Performing Database Backups
    • Backup Solutions: Overview
    • Oracle Secure Backup
    • User-Managed Backup
    • Terminology
    • Recovery Manager (RMAN)
    • Configuring Backup Settings
    • Making a backup of the Control File to a Trace File
    • Monitoring the Flash Recovery Area
  • Performing Database Recovery
    • Opening a Database
    • Data Recovery Advisor
    • In case of losing a Control File
    • In case of losing a Redo Log File
    • Data Recovery Advisor
    • Data Failures
    • Listing Data Failures
    • Data Recovery Advisor Views
  • Moving Data
    • Describe ways to move data
    • Create and use directory objects
    • Use SQL*Loader to move data
    • Use external tables to move data
    • Oracle Data Pump Architecture
    • Data Pump Export and Import
  • Working with Support
    • Use the Enterprise Manager Support Workbench
    • Work with Oracle Support
    • Log service requests (SR)
    • Manage patches

Oracle Database 11g Administration Workshop I Release 2 Enquiry

 

Enquire Now


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

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

ABOUT Doncaster

Doncaster is a place where markets were organised in the past. It was not mandatory at all for the smooth conduct of the market, but it has potential to hold a fair was also termed as Market town. The geographical location is near to South Yorkshire territory of the United Kingdom. With the geographical area of nearby suburbs and settlements, it forms a Metropolitan Borough of Doncaster. As per the population census of mid-2016, the population was 306,450. The only territory of the Doncaster contributes 109,810 population. As per the Treaty of Durham,  its Jurisdiction comes from the Scotland. The urban vicinity of the region contributes 158,145 people including the nearby villages.

Politics

There are three seats for the member of parliament in the Doncaster constituency. The constituency is currently under the power of Caroline Flint(Don Valley), Ed Miliband(Doncaster North), and Rosie Winterton(Doncaster Central). At a European level,  The city was a part of European Parliament Constituency. In September 2014, UklP organised yearly conclave. In the European Union Referendum 2016, Doncaster was in favour of leaving the European Union.

Geography     

With the development of the Coal Mining sector, the population of the borough expanded at a very rapid pace. In the late of 1970 and the beginning of 1980, it faced a lot of problem in the economic sector of the town. There have been lost in the job opportunities of the city. There has been a drastic shift towards the service industry of the city. The city has an excellent link with the rest of the United Kingdom owing to the communication links of it. There has been a destination where tourists come from all over the world, i.e. Frenchgate Shopping Centre.

Climate

Doncaster has a coastal climatic condition, and it lacks in the extreme temperature conditions. There has not been much difference between the maximum temperature as well as the lower temperature. RAF Finningley is the official weather station for the town.

Economy        

From the 18th century to 20th century, Doncaster was the major industrial centre among the nearby cities. It attracted visitors from all over the world, and it became extremely busy and experienced migration in the past. In nowadays, the city experiences development in commercial and residential wise.  

Tractor production      

During the 1930’s, International Harvester initiated the production of agricultural tools and implements at their manufacturing units. Farmall M was the first tractor manufactured in the unit on 13th September 1949. The initial parts for the manufacturing of tractors came from the United States of America

Transport

Doncaster is situated at the beginning of the European Route E13. Other main cities that are connected with it are London, Nottingham, and Sheffield. The unusual thing is that there is not a single European route designator in the street of the United Kingdom. The Initial Point of M1 motorway is M18 Junction 2 of Doncaster

Culture, tourism, and Nightlife

Doncaster Museum and Art Gallery are only renowned museums opened in 1964. It has been the home of local history, natural history, archaeology and decorative art. A lot of visitors visit the city during the weekend.

The nightlife of the city is appreciated nearby region. This town has 43 bars and clubs. It is just 200 to 300 meters distance from each other

Sports  

The City provides a lot of opportunities in sports and games. The City is famous for many games such as horse races, rugby football, soccer game and Speedway Racing. The basketball game is also played by few clubs though followed much by the native people. The city also has twin town in different countries such as Avion, France and Herten, Germany