Expanded Library

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
2mins

About the author

Julie Lerman is a software coach with over 30 years of experience as a developer. She 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 Entity Framework. You can find Julie giving keynotes and hard-core coding sessions on Domain-Driven Design, Azure, Entity Framework and other topics at software conferences around the world. As a coach, Julie provides support f... more

Ready to upskill? Get started