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 18c.
5 Days/Lecture & Lab
This course is designed for: