Online or onsite, instructor-led live Database (DB) or Database Management System (DBMS) training courses are aimed at both system administrators as well as developers and demonstrate through hands-on practice how to administer Database systems as well as how to integrate a Database with software applications.
Database training is available as "online live training" or "onsite live training". Online live training (aka "remote live training") is carried out by way of an interactive, remote desktop. Onsite live Database training can be carried out locally on customer premises in Olsztyn or in NobleProg corporate training centers in Olsztyn.
NobleProg -- Your Local Training Provider
Olsztyn
sale szkoleniowe NobleProg, ul. Gietkowska 6a, Olsztyn, poland, 10-170
Training and conference room with full audio-visual equipment. p>
Functional furniture provides the possibility...
Training and conference room with full audio-visual equipment. p>
Functional furniture provides the possibility of setting them in a conference layout, school, workshop & cinema, or cinema, depending on the client's needs. p>
This instructor-led, live training in Olsztyn (online or onsite) is aimed at intermediate-level maintenance personnel who wish to streamline their maintenance processes using Oracle Cloud ERP Fusion.By the end of this training, participants will be able to:
Understand the core functionalities of the Oracle Maintenance Cloud.
Implement corrective, preventive, and predictive maintenance strategies.
Manage maintenance requests, work orders, and schedules efficiently.
Utilize analytics for maintenance performance and improvement.
This instructor-led, live training in Olsztyn (online or onsite) is aimed at beginner-level business analysts and data analysts who wish to leverage Oracle BI to extract valuable insights from their data.
By the end of this training, participants will be able to:
Navigate and utilize the Oracle BI interface effectively.
Create and customize reports and dashboards tailored to business needs.
Conduct ad-hoc analysis using various BI tools.
Utilize advanced features for comprehensive data exploration.
This instructor-led, live training in Olsztyn (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.
This instructor-led, live training in Olsztyn (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.
This instructor-led, live training in Olsztyn (online or onsite) is aimed at beginner-level to intermediate-level data analysts, database professionals, and software developers who wish to learn SQL to manage databases effectively.By the end of this training, participants will be able to:
Understand and use fundamental SQL commands and queries.
Create and manipulate tables and databases.
Use SQL to sort, filter, and summarize data.
Implement more complex operations like joins, subqueries, and set operations.
Apply intermediate techniques such as indexes, views, stored procedures, and triggers.
This instructor-led, live training in Olsztyn (online or onsite) is aimed at developers who wish to use and integrate Node.js, Express, and MongoDB to build fast and scalable REST APIs.
By the end of this training, participants will be able to:
Set up and integrate Node.js and Express with MongoDB.
Understand the features and architecture of Node.js, Express, and MongoDB.
Learn how to build RESTful APIs using the Node.js, Express, and MongoDB backend stack.
Implement routes, filtering, sorting, and pagination to Node.js REST APIs.
Design data models and perform CRUD operations with MongoDB and Mongoose.
This instructor-led, live training in Olsztyn (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.
This instructor-led, live training in Olsztyn (online or onsite) is aimed at intermediate-level database administrators, SQL developers, and data analysts who wish to enhance their SQL skills by mastering the use of Analytic Functions.
By the end of this training, participants will be able to:
Understand the concept and importance of Analytic Functions.
Apply various Analytic Functions to solve complex analytical problems.
Combine Analytic Functions with other SQL features for comprehensive data analysis.
Optimize queries for better performance using Analytic Functions.
This instructor-led, live training in Olsztyn (online or onsite) is aimed at data analysts and data scientists who wish to use the MongoDB Aggregation Framework to perform data analysis while simplifying complex operations and aggregation pipelines.
By the end of this training, participants will be able to:
Install and configure MongoDB for data analysis.
Understand the concepts and stages of the MongoDB Aggregation Framework.
Learn about the basic structure, syntax, and operations for aggregation.
Learn how to handle advanced operations in aggregation.
Apply some optimization tools and techniques to improve aggregation performance.
This instructor-led, live training in Olsztyn (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.
This instructor-led, live training in Olsztyn (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.
This instructor-led, live training in Olsztyn (online or onsite) is aimed at data scientists and developers who wish to use and integrate SQL, Python, and Tableau to perform complex data analysis, processing, and visualization.
By the end of this training, participants will be able to:
Set up the necessary environment to perform data analysis with SQL, Python, and Tableau.
Understand the key concepts of software integration (data, servers, clients, APIs, endpoints, etc.).
Get a refresher on the fundamentals of Python and SQL.
Perform data pre-processing techniques in Python.
Learn how to connect Python and SQL for data analysis.
Create insightful data visualizations and charts with Tableau.
This instructor-led, live training in Olsztyn (online or onsite) is aimed at system administrators who wish to have a comprehensive understanding of the security features of Oracle Database 19c.
By the end of this training, participants will be able to:
Understand the concepts of database security.
Implement authentication and authorization mechanisms to control access to the database.
Configure and manage user accounts, roles, and privileges effectively.
Implement robust security measures against various threats and vulnerabilities.
This instructor-led, live training in Olsztyn (online or onsite) is aimed at advanced-level developers who wish to learn and use MySQL and database technologies for building web applications.
By the end of this training, participants will be able to:
Write SQL queries to retrieve, filter, sort, and aggregate data.
Perform data manipulation operations such as inserting, updating, and deleting data.
Implement advanced SQL concepts such as subqueries, derived tables, and conditional logic.
Integrate MySQL with popular programming languages and execute queries from application code.
This instructor-led, live training in Olsztyn (online or onsite) is aimed at advanced-level database administrators who wish to learn how to configure and manage data workload on databases.
By the end of this training, participants will be able to:
This instructor-led, live training in (online or onsite) is aimed at developers who wish to use the FARM (FastAPI, React, and MongoDB) stack to build dynamic, high-performance, and scalable web applications.
By the end of this training, participants will be able to:
Set up the necessary development environment that integrates FastAPI, React, and MongoDB.
Understand the key concepts, features, and benefits of the FARM stack.
Learn how to build REST APIs with FastAPI.
Learn how to design interactive applications with React.
Develop, test, and deploy applications (front end and back end) using the FARM stack.
This instructor-led, live training in Olsztyn (online or onsite) is aimed at database administrators, SQL developers, and data analysts who wish to deepen their expertise in SQL. It covers advanced topics in database management, optimization, and performance tuning.
By the end of this training, participants will be able to:
Optimize database performance through effective preparation of databases and DBO.
Utilize and manage user-defined data types (UDDT) and user-defined types (UDT).
Effectively handle spatial data types, including Geography and Geometry.
Enhance hierarchical data management, including structure elements, storage methods, and indexing strategies.
Improve query performance through advanced techniques such as data indexing, query execution plan analysis, and control of SQL query execution.
This course covers the administration and performance tuning of PostgreSQL databases.
Target audience includes system administrators and database architects. Attendees will learn the use of specialised PostgreSQL (AKA Postgres) modules such as replication, connection pooling and full text searching.
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.
This course covers everything a database administrator needs to know to successfully deploy and maintain MongoDB databases.
Diagnosing performance issues, importing and exporting data, and establishing the proper backup and restore routines, overview of the MongoDB CRUD API, the command shell, and the drivers are also covered.
The audience of this course include people who want to:
Understand MongoDB from a developer's perspective, including its command shell, query API, and driver tools.
Deploy MongoDB in all its configurations - as a single server, with master/slave replication, as a replica set, and as a sharded cluster.
Evaluate applications and choose hardware appropriately.
Monitor MongoDB instances and integrate with standard monitoring software (Munin, Nagios, etc.)
Plan for backups and manage large data imports and exports.
Troubleshoot the most common developer issues and failure scenarios.
Each delegate will need to perform a series of practical exercises.
This course handles the administration and performance tuning of PostgreSQL databases. Attendees will learn the use of specialised PostgreSQL (AKA Postgres) modules such as replication, connection pooling and full text searching.
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.
This course provides programmatic interaction with PostgreSQL databases. Learn techniques, syntaxes and structures needed to develop quality applications using PostgreSQL backend. This training also covers SQL Tuning covering best practices for writing efficient SQL.
Target audience includes developers who want to use or extend PostgreSQL, as well as database architects.
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.
After the training, you will be able to write extract and modify the data in MongoDB database. You will also learn about powerful Aggregation Pipeline that is a flexible and fast tool for data analytics, and if it's not enough for you, how to connect your current BI tools like Tableau or Excel to data stored in Mongo.
This training is designed for Database Administrators and Architects who want to learn PostgreSQL from basics.
You will learn PostgreSQL architecture, installation, designing as well as how to perform backup and recovery databases in PostgreSQL.
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.
The "MongoDB Advanced Administration" course covers advanced aspects of using programming languages related to MongoDB, focusing on full mastery of the tool. The course structure includes an introduction to MongoDB, basic and advanced queries, storage engines, document validation, data modeling, MapReduce, Aggregation Framework, GridFS, indexes, Full Text Search, Change streams, replication, sharding, and administration and diagnostic tools. The course also includes an optional module on client libraries such as JavaDriver and CSharpDriver.
This SQL training course is for people who want to gain the necessary skills to extract and analyse data using Microsoft Access. Course members will learn:
how to write SQL queries
what relational databases are and how we can use them
what are relations and how to create them
the structure of data
differences between SQL dialects (Oracle, T-SQL, ANSI)
practical skills for writing queries
This SQL course deals with Microsoft Access dialect of SQL.
In this instructor-led, live training in Olsztyn (onsite or remote), participants will learn the general and advanced aspects of PostgreSQL, including administration, performance turning, advanced development, and replication as they step through a series of hands-on, live-lab exercises involving setup, configuration, testing, deployment and troubleshooting.
By the end of this training, participants will be able to:
Use advanced administration techniques to configure and manage a PostgreSQL server.
Optimize the database and queries for maximum performance.
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 course will help the participants prepare for Web Application Development using Python Programming with Data Analytics. Such data visualization is a great tool for Top Management in decision making.
This course covers the advanced areas in the use of programming languages related to MongoDB, the goal is for the participant to have the ability to completely master the tool.
This SQL training course is for people who want to gain the necessary skills to extract and analyse data from any database and create reports. Course members will learn:
how to write SQL queries
what relational databases are and how we can use them
what are relations and how to create them
the structure of data
differences between T-SQL and other dialects
practical skills for writing queries
This SQL course deals with Microsoft T-SQL dialect. If you are interested in generic SQL, please see SQL Fundamentals course.
This training is designed for Database Administrators and Architects who want to tune PostgreSQL Database for Performance. Learn how to log slow workload and find the possible pain points in a query. This topic also covers the most important parameters that must be tuned for optimal performance.
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 (online or onsite) is aimed at administrators wishing to solve complex deployment and management problems using MongoDB Ops Manager.
By the end of this training, participants will be able to:
Install and configure MongoDB Ops Manager
Set up and manage different types of environments
Understand and implement MongoDB Enterprise Server specific solutions to solve complex enterprise challenges
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 MongoDB Enterprise Server, which includes Ops Manager. Please consult with us to arrange license requirements.
To request a customized training for this course, please contact us to arrange.
Percona Server for MongoDB is a free, enhanced, fully compatible, open source, drop-in replacement for MongoDB 3.2 Community Edition with enterprise-grade features. It requires no changes to MongoDB applications or code.
Audience
This course is suitable for sysadmins and engineers seeking to switch to Percona Server from preexisting MongoDB instances, or deploy and administrate new Percona Server for MongoDB instances.
After completing this course, delegates will:
understand Percona Server’s structure and deployment mechanisms
be able to carry out installation / production environment / architecture tasks and configuration
be able to assess code quality, perform debugging, monitoring
be able to implement advanced production like replication, performance tuning and logging
This training is designed for Database Administrators and Architects who want to learn the tools and techniques for implementing Backups, High Availability and Database Security in PostgreSQL.
You will also learn how to find slow queries, monitor database performance and tune PostgreSQL for Performance.
The training is intended for programmers who know the basics of SQL and PL/SQL, but want to learn more advanced mechanisms of the language, and want to create database applications based on stored PL/SQL programs.
The aim of this course is to provide a clear understanding of the advanced use of (SQL) for Microsoft SQL Server and the advanced use of Transact-SQL. For more in depth coverage of the topics this course can be run as a three day course.
This training is designed for Database Administrators and Architects who want to learn Streaming Replication in PostgreSQL and how pgpool-II can be used to achieve automatic failovers and setup a highly available PostgreSQL Database Cluster.
The training clearly and extensively presents issues that allow you to understand the internal mechanisms that occur when executing SQL commands and PL/SQL programs, monitor and diagnose performance problems and implement solutions. It enables effective management of the process of optimizing SQL commands and PL/SQL programs.
This instructor-led, live training in Olsztyn (online or onsite) is aimed at web developers who wish to use the MERN Stack for fullstack development.
By the end of this training, participants will be able to:
Integrate React with MongoDB, Express, and Node.js.
Build a fullstack web application from scratch.
Implement application security through authorization and authentication.
This instructor-led, live training in Olsztyn (online or onsite) is aimed at sysadmins and developers who wish to use PostgreSQL 13 to set up, build, and manage databases for high-performance applications.
By the end of this training, participants will be able to:
Install and configure PostgreSQL 13.
Understand the features, architecture, and fundamentals of operating, managing, and maintaining databases with PostgreSQL 13.
Learn how to configure Postgres database tables and schemas.
Learn how to perform data manipulations and queries.
Explore the different programming interfaces (client and server) to fully utilize and extend functionalities in PostgreSQL 13.
Delegates will gain an understanding of some of the more advanced features of Transact SQL as well as being able to do each of the following:
Use queries to return complex result sets
Manage database objects to aid query performance
Tune queries to perform more efficiently
This course is for anyone who currently uses Transact SQL to extract data from a Microsoft SQL Server database and wishes to expand their knowledge particularly in the areas of data analysis and improving query speed.
This instructor-led, live training in Olsztyn (online or onsite) is aimed at database admins and sysadmins who wish to use PostgreSQL to manage large-scale data while optimizing the database systems for high availability and performance.
By the end of this training, participants will be able to:
Install and configure PostgreSQL.
Understand the features and architecture of PostgreSQL.
Learn how to perform database operations with SQL.
Perform database backup and recovery to prevent data loss.
Configure the server for high availability.
Learn the tools and techniques for high performance tuning.
Explore the external tools for monitoring and observability.
Delegates will gain an understanding of the basic principles of Structured Query Language as well as being able to do each of the following:
Construct queries to extract and filter data from an SQL Server database
Create summarised results
Change, derive and format data to suit the required output
Change data and maintain database components and definitions
This course is for anybody who needs information from a Microsoft SQL Server database. It is suitable for either system developers or people from other areas who need to use SQL to extract and analyse data.
This course has been created for people already acquainted with SQL. The course introduces you into secrets common to all SQL databases as well as MySQL specific syntax, functions and features.
This instructor-led, live training in Olsztyn (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.
In this instructor-led, live training in Olsztyn, participants will learn three different approaches for accessing, analyzing and visualizing data. We start with an introduction to RDMS databases; the focus will be on accessing and querying an Oracle database using the SQL language. Then we look at strategies for accessing an RDMS database programmatically using the Python language. Finally, we look at how to visualize and present data graphically using TIBCO Spotfire.
Format of the Course
Interactive lecture and discussion.
Lots of exercises and practice.
Hands-on implementation in a live-lab environment.
kdb+ is an in-memory, column-oriented database and q is its built-in, interpreted vector-based language. In kdb+, tables are columns of vectors and q is used to perform operations on the table data as if it was a list. kdb+ and q are commonly used in high frequency trading and are popular with the major financial institutions, including Goldman Sachs, Morgan Stanley, Merrill Lynch, JP Morgan, etc.
In this instructor-led, live training, participants will learn how to create a time series data application using kdb+ and q.
By the end of this training, participants will be able to:
Understand the difference between a row-oriented database and a column-oriented database
Select data, write scripts and create functions to carry out advanced analytics
Analyze time series data such as stock and commodity exchange data
Use kdb+'s in-memory capabilities to store, analyze, process and retrieve large data sets at high speed
Think of functions and data at a higher level than the standard function(arguments) approach common in non-vector languages
Explore other time-sensitive applications for kdb+, including energy trading, telecommunications, sensor data, log data, and machine and network usage monitoring
Audience
Developers
Database engineers
Data scientists
Data analysts
Format of the course
Part lecture, part discussion, exercises and heavy hands-on practice
This instructor-led, live training in Olsztyn (online or onsite) is aimed at developers and administrators who wish to use PostgreSQL with Python to build secure, reliable, and stable applications at scale.
By the end of this training, participants will be able to:
Install, configure, and connect PostgreSQL with Python.
Get a refresher on Python programming fundamentals.
Understand the benefits of using PostgreSQL with Python.
Learn how to perform basic SQL operations with Python.
Learn how to use the advanced PostgreSQL features with Python.
Implement data safety, security, monitoring, and optimization techniques.
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.
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.
The aim of this course is to provide a clear understanding of the use of SQL for different
databases (Oracle, SQL Server, MS Access...). Understanding of analytic functions and the
way how to join different tables in a database will help delegates to move data analysis
operations to the database side, instead of doing this in MS Excel application. This can also
help in creating any IT system, which uses any relational database.
This instructor-led, live training in Olsztyn (online or onsite) is aimed at system administrators who wish to learn how to use and manage an Oracle Linux 8 system.
By the end of this training, participants will be able to:
This instructor-led, live training in Olsztyn (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.
This instructor-led, live training in Olsztyn (online or onsite) is aimed at professionals who wish to learn the fundamental concepts of Oracle Fusion and implement Oracle Fusion HCM in their organization.
By the end of this training, participants will be able to:
Learn and understand the concepts of Oracle Fusion Human Capital Management (HCM).
Implement complete workforce structure management in any organization.
This instructor-led, live training in Olsztyn (online or onsite) is aimed at database administrators who wish to learn and use the features of Oracle Database 21c in performing administrative tasks.
By the end of this training, participants will be able to:
Understand the core concepts of Oracle Database 21c administration.
Understand the Oracle 21c architecture.
Learn how to perform administration tasks on Oracle 21c.
Understand the Oracle 21c backup and recovery process.
This SQL training course is for people who want to gain the necessary skills to extract and analyse data from any database and create reports. Course members will learn:
how to write SQL queries
what relational databases are and how we can use them
what are relations and how to create them
the structure of data
differences between SQL dialects (Oracle, T-SQL, ANSI)
practical skills for writing queries
This SQL course deals with generic ANSI SQL. It can be used in any database, including Oracle, MySQL, Microsoft Access, Microsoft SQL Server, DB2, Informix, PostgreSQL any other relational databases.
This instructor-led, live training in Olsztyn (online or onsite) is aimed at system administrators who wish to learn how to administer, monitor, and support an Oracle database.
By the end of this training, participants will be able to:
Understand the major feature and architectural changes Oracle database.
This instructor-led, live training in Olsztyn (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.
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.
In this instructor-led, live hands-on training in Olsztyn, 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 Olsztyn (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.
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.
This instructor-led, live training in Olsztyn (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 Olsztyn (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.
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.
This instructor-led, live training in Olsztyn (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.
Training is dedicated to the basics of create a data warehouse environment based on MS SQL Server 2008.
Course participant gain the basis for the design and construction of a data warehouse that runs on MS SQL Server 2008.
Gain knowledge of how to build a simple ETL process based on the SSIS and then design and implement a data cube using SSAS.
The participant will be able to manage OLAP database: create and delete database OLAP Processing a partition changes on-line.
The participant will acquire knowledge of scripting XML / A and MDX.
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
Make your existing data work harder for you
Integrate diverse data stores to a single repository
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.
This instructor-led, live training in Olsztyn (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.).
This instructor-led, live training in Olsztyn (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.
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 Olsztyn (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.
This instructor-led, live training in Olsztyn (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.
This instructor-led, live training in Olsztyn (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.
This instructor-led, live training in Olsztyn (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.
This instructor-led, live training in Olsztyn (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.
This instructor-led, live training in Olsztyn (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.
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/
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.
In this instructor-led, live training in Olsztyn, 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.
This instructor-led, live training in Olsztyn (online or onsite) is aimed at web developers who wish to develop an advanced node application using GraphQL.
By the end of this training, participants will be able to:
Create mutations to enable clients to manipulate data in databases.
Script an automated test suite for a node application.
Use GraphQL schemas to define data interaction.
Secure node application data with an authentication system.
In this instructor-led, live training in Olsztyn, 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.
This instructor-led, live training in Olsztyn (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.
Berkeley DB (BDB) is a software library intended to provide a high-performance embedded database for key/value data. Berkeley DB is written in C with API bindings for C++, C#, Java, Perl, PHP, Python, Ruby, Smalltalk, Tcl, and many other programming languages. Berkeley DB is not a relational database.
This course will introduce the architecture and capabilities of Berkeley DB and walk participants through the development of their own sample application using Berkeley DB.
Audience
Application developers
Software engineers
Technical consultants
Format of the course
Part lecture, part discussion, hands-on development and implementation, tests to gauge understanding
Hypertable is an open-source software database management system based on the design of Google's Bigtable.
In this instructor-led, live training, participants will learn how to set up and manage a Hypertable database system.
By the end of this training, participants will be able to:
Install, configure and upgrade a Hypertable instance
Set up and administer a Hypertable cluster
Monitor and optimize the performance of the database
Design a Hypertable schema
Work with Hypertable's API
Troubleshoot operational issues
Audience
Developers
Operations engineers
Format of the course
Part lecture, part discussion, exercises and heavy hands-on practice
Part lecture, part discussion, exercises and heavy hands-on practice
FlockDB is an open source distributed, fault-tolerant graph database for managing wide but shallow network graphs. It was initially used by Twitter to store relationships among users.
In this instructor-led, live training, participants will learn how to set up and use a FlockDB database to help answer social media questions such as who follows whom, who blocks whom, etc.
By the end of this training, participants will be able to:
Install and configure FlockDB
Understand the unique features of FlockDB, relative to other graph databases such Neo4j
Use FlockDB to maintain a large graph dataset
Use FlockDB together with MySQL to provide provide distributed storage capabilities
Query, create and update extremely fast graph edges
Scale FlockDB horizontally for use in on-line, low-latency, high throughput web environments
Audience
Developers
Database engineers
Format of the course
Part lecture, part discussion, exercises and heavy hands-on practice
In this instructor-led, live training in Olsztyn, participants will learn about the technology offerings and implementation approaches for processing graph data. The aim is to identify real-world objects, their characteristics and relationships, then model these relationships and process them as data using a Graph Computing (also known as Graph Analytics) approach. We start with a broad overview and narrow in on specific tools as we step through a series of case studies, hands-on exercises and live deployments.
By the end of this training, participants will be able to:
Understand how graph data is persisted and traversed.
Select the best framework for a given task (from graph databases to batch processing frameworks.)
Implement Hadoop, Spark, GraphX and Pregel to carry out graph computing across many machines in parallel.
View real-world big data problems in terms of graphs, processes and traversals.
This instructor-led, live training in Olsztyn (online or onsite) is aimed at engineers who wish to use JanusGraph to process very large graphs that require abnormal storage and computational capacity.
By the end of this training, participants will be able to:
Install and configure JanusGraph.
Integrate JanusGraph with multiple backend storage systems (Cassandra, HBase, etc.) and multiple indexing software (Elasticsearch, Solr, etc.).
Configure multiples machines into a cluster for use by JanusGraph.
Query the database using the Gremlin query language.
Process graph data at scale, beyond what a single machine can provide.
Support thousands of concurrent users traversing graph data in real time.
This instructor-led, live training in Olsztyn (online or onsite) is aimed at database administrators who wish to install, set up, and manage Flyway and its capabilities to perform database migrations.
By the end of this training, participants will be able to clean up, migrate, validate, repair, and monitor databases using Flyway.
This instructor-led, live training in Olsztyn (online or onsite) is aimed at database administrators and developers who wish to install, configure, and manage Flyway to track and apply changes in their continuous database delivery efforts.
By the end of this training, participants will be able to implement, track, reverse, and manage database workflows and changes to improve their continuous database delivery.
This instructor-led, live training in Olsztyn (online or onsite) will teach how to configure and run flyway to build a migration pipeline in SQL. Database-specific syntax such as PL/SQL and T-SQL are supported, as well as Java (for advanced data transformations or for dealing with LOBs). Practical scenarios will help to understand real-world usages.
The "Percona Server for MySQL" training focuses on optimizing the use of Percona Server for MySQL, optimized for cloud computing, NoSQL access, containers, and modern hardware such as SSDs and Flash storage. The course covers the installation, configuration and optimization of Percona Server, focusing on features related to security, scalability, monitoring and data management. Participants will acquire practical skills enabling effective use of the advanced capabilities of Percona Server for MySQL.
Adobe CouchDB is a scalable, fault-tolerant, and schema-free document-oriented database written in Erlang. It's used in large and small organizations for a variety of applications where a traditional SQL database isn't the best solution for the problem at hand.
Audience
This course is directed at engineers and developers seeking to deploy and develop with a CouchDB instance.
Created Linux/Unix Administrators and developers who are interested with getting involved in LInux/Unix Servers
Even beginners, who have the basic skill and knowledge on Linux, can catch up with this course just if you follow the instructor's lab and explanation in detail.
This course is intended to practice enough Managing Linux Servers and to show it is very easy to understand Linux/Unix servers.
This course will be delivered to audience with 40% lectures, 50% labs and 10% Q&A. This five-day course strongly emphasizes lab-based activities.
You'll learn how to deploy and manage Top 4 Linux Servers that provide highly useful network services to a mission-critical enterprise environment.
It can be deliver on any distribution (Fedora, CentOS are commonly used)
MariaDB Administration training course is for anyone who wants to administrate the MariaDB database server. It is a comprehensive course covering all administrator duties.
The course explains how MariaDB Database works, what tools are available, how we can use them, how we can secure the MariaDB Database Server and configure it. During the training course you will learn how to manage user accounts and how the MariaDB Access Privilege System works. You also will learn how to maintain your database, backup and recover your databases and perform crash recovery.
In this instructor-led, live training in Olsztyn, participants will learn how to install, configure and manage MariaDB for high availability and performance. Other topics include backup and recovery, security and clustering.
This course is intended for database administrators.
The course presents options for High-Availability solutions using Galera Cluster.
You will learn the basics of Galera technology, as well as more advanced topics and practical knowledge related to configuring, optimizing and administering a Galera Cluster.
This course will introduce Cassandra – a popular NoSQL database. It will cover Cassandra principles, architecture and data model. Students will learn data modeling in CQL (Cassandra Query Language) in hands-on, interactive labs. This session also discusses Cassandra internals and some admin topics.
This instructor-led, live training in Olsztyn (online or onsite) is aimed at sysadmins and developers who wish to use Cassandra 4.0 to create, build, and manage large-scale databases with high availability and less failures.
By the end of this training, participants will be able to:
Install and configure Apache Cassandra.
Migrate from earlier versions to Cassandra 4.0.
Learn more about the new features in Cassandra 4.0.
Build, manage, and scale high-performing databases.
Monitor table activities and optimize internode communications.
Use zero copy streaming to quickly transfer data across a distributed database.
This course introduces the basics of Cassandra including its installation & configuration, internal architecture, tools, Cassandra Query Language, and administration.
Audience
Administrators and developers seeking to use Cassandra. This course serves as a foundation and prerequisite for other advanced Cassandra courses.
This course will introduce Cassandra – a popular NoSQL database. It will cover Cassandra principles, architecture and data model. Students will learn data modeling in CQL (Cassandra Query Language) in hands-on, interactive labs. This session also discusses Cassandra internals and some admin topics.
Audience : Developers
This course will introduce Cassandra – a popular NoSQL database. It will cover Cassandra principles, architecture and data model. Students will learn data modeling in CQL (Cassandra Query Language) in hands-on, interactive labs. This session also discusses Cassandra internals and some admin topics.
Duration : 3 days
Audience : Developers
When traditional storage technologies don't handle the amount of data you need to store there are hundereds of alternatives. This course try to guide the participants what are alternatives for storing and analyzing Big Data and what are theirs pros and cons.
This course is mostly focused on discussion and presentation of solutions, though hands-on exercises are available on demand.
This course introduces HBase – a NoSQL store on top of Hadoop. The course is intended for developers who will be using HBase to develop applications, and administrators who will manage HBase clusters.
We will walk a developer through HBase architecture and data modelling and application development on HBase. It will also discuss using MapReduce with HBase, and some administration topics, related to performance optimization. The course is very hands-on with lots of lab exercises.
Duration : 3 days
Audience : Developers & Administrators
MemSQL is an in-memory, distributed, SQL database management system for cloud and on-premises. It's a real-time data warehouse that immediately delivers insights from live and historical data.
In this instructor-led, live training, participants will learn the essentials of MemSQL for development and administration.
By the end of this training, participants will be able to:
Understand the key concepts and characteristics of MemSQL
Install, design, maintain, and operate MemSQL
Optimize schemas in MemSQL
Improve queries in MemSQL
Benchmark performance in MemSQL
Build real-time data applications using MemSQL
Audience
Developers
Administrators
Operation Engineers
Format of the course
Part lecture, part discussion, exercises and heavy hands-on practice
Relational databases have been the technology of choice for storing, retrieving and querying data. Relational databases allow users to organize their data using a structured, well-defined set of patterns (model). While this approach works well for storing data that is standardized and well-understood in advance (think of a hospital check-in application that holds patient records with the same consistent set of pre-defined fields...patient id, first name, last name, date of last visit, etc.), there are limitations to this model. For organizations whose incoming data is not well-defined (think of an online inquiry form for a startup whose still in the process of experimenting with different fields for collecting visitor data, removing and adding fields as they go to accommodate for the changing nature of the business), any established definitions for how the data should fit into an existing database would need to be re-defined regularly. This would require recreating the data model (schema) that dictates the structure of the data and its allowed data types to support different types of data inputs, etc., before any new data could be saved to the database.
Enter NoSQL (Not Only SQL) databases. NoSQL databases free users from having to predefine the structure of the incoming data, allowing them to insert and update new data on the fly. NoSQL databases are often faster than relational databases and can handle very large amounts of data with ease. NoSQL databases also scale better than relational databases, due to their ability to efficiently partition data across many servers (cluster) and load balance the access to this data. NoSQL databases integrate particularly well with applications that support real-time analytics, site personalization, IoT, and mobile apps
In this instructor-led, live training, participants will understand the architecture, design principles and functionality of the most popular NoSQL databases as they setup, operate and asses a number of NoSQL databases in a live lab environment. The goal of this training is to enable participants to intelligently evaluate, propose and implement a suitable NoSQL database solution within their organization.
By the end of this training, participants will be able to:
Install and configure different types of NoSQL databases, including MongoDB, Cassandra, Redis and Neo4j
Understand the benefits and disadvantages of NoSQL databases vs relational databases
Understand the underlying data formats used by NoSQL databases and how these formats can be used to an advantage when developing modern applications (desktop, mobile, cloud, IoT)
Perform create, insert, update, delete operations in a NoSQL database
Setup a mixed environment with both a relational database and NoSQL working in tandem
Configure a cluster of NoSQL database to distribute the processing of very large datasets
Understand the security implications of using a NoSQL database
Deploy and scale a NoSQL database in a production environment
Audience
Database professionals
Data architects
Data strategists
Project managers
Application developers wishing to integrate a flexible database solution in their application
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.
OrientDB is a NoSQL Multi-Model Database that works with Graph, Document, Key-Value, GeoSpatial, and Reactive models. Its flexibility allows users to manage different kinds of data under one centralized database.
In this instructor-led, live training, participants will learn how to start using OrientDB and utilize its flexibility to manage data.
By the end of this training, participants will be able to:
Install OrientDB
Learn how to create and manage a database with OrientDB
Explore the different features and functionalities of OrientDB
Learn how to work with different APIs on OrientDB
Deploy OrientDB using Distributed Architecture
Audience
Software engineers and technicians
Technical people in all industries
IT people
Developers
Format of the course
Part lecture, part discussion, exercises and heavy hands-on practice
Scylla is an open-source distributed NoSQL data store. It is compatible with Apache Cassandra but performs at significantly higher throughputs and lower latencies.
In this course, participants will learn about Scylla's features and architecture while obtaining practical experience with setting up, administering, monitoring, and troubleshooting Scylla.
Audience
Database administrators
Developers
System Engineers
Format of the course
The course is interactive and includes discussions of the principles and approaches for deploying and managing Scylla distributed databases and clusters.
The course includes a heavy component of hands-on exercises and practice.
Key features and functions of MDS: Master Data Management: MDS allows you to centrally manage master data that is shared and used by various systems and applications in your organization. This data may include information about products, customers, employees, suppliers and other categories important to the company. Data Modeling: Enables you to create data models that match your organization's structure and requirements. Entities, attributes, and relationships can be defined within these models. Data Integration and Synchronization: MDS integrates with various data sources, allowing you to synchronize and update master data across your organization. Versioning and change management: Offers data versioning capabilities, which allows you to track changes and manage different versions of master data. Data Quality Management: Provides tools to maintain high data quality, including data validation and cleansing capabilities. Security and access control: MDS allows you to define permissions and access rules for data, ensuring that only authorized people can make changes or view sensitive information. Workflow and business processes: Ability to create workflow processes that ensure that data goes through the appropriate approval stages before being published or updated. MDS is particularly useful in large organizations where there is a need to coordinate and manage master data across various systems and applications. This enables effective management of information resources, which is key to making informed business decisions and maintaining high quality operations.
This instructor-led, live training in Olsztyn (online or onsite) is aimed at beginners, programmers, and database administrators who wish to learn or improve their SQL development skills and knowledge.
By the end of this training, participants will be able to install, create, manage, manipulate, and monitor databases using SQL and database management systems.
This instructor-led, live training in Olsztyn (online or onsite) is aimed at database administrators, SQL developers, and data analysts who wish to enhance their SQL tuning expertise.
By the end of this training, participants will be able to:
Work with user-defined data types (UDDT) and user-defined types (UDT) to enhance data modeling.
Manage hierarchical data effectively, considering structure elements, storage methods, indexing strategies, and methods.
Implement ranking and analytical features using the OVER clause, window functions, and various operators like GROUPING SETS, GROUPING_ID, ROLLUP, CUBE, PIVOT, UNPIVOT.
Utilize temporary data and other temporary facilities for efficient query processing.
Improve query performance through advanced data indexing techniques, including index selectivity, server suggestions for missing indexes, and measuring execution time with and without indexes.
Create and maintain statistics to optimize cardinality estimation and address potential errors.
Analyze execution plans for SQL queries, understand query plan reading, parameter sniffing, and code recompilations.
Control the execution of SQL queries using hints, Extended Events, Database Engine Tuning Advisor, Data Collector, and Query Store.
The "Basics of Database Administration Oracle 18g XE for Developers" training covers topics related to server architecture Oracle, instance management, data storage structures, security, data space, transactionality, data migration and backup and recovery. Participants will gain knowledge of tools, processes and configurations to effectively administer a database Oracle.
This instructor-led, live training in Olsztyn (online or onsite) is aimed at engineers who wish to set up, deploy, migrate to and manage an Oracle 18c Database.
By the end of this training, participants will be able to:
Understand the major feature and architectural changes from previous Oracle versions.
Migrate to Oracle 18c from a previous version.
Deploy Oracle 18c in cloud or on premise.
Understand Oracle 18c's new yearly release cycle and plan maintenance around it.
This instructor-led, live training in Olsztyn (online or onsite) is aimed at IT administrators and developers who wish to set up, deploy and manage cloud applications using the services and technologies provided by Oracle PaaS.
By the end of this training, participants will be able to:
Build, deploy, and manage cloud applications using Oracle PaaS.
Configure and use data management tools for easy storage and backup.
Visualize and evaluate application performance and logs.
This instructor-led, live training in Olsztyn (online or onsite) is aimed at engineers who wish to migrate from Oracle Forms to Oracle Web Forms.
By the end of this training, participants will be able to:
Understand the major feature and architectural changes in Oracle Web Forms.
Migrate to Oracle Web Forms from a previous Forms version.
***Deploy Oracle Web Forms in cloud or on premise.
Leverage Oracle Web Forms to enhance user services and experience.
Audience: Any IT professionals who aspire to become DBAs or database support professionals on MySql Database on linx/windows platforms.
Format: 40% theoretical/lectures, 60%Practical/hands on lab
MySQL Administration training course is for anyone who wants to administrate the MySQL database server. It is a comprehensive course covering all administrator duties.
The course explains how MySQL Database works, what tools are available, how we can use them, how we can secure the MySQL Database Server and configure it. During the training course you will learn how to manage user accounts and how the MySQL Access Privilege System works. You also will learn how to maintain your database, backup and recover your databases and perform crash recovery.
This instructor-led, live training in Olsztyn (online or onsite) is aimed at engineers who wish to use a proxy approach to ensure high availability for MySQL based databases.
By the end of this training, participants will be able to:
Install and configure ProxySQL.
Enable thousands of concurrent database connections over multiple backend servers.
MySQL is a popular relational database management system (RDBMS) that allows you to create, manage, and operate databases. Jest is open-source software, which means it is available for free to users and the source code is open and publicly available. MySQL is one of the most popular database management systems in the world, especially in online environments. Thanks to its reliability, efficiency and ability to access open sources, it is widely used by companies, from small startups to large corporations, as a basis for storing and managing data.
About This Course
This three-day instructor-led course is aimed at people looking to move into a database professional role or whose job role is expanding to encompass database elements. The course describes fundamental database concepts including database types, database languages, and database designs.
Audience Profile
The primary audience for this course is people who are moving into a database role, or whose role has expanded to include database technologies.
At Course Completion
After completing this course, students will be able to:
• Describe key database concepts in the context of SQL Server 2016
• Describe database languages used in SQL Server 2016
• Describe data modelling techniques
• Describe normalization and denormalization techniques
• Describe relationship types and effects in database design
• Describe the effects of database design on performance
• Describe commonly used database objects
This course has been created for delegates already acquainted with SQL in Microsoft SQL Server Environment 2008/2012. The course focuses on set-based querying and query tuning, working with indexes and analyzing execution plans.The training also covers table expressions, ranking functions and how to deal with partitioned tables.
This three-day instructor-led course provides students moving from earlier releases of SQL Server with an introduction to the new features in SQL Server 2016.
Skills gained
Describekey capabilities and components of SQL Server 2016
Describe new and enhanced features in SQL Server performance
Describes new and enhanced features in SQL Server security
Describe what’s new inSQL Server Availability and Scalability
Describe new and enhanced features in reporting and PowerBIin SQL Server 2016
Describe new and enhanced data access features
Describe new and enhanced features in SQL Server OLAP
This five-day instructor-led course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2014 database. The course focuses on teaching individuals how to use SQL Server 2014 product features and tools related to maintaining a database.
Note: This course is designed for customers who are interested in learning SQL Server 2012 or SQL Server 2014. It covers the new features in SQL Server 2014, but also the important capabilities across the SQL Server data platform.
This five-day instructor-led course provides students who administer and maintain SQL Server databases with the knowledge and skills to administer an SQL server database infrastructure. Additionally, it will be of use to individuals who develop applications that deliver content from SQL Server databases.
This training is designed to introduce participants to various advanced solutions for data types and database structures. Participants will learn to use spatial type data, hierarchical type data, XML type data, and process data from/to JSON format.
Upon completion of the training, the participant:
▪ will be able to use various advanced solutions for data types and database structures
▪ will be able to process data from/to JSON format.
This training course is designed to familiarize participants with the security principles of relational databases, learn how to manage security copies and manage user access rights to specific resources. Participants will also learn how to securely store data and "hide" sensitive information, but will also learn how to monitor the database and server for security.
Upon completion of the training, the participant:
▪ will be familiar with the security principles of relational databases
▪ will know how to use copies of databases
▪ will be able to extract interesting data from the database
▪ will be able to manage user access rights to specific resources
▪ will know how to store data securely
▪ will know how to "hide" sensitive information
▪ will know how to monitor the database and server for security.
This training is designed to introduce the knowledge that allows you to configure the database server according to your requirements, and to create appropriate procedures for monitoring the functioning of its various components, as well as to quickly respond to any irregularities that arise. After completing this training, the participant will be able to effectively diagnose the sources of performance problems in the operation of SQL Server and apply various types of implementations leading to the removal of so-called "bottlenecks".
Upon completion of the training, the participant:
▪ will be able to diagnose so-called "bottlenecks" in the operation of the database and/or server
▪ will be able to monitor the operation of SQL Server
▪ will know what to recommend to improve the performance of the database and server.
This three-day instructor-led course is aimed at people looking to move into a database professional role or whose job role is expanding to encompass database elements. The course describes fundamental database concepts including database types, database languages, and database designs.
Skills gained
Describe key database concepts in the context of SQL Server 2016
Describe database languages used in SQL Server 2016
Describe data modelling techniques
Describe normalization and denormalization techniques
Describe relationship types and effects in database design
Describe the effects of database design on performance
Microsoft SQL Server is a relational database management system (RDBMS) for storing and retrieving data.
In this instructor-led, live training (onsite or remote), participants will learn the essentials of the SQL language needed to query a Microsoft SQL Server database.
By the end of this training, participants will be able to:
Install and configure Microsoft SQL Server
Query a Microsoft SQL Server database using Microsoft's Transact-SQL (T-SQL) language
Understand the essentials of database design
Optimize a database through normalization
Use aggregate functions to generate results similar to those of "pivot-tables"
Access Microsoft SQL Server through Excel
Audience
Data analysts
Business Intelligence professionals
Business managers
Excel experts who wish to expand their analysis skill set
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
To request a customized training for this course, please contact us to arrange.
The course participants will learn the terminology of relational databases, acquire the skills to design database applications, know the basic principles of creating forms and reports.
The training discusses issues related to programming in Visual Basic for Applications and presents ways of accessing data using VBA. The training participants also learn the mechanisms that allow them to write a professional database application.
The course participants will learn how to speed up the operation of the database, how to write advanced queries, create a convenient system of forms and reporting. The course introduces the participant to automate all operations using macros and VBA.
The Microsoft Access course is an intensive learning of using the database engine, focusing on practical skills. Master table design, creating queries, relationships between them, and effective collaboration with Excel. The course also covers creating forms, reports and automating work using macros.
This instructor-led, live training in Olsztyn (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.
This instructor-led, live training in Olsztyn (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.
Reporting Services (or SQL Server Reporting Services - SSRS) is a service available as part of the Microsoft SQL Server suite that allows you to create, manage and deliver various types of reports. Here are the main features and functions of Reporting Services: - It allows you to create a variety of reports such as tabular reports, charts, graphs, map reports, as well as subscription reports and interactive reports. - Ability to connect to various data sources, such as databases, Excel files, text files or external data sources. - It has a graphical environment (Report Builder and SQL Server Data Tools) that facilitates the design and creation of reports without the need for programming. - Allows you to manage reports, catalog, share, schedule and view reports. - Provides various report delivery methods, including e-mail, sharing on a server, publishing as interactive websites, printing, etc. - Has permission management mechanisms that allow you to control access to reports. - Enables the creation of reports that allow users to interactively filter, sort and navigate data. SQL Server Reporting Services is a tool used by organizations to generate, manage and deliver various types of business reports. Thanks to this tool, users are able to use data effectively, visualize information and support decision-making based on data analysis.
About the training
Training on working with SQL language for a selected SQL database server including DML and DDL - updating data and creating database objects. General-purpose training aimed at people involved in active data processing.
Purpose of the training
To familiarize with the terminology and tools necessary for working with a database. To learn the extension of the knowledge of SQL language and its use in everyday work with a database.
What will Sharepoint improve in your work?
You will learn how to retrieve data efficiently. You will shorten data flow paths by skipping CSV, Excel files, etc. You will gain the ability to use the latest analytical tool. You will increase your confidence at work by learning new skills. You will dramatically increase your chances for promotion. You will radically increase the level of your professional competence.
Where will you use the acquired knowledge?
You will increase the efficiency of your work related to creating reports and statements in spreadsheets and BI tools. You will also notice an increase in your comfort in accessing data.
What will you learn?
You will improve information sharing with colleagues. You will be able to create a unified reporting system. Standardization of methods for generating reports and creating statements for analysis will no longer be a problem for you. At the same time, you will move the security of the created analyses to a new higher level.
This course will teach the basics of Microsoft's dialect of the standard SQL language: Transact-SQL. Topics include both querying and modifying data in relational databases that are hosted in Microsoft SQL Server-based database systems, including: Microsoft SQL Server, Azure SQL Database and, Azure Synapse Analytics.
Oracle 11g is a version of Oracle's database that was released in 2007. Jest is a relational database management system that offers a wide range of features and tools for storing, managing and analyzing data. The "g" in the name stands for "grid computing" - an approach to managing IT resources. Oracle 11g offers a number of improvements over previous versions, including improved memory management, improved performance, additional security features, expanded language programming capabilities PL/SQL, and new administration tools. This version was widely used in many organizations before subsequent updates and releases of Oracle. However, it is worth noting that since the release of Oracle 11g, Oracle has released subsequent versions of its database management system, including 12c, 18c and 19c, with various improvements and new features.
For who
The 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 Certificates
The 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 Database
Purpose of training
The 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
Remarks
The workshops are based on 11g XE software
For who
Workshops 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 Certificates
The 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 Expert
Purpose of training
The 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
Notes
The workshops are based on the software version 11g XE
For who
Workshops 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 applications
Exams and Certificates
The 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 Associate
Purpose of training
The 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
Notes
The workshops are based on the software version 11g XE
For who
This 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 Certificates
The 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 Professional
Purpose of training
The 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.
Notes
The workshops are based on the software version 11g XE
For who
The workshop is intended for advanced programmers and Oracle users who seek knowledge and information on the efficient development of information systems in an Oracle database, and the tuning and testing of performance issues in existing applications. This course builds on knowledge often unavailable or incorrectly presented in the technical documentation, and collected during many years of practice leading them instructors. These workshops may be the end of the training path for developers, or a single step for people with extensive experience designing and programming in Oracle
Purpose of training
The workshop aims to provide mechanisms that occur in an Oracle database when performing SQL statements. Allows participants to avoid errors during software development, and explore, diagnose, and resolve performance problems in existing applications.
Particular emphasis is placed on the workshops, where we show the methodology and the practical aspects of the application and tuning SQL statements.
The content of the training
Mechanics perform SQL commands
Managing the process cost optimization
Methods of data storage and indexing
Monitoring database performance and processes based on dictionaries and track system applications
Analysis of cases of the most common problems that cause performance
Notes
The workshops are based on the software version 11g XE
Read more...
Last Updated:
Testimonials (25)
Everything, the exercises, the thorough explanations, Philip is a great trainer!
Zsolt - REGNOLOGY ROMANIA S.R.L.
Course - SQL Advanced
It was informative.
Seidu - MTN Ghana
Course - Fundamentals of Cassandra DB
The topic was interesting, and the trainer was very friendly and has adept knowledge of the subject.
Jacqueline - Tribal Grou[
Course - Developing Applications with Oracle Application Express (APEX)
Good introduction to the subject, the trainer totally adapted to my requests
Mathieu - Crédit Agricole Corporate & Investment Bank
Course - KDB+/Q/Python Financial Data Ananlysis
Machine Translated
Practical knowledge over theory
Szymon - Agora SA
Course - Scylla Database
Duży zasób wiedzy u prowadzącego
Tomasz - Viessmanna R&D Center
Course - MongoDB Atlas Fundamentals
Lot of content and exactly the requested one.
Pascal - Diehl
Course - Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server
Hands on work, not just theory.
Atilla Kolali - Raiffeisen Schweiz
Course - Redis for Developers and System Administrators
Was well organized
Instructor ability to explain concepts, in a manner that is easy to understand
Oana Bunea - SERVICIUL DE TELECOMUNICATII SPECIALE
Course - MariaDB Galera Cluster Administration
The trainer explained everything with a lot o detail, and it was always engaging us.
Florian Lipianu - SERVICIUL DE TELECOMUNICATII SPECIALE
Course - MariaDB Database Administration
The adjustment made in the lecture/lessons by the trainer once he understood the current SSIS application that we are bound to maintain.
The topics became more suitable/usable to us.
Angelito Aguilar - Metrobank
Course - Introduction to SQL Server 2012 Integration Services (SSIS)
ćwiczenia i sposób ich tłumaczenia
Marcin Lipiec - Izba Administracji Skarbowej w Rzeszowie
Course - Wprowadzenie do Neo4j - grafowej bazy danych
Dbałość trenera o aktywność całej grupy.
Kamil Matejak - ENIGMA Systemy Ochrony Informacji Sp. z o. o.
Course - Redis for High Availability and Performance Training Course
Aktualność wiedzy oraz nacisk na dobre praktyki. Wiedza została zilustrowana faktycznymi realizacjami.
Bartłomiej Nowak - Politechnika Łódzka
Course - React, Relay, and GraphQL
Duża wiedza z zagadnień objętych szkoleniem. Otwartość prowadzącego i dostosowanie treści i przebiegu szkolenia do uczestników.
Andrzej Kowalewski - ZETO Software SP. z o.o.
Course - Building Interactive Applications with React, Redux and GraphQL
The trainer had a lot of knowledge of the material and was able to bring it to us in a fun and lighthearted way.
Yordi Habets - Etesian IT consulting
Course - GraphQL Basics
Exercises, balance between theory and practice
Damian Kajewski - Glosel Sp. z o. o. Sp. k.
Course - Advanced MariaDB for High Availability and Performance
Projekt do samodzielnego przygotowania, interesujący przykład DevOps-owej pacy z Ambari, wsparcie trenera (logowanie na maszynę wirtualną, dobra i bezpośrednia komunikacja)
Bartłomiej Krasiński - Rossmann SDP
Course - HBase for Developers
The smoothness of the training flow.
Alby Geronimo - Aarki, Inc.
Course - SQL DATABASE MANAGEMENT AND DESIGN - Bespoke
Przygotowanie trenera, bogata wiedza, sprawne prowadzenie zajęć.
Damian Gzik - TRW Polska sp. z o.o.
Course - A Practical Introduction to NoSQL Databases
Extensive knowledge of NoSQL environments, not only Cassandra (ex: HADOOP)
Stefan Marcoci - Vidéotron ltée
Course - Cassandra Administration
Szkolenie było przygotowane perfekcyjnie, najbardziej podobał mi się sposób prowadzenia oparty przykładach pisanych w czasie rzeczywistym z dokładnym omówieniem jaki wpływ na bazę danych mają poszczególne instrukcje.
Joanna Dymarczyk
Course - Oracle 11g - Programowanie w PL/SQL I - warsztaty
I like fact, that after each section we had exercises. It helps to remember discussed topic.
Adam Bińczycki
Course - Oracle 11g - SQL language for developers - Workshop
Interakcja z prowadzącym, możliwość zadawania pytań na gorąco
Grzegorz Ziegert
Course - Administration with Powershell
wiedza i przekłady
Jan Maksymowski
Course - Oracle 11g - Język SQL dla administratorów - warsztaty
Online Database training in Olsztyn, Database training courses in Olsztyn, Weekend Database courses in Olsztyn, Evening Database training in Olsztyn, Database instructor-led in Olsztyn, Database instructor-led in Olsztyn, Database trainer in Olsztyn, Weekend Database training in Olsztyn, Online Database training in Olsztyn, Database one on one training in Olsztyn, Database private courses in Olsztyn, Evening Database courses in Olsztyn, Database coaching in Olsztyn, Database instructor in Olsztyn, Database classes in Olsztyn, Database on-site in Olsztyn, Database boot camp in Olsztyn