Working With SQL and Databases in JetBrains IDEs
Livestream
Webinar Agenda
Let's use Python and MongoDB to map some Urban Forestry Administration data for Washington, DC. We'll see which neighborhoods are dense with trees and which are sparse, and find out whether the tree on a particular corner is a red oak or a pin oak.
We'll install MongoDB and scientific Python libraries, and code up a web application. Learn to use PyMongo from one of its developers, and create a working app that you can adapt to a variety of data and visualizations.
We'll install MongoDB and scientific Python libraries, and code up a web application. Learn to use PyMongo from one of its developers, and create a working app that you can adapt to a variety of data and visualizations.
Agenda
In this demo session, we’ll show you how to write SQL queries and work with databases in JetBrains IDEs – from simple queries to more advanced tasks, using embedded database management functionality.
Here’s 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.
- JetBrains AI: Text-to-SQL, Fix with AI, Schema-aware AI chat.
- Other features: user parameters, the diff tool, and query history.
Livestreams Agenda
day 1
day 2
day 3
day 4
day 5
|
June 30, 2025
17:45 - 18:15 |
Registration |
|
June 30, 2025
18:15 - 19:00 |
Welcome Words |
|
June 30, 2025
19:00 - 20:30 |
IntelliJ IDEA-based IDEs Tips & TricksMikhail Vink / Hadi HaririAn IDE is so much more than an editor, yet people still seem to compare one to another. This session looks at IntelliJ IDEA and shows tips and tricks that will make you a more efficient and productive developer (most of the tips’n’tricks are also applicable to all IntelliJ IDEA-based IDEs, such as WebStorm, PhpStorm, PyCharm, and others). From searching for symbols to having a smooth workflow when working with version control, the presentation examines all the aspects that make it possible to have a pleasurable development experience. You’re guaranteed to leave this session knowing things you probably didn’t even know existed and were afraid to ask whether they did. |
|
June 30, 2025
17:45 - 18:15 |
Registration |
|
June 30, 2025
18:15 - 19:00 |
Welcome Words |
|
June 30, 2025
19:00 - 20:30 |
IntelliJ IDEA-based IDEs Tips & TricksMikhail Vink / Hadi HaririAn IDE is so much more than an editor, yet people still seem to compare one to another. This session looks at IntelliJ IDEA and shows tips and tricks that will make you a more efficient and productive developer (most of the tips’n’tricks are also applicable to all IntelliJ IDEA-based IDEs, such as WebStorm, PhpStorm, PyCharm, and others). From searching for symbols to having a smooth workflow when working with version control, the presentation examines all the aspects that make it possible to have a pleasurable development experience. You’re guaranteed to leave this session knowing things you probably didn’t even know existed and were afraid to ask whether they did. |
|
June 30, 2025
17:45 - 18:15 |
Registration |
|
June 30, 2025
18:15 - 19:00 |
Welcome Words |
|
June 30, 2025
19:00 - 20:30 |
IntelliJ IDEA-based IDEs Tips & TricksMikhail Vink / Hadi HaririAn IDE is so much more than an editor, yet people still seem to compare one to another. This session looks at IntelliJ IDEA and shows tips and tricks that will make you a more efficient and productive developer (most of the tips’n’tricks are also applicable to all IntelliJ IDEA-based IDEs, such as WebStorm, PhpStorm, PyCharm, and others). From searching for symbols to having a smooth workflow when working with version control, the presentation examines all the aspects that make it possible to have a pleasurable development experience. You’re guaranteed to leave this session knowing things you probably didn’t even know existed and were afraid to ask whether they did. |
|
June 30, 2025
17:45 - 18:15 |
Registration |
|
June 30, 2025
18:15 - 19:00 |
Welcome Words |
|
June 30, 2025
19:00 - 20:30 |
IntelliJ IDEA-based IDEs Tips & TricksMikhail Vink / Hadi HaririAn IDE is so much more than an editor, yet people still seem to compare one to another. This session looks at IntelliJ IDEA and shows tips and tricks that will make you a more efficient and productive developer (most of the tips’n’tricks are also applicable to all IntelliJ IDEA-based IDEs, such as WebStorm, PhpStorm, PyCharm, and others). From searching for symbols to having a smooth workflow when working with version control, the presentation examines all the aspects that make it possible to have a pleasurable development experience. You’re guaranteed to leave this session knowing things you probably didn’t even know existed and were afraid to ask whether they did. |
|
June 30, 2025
17:45 - 18:15 |
Registration |
|
June 30, 2025
18:15 - 19:00 |
Welcome Words |
|
June 30, 2025
19:00 - 20:30 |
IntelliJ IDEA-based IDEs Tips & TricksMikhail Vink / Hadi HaririAn IDE is so much more than an editor, yet people still seem to compare one to another. This session looks at IntelliJ IDEA and shows tips and tricks that will make you a more efficient and productive developer (most of the tips’n’tricks are also applicable to all IntelliJ IDEA-based IDEs, such as WebStorm, PhpStorm, PyCharm, and others). From searching for symbols to having a smooth workflow when working with version control, the presentation examines all the aspects that make it possible to have a pleasurable development experience. You’re guaranteed to leave this session knowing things you probably didn’t even know existed and were afraid to ask whether they did. |
Speaking to you
Maxim Sobolevskiy
Maxim Sobolevskiy has 10 years of experience as an SQL developer. He joined JetBrains in 2015 and worked on the marketing for DataGrip, JetBrains SQL IDE, until 2020, when he became the DataGrip team lead.
Speakers Name 2
linkedin.com/in/baekjun-lim-499a1222
An IDE is so much more than an editor, yet people still seem to compare one to another. This session looks at IntelliJ IDEA and shows tips and tricks that will make you a more efficient and productive developer (most of the tips’n’tricks are also applicable to all IntelliJ IDEA-based IDEs, such as WebStorm, PhpStorm, PyCharm, and others). From searching for symbols to having a smooth workflow when working with version control, the presentation examines all the aspects that make it possible to have a pleasurable development experience. You’re guaranteed to leave this session knowing things you probably didn’t even know existed and were afraid to ask whether they did.
An IDE is so much more than an editor, yet people still seem to compare one to another. This session looks at IntelliJ IDEA and shows tips and tricks that will make you a more efficient and productive developer (most of the tips’n’tricks are also applicable to all IntelliJ IDEA-based IDEs, such as WebStorm, PhpStorm, PyCharm, and others). From searching for symbols to having a smooth workflow when working with version control, the presentation examines all the aspects that make it possible to have a pleasurable development experience. You’re guaranteed to leave this session knowing things you probably didn’t even know existed and were afraid to ask whether they did.
Speakers Name 3
linkedin.com/in/baekjun-lim-499a1222
An IDE is so much more than an editor, yet people still seem to compare one to another. This session looks at IntelliJ IDEA and shows tips and tricks that will make you a more efficient and productive developer (most of the tips’n’tricks are also applicable to all IntelliJ IDEA-based IDEs, such as WebStorm, PhpStorm, PyCharm, and others). From searching for symbols to having a smooth workflow when working with version control, the presentation examines all the aspects that make it possible to have a pleasurable development experience. You’re guaranteed to leave this session knowing things you probably didn’t even know existed and were afraid to ask whether they did.
An IDE is so much more than an editor, yet people still seem to compare one to another. This session looks at IntelliJ IDEA and shows tips and tricks that will make you a more efficient and productive developer (most of the tips’n’tricks are also applicable to all IntelliJ IDEA-based IDEs, such as WebStorm, PhpStorm, PyCharm, and others). From searching for symbols to having a smooth workflow when working with version control, the presentation examines all the aspects that make it possible to have a pleasurable development experience. You’re guaranteed to leave this session knowing things you probably didn’t even know existed and were afraid to ask whether they did.
Speakers Name 4
linkedin.com/in/baekjun-lim-499a1222
An IDE is so much more than an editor, yet people still seem to compare one to another. This session looks at IntelliJ IDEA and shows tips and tricks that will make you a more efficient and productive developer (most of the tips’n’tricks are also applicable to all IntelliJ IDEA-based IDEs, such as WebStorm, PhpStorm, PyCharm, and others). From searching for symbols to having a smooth workflow when working with version control, the presentation examines all the aspects that make it possible to have a pleasurable development experience. You’re guaranteed to leave this session knowing things you probably didn’t even know existed and were afraid to ask whether they did.
An IDE is so much more than an editor, yet people still seem to compare one to another. This session looks at IntelliJ IDEA and shows tips and tricks that will make you a more efficient and productive developer (most of the tips’n’tricks are also applicable to all IntelliJ IDEA-based IDEs, such as WebStorm, PhpStorm, PyCharm, and others). From searching for symbols to having a smooth workflow when working with version control, the presentation examines all the aspects that make it possible to have a pleasurable development experience. You’re guaranteed to leave this session knowing things you probably didn’t even know existed and were afraid to ask whether they did.
Speakers Name 5
linkedin.com/in/baekjun-lim-499a1222
An IDE is so much more than an editor, yet people still seem to compare one to another. This session looks at IntelliJ IDEA and shows tips and tricks that will make you a more efficient and productive developer (most of the tips’n’tricks are also applicable to all IntelliJ IDEA-based IDEs, such as WebStorm, PhpStorm, PyCharm, and others). From searching for symbols to having a smooth workflow when working with version control, the presentation examines all the aspects that make it possible to have a pleasurable development experience. You’re guaranteed to leave this session knowing things you probably didn’t even know existed and were afraid to ask whether they did.
An IDE is so much more than an editor, yet people still seem to compare one to another. This session looks at IntelliJ IDEA and shows tips and tricks that will make you a more efficient and productive developer (most of the tips’n’tricks are also applicable to all IntelliJ IDEA-based IDEs, such as WebStorm, PhpStorm, PyCharm, and others). From searching for symbols to having a smooth workflow when working with version control, the presentation examines all the aspects that make it possible to have a pleasurable development experience. You’re guaranteed to leave this session knowing things you probably didn’t even know existed and were afraid to ask whether they did.
Partners
Lorem ipsum dolor sit amet, no purto eros posse per. An mel volumus euripidis, mel adhuc accumsan no, porro invenire id sit.
Thank you
for submitting your inquiry for Meta Programming System: Intermediate course
We will contact you by e-mail with additional information and concrete instructions within a few days.
Stay tuned to get all the updates about upcoming events and product news.
Follow us on Twitter @jetbrains_mps, read our blog and check out our website.
If you’re struggling to find a good match between our standard courses and your actual needs, please feel free to contact us directly at [email protected] and detail your situation. We may be able to prepare a customized training that fits your needs.
Stay tuned to get all the updates about upcoming events and product news.
Follow us on Twitter @jetbrains_mps, read our blog and check out our website.
If you’re struggling to find a good match between our standard courses and your actual needs, please feel free to contact us directly at [email protected] and detail your situation. We may be able to prepare a customized training that fits your needs.