TRAINING CATEGORIES
(Click Category to List Courses)

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


IT-D 211 - Oracle - Administration Workshop I - Release 2

Code Start Date Duration Venue
IT-D 211 04 November 2024 5 Days Istanbul Registration Form Link
IT-D 211 09 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 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 learn how to secure the availability of database through appropriate backup and recovery strategies.

Course Objectives

  • Installing Oracle Grid Infrastructure
  • Installing and configuring Oracle Database 
  • Configuring Oracle Net services
  • Monitoring and administering undo data
  • Managing the database storage structures
  • Creating and administer user accounts
  • Performing basic backup and recovery of a database
  • Managing data concurrency
  • Monitoring performance
  • Describing Oracle Database Architecture

Who Should Attend?

  • Database Administrators
  • Technical Administrator
  • Support Engineer
  • Technical Consultant
  • Java Developer
  • Anyone who deal directly or indirectly with database systems

Course Details/Schedule

Day 1

  • Installing your Oracle Software
  • Creating an Oracle Database
  • Managing the Oracle Database Instance

Day 2

  • Manage the ASM Instance
  • Configuring the Oracle Network Environment
  • Managing Database Storage Structures
  • Administering User Security

Day 3

  • Managing Data Concurrency
  • Managing Undo Data
  • Implementing Oracle Database Auditing

Day 4

  • Database Maintenance
  • Performance Management
  • Backup and Recovery Concepts
  • Performing Database Backups

Day 5

  • Performing Database Recovery
  • Moving Data
  • Exploring the Oracle Database Architecture

 

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