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
About London
The UK capital of London is a city that combines the old and the new. It is as equally famous for the latest fashion and innovation as it is for its impressive heritage. London's attractions range from the Royal Palace to the DIY atmosphere of its markets. It is also a picturesque city of parks and of course, the majestic Thames River. The city extends for miles beyond its ancient core and each neighborhood has its own charming atmosphere for visitors to explore. London also wears its status as a world city proudly and the influence of different cultures is plain to see in the food and fashion of the capital.
Things to do and places to visit in London
With so many attractions in London, anyone can find something to delight them. Art lovers will enjoy the world-renowned museums and galleries, most of which are free. Sports fans are spoilt for choice by the city's array of football clubs. Theatre and music fans have a vast list of venues to visit, whilst shopaholics have Harrods, Oxford Street, Camden and much more to look forward to after arranging flights to London.
Some unmissable London attractions include:
- Seeing priceless masterpieces in the Tate Britain or the National Gallery.
- Watching the changing of the guard at Buckingham Palace.
- Visiting Trafalgar Square's famous monument.
- Marveling at the Crown Jewels in the Tower of London.
- Getting a bird's eye view of the city from the London Eye.
- Tasting one of Brick Lane's famous curries.
- Browsing the exclusive shops of Knightsbridge.
- Visiting a market – Spitalfields for antiques, Camden for clothes or Borough Market for street food.
- Admiring design from around the world in the Victoria and Albert Museum.
- Looking for clues at the home of fiction's most famous detective, Sherlock Holmes.
- Strolling through one of the lovely parks, including Hyde Park, St James' Park or Kew Gardens.
- Eating Britain's most famous dish, fish and chips.
- Watching the street performers in Covent Garden.
- Enjoying the views at a South Bank cafe.