Simple play icon Course
Skills Expanded

Cross-platform SQL Server Management for Developers Using VS Code

by Julie Lerman

Visual Studio Code is an open-source and cross-platform IDE that allows you to code almost any language. Learn how to use the mssql extension for VS Code to manage almost any SQL Server database on any platform without leaving your development IDE.

What you'll learn

Thanks to over 3000 extensions, Visual Studio Code lets you code, debug, and control your source code in almost any language or framework. In this course, Cross-platform SQL Server Management for Developers Using VS Code, you'll be introduced to the mssql extension for Visual Studio Code to perform basic SQL Server management functions without leaving the developer IDE. The mssql extension allows you to interact directly with SQL Server databases. First, you'll learn how to use the extension to interact with local or remote SQL Server databases, including SQL Server LocalDb Azure SQL and SQL Server for Linux. Next, you'll explore tips and tricks for benefiting from this extension to inspect and export data. Finally, you'll discover how to perform maintenance on your database without depending on a resource-intensive database IDE. By the end of this course, you'll have a solid foundational knowledge of every feature to utilize Visual Studio Code efficiently in practice.

Table of contents

Course Overview

About the author

Julie Lerman is a software coach with over 30 years of experience building software. As a coach, Julie provides support for DDD and architecture implementation, facilitates Event Storming workshops and domain discovery. She also provides deep dives into Entity Framework for her clients in the .NET world. Julie is a long-time Pluralsight author, Microsoft MVP, Microsoft Regional Director and Docker Captain who lives in the hills of Vermont and continues to be known as the world’s top expert in E... more

Ready to upskill? Get started