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.
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.
Julie Lerman is a Microsoft MVP, .NET mentor and consultant who lives in the hills of Vermont. You can find Julie presenting on data access and other Microsoft .NET topics at user groups and conferences around the world. Julie is the author of the highly acclaimed "Programming Entity Framework (with a second edition coming soon) and authors the MSDN Magazine Data Points column.
Course Overview Welcome to Pluralsight. My name is Julie Lerman and you may already know me as an authority on interacting with data while developing software. I love data and I love playing with data. That's why I'm excited to share with you the very awesome MS SQL extension for Visual Studio Code. Visual Studio Code is a lightweight, cross-platform and open source IDE created by Microsoft for coding almost any language or framework thanks to the thousands of extensions but the extensions go way beyond coding and the MS SQL extension lets you interact with any type of SQL Server from within VS Code, so you could be coding away working on a Node. js API, a UI with Angular or React or maybe a. NET Core MVC app or whatever you work in and when you need to do something in your Azure SQL database, or the SQL Server for Linux database you've got running in a Docker container on your Mac, you can just do that without leaving the VS Code IDE. In this course you'll learn how to set up a variety of SQL servers including Azure SQL and SQL Server for Linux. You'll learn how to use the MS SQL extension to connect to your various SQL servers from any platform and then how to interact with the databases once the connection is made. MS SQL lets you run any type of T-SQL whether you're querying data, creating databases or changing data and it has so many features to help you build commands, interact with the result sets and control how the extension behaves. By the end of this course you'll experience every single feature I was able to discover so you don't have to miss out on any of its functionality, so crack open your Windows machine, your MacBook or your Linux box and follow along while I show you how to leverage my favorite Visual Studio Code extension MS SQL.