IT manager

Training Course: Oracle Databases 19C


Register Now
Quick Inquiry
Discount Group Download Brochure (5)

IT235595

23 - 27 Feb 2025

Cairo (Egypt)

Hotel : Holiday Inn & Suites Cairo Maadi, an IHG Hotel

Cost : 3575 € Euro

Introduction:

 
The Oracle Databases 19c training program is meticulously designed by Global Horizon Training Center to provide professionals with comprehensive knowledge and skills in managing Oracle Databases. This program aims to build a solid foundation in Oracle Database 19c architecture, features, and advanced tools, ensuring participants can handle real-world database challenges efficiently.

Oracle Database 19c is the latest long-term release, offering a highly scalable, secure, and efficient database solution. The course provides practical and hands-on training to help learners understand the database management and application environment.

This training program is combined elements from both Oracle Database Administration 1 and 2, and goes more heavily towards Administration 2 

Objectives:

  • Understand Oracle Database 19c architecture and core components.
  • Master advanced database administration, performance tuning, and security practices.
  • Gain hands-on experience in backup, recovery, and data management.
  • Explore new features introduced in Oracle Database 19c and how to leverage them.
  • Learn to monitor, troubleshoot, and optimize database performance for enhanced efficiency.

 

Course Methodology:

This course is delivered using a combination of interactive lectures, practical demonstrations, and hands-on exercises. Participants will engage in case studies, group discussions, and real-world scenarios to ensure they acquire both theoretical knowledge and practical skills. Each day will include Q&A sessions for addressing specific queries.

 

Organizational Impact:

  • Enhance database performance, stability, and security in organizational IT systems.
  • Improve decision-making with timely and accurate data management.
  • Reduce downtime and risks through effective backup and recovery strategies.
  • Increase efficiency through automation and better resource management.
  • Empower the IT team to adopt the latest Oracle database features, ensuring competitive advantage.

 

Target Audience:

  • Database Administrators
  • IT Managers and System Administrators
  • Data Architects and Engineers
  • Professionals involved in database migration and upgrades
  • Any individual responsible for Oracle database infrastructure

 

Course Outline

Day 1: Introduction to Oracle Database 19c

  • Overview of Oracle Database 19c architecture
  • Core database components and structures
  • Installation and configuration
  • Oracle tools and utilities
  • Overview of Oracle Cloud and Autonomous Database

Day 2: Database Administration Essentials

  • Creating and managing databases
  • Database storage structures
  • Managing database users, privileges, and roles
  • Oracle Database file management
  • Understanding tablespaces and data files

Day 3: Backup and Recovery Techniques

  • Backup strategies and types
  • Oracle Recovery Manager (RMAN) basics
  • Performing backups using RMAN
  • Recovery techniques and disaster recovery planning
  • Flashback technology for data recovery

Day 4: Performance Tuning and Optimization

  • Oracle Database performance architecture
  • Tuning methodologies and tools
  • Monitoring system performance using AWR and ADDM
  • Index management and optimization
  • SQL query tuning techniques

Day 5: Advanced Database Security and New Features

  • Implementing database security and encryption
  • Managing user security and roles
  • Data auditing and compliance
  • New features in Oracle 19c
  • Hands-on lab: Advanced security and performance optimization

IT manager

Training Course: Oracle Databases 19C


Register Now
Quick Inquiry
Discount Group Download Brochure (5)

IT235595

23 - 27 Feb 2025

Cairo (Egypt) - Holiday Inn & Suites Cairo Maadi, an IHG Hotel

Hotel : Holiday Inn & Suites Cairo Maadi, an IHG Hotel

Cost: 3575 € Euro


  About Cairo

Cairo is a mesmerizing assortment of iconic monuments, bustling markets, and ancient sites encircled by a vast and sprawling metropolis. At its core lies a maze-like medieval quarter. A world away from the modern side of the city, it boasts a seductive blend of intricate mosques, jostling crowds, madrasas, and traditional hammams. No visit could be complete without visiting the awe-inspiring Giza Pyramids that preside over the city's horizon. Whether you come to delve into the city's ancient past, dive into colorful souqs, sip mint tea and contemplate thousands of years of history or explore the city's cosmopolitan side, you'll be left with memories to last a lifetime.


  Things to do and places to visit in Cairo

The multi-layered capital of Egypt offers its visitors lively markets, authentic restaurants, and a multitude of ancient sights and archeological findings. Gaze in wonder at the Pyramids, take an awe-inspiring look at Tutankhamen's burial mask, shop for handmade souvenirs in the bazaars or hop on a sunset cruise down the Nile and embrace the sensory overload that is Cairo.

Take a vacation in Cairo and you can:

  • Visit the Great Sphinx of Giza, one of Ancient Egypt's great mysteries.
  • Explore the ramparts of the Salah El-Din Citadel.
  • Join locals drinking coffee at Fishawi Café, one of Cairo's first cafes and most important meeting spots.
  • Marvel at the seemingly endless historical artifacts on display at the Egyptian Museum.
  • Learn about the Ummayad, Ottoman, and Ayyubbid dynasties and more at the Museum of Islamic Art.
  • Haggle for souvenirs and gifts at the Khan el-Khalili souk.
  • See one of the world's oldest universities at the Al-Azhar Mosque, one of the city's original mosques.
  • Take a tour of the showstopping Giza pyramids.
  • Savor local cuisine such as mezze in the old city.
  • Wander through the labyrinth-like streets of Coptic Cairo, the city's ancient quarter, and spot Roman relics.
 22 Portman Square, Marylebone, London W1H 7BG, UK
 3 Oudai street, Aldouki, Giza, Giza Governorate, Egypt
 0020233379764
 00201095004484
 00201102960555
 00201102960666
 19 Mayıs Mahallesi, 19 Mayis Street No 2 Sisli, 34360 Istanbul/Turkey
 00905357839460
 Australia Street, Raouche Beirut, Lebanon .، Beirut, Lebanon
 0096181746278
 811 Massachusetts Avenue, Boston, Massachusetts, 02118, USA
 6 Beirut Street - Fifth Circle Abdoun, P.O. Box 831370, 11183 Amman, Jordan
Copyright Global Horizon Training Center © 2019