SQL & Database Training
SQL and database training: MySQL, PostgreSQL, Oracle, MongoDB. From basic SQL queries to advanced optimization and database administration.
21 courses available
Intermediate
Apache Drill - SQL on Big Data
This training provides practical introduction to Apache Drill, a SQL query system for various big data sources. Participants will learn advanced data analysis techniques using familiar SQL syntax on heterogeneous data sources. The program combines theory with intensive workshops, where participants learn to design and optimize queries for distributed systems, working on real-world use scenarios.
from 3,900 PLNApache Spark SQL - structured data processing
An intensive training course dedicated to the effective use of Apache Spark SQL in processing structured data in a distributed environment. The program covers both the theoretical basics of DataFrame processing and the practical aspects of implementing efficient transformations and analysis. Participants work with real data sets, learning how to optimize queries and effectively use the Catalyst engine. The workshop is conducted in the form of practical classes, where each concept is immediately verified through the implementation of specific use cases.
from 1,850 PLNBuilding Desktop Applications with VS 2022, VB.NET and SQL Server 2022
The training guides participants through the process of creating professional desktop applications using Visual Studio 2022, VB.NET and SQL Server 2022. The program combines theory with practice, where participants build a full-fledged business application from scratch. Classes are conducted in a workshop format, where each theoretical element is immediately translated into practical exercises using modern development tools.
from 2,150 PLNData analysis with SQL, Python and Tableau
Intensive training combining practical knowledge of data analysis using SQL, Python and Tableau. Participants will learn the process of data acquisition, processing and visualization in a business environment. The program includes hands-on workshops where participants independently implement analytical projects from start to finish.
from 2,450 PLNIBM Db2 12 for z/OS SQL Performance and Tuning
Learn how to improve SQL performance in DB2 12 for z/OS. EITT training covers index optimization, multi-table access, subquery and lock management.
from 9,840 PLNMemSQL - In-Memory SQL Database
This training introduces participants to the world of high-performance in-memory databases using MemSQL as an example, combining traditional SQL syntax with modern in-memory processing techniques. The workshop program allows understanding how to effectively use in-memory architecture to significantly accelerate database operations while maintaining a familiar SQL environment. Participants will learn both the theoretical foundations of in-memory database operation and practical aspects of deploying them in production environments, with particular emphasis on performance optimization and resource management.
from 3,500 PLNMigration from Oracle to Azure SQL or PostgreSQL
Practical training focusing on the database migration process from Oracle to Azure SQL or PostgreSQL platforms. The program covers planning methodology, preparation, and migration execution, with particular emphasis on maintaining data integrity and minimizing downtime. Participants will learn migration tools, schema conversion techniques, and data validation methods. The training is conducted in workshop format where theory is immediately verified in practical migration scenarios.
from 1,650 PLNPower BI with SQL - Data Integration and Analysis
A three-day training combining Microsoft Power BI Desktop with SQL database server. Participants will learn efficient data retrieval and transformation from SQL, creating reports and analyses in Power BI, working with DirectQuery, and writing SQL queries directly from Power BI. The program also covers DAX fundamentals, Power Query, and using AI tools for data transformation automation and query generation.
from 3,900 PLNSQL and PL/SQL Optimization for Developers
Advanced training dedicated to SQL query and PL/SQL procedure optimization techniques, focusing on increasing database performance and efficiency. The program guides participants through the process of identifying bottlenecks, analyzing execution plans, and implementing optimization solutions. Practical workshops constitute the main part of the training, where participants work on real-world cases and complex database scenarios. Sessions combine theory with intensive exercises on prepared test environments, allowing safe experimentation with various optimization techniques.
from 3,500 PLNSQL Database Management and Design - Customized Course
Two-day workshop training on SQL database design and management. The program was developed with practical applications in mind, covering both schema design basics and advanced optimization techniques. Participants work on real examples, learning best practices and solving common problems.
from 1,400 PLNSQL from Basics to Practice - Intensive Course with AI
A three-day intensive SQL course with AI elements, guiding participants from their first SELECT query to advanced CTE techniques, window functions, and aggregation cubes. The program integrates AI tools for automatic data structure recognition, query optimization, and trend prediction. Participants will also explore SQL usage in external applications - Excel, Power BI, and ODBC connections.
from 3,900 PLNSQL in MySQL - Professional Course
This training provides thorough knowledge of SQL use in MySQL environment, combining theory with intensive practice. Participants will learn advanced MySQL database techniques through a series of practical workshops and exercises. The program covers both basic and advanced SQL aspects, with particular emphasis on MySQL specifics. Sessions are conducted interactively, with emphasis on solving real-world problems.
from 2,450 PLNAdvanced
Advanced SQL II
The training delves into advanced aspects of SQL, focusing on query optimization and database performance. The program combines theory with intensive hands-on workshops where participants work on real database examples. Classes are conducted in a workshop format with an emphasis on solving complex database problems.
from 3,300 PLNAdvanced SQL - Optimization and Performance
This training focuses on advanced SQL query optimization techniques and improving database performance. Participants will learn methods for analyzing query execution plans, indexing techniques, and optimization strategies in real scenarios. The program combines theory with practical workshops on real use cases.
from 1,400 PLNAdvanced SQL in MySQL
The training is dedicated to advanced MySQL techniques. The program focuses on practical aspects of creating complex queries and database performance optimization. Participants will learn advanced MySQL mechanisms through workshops with real use cases. Sessions are conducted in the form of intensive practical exercises where each participant has the opportunity to independently solve problems.
from 1,250 PLNConfluent KSQL - streaming SQL processing
Advanced training on using KSQL for streaming processing using SQL. The training program guides you through the design and implementation of advanced streaming queries, data transformation and real-time analytics. During intensive hands-on workshops, participants work with real data streams, learning to formulate complex queries and create processing pipelines. The training methodology is based on a hands-on approach, where each new concept is immediately applied in the context of real use cases.
from 1,850 PLNData analysis with SQL, Python and Spotfire
The training combines the potential of Python, SQL and the Spotfire platform to create advanced analytical solutions. The program guides participants through the process of data acquisition, processing and visualization, using the best features of each tool. The class is delivered in a workshop format, where participants work on real use cases, learning how to integrate different technologies into cohesive analytical solutions. The training focuses on the practical aspects of creating end-to-end analytical solutions.
from 2,450 PLNIntensive SQL Programming Course
Intensive workshop training dedicated to SQL programming, from fundamentals to advanced techniques. The program covers practical aspects of creating queries, stored procedures, and functions, along with database administration elements. Sessions are conducted in workshop format with many practical exercises and real-world examples.
from 3,750 PLNSQL - Advanced Data Processing
This training guides participants through advanced SQL data processing techniques, focusing on creating efficient and scalable database solutions. The program combines deep theoretical understanding with intensive practical workshops where participants learn to design complex queries, optimize performance, and implement advanced data processing patterns. Sessions are conducted in a way that helps understand not only how to write advanced SQL code, but also why certain solutions are more effective than others.
from 3,300 PLNSQL in Microsoft Access - Advanced Queries and Data Analysis
Advanced training focusing on using SQL in the Microsoft Access environment to create complex queries and perform in-depth data analysis. The program combines the theoretical foundations of advanced SQL with intensive hands-on workshops where participants work on real data sets. The training uses a project-based methodology, where each module ends with the implementation of a practical analytical solution.
from 1,150 PLNFrequently Asked Questions
What SQL training does EITT offer?
We offer SQL training at every level: from basics (SQL from scratch), through advanced queries, to administration and optimization of MySQL, PostgreSQL, Oracle, and SQL Server databases.
Do you offer NoSQL training?
Yes — we offer training in MongoDB, Redis, Cassandra, and Elasticsearch. Both introductory and advanced, covering schema design, scaling, and application integration.
Where should I start learning SQL?
We recommend the 'SQL Basics' course, which requires no prior experience. You can then specialize in a specific engine (MySQL, PostgreSQL, Oracle) or data analysis.
Can't find the right training?
We design custom training programs. Describe your needs and we'll prepare a tailored offer.
Ask about training