Database Design and Programming with SQL Training Course

Neo4j is an innovative graph database that is based on a graph data structure, which means that data is stored in the form of nodes, relationships and properties. Neo4j has been used in many areas where relationships between data are crucial. As a graph database, it is used in cases where traditional relational databases may be insufficient to effectively analyze and extract information from related data. Its strength lies in representing and analyzing the relationships between different data elements, which makes it an important tool in the field of data analysis and knowledge management.

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.

In this instructor-led, live hands-on training in Poland, 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.

The "Tuning SQL and PL/SQL for Programmers" training is aimed at experienced programmers and database administrators working with Oracle, focusing on optimizing the performance of commands SQL and programs PL/SQL. Participants acquire the skills to diagnose performance problems and effectively manage the optimization process. The course integrates lectures, presentations and practical tasks, enabling you to delve deeper into the topic of tuning SQL and PL/SQL in the Oracle environment.

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

Level
Basic
Form
Lecture, Presentation, Intensive workshop
Purpose of the training
The training is addressed to data analysts and users who need to efficiently and flexibly extract data from the database using SQL language commands directly.
Benefits of completing the training
Learn the basic techniques of data analysis using SQL language.

Level
Advanced
Form
Lecture, Presentation, Intensive workshop
Purpose of the training
The training is addressed to data analysts and users who need to efficiently and flexibly extract data from the database using SQL language commands directly. It complements the ORA-SA1 training with advanced SQL language mechanisms.
Benefits of completing the training
Learn advanced data analysis techniques using SQL language for more flexible and efficient reporting.

The training is addressed to data analysts and users who need to flexibly and efficiently extract data from the database using SQL commands directly. It is a complement to the ORA_SA1 training and focuses on the efficiency of executing SQL statements and on scenarios in which the SELECT command alone is not enough and one should use the much more powerful PL/SQL language.

Level
Basic
Form
Lecture, Presentation, Workshop
Purpose of the training
The training is dedicated to people with a user, programmer or administrator profile who are starting to work with Oracle database.
Benefits of completing the training
The training will provide participants with the skills to work with Oracle database using SQL language and enables them to participate in further directional training in this field. 
The training prepares you to pass the Oracle Database 12c: SQL Fundamentals (1Z0-061) certification exam, which is an official, internationally respected validation of your skills and required for most Oracle certifications in database administration and programming.

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

The training is dedicated to people with the profile of user, programmer or administrator who already have some knowledge of working with Oracle database and want to deepen and systematize it. It is a complement to the ORA_S1 training course.

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

• The training will provide participants with the skills to efficiently store and process data using SQL, introducing knowledge of optimization, analysis and various methods of data extraction. At the same time, it will provide knowledge of the database architecture and its advanced capabilities to create effective applications.

Format of the Course

• Interactive lecture and discussion.
• Lots of exercises and practice.
• Hands-on implementation in a live-lab environment.

Course Customization Options

• To request a customized training for this course, please contact us to arrange.

The training is intended for people who work with databases as programmers using the SQL language and need to extend the possibilities of work with the mechanisms of the procedural language.

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