Oracle Database 11g Administration Workshop I Release 2

by MSP Training Claim Listing

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.

Price : Enquire Now

Contact the Institutes

Fill this form

Advertisement

MSP Training Logo

img Duration

Enquire Now

Course Details

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

 

Prerequisities

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

 

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 

  • Belfast City Branch

    21 Malone Road, Belfast City

Check out more Oracle courses in UK

Mullan I.T. Training Logo

SQL Server

Learn how to write SQL (Structured Query Language) to access, extract, organise & manipulate the data stored in your relational database.

by Mullan I.T. Training [Claim Listing ]
Wise Owl Education Logo

Introduction To SQL

You can use SQL to retrieve information from your corporate database (providing, of course, that you understand its structure). This two-day introductory course will show you how to create tables in SQL Server, and then how to write SQL to extract information from them.

by Wise Owl Education [Claim Listing ]
EQV (UK) Ltd Training Logo

SQL Programming Introduction

This SQL Introduction programming course teaches relational database fundamentals and SQL programming skills. Topics covered include relational database architecture, database design techniques, and simple and complex query skills.

by EQV (UK) Ltd Training [Claim Listing ]
Babington Logo

SQL for Data Analytics

The SQL course and lab will teach you everything from the basics of SQL for Analytics to SQL for Data preparation. This includes, how to aggregate functions for Data analysis, importing and exporting data; analytics using complex data types, and more.

by Babington [Claim Listing ]
  • Price
  • Start Date
  • Duration
ITrain Scotland Logo

Microsoft SQL Server 2016 Querying Essentials

This 4 day course is intended for students who already have some experience with SQL and need to fast-track their querying skills to an advanced level.

by ITrain Scotland [Claim Listing ]

© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy