Overview
Learn essential SQL skills for data scientists in this 22-minute video tutorial. Explore key concepts including SELECT statements, dataset processing, JOIN operations, WHERE clauses, aggregations, CASE WHEN statements, Common Table Expressions (CTEs), and window functions. Apply these skills to real-world scenarios such as time series forecasting and fraud prediction. Gain practical knowledge to enhance your data science toolkit and perform day-to-day tasks efficiently.
Syllabus
Introduction
SELECT
Process Dataset
JOIN
WHERE
Aggregations
CASE WHEN Statements
Common Table Expressions CTEs
Window Functions
Application 1: Time Series Forecasting
Application 2: Fraud Prediction
Conclusion & Announcement!
Taught by
CodeEmporium