Oracle Database 12cR2 Essential Administration
- Course Code O12CEA
- Duration 2 days
Course Delivery
Additional Payment Options
-
GTC 16 inc. VAT
GTC, Global Knowledge Training Credit, please contact Global Knowledge for more details
Jump to:
Course Delivery
This course is available in the following formats:
-
Company Event
Event at company
-
Public Classroom
Traditional Classroom Learning
-
Virtual Learning
Learning that is virtual
Request this course in a different delivery format.
Course Overview
TopOracle Database 12cR2 Essential Administration Course Overview
The Oracle Database 12cR2 Essential Administration course is designed for Database Administrators of small sized databases who need to carry out basic system administration tasks on Oracle Database 12cR2 database.
The Oracle Database 12cR2 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 12cR2 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.
Exercises and examples are used throughout the course to give practical hands-on experience with the techniques covered.
Full time Database Administrators should attend the Oracle Database 12cR2 Administration course.
Versions supported 12cR2,18c,19c.
Course Schedule
Top-
- Delivery Format: Virtual Learning
- Date: 30-31 May, 2024
- Location: Virtual
-
- Delivery Format: Virtual Learning
- Date: 01-02 August, 2024
- Location: Virtual
-
- Delivery Format: Virtual Learning
- Date: 07-08 October, 2024
- Location: Virtual
Target Audience
TopWho will the Course Benefit?
The Oracle Database 12cR2 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 12cR2 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
TopCourse Objectives
The Oracle Database 12cR2 Essential Administration course is designed to provide the knowledge and skills needed to successfully manage an Oracle database.
Course Content
TopOracle Database 12cR2 Essential Administration Training Course
Course Contents - DAY 1
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 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 12cR2 Essential Administration Training Course
Course Contents - DAY 2
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
Course Prerequisites
TopRequirements
Delegates wishing to attend the Oracle Database 12cR2 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.
This course is run on a Linux operating system,a basic knowledge of UNIX/Linux is recommended but is not essential.
Follow on Courses
TopFurther Learning
- Oracle Database 19c Administration
- Oracle PL/SQL
- Oracle SQL Advanced
- STA_O12CEA
- Oracle Database 12cR2 Essential Administration
- Operating Systems
- STA_O12CEA | Oracle Database 12cR2 Essential Administration | Training Course | Oracle.
- Oracle