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.
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
- Introduction 0m
- Module and Course Overview 1m
- Introducing Visual Studio Code and the mssql Extension 4m
- Installing Visual Studio Code on Windows 2m
- Installing Visual Studio Code on macOS 1m
- Introducing Visual Studio Code’s Coding Super Powers 3m
- Installing the mssql Extension in VS Code 3m
- Review 1m
- Resources 1m
- Introduction 0m
- Overview 2m
- SQL Server LocalDB: The Simplest SQL Server 4m
- Setting up an Azure SQL Database in the Cloud 5m
- Verifying the New Azure SQL Database 1m
- Setting up the Last Details of Your Azure SQL Database 1m
- Using a Docker Container to Host SQL Server for Linux on Any O/S 3m
- Installing Docker and Getting the SQL Server Container Running 6m
- Verifying the Containerized Database 4m
- Understanding Persistence and Lack of Persistence in Containers 3m
- Pulling a Custom Image with the Sample Database in Place 3m
- Summary 1m
- Resources 1m
- Introduction 0m
- Overview 1m
- mssql's Commands and Execution Engine 4m
- Connecting to LocalDB While Learning More About mssql Connections 3m
- Connecting to Azure SQL from Windows and macOS 4m
- Demonstrating How mssql Securely Stores Your Passwords 1m
- Using ADO.NET Connection Strings to Connect 2m
- Connecting to the Database in the Docker Container 2m
- Connection Keyboard and Status Bar Shortcuts 4m
- Creating a Keyboard Shortcut to Start up mssql and Connect 3m
- Summary 1m
- Resources 0m
- Introduction 0m
- Overview 1m
- Attaching an Existing Database File 2m
- Interacting with the Results of Your First Query 2m
- The Intelligent Editor Window 3m
- Using Snippets to Speed up Command Building 3m
- Exploring Multiple Result Sets Further 2m
- Using Snippets to See Database Metadata 2m
- Creating Databases, Tables, and Data 6m
- Summary 2m
- Resources 0m
- Introduction 0m
- Overview 1m
- Exporting Results to CSV, JSON, or Excel 3m
- Localization of mssql's Messages 4m
- Controlling Behavior Through VS Code's Settings 4m
- Formatting Code in the Editor Window 5m
- Results Window Tricks, Shortcuts, and Settings 8m
- Checking out the Last Few Settings 2m
- Creating Your Own SQL Snippets in VS Code 5m
- Looking Ahead to Integrated Authentication on Mac and Linux 6m
- Summary 2m
- Resources 1m
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