Azure data studio tutorial install#

In DDL (Data Definition Language) SQL is very simple in PostgreSQL. In this section, we will refresh some basic SQL knowledge and some queries and their purposes. I use the notebook window from the Azure Data Studio (ADS) and execute the following SQL which created the database as intended.īasic SQL Queries (Create, Alter, Select and Drop Basics) Ok, let's start something simple and create a database. The following screenshot shows that I am connected to Postgres server. You can also use pgAdmin or any other tool as u wish. I have installed the PostgreSQL database on my machine and I also have installed Azure Data Studio which I will use to execute various queries for the database. If you haven’t used ADS before, give it a try and you will like it.

You can execute queries via a query window or via a notebook window. You can learn more about it from the official website on this link.ĪDS also has notebooks that are similar to Jupiter notebooks for python and other languages and are great for combining formatted text with code. It’s engineered with the data platform user in mind, with the built-in charting of query result sets and customizable dashboards.

Azure data studio tutorial install#

It is very easy to install and offers a modern editor experience with IntelliSense, code snippets, source control integration, and an integrated terminal. I have already written a few posts about PostgreSQL and this time I would like to take a step back and discuss some of the basics and at the same time share with you my experience of using Azure Data Studio.Īzure Data Studio is a cross-platform database tool for data professionals using the Microsoft family of on-premises and cloud data platforms on Windows, macOS, and Linux.