YoVDO

SQL You Need as a Data Scientist

Offered By: CodeEmporium via YouTube

Tags

SQL Courses Data Science Courses Relational Databases Courses

Course Description

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

Related Courses

Data Analysis
Johns Hopkins University via Coursera
Computing for Data Analysis
Johns Hopkins University via Coursera
Scientific Computing
University of Washington via Coursera
Introduction to Data Science
University of Washington via Coursera
Web Intelligence and Big Data
Indian Institute of Technology Delhi via Coursera