Extracting Insights from Data with Databricks SQL
Databricks SQL provides a unified interface to create and run SQL queries, and then visualize the results using a variety of built-in charts. This course explores how these can be combined with dashboards to extract useful insights from data.
What you'll learn
Most data analysts, and other big data professionals will often need to draw useful information from data which can then be used to make data-driven decisions that help their organization achieve their goals. In this course, Extracting Insights from Data with Databricks SQL, you'll learn how Databricks SQL can play a crucial role in this task, with a combination of SQL queries, visualizations and dashboards. First, you'll discover different kinds of SQL queries, from the use of simple WHERE clauses to nested queries. Next, you'll explore aggregations on data, and the different types of aggregate functions which can be used to combine records in a large dataset to generate a meaningful summary, such as aggregate sales in a certain region. Finally, you'll learn how finding patterns and identifying trends in data can be greatly simplified by visualizing data. At the end of this course, you'll have the skills necessary to make the best use of all the tools available in Databricks SQL to learn from your data, extract actionable insights, and help your organizations make the best decisions based on data.
Table of contents
- Course Prerequisites and Outline 2m
- An Overview of Databricks SQL 3m
- Querying Data in Databricks 3m
- Demo: Creating a Table from a CSV File 7m
- Demo: Running SQL Queries for Analysis 4m
- Demo: Filtering Results with Multiple Conditions 2m
- Demo: The IN and BETWEEN Clauses 3m
- Demo: Using Nested Queries 8m