AtlantaPHP Special JetBrains Event September 2017

PRESENTATION: JetBrains DataGrip Tips and Tricks

(If you use PHPStorm/WebStorm, this will be useful to you, as those IDEs include the same database features as DataGrip.)

Map Link: https://goo.gl/maps/N2F52DZs9Cs (parking deck entrance, 600 building is due north of the deck)

NOTE: This special event is off our regular meeting schedule and takes place during lunch.

Presentation by Max Sobolevskiy, Product Marketing Manager for JetBrains DataGrip

In this talk, Max Sobolevskiy is going to show what DataGrip ( https://www.jetbrains.com/datagrip/) is about. From basics — how to write a simple query faster to some more complicated stuff: using multiple cursors, transposing tables, etc.

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 expression, transaction control.

Food provided by Salesforce Engineering (@SalesforceEng (http://twitter.com/SalesforceEng))