Connect and interact with databases using Azure Data Studio
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.
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.
Course Content
- Azure Data Studio | SQL Server Setup –> 6 lectures • 21min.
- Azure SQL Database Setup –> 6 lectures • 21min.
- Connect Azure Data Studio to SQL Server Database –> 5 lectures • 12min.
- Connect Azure Data Studio to Azure SQL Database –> 4 lectures • 20min.
Requirements
- Basic understanding of database concepts.
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.