TRAINING CATEGORIES
(Click Category to List Courses)

38 - IT-D Information Technology - Databases and Related Technologies


IT-D 212 - Oracle - Administration Workshop II - Release 2

Code Start Date Duration Venue
IT-D 212 11 November 2024 5 Days Istanbul Registration Form Link
IT-D 212 16 December 2024 5 Days Istanbul Registration Form Link
Please contact us for fees

 

Course Description

This course takes the database administrator beyond the basic tasks covered in the first workshop. Participants will begin by gaining a deep understanding of the most important responsibilities a DBA has: performing backup and recovery. In this course also, they will learn how to diagnose and repair data failures with Flashback technology, manage space to optimize database storage so they can respond to growing space requirements and monitor and manage major database components, including memory, performance and resources. Finally they will also learn how to secure the availability of their database through appropriate backup and recovery strategies and Automate DBA tasks with the Scheduler.

Course Objectives

  • Learning how to use Oracle Secure Backup to backup and recover a database
  • Learning how to use Oracle's Flashback technology to recover your database
  • Detecting block corruptions and take appropriate measures to correct them
  • Learning how to use the various database advisors and views to monitor 
  • Exploring control database resource usage with the Resource Manager
  • Simplifying management tasks by using the Scheduler
  • Reviewing database log files for diagnostic purposes
  • Customizing language-dependent behavior for the database and individual sessions
  • Administering a VLDB
  • Implementing a secure database
  • Transporting data across platforms

Who Should Attend?

  • Database Administrators
  • Sales Consultants
  • Support Engineers
  • Technical Consultants
  • Anyone who deal directly or indirectly with database systems

Course Details/Schedule

Day 1

  • Core Concepts and Tools of the Oracle Database
  • Configuring for Recoverability
  • Using the RMAN Recovery Catalog
  • Configuring Backup Settings
  • Creating Backups with RMAN

Day 2

  • Restore and Recovery Task
  • Using RMAN to Perform Recovery
  • onitoring and Tuning RMAN
  • Diagnosing the Database
  • Using Flashback Technology I

 

Day 3

  • Using Flashback Technology II
  • Performing Flashback Database
  • Managing Memory
  • Managing Database Performance
  • Managing Performance by SQL Tuning
  • Managing Resources

Day 4

  • Configuring for Recoverability
  • Using the RMAN Recovery Catalog
  • Configuring Backup Settings
  • Creating Backups with RMAN
  • Restore and Recovery Task
  • Using RMAN to Perform Recovery
  • onitoring and Tuning RMAN
  •  Core Concepts and Tools of the Oracle Database

Day 5

  • Using Flashback Technology I
  • Using Flashback Technology II
  • Performing Flashback Database
  • Managing Memory
  • Managing Database Performance
  • Managing Performance by SQL Tuning
  • Managing Resources
  • Diagnosing the Database

 

ETABS and SAFE. Training 24 CCE 210 5 SAP 2000. Training 25 CCE 305 5 Quality Assurance in Pavement Construction 26 CCE 401 5 Construction Project Management 27 CCE 402 10 Construction Project Management (10 Days) 28 CCE 403 5 Construction Project Management-Intensive 29 CCE 405 5 Principles of Construction Project Management 30 CCE 406 10 Principles of Construction Project Management (10 Days) 31 CCE 410 10 Construction Project and Risk Management (10 days) 32 CCE 411 5 Project & Contract Management for Marine Construction 33 CCE 412 5 Application of GIS in Construction Management 34 CCE 415 4 Sustainable Water Management Techniques, Innovation and Solution (4 Days) 35 CCE 419 5 Construction Management of Hydraulic Projects 36 CCE 420 5 Water Project Management 37 CCE 421 10 Modern Technologies in the Supervision and Quality Control of Irrigation Projects and Dealing with Contractors (10 Days) 38 CCE 422 5 Rapid Earthquake Hazard Evaluation of Buildings 39 CCE 425 10 Practical Application of Computers in Structural Engineering (10 Days) 40 CCE 428 5 Survey & Profile Using Total Station 41 CCE 430 5 Bridge Construction and Maintenance 42 CCE 435 5 Bridge Inspection and Maintenance 43 CCE-A 410 10 إدارة المشاريع الهندسية -10 أيام
21 - TTC - Transportation and Traffic Control
22 - ADV - Architectural Design and Visualization
23 - SRM - Safety and Occupational Health
24 - CSM - Public Relations, Communication Skills & Office Management
25 - TEM - Training and Education Management
26 - CMR - Customer Relations