Explore Our Courses

Oracle Database 19c PL and Advanced SQL

28 Hours
This instructor-led, live training in Latvia (online or onsite) is aimed at intermediate-level database administrators who wish to have an in-depth understanding of Oracle Database 19c PL/SQL programming and advanced SQL techniques.By the end of this training, participants will be able to:
  • Understand the fundamentals and advanced features of PL/SQL.
  • Develop advanced SQL queries to retrieve and manipulate data efficiently.
  • Implement PL/SQL programming constructs to manage data and database operations.
  • Optimize SQL queries for better performance.
  • Use advanced PL/SQL features like collections, bulk processing, and error handling.
  • Learn to debug and manage PL/SQL programs effectively.
Read more...

Milvus: Open-Source Vector Database for AI Applications

 21 Hours
This instructor-led, live training in Latvia (online or onsite) is aimed at beginner-level to intermediate-level data scientists and software developers who wish to learn about Milvus and its practical applications in various AI scenarios.By the end of this training, participants will be able to:
  • Understand the architecture and features of Milvus.
  • Implement vector databases in different AI applications.
  • Perform similarity searches with high accuracy and speed.
  • Apply Milvus to real-world AI challenges.
Read more...

Pinecone: Vector Database Solutions for AI

 21 Hours
This instructor-led, live training in Latvia (online or onsite) is aimed at beginner-level to intermediate-level data scientists and software developers who wish to learn how to apply Pinecone to various AI scenarios, from semantic search to personalization.By the end of this training, participants will be able to:
  • Understand the architecture and features of Pinecone.
  • Implement vector databases in different AI applications.
  • Perform similarity searches with high accuracy and speed.
  • Apply Pinecone to real-world AI challenges.
Read more...

Mastering Vector Databases for Scalable AI Solutions

 14 Hours
This instructor-led, live training in Latvia (online or onsite) is aimed at intermediate-level to advanced-level data scientists and machine learning engineers who wish to master the use of vector databases for scalable, high-performance AI applications.By the end of this training, participants will be able to:
  • Understand the principles of vector databases.
  • Learn techniques for creating and managing vector embeddings.
  • Explore indexing strategies for high-dimensional data.
  • Develop skills for performing efficient similarity searches.
  • Apply vector database knowledge to machine learning projects.
Read more...

Database Design and Programming with SQL

 21 Hours
This instructor-led, live training in Latvia (online or onsite) is aimed at intermediate-level IT professionals who wish to learn how to design, implement, and manage relational databases, and how to query and manipulate data using SQL.By the end of this training, participants will be able to:
  • Understand the fundamentals of database design.
  • Learn to create and manage relational databases.
  • Gain proficiency in writing SQL queries to retrieve and manipulate data.
  • Understand advanced SQL concepts and techniques.
  • Develop skills to optimize and maintain databases.
Read more...

PL/SQL in Oracle 19c

 21 Hours
