Tutorialspoint

A Complete Introduction to Azure Data Studio

An Applied Introduction to Azure Data Studio, a Light-Weight Cross-Platform Database Development Tool

  Mike West

   Development, Databases, SQL Server

  Language - English

   Published on 11/2020

0

Description

Hello and welcome to A Complete Introduction to Azure Data Studio.

SQL Server Management Studio is the most common Graphical User Interface tool that we used to use for administrating our SQL Server instances that are located in our data center or hosted in the cloud. SSMS can be used also for developing our database projects, includes creating or modifying the database objects and viewing then modifying the data that is stored in these databases.

If you're a SQL Server DBA or developer, you might ask... why do I need this tool when I have SSMS?  Let's list a few reasons.

  • You are a Linux or MAC person

  • You need to connect and work within 2019 Big Data Clusters

  • You need something more lightweight than SSMS

  • More easily work with JSON, XML, or Excel files

  • Integrated terminal. You can run command line tools such as Bash, PowerShell... etc.

  • You're a developer

With Azure Data Studio, you can easily to develop your database components and view/modify the data in the database tables. It allows you to run T-SQL queries, review, edit, and export the result to different useful formats, such as CSV, Excel, XML, and JSON, that can be processed by your applications or to be imported by another database engine.

Thanks for your interest in A Complete Introduction to Azure Data Studio.  Let's get started!!!

Who this course is for:

  • If you're a SQL Server DBA at any level... this course is for you
  • If you're a Transact-SQL developer... this course is for you
  • If you have a basic understanding of SQL Server... this course is for you

What Will I Get ?

  • You'll learn what Azure Data Studio is and how to install it on a Windows platform
  • You'll learn how to use Azure Data Studio to author code against on-premise and Azure database servers
  • You'll learn how to use the Activity Bar to get the most out of Azure Data Studio
  • You'll learn everything you need to know to get up and running with Azure Data Studio in a production setting

Requirements

  • You should be familiar with the basics of SQL Server
  • You should be familiar with the basics of relational databases
0
Course Rating
0%
0%
0%
0%
0%

    Feedbacks (0)

  • No Feedbacks Yet..!

We make use of cookies to improve our user experience. By using this website, you agree with our Cookies Policy.