A Complete Introduction to Azure Data Studio
An Applied Introduction to Azure Data Studio, a Light-Weight Cross-Platform Database Development Tool
Lectures -30
Resources -1
Duration -1 hours
30-days Money-Back Guarantee
Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.
Course 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
Goals
- 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
Prerequisites
- You should be familiar with the basics of SQL Server
- You should be familiar with the basics of relational databases
![A Complete Introduction to Azure Data Studio A Complete Introduction to Azure Data Studio](https://d3mxt5v3yxgcsr.cloudfront.net/courses/3896/course_3896_image.jpg)
Curriculum
Check out the detailed breakdown of what’s inside the course
Introduction
6 Lectures
-
Introduction 01:12 01:12
-
Is this Course Right for You? 00:39 00:39
-
What is Azure Data Studio? 02:38 02:38
-
Installing Azure Data Studio (Windows Version) 02:35 02:35
-
Install SQL Server 2019 and SSMS 05:08 05:08
-
Attach AdventureWorks Database 06:05 06:05
Navigation
10 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Transact-SQL Editor
5 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
More Sidebars
3 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Customize Your Workspace
5 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Instructor Details
![Mike West](https://www.tutorialspoint.com/assets/profiles/265722/profile/200_176203-1603432665.jpg)
Mike West
I'm the founder of LogikBot. I've worked at Microsoft and Uber. I helped design courses for Microsoft's Data Science Certifications. If you're interested in machine learning, I can help.
I've worked with databases for over two decades. I've worked for or consulted with over 50 different companies as a full time employee or consultant. Fortune 500 as well as several small to mid-size companies. Some include: Georgia Pacific, SunTrust, Reed Construction Data, Building Systems Design, NetCertainty, The Home Shopping Network, SwingVote, Atlanta Gas and Light and Northrup Grumman.
Over the last five years I've transitioned to the exciting world of applied machine learning. I'm excited to show you what I've learned and help you move into one of the single most important fields in this space.
Experience, education and passion
I learn something almost every day. I work with insanely smart people. I'm a voracious learner of all things SQL Server and I'm passionate about sharing what I've learned. My area of concentration is performance tuning. SQL Server is like an exotic sports car, it will run just fine in anyone's hands but put it in the hands of skilled tuner and it will perform like a race car.
Certifications
Certifications are like college degrees, they are a great starting points to begin learning. I'm a Microsoft Certified Database Administrator (MCDBA), Microsoft Certified System Engineer (MCSE) and Microsoft Certified Trainer (MCT).
Personal
Born in Ohio, raised and educated in Pennsylvania, I currently reside in Atlanta with my wife and two children.
Course Certificate
Use your certificate to make a career change or to advance in your current career.
![sample Tutorialspoint certificate](/market/public/assets/newDesign/img/primePacks/V-certificate.png)
Our students work
with the Best
![adobe logo](/market/public/assets/newDesign/img/adobe.png)
![adp logo](/market/public/assets/newDesign/img/adp.png)
![apple logo](/market/public/assets/newDesign/img/apple.png)
![armani logo](/market/public/assets/newDesign/img/armani.jpg)
![bosch logo](/market/public/assets/newDesign/img/bosch.png)
![capegemini logo](/market/public/assets/newDesign/img/capegemini.png)
![cisco logo](/market/public/assets/newDesign/img/cisco.png)
![hdfc bank logo](/market/public/assets/newDesign/img/hdfcbank.png)
![ibm logo](/market/public/assets/newDesign/img/ibm.png)
![intel logo](/market/public/assets/newDesign/img/intel.png)
![mastercard logo](/market/public/assets/newDesign/img/mastercard.png)
![netflix logo](/market/public/assets/newDesign/img/netflix.png)
![qualcomm logo](/market/public/assets/newDesign/img/qualcomm.png)
![samsung logo](/market/public/assets/newDesign/img/samsung.png)
![sony logo](/market/public/assets/newDesign/img/sony.png)
![unilever logo](/market/public/assets/newDesign/img/unilever.png)
![walmart logo](/market/public/assets/newDesign/img/walmart.png)
![adobe logo](/market/public/assets/newDesign/img/adobe.png)
![adp logo](/market/public/assets/newDesign/img/adp.png)
![apple logo](/market/public/assets/newDesign/img/apple.png)
![armani logo](/market/public/assets/newDesign/img/armani.jpg)
![bosch logo](/market/public/assets/newDesign/img/bosch.png)
![capegemini logo](/market/public/assets/newDesign/img/capegemini.png)
![cisco logo](/market/public/assets/newDesign/img/cisco.png)
![hdfcbank logo](/market/public/assets/newDesign/img/hdfcbank.png)
![ibm logo](/market/public/assets/newDesign/img/ibm.png)
![intel logo](/market/public/assets/newDesign/img/intel.png)
![mastercard logo](/market/public/assets/newDesign/img/mastercard.png)
![netflix logo](/market/public/assets/newDesign/img/netflix.png)
![qualcomm logo](/market/public/assets/newDesign/img/qualcomm.png)
![samsung logo](/market/public/assets/newDesign/img/samsung.png)
![sony logo](/market/public/assets/newDesign/img/sony.png)
![unilever logo](/market/public/assets/newDesign/img/unilever.png)
![walmart logo](/market/public/assets/newDesign/img/walmart.png)
Related Video Courses
View MoreAnnual Membership
Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses
Subscribe now![Annual Membership Annual Membership](/market/public/assets/newDesign/img/membership-large-small.jpg)
Online Certifications
Master prominent technologies at full length and become a valued certified professional.
Explore Now![Online Certifications Online Certifications](/market/public/assets/newDesign/img/traning-for-a-team.png)