Learn how to apply operations like add, subtract, divide, multiply, and a lot more in Google Spreadsheets with the help of an actual dataset.
Learn how to store the results of a query with the help of materialized views in PostgreSQL.
In this tutorial, you'll learn how to create visualizations to display data and gain more meaningful insights with spreadsheets.
In this tutorial, you'll learn techniques on how to clean messy data in SQL, a must-have skill for any data scientist.
Learn how to use aggregate functions for summarizing results and gaining useful insights about data in SQL.
Learn how to organize rows and columns, add values, find the sum of revenue, and finally apply filtering to select a subset of data from a given dataset.
In this video tutorial, you'll break down real-world questions to construct complex queries using CASE statements, subqueries, and common table expressions.