Home  |  About Us  |  Careers |  Resources  |  Client List  |  Sitemap  |  Contact Us
 

Call: 416-623-9493 or 905-497-8717

Toll Free: 1-866-955-4526
E-mail: info@globalerp.ca

 
Software Quality Assurance Training Business Analysis Training SAP Training PMP Training Informatica Training JAVA Training MICROSOFT .NET Training Big Data & Hadoop Training Scrum Training Microsoft BI Training Devops Jenkins Course ORACLE Admin Training

 
 
 
 
 
 
ORACLE 12C Admin Part 1
     
  COURSE ID   GES-OA1
  DURATION   20 hrs
  Course Fee   $$1000+HST
  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.
  AUDIENCE  
  PREREQUISITES  
  COURSE OBJECTIVES  

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

  COURSE OUTLINE  

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
  SOFTWARE  
  CONTACT INFORMATIONwe  

Address: 199 Advance Blvd, Suite: 201
..................Brampton, ON, L6T 4N2

Phone: 416-623-9493 or 647-233-8717
E-mail: info@globalerp.ca