This instructor-led, live training in Latvia (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.
Read more...

Mastering Oracle APEX 23-24: Workflows and Security

 21 Hours
This instructor-led, live training in Latvia (online or onsite) is aimed at intermediate-level developers and IT professionals who wish to learn how to leverage new features in APEX 23-24, design efficient workflows, and ensure application security.By the end of this training, participants will be able to:
  • Develop and manage APEX applications using the latest features in versions 23-24.
  • Design and implement efficient workflows within APEX.
  • Apply advanced security measures to protect APEX applications and data.
  • Integrate APEX applications with external systems and ensure smooth data exchange.
  • Test, debug, and deploy APEX applications following best practices.
Read more...

Introduction to SQL Server 2022 Integration Services (SSIS)

 28 Hours
This instructor-led, live training in Latvia (online or onsite) is aimed at beginner-level data professionals who wish to learn how to design, implement, and manage SSIS packages to perform data integration and transformation tasks.By the end of this training, participants will be able to:
  • Understand the architecture and components of SSIS.
  • Design and implement ETL processes using SSIS.
  • Use SSIS tools to develop, deploy, and manage data integration solutions.
  • Troubleshoot and optimize SSIS packages for performance and reliability.
Read more...

Introduction to Vector Databases

 14 Hours
This instructor-led, live training in Latvia (online or onsite) is aimed at beginner-level software developers and database administrators who wish to learn the basics of vector databases, including their structure, operation, and use cases.By the end of this training, participants will be able to:
  • Understand the concept and purpose of vector databases.
  • Recognize the differences between vector and traditional databases.
  • Learn basic techniques for creating and managing vector data.
  • Perform simple similarity searches.
  • Appreciate the role of vector databases in AI applications.
Read more...

Cost Analysis with Presto COST IT Module

 14 Hours
This instructor-led, live training in Latvia (online or onsite) is aimed at intermediate-level data scientists who wish to learn how to utilize the COST IT module of Presto for cost analysis. By the end of this training, participants will be able to:
  • Understand the fundamentals of Presto and its role in big data analytics.
  • Gain proficiency in using Presto's COST IT module for cost analysis.
  • Optimize Presto queries for improved performance and resource utilization.
  • Identify and implement cost-based optimizations in Presto.
  • Troubleshoot and resolve common performance and cost-related issues in Presto.
Read more...

Oracle SQL for beginners

 21 Hours
ListenersThis training is addressed for people starting to work with the SQL language in Oracle databaseThe 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
Read more...

ORACLE SQL Fundamentals

 14 Hours
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.
Read more...

ORACLE PL/SQL Fundamentals

 21 Hours
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.
Read more...

Oracle SQL Intermediate

 14 Hours
AudienceAll who want to improve their basic skills in Oracle SQL and also systematize already gained knowledge.Format of the course25% lectures, 75% labs
Read more...

Oracle SQL Advanced

 14 Hours
ListenersThis course is designed for people who want to use the advanced features of SQL in OracleThe course answers the questions
  • How to build advanced queries?
  • How to create advanced reports?
Read more...

Monitoring Kubernetes with Prometheus

 7 Hours
This instructor-led, live training in Latvia (online or onsite) is aimed at system administrators and developers who wish to use Prometheus to monitor Kubernetes clusters. By the end of this training, participants will be able to:
  • Install and configure Prometheus.
  • Monitor dynamic cloud environments.
  • Gain better insight into their Kubernetes clusters.
  • Set up alerts that are precise and insightful.
Read more...

Oracle SQL for development and database management

 35 Hours
This 5-day course demonstrates how to use Oracle SQL for database development and database management.
Read more...

Oracle SQL Intermediate - Data Extraction

 14 Hours
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.
Read more...

Migrating Oracle to Azure SQL or PostgreSQL

 7 Hours
This instructor-led, live training in Latvia (online or onsite) is aimed at database administrators and cloud architects who wish to migrate Oracle databases to Azure SQL or PostgreSQL. By the end of this training, participants will be able to:
  • Compare Azure SQL with PostgreSQL to choose the database that best meets business objectives and needs.
  • Prepare databases to move definitions, data, and procedures from Oracle to AzureSQL or PostgreSQL database system.
  • Perform post-migration steps to test, optimize, update, and maintain a migrated database.
Read more...

Data Management

 35 Hours
Audience
  • Programmers
  • Beginner IT professionals
Format of the course
  •     Part lecture, part discussion, heavy hands-on practice
Read more...

SAP ASE for Database Administrators

 28 Hours
In this instructor-led, live training in Latvia, participants will learn the fundamentals of SAP ASE (SAP Adaptive Server Enterprise) Database Administration as they step through the creation and deployment of a sample SAP ASE Database System. By the end of this training, participants will be able to:
  • Install and configure SAP ASE for data storage as well as transactional operations.
  • Understand and use SAP ASE components, tools, and utilities.
  • Integrate SAP ASE with non-SAP ASE applications.
Read more...

Pivotal Greenplum for Developers

 21 Hours
This instructor-led, live training in Latvia (online or onsite) is aimed at developers who wish to set up a multi-node Greenplum database. By the end of this training, participants will be able to:
  • Install and configure Pivotal Greenplum.
  • Model data in accordance to current needs and future expansion plans.
  • Carry out different techniques for distribute data across multiple nodes.
  • Improve database performance through tuning.
  • Monitor and troubleshoot a Greenplum database.
Read more...

MarkLogic Server

 14 Hours
This instructor-led, live training in Latvia (online or onsite) is aimed at system administrators, database administrators, data architects, and developers who wish to install, configure, and manage MarkLogic Server to optimize their database systems. By the end of this training, participants will be able to implement, develop, manage, and secure their enterprise data and database systems using MarkLogic Server.
Read more...

Hasura GraphQL Engine

 14 Hours
This instructor-led, live training in Latvia (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.
Read more...

Blazegraph: Creating a Graph Database Application

 21 Hours
Blazegraph is an open source, Java-based RDF graph database for storing and representing data with complex relationships. It supports Blueprints and RDF/SPARQL 1.1. In this instructor-led, live training, participants will learn how to use Blazegraph to capture complex data in graph format for retrieval from a number of sample applications. All exercises will be carried out hands-on in a live-lab environment. By the end of this training, participants will be able to:
  • Install and configure Blazegraph in standalone mode, clustered mode (optional) or embedded mode (optional)
  • Create, test and deploy a sample application to query complex data in a Blazegraph data store
  • Understand how to leverage GPU (graphics processing unit) to accelerate computations
Audience
  • Developers
Format of the Course
  • Part lecture, part discussion, exercises and heavy hands-on practice
Note
  • To request a customized training for this course, please contact us to arrange.
Read more...

Beyond the Relational Database: Neo4j

 21 Hours
In this instructor-led, live hands-on training in Latvia, 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.
Read more...

Building Graph Databases with Neo4j AuraDB

 14 Hours
This instructor-led, live training in Latvia (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.
Read more...

NoSQL Database with Microsoft Azure Cosmos DB

 14 Hours
This instructor-led, live training in Latvia (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.
Read more...

Developing Applications with Oracle Application Express (APEX)

 21 Hours
This instructor-led, live training in Latvia (online or onsite) is aimed at developers who wish to use Oracle APEX to develop, scale, and deploy applications faster with less code. By the end of this training, participants will be able to:
  • Set up the necessary development environment to start developing database apps with Oracle APEX.
  • Understand and explore the Oracle APEX tools to build a fully-featured application.
  • Learn how to create applications and pages using Oracle APEX and the Page Designer UI.
  • Extend the functionality of complex enterprise apps easily with Oracle APEX.
  • Optimize and scale application performance and deployment.
  • Control and secure access to application data and components.
Read more...

Business Intelligence with SSAS

 14 Hours
SSAS (SQL Server Analysis Services), is a Microsoft SQL Server transactional processing (OLAP) and data mining tool for analyzing data across multiple databases, tables or files. The semantic data models provided by SSAS are used by client applications such as Power BI, Excel, Reporting Services, and other data visualization tools. In this instructor-led, live training (onsite or remote), participants will learn how to use SSAS to analyze large volumes of data in databases and data warehouses. By the end of this training, participants will be able to:
  • Install and configure SSAS
  • Understand the relationship between SSAS, SSIS, and SSRS
  • Apply multidimensional data modeling to extract business insights from data
  • Design OLAP (Online Analytical Processing) cubes 
  • Query and manipulate multidimensional data using the MDX (Multidimensional Expressions) query language
  • Deploy real-world BI solutions using SSAS
Audience
  • BI (Business Intelligence) professionals
  • Data Analysts
  • Database and data warehousing professionals
 
Format of the Course
  • Interactive lecture and discussion
  • Lots of exercises and practice
  • Hands-on implementation in a live-lab environment
Course Customization Options
  • This training is based on the latest version of Microsoft SQL Server and SSAS.
  • To request a customized training for this course, please contact us to arrange.
Read more...

Introduction to SQL Server 2012 Integration Services (SSIS)

 28 Hours
This instructor-led, live training in Latvia (online or onsite) is aimed at beginner to intermediate-level developers and database administrators who wish to gain proficiency in SQL Server 2012 Integration Services. By the end of this training, participants will be able to:
  • Understand the principles of ETL and the role of SSIS.
  • Create, deploy, and manage SSIS packages.
  • Design and implement Control Flow to define the flow of tasks in a package.
  • Implement Workflow and set up constraints for effective task execution.
  • Construct Data Flows to extract, transform, and load data.
  • Work with Variables and Containers to enhance package flexibility.
  • Manage Transactions to ensure data consistency.
  • Implement effective error handling and debugging techniques.
  • Set up Logging for tracking and monitoring.
  • Handle Slowly Changing Dimensions for managing changing data.
  • Deploy a Package for production use.
  • Implement Security measures to protect sensitive data.
  • Utilize Scripting to extend SSIS functionality.
  • Apply Best Practices for efficient and maintainable SSIS solutions.
Read more...

Administration with Powershell

 35 Hours
This intensive training provides the fundamental knowledge and skills to use Windows PowerShell for automating administration of Windows based computers. The skills taught in this course are applicable to all Microsoft products that use Windows PowerShell for daily administration. Training focuses mainly on using Windows PowerShell as an interactive command line interface however it also includes some coverage of scripting and programming topics.
Read more...

Developing in SQL Server Business Intelligence

 35 Hours
Developers, analysts and business users need to quickly analyse large amounts of data, get insight into that data, retrieve hidden knowledge inside it, and report against various data sources professionally and effectively. This course will enable them to do this with SQL Server Business Intelligence. The 5 day course will cover the SQL Server components and tools used for B.I. projects. The course will also include the new features in SQL Server B.I. 2016. Reporting Services, Analysis Services and Integration Services will be explored and worked with. Components of Business Intelligence in SQL Server are completely independent from the SQL Server databases, so they can be used over any data sources. Therefore, it is not necessary to know the SQL Server itself. 4 Top Takeaways from the Course
  1. Make your existing data work harder for you
  2. Integrate diverse data stores to a single repository
  3. Transform raw data to business intelligence
  4. Create eloquent reports from raw data
Read more...

ClickHouse Fundamentals

 14 Hours
This instructor-led, live training in Latvia (online or onsite) is aimed at developers and IT professionals who wish to set up, manage, and use ClickHouse for processing SQL queries faster than traditional database management systems. By the end of this training, participants will be able to:
  • Install and configure ClickHouse.
  • Understand the features and architecture of ClickHouse.
  • Know the differences between ClickHouse and other database systems (MySQL, PostgreSQL, etc.).
  • Configure user authentication, roles, and access controls in ClickHouse.
  • Perform SQL queries, manipulate data, and manage tables in ClickHouse.
  • Apply administrative tools and techniques to optimize performance.
  • Implement custom integrations with external systems (MySQL, PostgreSQL, MongoDB, Apache Kafka, etc.).
Read more...

SQLite Fundamentals

 14 Hours
This instructor-led, live training in Latvia (online or onsite) is aimed at developers who wish to use SQLite to develop embedded applications for various devices, such as desktops, mobile phones, Android TV, cameras, etc. 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.
  • Learn how to execute common SQL operations in SQLite.
  • Learn how to manipulate data and tables in SQLite.
  • Understand the various SQLite data types, tools, and functions.
  • Perform calculations with SQLite aggregate functions.
Read more...

MongoDB Atlas Fundamentals

 14 Hours
MongoDB Atlas is a multi-cloud database-as-a-service (DBaaS) platform. It simplifies the setup, operation, and management of MongoDB deployments in the cloud. This instructor-led, live training in Latvia (online or onsite) is aimed at developers and sysadmins who wish to use MongoDB Atlas to run, deploy, and manage databases at scale through automation and simplified configurations. By the end of this training, participants will be able to:
  • Set up, configure, and access the MongoDB Atlas cluster.
  • Understand the features, architecture, and advantages of MongoDB Atlas.
  • Learn how to import/export, query, and manipulate data in MongoDB Atlas.
  • Use Atlas APIs to automate database operations and administration.
  • Apply the best practices in managing and scaling MongoDB deployments.
Read more...

Prometheus Fundamentals

 14 Hours
This instructor-led, live training in Latvia (online or onsite) is aimed at system administrators and DevOps engineers who wish to use Prometheus to monitor systems and applications natively or through highly dynamic microservices running in a cloud environment. By the end of this training, participants will be able to:
  • Install and configure Prometheus.
  • Understand the features, architecture, and core concepts of Prometheus.
  • Learn how to query data using PromQL.
  • Build visualizations and dashboards with Grafana.
  • Configure systems monitoring and alerting rules.
  • Analyze and optimize systems and application performance.
  • Enable secure integration to remote endpoints and existing systems.
Read more...

Distributed Data Processing and Storage with Hazelcast

 14 Hours
This instructor-led, live training in Latvia (online or onsite) is aimed at developers and system administrators who wish to use Hazelcast for processing distributed data structures and optimizing application performance. By the end of this training, participants will be able to:
  • Install and configure Hazelcast to start creating and managing a cluster.
  • Create a cluster for initiating automatic discovery of multiple processes.
  • Set up Management Center for cluster connections and monitoring.
  • Develop applications and deploy them through the Hazelcast cluster.
Read more...

Change Data Capture (CDC) with Debezium

 14 Hours
This instructor-led, live training in Latvia (online or onsite) is aimed at engineers who wish to enable applications to continuously monitor and stream all commits made to their database. By the end of this training, participants will be able to:
  • Install and configure ZooKeeper, Kafka, and the Debezium connector service.
  • Set up applications to automatically consume and respond to database inserts, updates, and deletes.
  • Turn database row-level changes into event streams that applications can respond to immediately.
  • Stream each row-level change in the same order that it was committed to the database.
Read more...

Presto for Data Science

 14 Hours
This instructor-led, live training in Latvia (online or onsite) is aimed at data scientists who wish to query big data sources with Presto. By the end of this training, participants will be able to:
  • Employ Presto key concepts to optimize modern big data systems.
  • Use Presto to run exabyte scale warehouses.
  • Clone data to a proprietary data storage system.
  • Work with existing BI tools such as R and Tableau.
Read more...

Mastering LINQ with C#

 14 Hours
This instructor-led, live training in Latvia (online or onsite) is aimed at web developers who wish to query and update big data with LINQ using C#. By the end of this training, participants will be able to:
  • Create and execute LINQ queries.
  • Implement advanced libraries for data querying.
  • Filter, search, transform, and manipulate local or remote objects.
Read more...

Firebase Fundamentals

 14 Hours
This instructor-led, live training (online or onsite) is aimed at developers who wish to use Firebase to build powerful data-driven mobile or web application.  By the end of this training, participants will be able to:
  • Understand the Firebase Web Platform
  • Understand how to simplify a database by using Firebase data modeling
  • Develop powerful applications that can process real-time data without the need to define detailed database structures.
  • Transact data on Firebase
  • Perform realtime data synchronization
  • Authenticate users with Firebase
  • Monitor users
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.
  • To learn more about Firebase, please visit: https://firebase.google.com/
Read more...

Serverless Cloud Based Mobile and Web Development with Firebase

 28 Hours
This instructor-led, live training (online or onsite) is aimed at mobile and web developers who wish to use Firebase to build serverless cloud based Android, iOS or web applications. By the end of this training, participants will be able to:
  • Install and configure Firebase into an Android, iOS or web application.
  • Manage and authenticate application users. 
  • Access cloud based resources directly from client applications.  
  • Obtain usage and performance metrics from 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 customized training for this course, please contact us to arrange.
  • To learn more about Firebase, please visit: https://firebase.google.com.
Read more...

Building Interactive Applications with React, Redux and GraphQL

 28 Hours
In this instructor-led, live training in Latvia, participants will learn how to build React applications using Flux and GraphQL. The course covers installation, setup, integration, testing, deployment and best practices as it walks participants through the creation of a series of sample applications that demonstrate how to add additional levels of complexity and "coolness" to an application using the most advanced toolkits and techniques. Developing applications with React requires a different kind of thinking, compared to what some developers are accustomed to, especially when coming from the mindset of other MVC frameworks such as AngularJS and Bootstrap.
This training covers the fundamentals behind of the technologies used each step of the way so that participants are not only able to build a functional application, but also understand why a particular approach is used. This lays the groundwork for thinking independently and creatively about the design and the desired results for building their own applications in the future.
Read more...

GraphQL Basics

 7 Hours
In this instructor-led, live training in Latvia, participants will learn the fundamentals of GraphQL as they step through the creation of a simple API with GraphQL. By the end of this training, participants will be able to:
  • Understand what GraphQL is and what distinguishes it from REST.
  • Understand top-level GraphQL terms.
  • Set up a GraphQL coding environment.
  • Build and improve a GraphQL API.
Read more...

React, Relay, and GraphQL

 14 Hours
This instructor-led, live training in Latvia (onsite or remote) is aimed at developers who wish to use GraphQL and Relay to manage data on React applications. By the end of this training, participants will be able to:
  • Set up the necessary development environment to start data control for React applications.
  • Deliver instant UI-response interactions.
  • Aggregate data from multiple libraries into one convenient API.
  • Pre-fetch using GraphQL and Relay.
Read more...

Oracle SQL Language

 14 Hours
The course answers questionsHow to build a query?What possibilities have SQL?What is a relational database?What is the structure and SQL commands
Read more...

Oracle 11g - SQL language for administrators - workshops

 21 Hours
For whoThe workshop is intended for beginners, starting to work with the Oracle database, future administrators and users of systems based on this database need able to use the SQL language for the extraction and modification of the information contained in the systems.Exams and CertificatesThe training plan coincides with the material required to pass the exam: 1Z0-051 Oracle Database 11g: SQL Fundamentals I, the first step to getting most certifications Oracle's DatabasePurpose of trainingThe workshop aims to introduce participants to work with the Oracle database, making them familiar with the SQL language to the extent required for the efficient operation of the system and to take in the future obligations of database applications and Oracle databases.The content of the training
  • The organization of the working environment
  • Introduction to relational databases
  • Extraction of the data using the SELECT statement
  • Modifying data using INSERT, UPDATE, DELETE
  • Overview of schema objects
RemarksThe workshops are based on 11g XE software
Read more...

Oracle 11g - SQL language for developers - Workshop

 35 Hours
For whoWorkshops are dedicated as a first step for developers and designers of applications based on Oracle databases. Participants do not need to have any prior knowledge of the Oracle database, or other relational database systems, even though such knowledge may be useful.Exams and CertificatesThe plan covers the training material required to pass the exam 1Z0-047 Oracle Database SQL Expert and obtain the title of Oracle Database SQL Certified ExpertPurpose of trainingThe workshop aims to familiarize participants with the Oracle database techniques to build database structures and data manipulation. Particular emphasis is placed on the participant to see across the board, which offers opportunities to design and build applications Relational Database Management System, Oracle Database, and to be able to independently work with her.The content of the training
  • Introduction to database technology and the organization of the work environment
  • Acquisition and modification of data
  • Construction of the repository application
  • Safety and concurrency runtime
NotesThe workshops are based on the software version 11g XE
Read more...

Oracle 11g - Programming with PL / SQL I - Workshops

 28 Hours
For whoWorkshops are dedicated to developers, end users and administrators, who until now have had no contact with the language PL / SQL, and the need to exploit its huge potential in working with a database, automate processes, and in building applicationsExams and CertificatesThe plan covers the training material required to pass the exam 1Z0-144 Oracle Database 11g Program with PL / SQL and obtain the title of Oracle PL / SQL Developer Certified AssociatePurpose of trainingThe workshop aims to familiarize participants with the programming language PL / SQL, its capabilities and limitations. This workshop will include a full understanding of the mechanisms involved in the programming language PL / SQL needed to implement the logic of the free applications, automation of data processing and database management.The content of the training
  • Introduction to PL / SQL architecture solutions based on this language, the organization of the working environment
  • Create scripts and stored program units that operate on data
NotesThe workshops are based on the software version 11g XE
Read more...

Oracle 11g - Programming with PL / SQL II

 21 Hours
For whoThis training is in addition to, and continuation of the 'Oracle 11g - Programming in PL / SQL and - workshops ", but can also be designed for practitioners, developers, PL / SQL who already have experience with the language, and who want to systematize their knowledge and learn advanced mechanisms and solutions developed in this language.The content of the training
  • Objects, streams and complex data structures
  • Advanced solutions based on PL / SQL
Exams and CertificatesThe plan covers the training material required to pass the exam 1Z0-146 Oracle Advanced PL / SQL and obtain the title of Oracle Advanced PL / SQL Developer Certified ProfessionalPurpose of trainingThe training is designed to familiarize participants with the advanced aspects of programming in an Oracle database. The emphasis is on flexibility and performance solutions based on PL / SQL.NotesThe workshops are based on the software version 11g XE
Read more...

Last Updated:

Testimonials(25)

The way trainer demonstrated everything

Manveen - Tribal Grou[

Course - Developing Applications with Oracle Application Express (APEX)

The quality of training and wealth of experience !

Edvin - Verizon Connect

Course - MySQL Developer

Intresting presentation and excercises

Szymon - Agora SA

Course - Scylla Database

Andres consistently ensures that he addresses all attendee questions and strives to ensure everyone comprehends his teachings. I admire his expertise and proficiency in the subject matter

Ryan - Questronix Corporation

Course - PostgreSQL for Administrators - 3 Days

Being human and talking to us as understandable possible

Sorin

Course - Database Administration Fundamentals for MS SQL Server

Trainer expertise on SQL tuning

Bogdan - DB Global Technology

Course - Oracle 11g - Application Tuning - Workshop

The situation was atypical because an intensive training for developers was to be conducted with non-developers. Lukasz took up this challenge with empathy and a lot of humour. Through his intelligent and flexible manner, he was able to ensure that a concrete learning gain was achieved for everyone. I enjoyed this very much and would gladly take a seminar with Lukasz again.

Christoph - Honda Bank GmbH

Course - MERN Fullstack Development

Philip was very kind, his style of explaining SQL concepts is outstanding. I liked that he give us information and answered to questions which were not part of this course.

Stefan

Course - SQL in SQL Server

The trainings by our self

Andreas - Diehl

Course - Access Advanced

analytical functions

khusboo dassani - Tech Northwest Skillnet

Course - SQL Advanced

Our group was not that big so every time we asked a question we received an extensive answer with examples. So everything was well explained and it can be noticed that trainer has a great knowledge.

Iwona - Universal-Investment-Gesellschaft mit beschränkter Haftung

Course - Access Intermediate

The training materials.

Mona Dobre - DB Global Technology

Course - SQL Advanced level for Analysts

I learned complex functions and how to apply them

Ana Alexandrescu - DB Global Technology

Course - Oracle SQL Advanced

Practical exercises for practice and understanding of the concept, clarification provided for any questions.

Safdar Abbas - Medtech Limited

Course - T-SQL Fundamentals with SQL Server Training Course

Was carefully tailored to our needs, very responsive to live questions and situations, gave us lots of practice repeating what we were learning.

Colin - Drax

Course - MySQL Administration

Great comunication, Łukasz explained everything in easy and understandable way

Tomasz Wojciechowski - GP Strategies Poland sp. z o.o.

Course - ORACLE SQL Fundamentals

Ahmed has been very cooperative and knowledgeable about the subject and throughout been a good and productive training session covering some basic and important topics on Postgres.

Imran Sadiq Bhat

Course - PostgreSQL Essentials

It was quite hands-on, not too much theory.

David Lambaerts - Estée Lauder BV

Course - ORACLE PL/SQL Fundamentals

It allowed us to have an applied hands on sproc to our company database.

Corneliu Buculei - Standard Building Supplies Ltd

Course - Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

Trainer was accommodative. And actually quite encouraging for me to take up the course.

Grace Goh - DBS Bank Ltd

Course - Python in Data Science

The lab environment

Samer Roshdi - epic ltd

Course - MongoDB for Analysts

I liked Osorios openness and kindness - and that it wasn't so dry but fun!

Jannis Hell - Planet Labs

Course - GraphQL Basics

It was clearly tailored to be very appropriate to our purpose which made it extra helpful. I really liked the zoom format as it helped me focus with the material right in front of you all the time and the trainer able to add illustrations and markings on to it as he explained. The trainer answered all our questions in a very satisfying way and I felt surprised at how much I was able to learn in one day. Usually i get tired of training by the afternoon but this was very engaging right through to the end. Pace was perfect and detail went into the right areas.

Davina Sanders - Scottish Government

Course - PostgreSQL Performance Tuning

Michal was very knowledgable and engaging as a teacher.

Nate Clifton - NIIT (USA) Inc.

Course - PostgreSQL Advanced DBA

They way the instructor teaches is very informative and effective especially on the 2nd day when topics are a bit advanced.

Aynanie Kiram - Aarki, Inc.

Course - SQL DATABASE MANAGEMENT AND DESIGN - Bespoke

Other regions in Latvia

Other Countries

These courses are also available in other countries

Consulting

Database Consulting
Online Database courses, Weekend Database courses, Evening Database training, Database boot camp, Database instructor-led, Weekend Database training, Evening Database courses, Database coaching, Database instructor, Database trainer, Database training courses, Database classes, Database on-site, Database private courses, Database one on one training