AMFASOFT CORPORATION - Laserfiche WebLink

Home Browse Search

Program Description This program focuses on Oracle Database Administration II, backup recovery, networking, and performance tuning. Included are theory and hands-on practice using the Oracle database engine, Oracle server, Oracle NET, Oracle Enterprise Manager, and tuning tools. Course Objectives • Manage data concurrency • Monitor performance • Describe Oracle Database Architecture • Back and recover a database (and its parts) with RMAN (command -line and Enterprise Manager) • Use flashback technology to view past states of data and to revert either objects or the entire database to a past state • Use an appropriate and flexible memory configuration for your database • Identify burdensome database sessions and poorly performing SQL • Configure the Oracle Database for optimal recovery • Configure the database instance such that resources are appropriately allocated among sessions and tasks • Schedule jobs to run inside or outside of the database • Use compression to optimize database storage and duplicate a database Course Delivery Option: Classroom, Online/Distance Learning Sequence and frequency of class sessions: Every 6 weeks Related Job Titles/Occupations Software Developers and Programmers SOC Code 15-1130 Computer Operators SOC Code 15-1100 Database Administrator SOC Code 15-1140 Instruction Details Oracle Database 12c- Administration D: This Oracle Database 1 lg: Administration Workshop II Release 2 training takes the database administrator beyond the basic tasks covered in the first workshop. You will begin by gaining a deep understanding of the most important responsibilities a DBA has: performing backup and recovery. Program In Duration: Course Name Clock Hours Duration Maximum Completion Time Oracle Database Admin II 160 hours 8 weeks 12 weeks Pre -requisite: Oracle Database 12C: Administration I 114