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 |
Architecture Overview Database Structures Process Structures Memory Structures ? SGA Memory Structures ? PGA Alternative Configurations CDB and PDB
Basic Structures of an Oracle RDBMS Data Files Redo Log Files Archived Redo Log Files Control Files Oracle-Managed Files (OMF)
Connecting as a Privileged User Password file authentication Starting a Database Shutting Down a Database Reading the Alert Log / Trace Files SPFILE / Parameter management
Basic Definitions Blocks and Extents Multiplexing Control Files
Introduction to Segments Managing Undo Segments Automatic Undo Management Managing Data Segments Managing Index Segments Monitoring Database segments
Tablespace Overview System Tablespace Types of Tablespaces Creating additional tablespaces Altering Tablespaces Temporary Tablespaces - Default Temporary Tablespaces Tablespace Quotas Monitoring Tablespaces
Managing Database Users System / Object Privileges Managing Roles / Profiles Resource and Password Management
Statement Level Object Level Fine grained |
Recent comments
"I have joined Oracle course In Globalerp solutions.. The faculties is Very Good Explaining way of Teaching,"
"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. "
"Hi, very Delighted to learn Oracle course Here, our trainer is very Good Explaining way of Teaching..."