Updated 2/2022 | Size: 404 MB
Connect and interact with databases using Azure Data Studio
What you'll learn
Install Azure Data Studio
Connect Azure Data Studio to Azure SQL
Connect Azure Data Studio to SQL Server
Create database and table with Azure data studio on an Azure SQL Database
Query Azure SQL Database with Azure data studio
Create database and table with Azure data studio on an SQL Server Database
Query SQL Server Database with Azure data studio
Requirements
Basic understanding of database concepts
Description
Azure Data Studio is a cross-platform database tool for data professionals who use on-premises and cloud data platforms on Windows, macOS, and Linux.
Azure Data Studio offers a modern editor experience with IntelliSense, code snippets, source control integration, and an integrated terminal. It's engineered with the data platform user in mind, with the built-in charting of query result sets and customizable dashboards. You can use Azure Data Studio to query, design, and manage your databases and data warehouses wherever they are, on your local computer or in the cloud.
Azure Data Studio offers a modern, keyboard-focused SQL coding experience that makes your everyday tasks easier with built-in features, such as multiple tab windows, a rich SQL editor, IntelliSense, keyword completion, code snippets, code navigation, and source control integration (Git). Run on-demand SQL queries, view and save results as text, JSON, or Excel. Edit data, organize your favourite database connections, and browse database objects in a familiar object browsing experience.
SQL code snippets generate the proper SQL syntax to create databases, tables, views, stored procedures, users, logins, roles, and to update existing database objects. Use smart snippets to quickly create copies of your database for development or testing purposes, and to generate and execute CREATE and INSERT scripts.
Azure Data Studio also provides functionality to create custom SQL code snippets.
Who this course is for
Beginners to Azure Data Studio