Change Data Capture (CDC) with Debezium Training Course

This 3 day course gives an introduction to ORACLE PL/SQL, an application development environment that enables the writing of stored procedures, functions and triggers using both SQL and PL/SQL commands.

The course takes the format of a workshop, with a mix of lecture, working examples and practical exercises. Although the content may be customised, at least 2 days are needed to cover the core elements.

Full course notes are provided along with sample database files, example SQL files and free software tools for use in accessing an ORACLE database.

This 2 day course gives an introduction to SQL Developer, SQL*Plus and to SQL, the Structured Query Language used to access a Relational Database and includes the new features of the latest version of ORACLE. The principles learnt may also be applied to databases as diverse as Microsoft SQL Server, MySQL, Access, Informix and DB2.

The course takes the format of a workshop, with a mix of lecture, working examples and practical exercises. Although the content may be customised, at least 2 days are needed to cover the core elements.

Full course notes are provided along with sample database files, example SQL files and free software tools for use in accessing an ORACLE database.

The course answers questions

How to build a query?

What possibilities have SQL?

What is a relational database?

What is the structure and SQL commands

Listeners

This training is addressed for people starting to work with the SQL language in Oracle database

The course answer for questions:

• How to build a query?
• What possibilities have SQL?
• What is a relational database?
• What is the structure and SQL commands

Listeners

This course is designed for people who want to use the advanced features of SQL in Oracle

The course answers the questions

• How to build advanced queries?
• How to create advanced reports?

Audience

All who want to improve their basic skills in Oracle SQL and also systematize already gained knowledge.

Format of the course

25% lectures, 75% labs

The objective of the course is to enable participants to gain a mastery of how to work with the SQL language in Oracle database for data extraction at intermediate level.

This instructor-led, live training in Portugal (online or onsite) is aimed at intermediate-level database professionals who wish to enhance their skills in Oracle SQL development and administration.

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

• Build and optimize complex SQL queries.
• Manage databases efficiently using Oracle SQL tools.
• Apply best practices in database development and maintenance.
• Administer user access and database security in an Oracle environment.

In this instructor-led, live hands-on training in Portugal, we will set up a live project and put into practice the skills to model, manage and access your data using neo4j. We contrast and compare graph databases with SQL-based databases as well as other NoSQL databases and clarify when and where it makes sense to implement each within your infrastructure.

This instructor-led, live training in Portugal (online or onsite) is aimed at database administrators or developers who wish to use Microsoft Azure Cosmos DB to develop and manage highly responsive and low latency applications.

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

• Provision the necessary Cosmos DB resources to start building databases and applications.
• Scale application performance and storage by utilizing APIs in Cosmos DB. 
• Manage database operations and reduce cost by optimizing Cosmos DB resources.

This instructor-led, live training in Portugal (online or onsite) is aimed at database administrators and developers who wish to use Hasura to build, access, and manage databases and applications efficiently with GraphQL.

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

• Set up the necessary development environment to start building databases with Hasura.
• Build, run, manage data access and queries on Hasura using GraphQL models.
• Secure data access by setting up authentication with JSON Web Tokens and Firebase.
• Extend database functions by integrating business logic.
• Manage database migrations and metadata effectively on Hasura to prevent data loss.

This instructor-led, live training in Portugal (online or onsite) is aimed at developers who wish to use Neo4j AuraDB graph database to build cloud applications with high availability and zero administration.

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

• Set up the necessary development environment to start developing graph database applications with Neo4j AuraDB.
• Understand the features, core concepts, and architecture of Neo4j AuraDB.
• Learn how to build and scale graph database applications in the cloud.
• Enhance cloud security with AuraDB's pre-configured authentication and encryption features.
• Migrate existing Neo4j databases to AuraDB.

This instructor-led, live training in Portugal (online or onsite) is aimed at intermediate-level developers and administrators who wish to have a solid PL/SQL programming foundation to develop efficient and robust database applications using Oracle 19c.

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

• Gain a comprehensive understanding of what PL/SQL is and its advantages over standard SQL.
• Learn how to declare and use variables and different data types within PL/SQL blocks.
• Apply control structures like IF-THEN-ELSE, CASE statements, and loops to create robust PL/SQL programs.
• Understand and implement explicit and implicit cursors for data retrieval.
• Handle exceptions effectively using predefined and user-defined exceptions.
• Develop and manage triggers to automate and enforce business rules.
• Create and use PL/SQL packages to encapsulate and modularize code for reuse and maintainability.

This instructor-led, live training in Portugal (online or onsite) is aimed at beginner-level database administrators and developers who wish to learn SQL to efficiently manage, query, and manipulate data in Oracle databases for administrative and operational tasks.

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

• Understand Oracle database architecture, including schemas, users, and sessions.
• Write and optimize SQL queries for data retrieval, filtering, and manipulation.
• Use joins, subqueries, and set operators to work with multiple tables and complex queries.
• Perform data aggregation, grouping, and analysis using SQL functions.
• Manage schema objects like views, sequences, and indexes to enhance database operations. 

This instructor-led, live training in Portugal (online or onsite) is aimed at intermediate-level developers and database administrators who wish to use Oracle SQL to design, manage, and optimize database applications and automate tasks efficiently.

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

• Understand Oracle database architecture and manage users, schemas, and permissions.
• Write optimized SQL queries for data retrieval, manipulation, and analysis.
• Use advanced SQL techniques, including joins, subqueries, and hierarchical queries.
• Design and manage database objects like tables, indexes, views, and sequences.