Oracle Database 12c Essential Administration

Oracle Database 12c Essential Administration

2 days @ £990.00 exc. VAT 

Course Code: O12CEA

25 Years - The IT Training specialist

Upcoming Scheduled Events - next 12 months

Location Start Date Spaces Book
London 29 May 2018 Spaces StayAhead - Course Running Book
London 26 Jul 2018 Spaces StayAhead - Course Running Book
London 20 Sep 2018 Spaces StayAhead - Course Running Book
London 12 Nov 2018 Spaces StayAhead - Course Running Book
View Further Dates

Location Start Date Spaces Book
London 21 Jan 2019 Spaces StayAhead - Course Running Book
London 21 Mar 2019 Spaces StayAhead - Course Running Book
Virtual Events StayAhead Virtual Courses available You can attend your training virtually using the London dates shown above. Please contact us for more details on our Virtual training options or to discuss specific Virtual course dates to meet your requirements.

S6

Oracle Database 12c Essential Administration Course Overview

The Oracle Database 12c Essential Administration course is designed for Database Administrators of small sized databases who need to carry out basic system administration tasks on Oracle Database 12c database. The Oracle Database 12c Essential Administration course is also suitable for support staff and personnel who are required to carry out occasional administration or troubleshooting tasks. The Oracle Database 12c Essential Administration course is not aimed at delegates who are full time Database Administrators. The focus is on using Enterprise Manager Express and SQL Developer to teach delegates how to manage the database. The usage of SQL*Plus is also covered.

Full time Database Administrators should attend the Oracle Database 12c Administration course.

The delegate will learn and acquire skills as follows:

  • Installing Oracle Database 12c Software
  • Creating an Oracle database
  • Administering an Oracle database with Enterprise Manager Express, SQL Developer and SQL*Plus
  • Configuring the Oracle Network Environment
  • Creating and Managing Database Storage Structures
  • Managing Schema Objects
  • Managing Users
  • Maintaining Database Security
  • Backing up, Restoring and Recovering the Database
  • Monitoring the Performance of the Database Using Advisors

Who will the Course Benefit?

The Oracle Database 12c Essential Administration course is aimed at Database Administrators of small sized databases who need to install the Oracle Database 12c software, create, monitor and support an Oracle Database 12c database.

The Oracle Database 12c Essential Administration course is also suitable for support staff and personnel who are required to carry out occasional administration or troubleshooting tasks. It aims to gives delegates practical experience in installing Oracle Database 12c software, configuring the database, performing basic monitoring of the database and in carrying out basic administration tasks.

Course Objectives

The Oracle Database 12c Essential Administration course is designed to provide the knowledge and skills needed to successfully manage an Oracle database.

Requirements

Delegates wishing to attend the Oracle Database 12c Essential Administration course should have an understanding of relational database concepts and basic operating system knowledge. They should also have a working knowledge of Oracle SQL, this can be gained by attendance on the pre-requisite course.

Pre-Requisite Courses

Follow-On Courses

Notes:
  • Course technical content is subject to change without notice.
  • Course content is structured as sessions, this does not strictly map to course timings. Concepts, content and practicals often span sessions.

Oracle Database 12c Essential Administration Training Course

Course Introduction

  • Administration and Course Materials
  • Course Structure and Agenda
  • Delegate and Trainer Introductions

Session 1: INTRODUCTION

  • Oracle product overview
  • Oracle Support services
  • Relational database concepts
  • Oracle architecture
  • Oracle 12c Multitenant architecture
  • Overview of the Oracle Cloud
  • Database administration tasks
  • Database administration responsibilities

Session 2: INSTALL THE ORACLE DATABASE SOFTWARE WITH THE OIU

  • Installation planning
  • Understand system requirements and operating system pre-requisites
  • Oracle flexible architecture
  • Environment variables
  • Use Oracle Universal Installer to install Oracle software (OUI)
  • The Oracle Inventory
  • De-install Oracle Database softare

Session 3: CREATE A DATABASE WITH THE DATABASE CONFIGURATION ASSISTANT (DBCA)

  • Select a storage method
  • Select a CDB or non-CDB database
  • Select a database type based on workload
  • Select a character set for the database
  • Create a database using the DBCA

Session 4: ADMINISTER A DATABASE

  • Administrative tools available to a DBA
  • Use SQL*Plus and SQL Developer to manage a database
  • Administer the database using Enterprise Manager Express
  • An overview of Enterprise Manager Cloud Control

Session 5: CONFIGURE THE ORACLE NETWORK ENVIRONMENT

  • Overview of network configuration
  • Oracle Net Listener configuration and management
  • Oracle Net Naming methods
  • Tools for configuring and managing the Oracle network
  • Configure local naming for client connections with Net Manager
  • Start and stop the Oracle listener
  • Configure the listener with EM
  • Use TNSPING to test Oracle Net connectivity
  • Connect to the database

Oracle Database 12c Essential Administration Training Course

Session 6: MANAGE AN ORACLE INSTANCE

  • Oracle Instance
  • Instance management
  • Memory structures
  • Background processes
  • Database authentication methods
  • Initialization parameters
  • Password file
  • Shut down the database
  • Start up the database
  • View alert log and trace files

Session 7: DATABASE STORAGE STRUCTURES

  • Oracle database structures
  • Control files
  • Redo log and archive redo log files
  • Tablespaces and data files
  • Create tablespaces
  • Manage tablespaces
  • Manage undo and use the Undo Advisor
  • Use Enterprise Manager Express and SQL Developer to view the storage structure of the database

Session 8: MANAGE USERS

  • Database administration accounts
  • User accounts
  • Create and administer user accounts
  • Lock and unlock user accounts
  • Change a user's password
  • Administer privileges and roles

Session 9: MANAGE SCHEMA OBJECTS

  • Create schema objects
  • Create a new table
  • View the attributes and contents of a table
  • Understand data integrity
  • Define constraints
  • Create indexes
  • View index attributes
  • Create views
  • Create synonyms
  • Create sequences

Session 10: BACKUP, RECOVER AND RESTORE A DATABASE

  • Oracle backup strategy
  • Overview of backup, restore and recovery
  • Backup and recovery configuration
  • Configure ARCHIVELOG mode
  • Overview of backup and recovery operations
  • Overview of scheduled backups
  • Configure backup settings
  • Configure recovery settings
  • Perform recovery

Session 11: PERFORMANCE MONITORING

  • Overview of self-monitoring architecture
  • Monitor an Oracle database
  • Automatic Workload Repository
  • Automatic Database Diagnostics Monitor (ADDM)
  • Additional monitoring
  • Use the advisors
Home Let Us Call You Enquiry

Place A booking





Print Friendly



Course Reviews

I've really enjoyed the course, it has had me interested from the start to finish and has improved my knowledge in a lot of areas regarding Oracle. I now feel a lot more confident and I am looking forward to putting the training/knowledge into action.

Mark - Manufacturing - January 2018




StayAhead Promo 2


Oracle User Group - Membership Benefits

Oracle User Group - Membership Benefits

Course Certification

Our independent Oracle, Solaris & Red Hat Linux curriculums helps prepare delegates for official certification.

See what our clients say . . .

I was really impressed with how much we managed to achieve in one day. I now feel confident to put some of the learnings into practice and feel that it will really help in my day-to-day role. Really impressed with the instructor, all concepts were explained in a very clear manner and I really enjoyed the day.

Janine - CRM Assistant - Retail / Hire - May 2018

More Reviews

+44 (0)20 7600 6116
Copyright © 2018 StayAhead Training Ltd
Cookies   /   Privacy Policy
sales@stayahead.com