Скачать с ютуб WINDOW FUNCTIONS | Advanced SQL в хорошем качестве

WINDOW FUNCTIONS | Advanced SQL

TRY LATITUDE FOR FREE 👉 https://bit.ly/3o9iGlX https://mochen.info/ ⬅ Exclusive Community┋Ultimate Data Portfolio┋Ultimate Data Roadmap┋Ultimate Excel Projects┋Data Analysis Bundle   / mo-chen1   ⬅ Daily tips & advice on how to enhance your data analysis skills   / mo_chen   ⬅ Support me on Patreon    • Data Analysis Portfolio Projects   ⬅ Portfolio Projects Playlist: End-to-end, FREE guided portfolio projects covering Excel, SQL, Tableau, Power BI and Python ┋Professional Certificates┋ DataCamp Certifications ➡ https://datacamp.pxf.io/c/4216860/205... Google Data Analytics Professional Certificate ➡ https://www.coursera.org/google-certi... Google Advanced Data Analytics Professional Certificate ➡ https://www.coursera.org/google-certi... Tableau Business Intelligence Professional Certificate ➡ https://imp.i384100.net/TableauBIAnalyst Microsoft Power BI Data Analyst Professional Certificate ➡ https://www.coursera.org/professional... IBM Data Science Professional Certificate ➡ https://imp.i384100.net/IBMdataScience Google Project Management Professional Certificate ➡ https://imp.i384100.net/GoogleProject... ┋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 ➡ https://github.com/mochen862/window-f... New York City Airbnb Open Data ➡ https://www.kaggle.com/datasets/dgomo... Thanks so much for taking a little time out of your day to watch this!