How to Get Started with Azure Data Studio

Originally published at https://adamtheautomator.com by Nicholas Xuan Nguyen on September 7, 2022.

If you’ve been used to managing databases via the command-line interface, that’s good enough. But admit it, that method requires a lot of typing, and remembering all the different commands can be challenging. Luckily, with Azure Data Studio, you can manage your databases in a GUI.

Azure Data Studio is one of the most popular solutions for data professionals working with local and cloud platforms on Windows, macOS, and Linux. And in this tutorial, you’ll learn how to install Azure Data Studio and create a connection to your database.

Read on and get started with the basic tasks in Azure Data Studio’s database management!

Prerequisites

This tutorial will be a hands-on demonstration. If you’d like to follow along, be sure you have the following.

• A Windows 10 computer.
• A Linux computer — This tutorial uses Ubuntu 20.04, but other Linux distributions will work.

Related:How to Install Ubuntu 20.04 [Step-by-Step]

• MySQL installed on your Windows and Ubuntu computers — This tutorial assumes you have a database to manage with Azure Data Studio.

Related:How to Install MySQL on Ubuntu

• SSH access to your Linux system.

Related:A Windows Guy in a Linux World: Setting up SSH Command

• A non-root account with sudo privileges — This tutorial uses a root account for simplicity. But using a non-root user with sudo access is always recommended.

Downloading and Installing Azure Data Studio on Windows

Azure Data Studio is a cross-platform database tool. This tool lets you manage SQL Server, Azure SQL Database, and Azure SQL Data Warehouse on Windows, macOS, and Linux.

Azure Data Studio provides you with several features, including all SSMS (SQL Server Management Studio) features you’re familiar with. In addition, a modern user interface, IntelliSense code-completion aid, built-in source control, integrated collaboration tools, etc.