Patreon:
https://www.patreon.com/kfsoft1) Cross join
2) Inner join
3) Outer join - left join / right join / full join
Join cheatsheet:
https://github.com/learn10kYear/learn-pandas/blob/master/sql2-join/sql_join_cheatsheet_kfsoft.pdf00:00 Introduction: SQL JOIN
00:40 3 types of join: cross join, inner join, outer join
03:26 Revision: 1-to-many relationship
04:28 Revision: WHERE join statement
05:45 SQL92 Join keyword
08:22 Goal1: cross + inner, Goal2: outer (left / right / full)
09:32 Cross join
11:06 Cross join - example
14:16 Cross join - Cartesian product - all possible combinations
18:00 Different ways to write cross join
21:08 Inner join
22:12 Inner join = Cross Join + condition(s)
24:33 Inner join - WHERE...
30:02 Inner join - INNER JOIN... ON...
34:32 Inner join - JOIN... USING(...)
36:55 Inner join - joining multiple tables
43:56 Outer join (left / right / full)
47:00 Left join
48:19 Left join - example
56:31 Right join - example
01:00:53 Rewrite RIGHT JOIN query with LEFT JOIN
01:01:45 Full join
01:02:29 Full join - example
01:06:51 Full join = left join UNION right join
01:09:42 Summary & conclusion
Python入門:第1課 - PyCharm + Data Types
https://youtu.be/s9toTBXQSPEPython入門:第2課 - Python containers (1): List, Tuple
https://youtu.be/7hm0zHgEGZ4Python入門:第3課 - Python containers (2): Dictionary & Set
https://youtu.be/7Jvfd6qFLzUPython入門:第4課 - If-Else, Looping, Try-except
https://youtu.be/sXdh5L5rcX0Python入門:第5課 - Function + File
https://youtu.be/rk8kU3no5NoPython入門:第6課 - Class and Object
https://youtu.be/HPb0Lg3FQfMPython入門:第7課 - URL, JSON, Sqlite
https://youtu.be/93lOZTxJtrsPython入門:第8課 - 用Flask進行Web開發
https://youtu.be/Z4CR3rwVkGcPython入門:第9課 - Flask + DB ORM
https://youtu.be/ZQoBdEH1zowPython入門:第10課 - Flask補充1
https://youtu.be/AC23QWvFNWIPython入門:第11課 - Flask補充2
https://youtu.be/-PkZ8sGhm-UPython入門:Project 2 - Password generator 密碼生成器
https://youtu.be/5miejVDO9_wPython入門:Apache 安裝Flask app - mod_wsgi
https://youtu.be/E6dqWawzc14Python入門:第12課 - GUI (Tkinter) + PyInstaller 打包EXE
https://youtu.be/_-LKQvmG8Uc1Python入門:第13課 - More loops - Iterable Vs Iterator
https://youtu.be/xKPK6CRnBT4Python入門:第14課 - More loops - Generator
https://youtu.be/sl3seUetRkADatabase初級:SQL入門
https://youtu.be/OtM74u3Fbw0Database初級:JOIN連接
https://youtu.be/tpDvgr7qHswDatabase初級:MongoDB入門
https://youtu.be/XTqW3oOt3PsPython初級:第15課 - Web Scraping 靜態網頁抓取
https://youtu.be/_LRfuctPLdsPython初級:第16課 - Web Scraping 動態網頁抓取
https://youtu.be/lXwgSweHf5QPython初級:第17課 - Pygame貪食蛇遊戲
https://youtu.be/kaDEcF5LTWUPython初級:第18課 - if __name__ == '__main__' 入口點
https://youtu.be/ihDNLQOQrSkPython初級:第19課 - Type hints 類型提示
https://youtu.be/Z_AF3K-BMBsPython初級:第20課 - Decorator 裝飾器
https://youtu.be/mAyJI-proksPython初級:第21課 - Multi-threading 多線程
https://youtu.be/mHp7bfDZOSUPython初級:第22課 - Multi-processing 多進程
https://youtu.be/yFdGhaxW_5oPython初級:第23課 - Asyncio 非同步I/O
https://youtu.be/cejki29TcOkPython初級:Django 入門 1 - Model + Admin Site
https://youtu.be/en6NXFI6CsQPython初級:Django 入門 2 - Template + View
https://youtu.be/en6NXFI6CsQPython初級:Django 入門 3 - 部署
https://youtu.be/GfMiJvbYk2kPython初級:openpyxl - 讀寫 MS Excel 文件
https://youtu.be/tjcJV2fur5gPython初級:python-docx - 讀寫 MS Word 文件
https://youtu.be/PEKWb5R3sSUPython入門 - 數據科學 - Jupyter Lab & Notebook 安裝+入門教程
https://youtu.be/niWD8kxgpH0Python入門 - 數據科學 - Anaconda + PyCharm 安裝
https://youtu.be/H4ihRvtdY7MPython初級 - 數據科學 - Numpy入門
https://youtu.be/t7ygnafk760Python初級 - 數據科學 - Pandas入門
https://youtu.be/ZYjhM7J9eFQPython初級 - 數據科學 - Pandas入門 (第二版 更新column部分)
https://youtu.be/w76oa7YzvkYPython初級 - 數據科學 - Pandas時間 + 圖表
https://youtu.be/jrd8shHEVFQPython初級 - 數據科學 - Pandas類別 + 樣式
https://youtu.be/4ntwbAWnKbgPython初級 - 機器學習 - Scikit-learn 入門
https://youtu.be/3m8Bb01uNNEPython初級 - 機器學習 - Scikit-learn - Regression 回歸
https://youtu.be/QyYZT8o-f3UPython初級 - 機器學習 - Scikit-learn - Classification 分類
https://youtu.be/JKn0OoHSoRoPython初級 - 機器學習 - Scikit-learn - Clustering 聚類+降維
https://youtu.be/UgXyK-k-CgMAbout the Site 🌐
This site provides links to random videos hosted at YouTube, with the emphasis on random. 🎥
Origins of the Idea 🌱
The original idea for this site stemmed from the need to benchmark the popularity of a video against the general population of YouTube videos. 🧠
Challenges Faced 🤔
Obtaining a large sample of videos was crucial for accurate ranking, but YouTube lacks a direct method to gather random video IDs.
Even searching for random strings on YouTube doesn't yield truly random results, complicating the process further. 🔍
Creating Truly Random Links 🛠️
The YouTube API offers additional functions enabling the discovery of more random videos. Through inventive techniques and a touch of space-time manipulation, we've achieved a process yielding nearly 100% random links to YouTube videos.
About YouTube 📺
YouTube, an American video-sharing website based in San Bruno, California, offers a diverse range of user-generated and corporate media content. 🌟
Content and Users 🎵
Users can upload, view, rate, share, and comment on videos, with content spanning video clips, music videos, live streams, and more.
While most content is uploaded by individuals, media corporations like CBS and the BBC also contribute. Unregistered users can watch videos, while registered users enjoy additional privileges such as uploading unlimited videos and adding comments.
Monetization and Impact 🤑
YouTube and creators earn revenue through Google AdSense, with most videos free to view. Premium channels and subscription services like YouTube Music and YouTube Premium offer ad-free streaming.
As of February 2017, over 400 hours of content were uploaded to YouTube every minute, with the site ranking as the second-most popular globally. By May 2019, this figure exceeded 500 hours per minute. 📈
List of ours generators⚡
Random YouTube Videos Generator
Random Film and Animation Video Generator
Random Autos and Vehicles Video Generator
Random Music Video Generator
Random Pets and Animals Video Generator
Random Sports Video Generator
Random Travel and Events Video Generator
Random Gaming Video Generator
Random People and Blogs Video Generator
Random Comedy Video Generator
Random Entertainment Video Generator
Random News and Politics Video Generator
Random Howto and Style Video Generator
Random Education Video Generator
Random Science and Technology Video Generator
Random Nonprofits and Activism Video Generator