Oracle 12c Database Management Workshop

PT10318
Training Summary
This course provides an educational starting point for administration of the Oracle database. The course begins with an in-depth discussion of the database architecture, then installing the Oracle software and creating an Oracle database are covered. The Oracle instance, background processes, the SGA and memory structures are explored. As well as administering the initialization parameter file and the procedures for database startup and shutdown. Various models of data concurrency and consistency and alternative isolation levels are explained along with their uses. A large portion of the class covers common administration tasks such as managing the use of disk space through data files, tablespaces, extents, blocks and rows, the UNDO tablespace and the on-line redo log. The effective use of indexes is presented and how Oracle uses indexes to improve query performance. Since so much access to Oracle’s features is based upon it, a comprehensive overview of the PL/SQL language is conducted, including stored procedures and database triggers. All aspects of database user creation, maintenance and management are provided. Also including database security and controlling user access to database objects and resources There is a review of Oracle’s approach to the “self-tuning database” and the SQL Access and SQL Tuning advisors. The Oracle data utilities SQL Loader, Import data pump and Export data pump are described. Finally an overview of backup and recovery concepts is given along with simple backup and recovery procedures. The content of this course is applicable to Oracle version 12c. This class provides preparation for the OCP Oracle Database 12c: Installation and Administration 1Z0-062 exam. Oracle Corporation suggests that candidates also have six months of hands-on experience before testing.
Prerequisites
Prior to taking this course, you should have the following skills and experience: • Skill with GUI interfaces • Data processing background • An understanding of SQL is required to succeed in this class
Duration
5 Days/Lecture & Lab
Audience
This course is designed for: • Oracle developers and novice DBAs • Oracle developers and DBAs wishing to ‘back fill’ gaps in their expertise • Oracle APEX, Forms and Reports developers • Technical managers needing Oracle expertise for project administration
Course Topics
Oracle Architecture
  • Data Dictionary
  • Installing Oracle 12c Enterprise Edition
  • Database Creation
  • Database Startup and Shutdown
  • Managing the Initialization Parameter file
  • Managing the System Global Area (SGA)
  • Concurrency and Consistency
  • Managing Database Storage
  • Managing UNDO
  • PL/SQL Overview
  • Managing Database Users
  • Controlling User Access
  • Managing Database Security
  • Creating Tables
  • Maintaining Tables
  • Creating Constraints
  • Maintaining Constraints
  • Effective Indexing
  • Creating Other Schema Objects
  • Working with Statistics
  • Self-managing Database
  • Loading and Moving Data
  • Backup and Recovery Concepts

Related Scheduled Courses