Working With SQL and Databases in Rider

In this webinar, we&show the basics of writing SQL queries and working with data in Rider. All described is also relevant to the dedicated database IDE called DataGrip and all other IntelliJ-based IDEs. Even if you are familiar with the database features in Rider, it&really probable that you&learn something new for yourself and explore features that may be not obvious. 0:00 Introduction 1:45 Welcome, Max 3:07 DataGrip and JetBrains Rider 4:55 SQL Server, MySQL, PostgreSQL, different databases 8:04 Data sources and schemas 12:50 Query console 28:23 Data editor 36:00 Data extractors (export, import, migrate between databases) 45:18 Linked servers (SQL Server) 46:52 Language injections 50:10 Q&A 52:20 Compare schema and migration scripts 55:35 Execution plans 57:45 Geo viewer 58:48 Stored procedures 1:05:44 Working with XML columns 1:07:34 Wrap up Speaker: Maksim Sobolevskiy // DataGrip Team Lead, JetBrains Maksim Sobolevskiy was an SQL developer for 10 years. From Summer, 2015 he does marketing for JetBrains SQL IDE called DataGrip, and from 2020 he is the team lead of DataGrip.