Oracle Database 23ai: Administration Workshop Training Course

This instructor-led live training in Thailand (delivered online or onsite) is designed for system administrators who want to master the administration, monitoring, and support of Oracle databases.

Upon completion of this training, participants will be equipped to:

• Comprehend the significant feature and architectural changes in Oracle databases.
• Efficiently manage and monitor Oracle databases.
• Optimize the performance of Oracle databases.

This instructor-led, live training offered in Thailand (either online or onsite) is designed for entry-level database administrators who aim to take control of backup and recovery tasks within Oracle Database 19c.

By the conclusion of this program, participants will be able to:

• Comprehend the core concepts of backup and recovery in Oracle Database 19c, including its architecture and the impact of different failure types.
• Gain practical experience in configuring backup and recovery settings, particularly within the RMAN environment and fast recovery area.
• Develop hands-on skills in executing various backup and recovery operations, including full, incremental, and point-in-time recovery.
• Utilize Oracle’s Flashback technology to streamline database recovery and handle disaster recovery scenarios effectively.
• Apply best practices for backup, recovery, and disaster recovery to ensure high data availability and minimize downtime in Oracle Database 19c.

This live, instructor-led training, conducted in Thailand either online or on-site, is tailored for intermediate-level database administrators seeking to effectively manage, optimize, and secure Data Guard environments to achieve robust disaster recovery and high availability.

Upon completion, participants will be equipped to:

• Grasp the architectural framework and advantages of Oracle Data Guard in enhancing disaster recovery and high availability.
• Acquire hands-on proficiency in setting up and overseeing physical and logical standby databases, encompassing the Data Guard broker.
• Hone practical capabilities in monitoring, troubleshooting, and fine-tuning Data Guard environments for peak performance.
• Explore advanced functionalities such as Active Data Guard, Data Guard integration with RAC, and the securing of Data Guard communication channels.
• Implement best practices for disaster recovery planning, maintaining data consistency, and automating Data Guard workflows.

This instructor-led, live training in Thailand (online or onsite) is tailored for entry-level database administrators aiming to be fully prepared to manage and optimize their Oracle environments.

By the end of this course, participants will have the ability to:

• Comprehend the essential features and architecture of Oracle Database 19c, including system prerequisites and installation strategies.
• Develop practical skills for installing Oracle Database 19c and Oracle Grid Infrastructure, encompassing network, storage, and security configuration.
• Understand the full upgrade lifecycle to Oracle Database 19c, from preliminary planning to post-upgrade verification.
• Enhance troubleshooting skills to address frequent issues during installation and upgrade tasks.
• Apply best practices to Oracle Database installation and upgrades, ensuring a seamless and successful deployment.

This instructor-led live training in Thailand (delivered online or onsite) is tailored for intermediate-level database administrators looking to effectively manage and optimize a multitenant environment.

By the conclusion of this training, participants will be capable of:

• Understanding the essential components and benefits of Oracle Database 19c's multitenant architecture, including CDBs and PDBs.
• Gaining practical skills in the installation, configuration, and management of container databases (CDBs) and pluggable databases (PDBs).
• Developing proficiency in implementing security measures, backup and recovery strategies, and performance tuning within a multitenant environment.
• Learning to manage high availability and disaster recovery in a multitenant architecture, including the configuration of Data Guard and Oracle RAC.
• Acquiring troubleshooting techniques and best practices for maintaining a secure, efficient, and reliable multitenant database environment.

This live, instructor-led training session is available in Thailand (either online or onsite) and is designed for intermediate-level database administrators aiming to oversee and optimize complex, high-availability Oracle database environments.

By the conclusion of the program, participants will be able to:

• Fully comprehend the Oracle RAC architecture and Grid Infrastructure, encompassing installation, configuration, and management workflows.
• Cultivate hands-on skills in managing Automatic Storage Management (ASM), including the oversight of disk groups, instance tuning, and backup/recovery protocols.
• Adopt advanced RAC performance tuning techniques, disaster recovery configurations, and best practices for high availability.
• Develop strong troubleshooting and diagnostic skills for resolving issues in RAC and Grid Infrastructure environments.
• Manage the patching and upgrading of Oracle RAC and Grid Infrastructure with a focus on minimizing downtime and preserving system integrity.

This live, instructor-led training, offered in Thailand (online or onsite), is designed for beginner-level database administrators and developers. It focuses on mastering SQL to efficiently manage, query, and manipulate data within Oracle databases for administrative and operational purposes.

By the end of this training, participants will be able to:

• Comprehend Oracle database architecture, including the roles of schemas, users, and sessions.
• Write and optimize SQL queries for effective data retrieval, filtering, and manipulation.
• Utilize joins, subqueries, and set operators to interact with multiple tables and complex queries.
• Perform data aggregation, grouping, and analysis using SQL functions.
• Manage schema objects such as views, sequences, and indexes to improve database operations. 

This instructor-led live training in Thailand (online or onsite) is designed for intermediate-level developers and database administrators seeking to utilize Oracle SQL to design, manage, and optimize database applications, as well as to automate tasks with efficiency.

Upon completion, participants will have the capability to:

• Understand Oracle database architecture and administer users, schemas, and permissions.
• Write optimized SQL queries for effective data retrieval, manipulation, and analysis.
• Implement advanced SQL techniques, including joins, subqueries, and hierarchical queries.
• Design and maintain database objects such as tables, indexes, views, and sequences.