Dual Learn | SQL & Python Part #1 | Fundamental Actions

Опубликовано: 28 Сентябрь 2024
на канале: Absent Data

4,699

154

Learning these two languages is complementary. It will help you quickly add multiple data analysis and data science skills to your toolkit in the most efficient way possible.

You can find the dataset here:
https://www.kaggle.com/neuromusic/avo...

A great way to practice for any FANG practical or other Python/SQL interviews is to answer interview questions. Don't hesitate to dive into the mini-case studies and questions and create your own answers. Learn by doing!
______________________________________________________________________
Check out StrataScratch( Affiliate ): https://stratascratch.com/?via=absent...
______________________________________________________________________

You will learn in SQL :
Selecting data 3:08
Filtering (WHERE ) 4:32
Grouping 5:46
Creating conditional columns (CASE) 9:10
Common Table Expression( Temp Table) 10:26
Top Results 14:10
Unpivot 17:13
Merging 20:30
Subquery 24:02

28:28 Python version starts.

#python
#sql
#dataanalysis