Getting Started with Databricks SQL

Focused View

Kishan Iyer

1:04:15

11 View

01. Course Overview

01. Course Overview.mp4

01:49

02. Introducing Databricks SQL

02. Course Prerequisites and Outline.mp4

01:36

03. An Overview of Databricks.mp4

03:36

04. Data Warehouses Data Lakes and Lakehouses.mp4

08:39

05. Delta Lakes.mp4

03:54

06. An Overview of Databricks SQL.mp4

03:30

07. Use Cases of Databricks SQL.mp4

04:15

03. Understanding Databricks SQL Architecture and Concepts

08. Components in Databricks SQL.mp4

06:11

09. Administering Databricks SQL.mp4

05:02

04. Running Queries in Databricks SQL

10. Defining and Executing Queries.mp4

01:57

11. Demo.Creating a Databricks Workspace.mp4

04:43

12. Demo.Configuring a SQL Endpoint.mp4

02:54

13. Demo.Loading Data into the Databricks File System.mp4

04:22

14. Demo.Creating an External Table.mp4

03:55

15. Demo.Querying and Visualizing Data.mp4

06:44

16. Course Summary and Related Content.mp4

01:08

Description

This course introduces you to the concepts, architecture, and features of Databricks SQL. These make it possible to analyze and extract insights from data using a combination of queries, visualizations, and dashboards - all from a single platform.

What You'll Learn?

Most data analysts use a variety of tools in order to gain an all-round understanding of their business data. In this course, Getting Started with Databricks SQL, you will learn various concepts, components, and features of Databricks SQL which allow all of this to be accomplished from a single platform. First, you will discover some of the core concepts around the storing of data in Databricks, including data lakes and lakehouses, and how Databricks SQL makes it easy to access and analyze this data. Then, you will explore into the various components of Databricks SQL, such as SQL endpoints, queries, visualizations, and dashboards, and how all of these come together to enable analysts to look at their data from many points of view and gain a big-picture view of it. Finally, you will learn how to create a table using Databricks SQL, which you will then analyze using a query and a visualization. Once you finish this course, you will recognize the true power of Databricks SQL when it comes to analyzing and gaining insights from big data.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Database Programming

Microsoft SQL

Microsoft Azure

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.