Working With Databases in IntelliJ IDEA

In this demo session we’ll show you how to write SQL queries and work with data in IntelliJ IDEA, from writing simple queries to more advanced tasks with the help of embedded database management functionality.
What we’ll cover:
– Creating a simple query: various types of code completion, code snippets, expanding wildcards, and working with subqueries.
– Using the data editor: editable result sets, bulk submit, multiple submit, transposing data, and comparing data.
– Data import/export: import from CSV files, export to JSON or UPDATES/INSERTS, and export to other databases.
— Navigation: searching for database objects, data, SQL code, files, settings, and more.
— Other features: user parameters, the diff tool, and query history.

Speaker: Maxim Sobolevskiy
Maxim Sobolevskiy was an SQL developer for 10 years. He started doing marketing for DataGrip, JetBrains’ SQL IDE, in 2015 and became the team lead in 2020.

Join us:

#javadatabase #java #intellijidea #intellijideaconf

[ClarkeDesign]

Nice tutorial - learnt so much even though I have used this for a few months. Would love to see some more tutorials on this topic please.

[samueladetoye]

you did not take about restoring database using intelij. like bring existing data inside.