Power BI Fundamentals - Create visualizations and dashboards from scratch
Save 40% on 3 months of Coursera Plus
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