Database Training in Bangkok

This instructor-led, live training in Bangkok (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 live, instructor-led training, conducted in Bangkok 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 live, instructor-led training session is available in Bangkok (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 instructor-led, live training offered in Bangkok (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 instructor-led live training in Bangkok (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 in Bangkok (online or onsite) is designed for advanced-level developers and database administrators seeking to use PL/SQL to build high-performance, secure, and scalable database solutions by leveraging advanced programming techniques and integrations.

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

• Manage complex data types, collections, and bulk operations for efficient data handling.
• Enhance database functionality by developing object types, table functions, and custom aggregates.
• Ensure security and speed by applying performance tuning techniques, utilizing native compilation, and protecting against SQL injection.
• Build robust database solutions by implementing application contexts, VPD, and secure program units.

This live, instructor-led training session, conducted in Bangkok (either online or onsite), is designed for beginner-level developers and database administrators aiming to harness PL/SQL for automating database tasks, implementing business logic, and crafting robust database applications.

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

• Develop efficient PL/SQL programs to streamline database operations and effectively integrate SQL commands.
• Create reusable program units, such as procedures, functions, packages, and triggers, to support modular and scalable applications.
• Utilize advanced data structures like associative arrays and control query results using cursors.
• Manage errors effectively and secure code through encryption, obfuscation, and conditional compilation techniques.
• Apply PL/SQL in real-world scenarios by leveraging built-in packages for file handling, email automation, and other advanced functionalities. 

This live, instructor-led training (offered online or on-site) is tailored for intermediate-level database administrators looking to gain a comprehensive understanding of Oracle Database 19c PL/SQL programming and advanced SQL techniques.

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

• Comprehend the foundational and advanced aspects of PL/SQL.
• Build efficient advanced SQL queries for data retrieval and manipulation.
• Utilize PL/SQL constructs to control data and database operations.
• Optimize SQL queries for improved performance metrics.
• Apply advanced PL/SQL features such as collections, bulk processing, and error handling.
• Effectively debug and manage PL/SQL codebases.

This instructor-led, live training in Bangkok (online or on-site) is tailored for advanced-level DevOps engineers and SREs aiming to effectively manage and scale Prometheus and Grafana within large environments.

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

• Design Prometheus and Grafana architectures suitable for large-scale and distributed settings.
• Enhance Prometheus performance to meet the demands of high-traffic systems.
• Configure Grafana to manage large datasets and intricate visualizations.
• Apply advanced troubleshooting techniques and scalability strategies.

This live, instructor-led training, available Bangkok (online or onsite), is tailored for intermediate developers and DevOps engineers aiming to master the instrumentation of applications for exporting and monitoring custom metrics via Prometheus and Grafana.

By the conclusion of this training, participants will have the ability to:

• Recognize the value of custom metrics in enhancing application monitoring.
• Instrument applications to export custom metrics for consumption by Prometheus.
• Design and set up Grafana dashboards to visualize custom metric data.
• Apply industry best practices for integrating monitoring solutions into the development workflow.

This live, instructor-led training, available Bangkok (online or onsite), is tailored for advanced Kubernetes administrators and DevOps engineers aiming to upgrade their monitoring proficiency with Prometheus and Grafana.

Once concluded, participants will possess the ability to:

• Configure Prometheus and Grafana for Kubernetes observability.
• Track vital metrics for pods, nodes, and services.
• Build dynamic dashboards to display cluster health and performance.
• Execute alerting strategies to resolve issues proactively.
• Utilize best practices for scaling monitoring systems in Kubernetes environments.

This instructor-led, live training, conducted in Bangkok (either online or onsite), is designed for advanced-level DevOps and SRE professionals aiming to elevate their alerting and automation capabilities with Grafana and Prometheus.

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

• Developing and overseeing advanced alerting rules in Prometheus.
• Linking Prometheus Alertmanager with external applications using webhooks.
• Accelerating issue resolution through automated alert responses.
• Utilizing Grafana to visualize and control alerts efficiently.

This instructor-led, live training in Bangkok (available online or on-site) is tailored for intermediate-level cloud and DevOps engineers seeking to strengthen cloud observability with Grafana and Prometheus.

By the end of the session, participants will be capable of:

• Recognizing the benefits of integrating Grafana and Prometheus with cloud platforms.
• Deploying Prometheus to monitor cloud-based resources.
• Configuring Grafana for the visualization of cloud service metrics.
• Leveraging cloud-native tools and integrations to support monitoring scalability.

This live, instructor-led training in Bangkok (available online or onsite) is designed for intermediate-level DevOps and SRE professionals seeking to develop impactful dashboards and enhance their monitoring strategies with Grafana and Prometheus.

By the end of the program, participants will be equipped to:

• Apply best practices for effective dashboard design.
• Construct and configure sophisticated Grafana dashboard components.
• Utilize Grafana templating to create dynamic, reusable interfaces.
• Deploy alerting strategies to strengthen operational vigilance.

This live, instructor-led training in Bangkok (delivered online or onsite) is designed for beginner-level system administrators and DevOps engineers seeking to acquire core monitoring skills using Grafana and Prometheus.

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

• Comprehend the role and importance of monitoring in IT environments.
• Install and configure Grafana and Prometheus for foundational monitoring activities.
• Create basic dashboards and alerts to visualize system performance.
• Adopt best practices for monitoring system availability and performance.

Conducted by an instructor, this live training takes place in Bangkok (either online or in-person). It is designed for data scientists and software developers ranging from beginner to intermediate levels who aim to explore Milvus and its practical use cases in various AI contexts.

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

• Comprehending the architecture and key features of Milvus.
• Deploying vector databases across different AI applications.
• Conducting similarity searches with optimal accuracy and performance.
• Applying Milvus to address real-world AI challenges.

This expert-led, live session in Bangkok (available online or in-person) is tailored for junior IT specialists and DevOps professionals aiming to acquire core competencies in Grafana and Prometheus.

After finishing this training, learners will be equipped to:

• Comprehend the role and primary attributes of Grafana and Prometheus.
• Install and optimize both systems in a Linux context.
• Configure initial data sources and construct simple dashboards within Grafana.
• Monitor operational metrics and generate visual representations via Prometheus.

This instructor-led, live training in Bangkok (available online or onsite) targets beginner to intermediate-level data scientists and software developers eager to learn how to leverage Pinecone for various AI scenarios, including semantic search and personalization.

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

• Understand the underlying architecture and features of Pinecone.
• Implement vector databases across different AI applications.
• Conduct similarity searches with high precision and speed.
• Utilize Pinecone to solve real-world AI problems.

This instructor-led, live training, offered online or onsite in Bangkok, is tailored for intermediate to advanced database administrators, network engineers, and IT professionals aiming to enhance database performance, scalability, and reliability using Spine-Leaf architecture with VXLAN.

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

• Understand the Spine-Leaf network topology and its key benefits.
• Implement VXLAN for scalable and efficient database networking.
• Optimize database workloads across distributed data center environments.
• Deploy Spine-Leaf architecture in cloud and on-premises data centers.
• Enhance network security, redundancy, and fault tolerance for database environments.
• Automate network configurations for database management using Python and Ansible.

This instructor-led live training in Bangkok (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.

Conducted in Bangkok, this instructor-led training focuses on crafting advanced SSIS data flows and transformations. Participants will gain mastery over Slowly Changing Dimensions, manage complex data sources, and learn to deploy robust packages, thereby enabling efficient data warehousing and migration strategies.

This live, instructor-led training in Bangkok (online or onsite) is designed for intermediate to advanced data scientists and machine learning engineers aiming to master the utilization of vector databases for building scalable, high-performance AI applications.

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

• Understand the core principles of vector databases.
• Learn methods for creating and managing vector embeddings.
• Explore indexing strategies for high-dimensional data.
• Develop the ability to perform efficient similarity searches.
• Apply vector database knowledge to machine learning initiatives.

This instructor-led, live training session in Bangkok (delivered online or on-site) is tailored for intermediate developers and IT professionals seeking to harness the new features of APEX 23-24. The course focuses on designing optimized workflows and fortifying application security.

By the end of the program, participants will be capable of:

• Developing and maintaining APEX applications using the latest functionalities in versions 23-24.
• Designing and implementing efficient workflows within APEX.
• Applying advanced security measures to protect APEX applications and data.
• Integrating APEX applications with external systems to ensure smooth data exchange.
• Testing, debugging, and deploying APEX applications while adhering to best practices.

This instructor-led, live training in Bangkok (online or onsite) is tailored for intermediate-level IT professionals aiming to develop expertise in designing, implementing, and managing relational databases, alongside querying and manipulating data using SQL.

Upon completion, participants will be capable of:

• Comprehending the essential elements of database design.
• Building and administering relational databases.
• Achieving proficiency in crafting SQL queries for data retrieval and modification.
• Understanding complex SQL techniques and concepts.
• Developing skills to enhance database performance and maintain integrity.

This live, instructor-led training, offered in Bangkok (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 Bangkok (available online or on-site) is designed for beginner-level data professionals aiming to acquire the skills necessary to design, implement, and manage SSIS packages for data integration and transformation tasks.

Upon completion, participants will be capable of:

• Understanding the architecture and components of SSIS.
• Designing and implementing ETL processes using SSIS.
• Utilizing SSIS tools to develop, deploy, and manage data integration solutions.
• Troubleshooting and optimizing SSIS packages for performance and reliability.

This live, instructor-led training session (available online or onsite) is designed for beginner-level software developers and database administrators aiming to acquire foundational knowledge of vector databases, encompassing their structure, functionality, and real-world applications.

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

• Comprehend the fundamental concepts and utility of vector databases.
• Identify key distinctions between vector databases and conventional database technologies.
• Master basic methods for creating and handling vector data.
• Conduct simple similarity searches.
• Recognize the contribution of vector databases to AI application development.

Targeted at system administrators, this instructor-led live session in Bangkok (delivered online or onsite) provides essential knowledge for administering, monitoring, and supporting Oracle databases.

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

• Comprehend key architectural and functional changes in the Oracle database.
• Oversee the management and monitoring of Oracle databases.
• Enhance Oracle database performance through optimization techniques.

CockroachDB is an open-source distributed SQL database engineered for high resilience and data locality. It serves as an alternative to proprietary global databases such as Google Spanner, granting organizations full control over their infrastructure. This instructor-led, live training (available online or onsite) is tailored for advanced database engineers and architects seeking to leverage CockroachDB to substitute proprietary global SQL databases.

This instructor-led, live training in Bangkok (online or onsite) is intended for database administrators and developers who aim to utilize Microsoft Azure Cosmos DB for developing and managing highly responsive, low-latency applications.

By the conclusion of this training, participants will have the ability to:

• Set up the required Cosmos DB resources to begin building databases and applications.
• Optimize application performance and storage by making use of Cosmos DB APIs.
• Control database operations and cut costs by refining Cosmos DB resources.

This live, instructor-led training in Bangkok (offered online or onsite) is designed for database administrators and developers seeking to transition from proprietary databases to open-source PostgreSQL.

By the end of the program, participants will have the capability to assess migration readiness, develop and execute schema migration plans, transfer data using appropriate tools, and facilitate application code conversion.

This live, instructor-led training session, conducted in Bangkok (either online or onsite), is designed for developers and system administrators looking to utilize Hazelcast for handling distributed data structures and improving application performance.

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

• Install and configure Hazelcast to begin creating and managing clusters.
• Set up a cluster to facilitate automatic discovery of multiple processes.
• Implement Management Center for cluster connection and monitoring.
• Create applications and deploy them through the Hazelcast cluster.

This live, instructor-led training in Bangkok, delivered online or onsite, is designed for developers looking to leverage Oracle APEX to develop, scale, and deploy applications more efficiently with reduced code complexity.

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

• Establish the development environment necessary for building database applications with Oracle APEX.
• Explore Oracle APEX tools to build robust, full-featured applications.
• Develop applications and pages using Oracle APEX and the Page Designer UI.
• Easily extend the capabilities of complex enterprise apps using Oracle APEX.
• Optimize application performance and streamline the deployment lifecycle.
• Secure and manage access rights to application data and components.

This instructor-led live course, offered online or on-site, is designed for system administrators and DevOps engineers seeking to utilize Prometheus for monitoring native systems and applications, or for observing highly dynamic microservices in cloud-based setups.

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

• Installing and configuring Prometheus.
• Comprehending the features, architecture, and core principles of Prometheus.
• Querying data effectively with PromQL.
• Building visualizations and dashboards in Grafana.
• Configuring system monitoring and alerting mechanisms.
• Analyzing and optimizing system and application performance.
• Implementing secure integrations with remote endpoints and existing infrastructure.

This live, instructor-led training offered in Bangkok is tailored for teams looking to answer questions based on their own documents and guidelines.

By the end of the training, participants will be equipped to:

• Structure documents so they are effectively usable by AI systems
• Develop a knowledge assistant leveraging Claude Projects, custom GPTs, or Langdock
• Obtain answers with supporting sources
• Ensure the knowledge base remains current and up-to-date

This instructor-led, live training, delivered in Bangkok (online or on-site), is designed for developers seeking to utilize SQLite for developing embedded applications on various devices, such as desktops, mobile phones, Android TV, and cameras.

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

• Install and configure SQLite on any platform.
• Understand the features and architecture of SQLite.
• Execute common SQL operations in SQLite.
• Manipulate data and tables within SQLite.
• Understand the various SQLite data types, tools, and functions.
• Perform calculations using SQLite aggregate functions.