In this webinar, we’ll show the basics of writing SQL queries and working with data in IntelliJ IDEA. From basics — how to write a simple query faster to some more complicated stuff: updating data, creating run configurations, using language injections.`
What will be covered:
— Creating a simple query. Various types of code completion, code snippets, expanding wildcards, working with subqueries.
— Data editor. Editable result-sets, bulk submit, multiple submit, transposing data.
— Data import/export. Import from CSV file, export to JSON or UPDATES, INSERTS. Export to other databases.
— Navigation. Searching for database objects, data, SQL code, files, settings, etc.
— Other features. User parameters, diff tool, evaluate an expression, transaction control,

All these features are also relevant to DataGrip, PhpStorm, PyCharm, Rider, and other IDEs based on the IntelliJ platform.

Speaker:
Maxim Sobolevskiy
Maksim Sobolevskiy lives in St. Petersburg, Russia. He is originally from Tashkent, Uzbekistan but moved to Russia in 2010. He has worked as a PMM for JetBrains since 2015. From 2020 he is a team lead of DataGrip. Before, he was an SQL-developer for 10 years, working for the charity organization “Foundation source”, the National bank of Uzbekistan, and “Soyuz” furniture factory.

You can find Maxim on Twitter: https://twitter.com/moscasposcas

#sql #databases #intellij #intellij-idea #developer