Gdańsk

Hotel Fahrenheit, Grodzka 19, Gdańsk, Poland, 80-841

The training room is located in the very heart of the picturesque Gdansk Old Town, making the surroundings...

Subcategories (31)

Image for Berkeley DB category
Berkeley DB
Image for SQL category
SQL
Image for MongoDB category
MongoDB
Image for Oracle category
Oracle
Image for Access category
Access
Image for PostgreSQL category
PostgreSQL
Image for Cassandra category
Cassandra
Image for MySQL category
MySQL
Image for MariaDB category
MariaDB
Image for Redis category
Redis
Image for Azure SQL Database category
Azure SQL Database
Image for Microsoft SQL Server category
Microsoft SQL Server
Image for PL/SQL category
PL/SQL
Image for Graph Database category
Graph Database
Image for NoSQL category
NoSQL
Image for Percona category
Percona
Image for kdb+ category
kdb+
Image for CouchDB category
CouchDB
Image for Database Migration category
Database Migration
Image for Hypertable category
Hypertable
Image for GraphQL category
GraphQL
Image for Firebase category
Firebase
Image for LINQ category
LINQ
Image for Presto category
Presto
Image for Change Data Capture (CDC) category
Change Data Capture (CDC)
Image for Hazelcast category
Hazelcast
Image for Prometheus category
Prometheus
Image for MongoDB Atlas category
MongoDB Atlas
Image for SQLite category
SQLite
Image for ClickHouse category
ClickHouse
Image for Vector Database category
Vector Database

Explore Our Courses

Oracle Cloud ERP Fusion Maintenance Module for Oil Field Operations

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

Oracle Business Intelligence (OBI)

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

Milvus: Open-Source Vector Database for AI Applications

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

Pinecone: Vector Database Solutions for AI

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

SQL: Basics to Intermediate

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

Building REST APIs with Node.js, Express, and MongoDB

 14 Hours
