How to Use VS Code to Run SQL on a Database

📝 Get my free SQL Cheat Sheets: https://databasestar.mykajabi.com/lpk... 🎓 Master SQL Fundamentals: https://databasestar.mykajabi.com/sql... VSCode is a popular editor for development. If you have any need to work with an SQL database, then you’ll likely be using another IDE as well, such as SSMS, MySQL Workbench, pgAdming, or Oracle SQL Developer. However, if you use VSCode, you can access the database directly from within VSCode. You can do this by using an extension. This means you can run queries and see your data all within the same application, saving time from using different applications. You may also find it easier to use one application instead of two. It’s not as powerful as a full SQL IDE, but for simple stuff, it’s quite useful. In this video, you’ll learn how to install the extension and drivers in VSCode, how to create connections to SQL Server, MySQL, and PostgreSQL, how to run some SQL queries, and some features of the extension (including the Run Query keyboard shortcut). The extension we use does not support Oracle, but there is a different extension for that. Timestamps: 00:00 Introduction 00:29 Prerequisites 01:09 Install extension and drivers 03:53 Adding a new connection 04:22 Create MySQL connection 06:14 Create SQL Server connection 07:48 Create PostgreSQL connection 09:14 Connect to database 09:47 Write and run SQL 12:38 More features