Extracting Insights from Data with Databricks SQL

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