Explore advanced SQL techniques tailored for data scientists in this 25-minute video tutorial by Databricks. Begin with a quick SQL refresher before diving into five crucial areas for working with relational databases: basic statistical operations, data preparation techniques, advanced filtering and aggregation methods, window functions, and strategies for preparing data for analytics tools. Learn through practical demonstrations how to leverage SQL effectively in data science workflows, enhancing your ability to manipulate and analyze complex datasets.
Overview
Syllabus
Introduction
Overview
What is SQL
Data Preparation
Data Restructuring
Demo
Taught by
Databricks