TRY LATITUDE FOR FREE 👉 [ Ссылка ]
GET YOUR DATA JOB ➡ [ Ссылка ]
ULTIMATE DATA PORTFOLIO: Everything you need to get your data job ➡ [ Ссылка ]
AI JOB QUEST: Change the way you apply to jobs ➡ [ Ссылка ]
PATREON ➡ [ Ссылка ]
1:1 MENTORSHIP: I put my heart and soul into this program. I'm here to help you succeed ➡ [ Ссылка ]
CourseCareers: Start the FREE Data Analytics Introduction Course Now ➡ [ Ссылка ]
Portfolio Projects Playlist: End-to-end, FREE guided portfolio projects covering Excel, SQL, Tableau, Power BI and Python ➡ [ Ссылка ]
┋Community & Socials┋
[ Ссылка ] ⬅ Join our Discord Data Community
[ Ссылка ] ⬅ My IG is personal -- only follow if you're interested in non-data stuff as well
[ Ссылка ] ⬅ Daily tips & advice on how to enhance your data analysis skills
[ Ссылка ] ⬅ Figuring out what I want to do in this space...
┋Professional Certificates┋
CourseCareers ➡ [ Ссылка ]
DataCamp Courses & Certifications ➡ [ Ссылка ]
Google Data Analytics Professional Certificate ➡ [ Ссылка ]
Google Advanced Data Analytics Professional Certificate ➡ [ Ссылка ]
Tableau Business Intelligence Professional Certificate ➡ [ Ссылка ]
Microsoft Power BI Data Analyst Professional Certificate ➡ [ Ссылка ]
IBM Data Science Professional Certificate ➡ [ Ссылка ]
Google Project Management Professional Certificate ➡ [ Ссылка ]
┋Timestamps┋
00:00 Intro
01:50 Import csv files
03:06 CREATE TABLE
04:18 psql command line tool
08:02 OVER
11:12 PARTITION BY
14:56 ROW_NUMBER
18:00 RANK and DENSE_RANK
20:38 LAG and LEAD
24:20 Bonus
25:23 Outro
┋The project┋
Github repo for code ➡ [ Ссылка ]
New York City Airbnb Open Data ➡ [ Ссылка ]
Thanks so much for taking a little time out of your day to watch this!
