Azure Data Studio for beginners
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
- 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.
Who this course is for:
- Beginners to Azure Data Studio
Bluelime is UK based and creates quality easy to understand eLearning solutions .All our courses are 100% video based. We teach hands –on- examples that teach real life skills .
Bluelime has engaged in various types of projects for fortune 500 companies and understands what is required to prepare students with the relevant skills they need.