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:
Website: https://jb.gg/website
Blog: https://jb.gg/blog
Twitter: https://twitter.com/intellijidea
Facebook: https://www.facebook.com/IntelliJIDEA/
Download IntelliJ IDEA: https://jb.gg/download-intellij-idea
Top 15 IntelliJ IDEA shortcuts: https://jb.gg/Top15IntelliJIDEAShortcuts
#javadatabase #java #intellijidea #intellijideaconf