Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

Getting Started with the PostgreSQL Extension for VS Code

Visual Studio Code via YouTube

Overview

Coursera Flash Sale
40% Off Coursera Plus for 3 Months!
Grab it
Learn to leverage the new PostgreSQL extension for Visual Studio Code in this comprehensive 20-minute tutorial. Discover how to set up local PostgreSQL servers directly within VS Code, create and manage databases, and visualize database schemas using the extension's intuitive visual tools. Master the art of writing SQL queries with enhanced IntelliSense support and explore the revolutionary natural language query feature that allows you to interact with your databases using conversational commands. Explore GitHub Copilot integration for automatic SQL generation and learn to connect seamlessly with cloud-hosted PostgreSQL databases. Dive deep into Agent mode functionality, which enables sophisticated database interactions through AI-powered assistance. The tutorial covers essential database management workflows, from initial setup through advanced querying techniques, making it ideal for developers looking to streamline their PostgreSQL development experience within Visual Studio Code. Gain practical experience with schema navigation, query optimization, and modern database development practices that combine traditional SQL skills with cutting-edge AI assistance tools.

Syllabus

00:00 Intro
00:45 Creating a local server
02:53 Creating a new database
03:53 Visualizing a schema
04:42 Writing queries
06:14 Chatting with your database
07:59 Connecting with a cloud hosted database
10:45 Using Agent mode with our database
19:01 Conclusion

Taught by

Visual Studio Code

Reviews

Start your review of Getting Started with the PostgreSQL Extension for VS Code

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.