Cross-platform SQL Server Management for Developers Using VS Code

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.
Course info
Rating
(22)
Level
Intermediate
Updated
Sep 11, 2017
Duration
2h 22m
Table of contents
Course Overview
Introducing and Installing VS Code and the mssql Extension
Preparing SQL Server for Any Platform, Locally and in the Cloud
Connecting to the Various SQL Servers from Various Platforms
Learning the mssql Basics to Connect, Query, and Create
Leveraging Advanced Tips and Tricks
Description
Course info
Rating
(22)
Level
Intermediate
Updated
Sep 11, 2017
Duration
2h 22m
Description

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.

About the author
About the author

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.

More from the author
Entity Framework Core: Getting Started
Beginner
3h 42m
Jan 11, 2020
Getting Started with Entity Framework 6
Beginner
2h 38m
Sep 16, 2019
Entity Framework Core 2.1: What's New Playbook
Intermediate
3h 23m
Oct 9, 2018
More courses by Julie Lerman
Section Introduction Transcripts
Section Introduction Transcripts

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.