Data Literacy : Essentials of Azure Data Studio from Pluralsight

Azure Data Studio is a lightweight, open source, cross-platform client tool that enables you to connect to a database and work with the data. This course will teach you how to use Azure Data Studio to get the data you want.

Getting data and working with data from an ever increasing number of data sources have become paramount for the developer. In this course, Data Literacy: Essentials of Azure Data Studio, you’ll learn how to connect to different databases, both on-premises and in the cloud, then run your SQL queries from a lightweight, cross-platform and open source client tool called Azure Data Studio. First, you’ll explore what Azure Data Studio is, what capabilities it has, what you can use it for, and how it compares to SQL Server Management Studio. Next, you’ll discover how to download and install this tool to start working with your data. Finally, you’ll learn what the differences between Data Manipulation Language and Data Definition Language SQL statements are, how to run your SQL queries, how to manage database connections to SQL Server, Azure SQL Database or PostgreSQL, and what notebooks are. When you’re finished with this course, you’ll have the skills and knowledge of using Azure Data Studio to query and work with your data from different data sources.

What's inside

Syllabus

Course Overview

Understanding Azure Data Studio

Querying Data with Azure Data Studio

Good to know

Know what's good

, what to watch for

, and possible dealbreakers

Teaches how to connect to databases and run SQL queries, which are core skills for working with data

Taught by Viktor Suha, an instructor who is recognized for expertise in data-centric topics

Suitable for beginners who are interested in learning the basics of working with data using Azure Data Studio

Emphasizes the use of a lightweight, open source tool that is widely used in industry

Covers both on-premises and cloud-based databases, making it relevant for a variety of work environments

Career center

Learners who complete Data Literacy : Essentials of Azure Data Studio will develop knowledge and skills that may be useful to these careers:

Database Administrator

Database Administrators set up, configure, and maintain databases, often in cloud environments. With training in Azure Data Studio, one would be able to work with data from a variety of data sources. This course may be particularly useful for a Database Administrator who needs to connect to disparate databases from a single tool.

See salaries and explore the career path for Database Administrator

Data Analyst

Data Analysts discover actionable insights from large datasets to help businesses make better decisions. While not required, training in Azure Data Studio may help a Data Analyst pull data from both on-premises and cloud data sources, and write SQL queries to manipulate and analyze the data in order to quickly derive the insights that drive business decisions.

See salaries and explore the career path for Data Analyst

Business Analyst

Business Analysts identify business needs and develop solutions through data analysis and modeling. Training in Azure Data Studio may be useful for a Business Analyst who needs to work with data from a variety of sources to derive insights for stakeholders across an organization.

See salaries and explore the career path for Business Analyst

Data Engineer

Data Engineers design, build, and maintain data pipelines to ensure data quality and availability. While not required, knowledge of Azure Data Studio may be helpful for a Data Engineer tasked with pulling data from a variety of on-premises and cloud-based data sources.

See salaries and explore the career path for Data Engineer

Data Scientist

Data Scientists build and apply predictive models to large datasets to uncover patterns and trends. While not required, training in Azure Data Studio may be helpful for a Data Scientist who wishes to work with data from both on-premises and cloud data sources to build models.

See salaries and explore the career path for Data Scientist

Software Engineer

Software Engineers design, build, and maintain software applications. While not required, training in Azure Data Studio may be useful for a Software Engineer tasked with working with or building features such as data dashboards or reporting functions.

See salaries and explore the career path for Software Engineer

Systems Engineer

Systems Engineers work with customers to design and implement technological solutions. Knowledge of Azure Data Studio may be helpful for Systems Engineers tasked with working with customers who need to connect to data sources and run SQL queries from a single tool.

See salaries and explore the career path for Systems Engineer

Information Security Analyst

Information Security Analysts protect an organization's data and computer systems from cyber threats. Training in Azure Data Studio may be useful for an Information Security Analyst tasked with maintaining database security.

See salaries and explore the career path for Information Security Analyst

Database Developer

Database Developers design and create databases to meet an organization's needs. Training in Azure Data Studio may be helpful for a Database Developer who needs to connect to both on-premises and cloud-based databases to design and implement database solutions.

See salaries and explore the career path for Database Developer

Data Architect

Data Architects design and manage an organization's data architecture. Training in Azure Data Studio may be helpful for a Data Architect who needs to manage data across a variety of data sources.

See salaries and explore the career path for Data Architect

Project Manager

Project Managers plan and execute projects to achieve specific goals. Training in Azure Data Studio may be helpful for a Project Manager who needs to work with data from a variety of sources to track project progress and make decisions.

See salaries and explore the career path for Project Manager

Data Governance Analyst

Data Governance Analysts ensure that an organization's data is used in a consistent and ethical manner. Training in Azure Data Studio may be helpful for a Data Governance Analyst who needs to track and manage data from a variety of sources to ensure compliance with internal and external regulations.

See salaries and explore the career path for Data Governance Analyst

IT Auditor

IT Auditors evaluate and report on the effectiveness of an organization's IT systems and processes. Training in Azure Data Studio may be helpful for an IT Auditor who needs to review and assess database security and compliance.

See salaries and explore the career path for IT Auditor

Technical Writer

Technical Writers create documentation and other materials to help users understand and use software and technology products. While not required, training in Azure Data Studio may be helpful for a Technical Writer who needs to document how to use the tool to connect to databases and run SQL queries.

See salaries and explore the career path for Technical Writer

Quality Assurance Analyst

Quality Assurance Analysts test software products to ensure that they meet quality standards. While not required, training in Azure Data Studio may be helpful for a Quality Assurance Analyst who needs to test software that interacts with databases.

See salaries and explore the career path for Quality Assurance Analyst