This instructor-led, live training in Gdansk (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.
  • Test and debug APIs with Postman.
Read more...

Mastering Vector Databases for Scalable AI Solutions

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

Analytic Functions Fundamentals

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

Data Analysis with MongoDB Aggregation Framework

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

Introduction to Vector Databases

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

Cost Analysis with Presto COST IT Module

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

Data Analysis with SQL, Python, and Tableau

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

Oracle Database 19c Security

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

MySQL Developer

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

MS SQL Server 2019

 14 Hours
This instructor-led, live training in Gdansk (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:
  • Create and manage databases, tables, and queries.
  • Manage query performance.
  • Create and restore database backups.
Read more...

FARM (FastAPI, React, and MongoDB) Full Stack Development

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

Advanced SQL II

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

PostgreSQL for Administrators - 2 Days

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

Oracle SQL for analysts - fundamentals

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

MongoDB for Administrators

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

PostgreSQL Administration and Development

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

Oracle SQL for analysts - advanced

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

MongoDB for Developers

 14 Hours
This course covers everything a database developer needs to know to successfully develop applications using MongoDB.
Read more...

PostgreSQL for Developers

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

Oracle SQL for data analysts - programming and performance

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

MongoDB for Analysts

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

PostgreSQL Essentials

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

Oracle SQL - introduction to working with the database

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

MongoDB zaawansowana administracja

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

SQL in Microsoft Access

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

PostgreSQL Administration, Optimization and Replication

 35 Hours
In this instructor-led, live training in Gdansk (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.
  • Replicate and scale a PostgreSQL server.
Read more...

Oracle SQL - advanced

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

Python in Data Science

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

MongoDB for Advanced Users

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

SQL in SQL Server

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

PostgreSQL Performance Tuning

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

Oracle PL/SQL - introduction to programming

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

MongoDB Advanced Administrator

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

Administrating Percona Server for MongoDB

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

PostgreSQL Advanced DBA

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

Oracle PL/SQL advanced programming

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

Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

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

Implementing High Availability in PostgreSQL

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

Oracle - Tuning SQL commands and performance of PL/SQL programs

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

MERN Fullstack Development

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

VBA For Access & Excel

 21 Hours
The objective of the course is to enable participants to gain a mastery of the fundamentals and usages of VBA for Access & Excel.
Read more...

SQL in MySQL

 14 Hours
  • How to build a query?
  • What is a relational database?
  • What is the structure and SQL commands?
Read more...

SQL Advanced

 14 Hours
Students will learn advanced queries and how to add, update, and delete data, tables, views, and indexes.
Read more...

PostgreSQL 13 for Developers and Administrators

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

Transact SQL Advanced

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

PostgreSQL for Administrators - 3 Days

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

Transact SQL Basic

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

SQL Advanced in MySQL

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

Monitoring Kubernetes with Prometheus

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

T-SQL Fundamentals with SQL Server Training Course

 14 Hours
This SQL training course is for people who want to acquire basic skills to deal with SQL Server Databases. Course will help the members to learn:
  • How to work with SQL Server and SQL Server Management Studio.
  • Meaning of Databases, SQL and RDBMS etc.
  • How to create tables, use DDL, DML and DAL.
  • Which are the various RDBMS Packages in the market and how they compare with each other.
  • An Introduction to NoSQL and how they are organizations are changing into hybrid databases.
Read more...

Data Analysis with SQL, Python and Spotfire

 14 Hours
In this instructor-led, live training in Gdansk, 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.
Read more...

kdb+ and q: Analyze Time Series Data

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

Which data storage to choose - from flat files, through SQL, NoSQL to massive distributed systems

 7 Hours
This course helps customer to chose the write data storage depend on their needs. It covers almost all possible modern approaches.
Read more...

SQL DATABASE MANAGEMENT AND DESIGN - Bespoke

 14 Hours
Format of the Course
  • Interactive lecture and discussion.
  • Lots of exercises and practice.
  • Hands-on implementation in a live-lab environment.
Read more...

PostgreSQL with Python

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

Tuning SQL i PL/SQL dla programistów

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

Oracle SQL Intermediate - Data Extraction

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

SQL Advanced level for Analysts

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

Oracle Linux 8: System Administration I

 35 Hours
This instructor-led, live training in Gdansk (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:
  • Configure passwordless authentication.
  • Administer user and group accounts.
  • Configure network interface.
  • Monitor and troubleshoot Oracle Linux.
Read more...

Migrating Oracle to Azure SQL or PostgreSQL

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

Oracle Fusion Human Capital Management (HCM)

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

Oracle Database 21c Administration

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

SQL Fundamentals

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

Oracle Database 19c: Administration

 35 Hours
This instructor-led, live training in Gdansk (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.
  • Manage and monitor Oracle databases.
  • Optimize Oracle database performance.
Read more...

Hasura GraphQL Engine

 14 Hours
This instructor-led, live training in Gdansk (online or onsite) is aimed at database administrators and developers who wish to use Hasura to build, access, and manage databases and applications efficiently with GraphQL. By the end of this training, participants will be able to:
  • Set up the necessary development environment to start building databases with Hasura.
  • Build, run, manage data access and queries on Hasura using GraphQL models.
  • Secure data access by setting up authentication with JSON Web Tokens and Firebase.
  • Extend database functions by integrating business logic.
  • Manage database migrations and metadata effectively on Hasura to prevent data loss.
Read more...

Blazegraph: Creating a Graph Database Application

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

Beyond the Relational Database: Neo4j

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

Building Graph Databases with Neo4j AuraDB

 14 Hours
This instructor-led, live training in Gdansk (online or onsite) is aimed at developers who wish to use Neo4j AuraDB graph database to build cloud applications with high availability and zero administration. By the end of this training, participants will be able to:
  • Set up the necessary development environment to start developing graph database applications with Neo4j AuraDB.
  • Understand the features, core concepts, and architecture of Neo4j AuraDB.
  • Learn how to build and scale graph database applications in the cloud.
  • Enhance cloud security with AuraDB's pre-configured authentication and encryption features.
  • Migrate existing Neo4j databases to AuraDB.
Read more...

Wprowadzenie do Neo4j - grafowej bazy danych

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

NoSQL Database with Microsoft Azure Cosmos DB

 14 Hours
This instructor-led, live training in Gdansk (online or onsite) is aimed at database administrators or developers who wish to use Microsoft Azure Cosmos DB to develop and manage highly responsive and low latency applications. By the end of this training, participants will be able to:
  • Provision the necessary Cosmos DB resources to start building databases and applications.
  • Scale application performance and storage by utilizing APIs in Cosmos DB. 
  • Manage database operations and reduce cost by optimizing Cosmos DB resources.
Read more...

Developing Applications with Oracle Application Express (APEX)

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

Business Intelligence with SSAS

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

Introduction to SQL Server 2012 Integration Services (SSIS)

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

Business Intelligence in MS SQL Server 2008

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

Developing in SQL Server Business Intelligence

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

Administration with Powershell

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

ClickHouse Fundamentals

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

SQLite Fundamentals

 14 Hours
This instructor-led, live training in Gdansk (online or onsite) is aimed at developers who wish to use SQLite to develop embedded applications for various devices, such as desktops, mobile phones, Android TV, cameras, etc. By the end of this training, participants will be able to:
  • Install and configure SQLite on any platform.
  • Understand the features and architecture of SQLite.
  • Learn how to execute common SQL operations in SQLite.
  • Learn how to manipulate data and tables in SQLite.
  • Understand the various SQLite data types, tools, and functions.
  • Perform calculations with SQLite aggregate functions.
Read more...

MongoDB Atlas Fundamentals

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

Prometheus Fundamentals

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

Distributed Data Processing and Storage with Hazelcast

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

Change Data Capture (CDC) with Debezium

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

Presto for Data Science

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

Mastering LINQ with C#

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

Firebase Fundamentals

 14 Hours
This instructor-led, live training (online or onsite) is aimed at developers who wish to use Firebase to build powerful data-driven mobile or web application.  By the end of this training, participants will be able to:
  • Understand the Firebase Web Platform
  • Understand how to simplify a database by using Firebase data modeling
  • Develop powerful applications that can process real-time data without the need to define detailed database structures.
  • Transact data on Firebase
  • Perform realtime data synchronization
  • Authenticate users with Firebase
  • Monitor users
Format of the Course
  • Interactive lecture and discussion.
  • Lots of exercises and practice.
  • Hands-on implementation in a live-lab environment.
Course Customization Options
  • To request a customized training for this course, please contact us to arrange.
  • To learn more about Firebase, please visit: https://firebase.google.com/
Read more...

Serverless Cloud Based Mobile and Web Development with Firebase

 28 Hours
This instructor-led, live training (online or onsite) is aimed at mobile and web developers who wish to use Firebase to build serverless cloud based Android, iOS or web applications. By the end of this training, participants will be able to:
  • Install and configure Firebase into an Android, iOS or web application.
  • Manage and authenticate application users. 
  • Access cloud based resources directly from client applications.  
  • Obtain usage and performance metrics from applications. 
Format of the Course
  • Interactive lecture and discussion.
  • Lots of exercises and practice.
  • Hands-on implementation in a live-lab environment.
Course Customization Options
  • To request customized training for this course, please contact us to arrange.
  • To learn more about Firebase, please visit: https://firebase.google.com.
Read more...

GraphQL Basics

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

Advanced Node Application Development With GraphQL

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

Building Interactive Applications with React, Redux and GraphQL

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

React, Relay, and GraphQL

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

KDB+/Q/Python Financial Data Ananlysis

 21 Hours
Audience *KDB+/Q developer Format of the course 50% lectures, 40% labs, 10% tests
Read more...

Berkeley DB for Developers

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

Hypertable: Deploy a BigTable Like Database

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

Flockdb: A Simple Graph Database for Social Media

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

Introduction to Graph Computing

 28 Hours
In this instructor-led, live training in Gdansk, 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.
Read more...

JanusGraph

 14 Hours
This instructor-led, live training in Gdansk (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.
  • Query graph data for analysis.
Read more...

Flyway for Database Migrations

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

Flyway for Continuous Database Delivery

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

Flyway from Intermediate to Advanced

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

Percona Server dla MySQL

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

Apache CouchDB for Developers

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

Redis for Developers and System Administrators

 14 Hours
Redis is an open source (BSD licensed), in-memory data structure store, used as database, cache and message broker.
Read more...

Top 4 Linux/Unix Servers - DNS,Web,Mail and Database

28 Hours
  • 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)
Read more...

MariaDB Database Administration

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

Advanced MariaDB for High Availability and Performance

 28 Hours
In this instructor-led, live training in Gdansk, participants will learn how to install, configure and manage MariaDB for high availability and performance. Other topics include backup and recovery, security and clustering.
Read more...

MariaDB Galera Cluster Administration

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

Cassandra Administration

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

Apache Cassandra 4.0

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

Fundamentals of Cassandra DB

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

Cassandra for Developers

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

Cassandra for Developers - Bespoke

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

Big Data Storage Solution - NoSQL

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

Big Data & Database Systems Fundamentals

 14 Hours
The course is part of the Data Scientist skill set (Domain: Data and Technology).
Read more...

HBase for Developers

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

MemSQL

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

A Practical Introduction to NoSQL Databases

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

OrientDB for Developers

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

Scylla Database

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

Microsoft Access - download the data

 14 Hours
The course is designed for persons with pre-information databases using SQL queries or queries.
Read more...

Developing Desktop Applications with Visual Studio 2012, VB.NET and SQL Server 2012

 21 Hours
This course is divided into 3 main sections and is made up of a mixture of presentations and practical exercises.
  1. VB.NET Language in Visual Studio 2012
  2. VB.NET Object Orientation
  3. VB.NET and Sql Server 2012
Read more...

Master Data Services - Wprowadzenie

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

SQL Development Bootcamp

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

SQL language in MSSQL

 14 Hours
The course answers questions
  • How to build a query?
  • What opportunities have SQL?
  • What is a relational database?
  • What is the structure and SQL commands?
Read more...

Tuning SQL

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

Podstawy administracji bazy danych Oracle 18g XE dla programistów

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

Oracle 18c Migration Strategy

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

Oracle PaaS

 14 Hours
This instructor-led, live training in Gdansk (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.
  • Generate business analytics reports.
  • Understand and implement security standards.
Read more...

Migrating to Oracle Web Forms

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

MySQL Administration

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

MySQL Database Administration

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

MySQL / Galera

 21 Hours
This bespoke course has been designed specifically against the requirements provided by Now Managed Learning Services
Read more...

ProxySQL

 14 Hours
This instructor-led, live training in Gdansk (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.
  • Deploy multiple ProxySQL proxies spanning numerous database instances.
  • Optimize the performance of a MySQL cluster, without altering the querying applications.
Read more...

Zaawansowana administracja MySQL

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

Introduction to SQL Databases (10985CC)

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

Administering in Microsoft SQL Server

 21 Hours
The course is designed for administrators, developers and database developers. The objectives of the training:
  • acquire and strengthen the skills to create and manage databases
  • knowledge of the syntax and use SQL to retrieve and modify data
  • apply safety rules in the database
  • the use of advanced elements (replication, automation, BI)
  • the use of Microsoft SQL Server capabilities to create complex reports and solutions for developers
Read more...

Microsoft SQL Server (MSSQL)

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

Database Administration Fundamentals for MS SQL Server

 35 Hours
Audience
  • Database Administrator
  • Developers
Read more...

Updating Your Skills to SQL Server 2016 10986-B

 21 Hours
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
  • Describenew SQL Server cloud functionality
Read more...

Administering Microsoft® SQL Server® 2014 Databases (authorized training course MS 20462)

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

Administering a SQL Database Infrastructure (authorized training course MS 20764)

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

Provisioning SQL Databases (authorized training course MS 20765)

 35 Hours
This course is designed to teach students how to provision SQL Server databases both on premise and in SQL Azure.
Read more...

MS SQL Server 2016

 14 Hours
As a core of the Microsoft data platform, SQL Server is a leading operational database management system.
Read more...

Ms SQL Server - Database Structures

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

Ms SQL Server - Database Security

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

Ms SQL Server - Query Optimization

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

Introduction to SQL Databases (szkolenie autoryzowane 10985-C)

 21 Hours
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
  • Describe commonly used database objects
Read more...

Learning SQL with Microsoft SQL Server

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

Access Intermediate

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

Access VBA

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

Access Advanced

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

Access - podstawy

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

Access - Data Base Designing

 21 Hours
The course participants will learn how to design a database and how to adapt it to work with the end user.
Read more...

Data Management

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

Pivotal Greenplum for Developers

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

MarkLogic Server

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

Reporting Services

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

SQL - data processing

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

DP-080T00: Querying Data with Microsoft Transact-SQL

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

Redis for High Availability and Performance Training Course

 21 Hours
redis nosql
Read more...

Oracle 11g - Administracja - warsztaty

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

Oracle 11g - SQL language for administrators - workshops

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

Oracle 11g - SQL language for developers - Workshop

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

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

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

Oracle 11g - Programming with PL / SQL II

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

Oracle 11g - Application Tuning - Workshop

 28 Hours
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

Upcoming Courses

Other regions in Poland

Other Countries

These courses are also available in other countries

Consulting

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