Running Queries and Visualizing Data with Databricks SQL

Focused View

Kishan Iyer

1:23:15

106 View

1. Course Overview

1. Course Overview.mp4

02:01

02. Visualizing Data with Basic Charts

01. Course Prerequisites and Outline.mp4

01:55

02. An Overview of Databricks SQL.mp4

02:51

03. Queries and Visualizations in Databricks SQL.mp4

05:56

04. Demo - Creating a Table with Databricks SQL.mp4

05:02

05. Demo - Building a Line Chart.mp4

05:42

06. Demo - Adding Charts to Dashboards.mp4

03:41

07. Demo - Duplicating a Visualization.mp4

02:48

08. Demo - Plotting a Basic Pie Chart.mp4

04:00

09. Demo - Defining Pie Charts for Different Groups.mp4

02:01

10. Demo - Parametrized Queries and Visuals.mp4

07:17

3. Creating Dashboards Using Visualizations

1. Working with Dashboards.mp4

04:31

2. Demo - Configuring Bar Charts.mp4

04:39

3. Demo - Building a Dashboard from a Query.mp4

02:04

4. Demo - Defining a Choropleth Map.mp4

05:43

5. Demo - Building a Word Cloud.mp4

04:41

4. Running Basic Queries Using SQL

1. Querying Data in Databricks.mp4

01:58

2. Demo - Querying for Subsets of Data in a Table.mp4

05:58

3. Demo - Introducing a Query Parameter.mp4

02:54

4. Demo - Defining Join Queries.mp4

04:42

5. Demo - Visualizing Join Results.mp4

01:49

6. Course Summary and Related Content.mp4

01:02

Description

To get an understanding of data, you need to analyze it using a variety of different techniques. This course delves into the use of SQL queries, and especially visualizations and dashboards to identify patterns and trends in data.

What You'll Learn?

What makes Databricks SQL such a powerful tool for data analysts is that it allows data to be examined in many different ways from a single platform. In this course, Running Queries and Visualizing Data with Databricks SQL, you'll learn about SQL queries, visualizations, and dashboards to get an all-round understanding of data. First, you'll discover basic visualizations such as line charts and pie charts out of the results generated by a query execution, and cover how these can capture useful patterns hidden in the data. Next, you'll explore some of the specialized charts such as maps and word clouds which have limited use cases, but are still very powerful and keep end users engaged. Finally, you'll learn different types of SQL queries and how these tie in to visualizations and dashboards in Databricks SQL. Once you've completed this course, you'll have the practical knowledge and skills required to analyze big data in an effective and efficient manner, and make the best use of the features of Databricks SQL.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Database Programming

Microsoft SQL

Kishan Iyer

Instructor's Courses

I have a Masters in Computer Science from Columbia University and have worked previously as a developer and DevOps engineer. I now work at Loonycorn which is a studio for high-quality video content. My interests lie in the broad categories of Big Data, ML and Cloud.

Pluralsight

View courses Pluralsight

Pluralsight, LLC is an American privately held online education company that offers a variety of video training courses for software developers, IT administrators, and creative professionals through its website. Founded in 2004 by Aaron Skonnard, Keith Brown, Fritz Onion, and Bill Williams, the company has its headquarters in Farmington, Utah. As of July 2018, it uses more than 1,400 subject-matter experts as authors, and offers more than 7,000 courses in its catalog. Since first moving its courses online in 2007, the company has expanded, developing a full enterprise platform, and adding skills assessment modules.