JAVA-SQL

SQL for Java programmers

SQL language and its use with different Java technologies
Form of participation
Form of training
Length of training
  • 3 day (3×8 Lessons)
  • daily 9:00 - 17:00
Available languages
  • Hungarian
Dates

Training price

315 000 Ft
+ VAT/person
Please choose the date and form of participation!
Would you like a custom made solution, group training on this topic?
Find out more about our customised training services here.

Description

Effective management and retrieval of data is vital for any business that wants to use information for decision-making and business growth. SQL is an essential database management tool that allows you to process data quickly and accurately.

In this training, participants will gain a comprehensive understanding of the SQL language, its basic structure and its key role in database management. Our goal is to prepare participants to work with data efficiently and to be able to perform complex queries and data manipulations.

During the training, you will learn SQL through hands-on exercises and real business situations. We will also demonstrate how to work with MySQL, MariaDB and PostgreSQL. At the end of the training we will give you a taste of how to issue SQL statements from JAva code.

Outline

  • Use of different databases (MySQL, MariaDB and PostgreSQL)
  • Using different clients (DBeaver, HeidiSQL, MySQL Workbench, pgAdmin, IntelliJ IDEA)
  • Basic concepts related to databases
  • Data types and tables
  • SELECT, DISTINCT - Simple queries
  • WHERE - Select data based on conditions
  • Handling NULL values
  • AND, OR, NOT - Linking conditions in queries
  • ORDER BY - Sorting results in a sequence
  • Scroll to
  • MIN, MAX - Find minimum and maximum values
  • COUNT, AVG, SUM - Count, average and sum
  • GROUP BY, HAVING - Grouping of results, criteria for groups
  • LIKE - Search by similarity
  • INSERT - Insert new records into data tables
  • UPDATE - Update each record
  • DELETE - Delete records
  • JOIN - Link tables (direct link, link to self, link to link table)
  • UNION, EXCEPT and INTERSECT - Merge results
  • Operators and functions
  • Date and time management
  • Subqueries
  • DDL
  • CREATE - Create table
  • ALTER - Modify table
  • DROP - Drop table
  • Primary and foreign keys
  • Assigning identifiers
  • Restrictions
  • Normal forms
  • Transaction handling
  • Introduction to JDBC
  • Introduction to Spring JdbcTemplate
  • Introduction to Spring Data JDBC
  • Introduction to MyBatis
  • Introduction to JOOQ
Outline (PDF)

Prerequisites

Basic Java programming skills.