ORACLE 12C Admin Part 1

 

COURSE ID

GES-OA1
DURATION 20 hrs
DELIVERY METHOD Classroom Instructor-led training (CILT)
Online Instructor-led training ( OILT)
COURSE OVERVIEW This course is designed to give the Oracle database administrator (DBA) a firm foundation in basic database administrative tasks. Students gain a thorough conceptual understanding of the Oracle database architecture, and how the architectural structures of an Oracle database work and interact with one another. Students also learn how to create an operational. This course is designed to give the Oracle database administrator (DBA) a firm foundation in basic database administrative tasks. Students will gain a conceptual understanding of the Oracle database architecture and how the architectural structures work and interact with one another. Students will also learn how to create an operational database and properly manage the various structures in an effective and efficient manner in order to have a well-designed and operational database. In addition to learning the various commands needed to perform the DBA tasks, the course also provides students with instruction to perform the same DBA tasks using the Oracle Enterprise Manager tool. The instructor-led lesson topics are reinforced with structured hands-on practices.
COURSE OBJECTIVES

This course is designed to prepare you for the corresponding Oracle Certified Associate exam: Exam #1Z0-031

1. Creation and installation of database.
2. Basic Oracle Architecture
Architecture Overview
Database Structures
Process Structures
Memory Structures ? SGA
Memory Structures ? PGA
Alternative Configurations
CDB and PDB

3. Oracle Database Files
Basic Structures of an Oracle RDBMS
Data Files
Redo Log Files
Archived Redo Log Files
Control Files
Oracle-Managed Files (OMF)

4.Starting and Stopping the Database
Connecting as a Privileged User
Password file authentication
Starting a Database
Shutting Down a Database
Reading the Alert Log / Trace Files
SPFILE / Parameter management

5.How Space is Physically Consumed
Basic Definitions
Blocks and Extents
Multiplexing Control Files

6.How Space is Logically Consumed
Introduction to Segments
Managing Undo Segments
Automatic Undo Management
Managing Data Segments
Managing Index Segments
Monitoring Database segments

7.Managing Tablespaces - Default behavior of CREATE TABLESPACE command
Tablespace Overview
System Tablespace
Types of Tablespaces
Creating additional tablespaces
Altering Tablespaces
Temporary Tablespaces - Default Temporary Tablespaces
Tablespace Quotas
Monitoring Tablespaces

8.Grid Configuration and ASM

9.Users and Security
Managing Database Users
System / Object Privileges
Managing Roles / Profiles
Resource and Password Management

10.Auditing
Statement Level
Object Level
Fine grained

popular courses
ORACLE 12C Admin Part 1 Training Montreal
QA view

ORACLE 12C Admin Part 1 Training Montreal
.net view

ORACLE 12C Admin Part 1 Training Montreal
Java view
Oracle view
ORACLE 12C Admin Part 1 Training Montreal
Sap view

Recent comments

Mahmood

"I have joined Oracle course In Globalerp solutions.. The faculties is Very Good Explaining way of Teaching,"

Alex

"Woked with the Global ERP Solutions team they have serviced as outstanding job. I recommend to Global ERP Solutions as a technology driven complete solution for current market driven companies. "

poojan

"Hi, very Delighted to learn Oracle course Here, our trainer is very Good Explaining way of Teaching..."