vTomb Logo

Database 初級:2.5小時 SQL入門|教學|廣東話 Video

Patreon: https://www.patreon.com/kfsoft

1) Relational database concept
2) SQL Statements

SQL statements & SQLite db file:

00:00 Introduction: SQL
00:59 Part 1: Theory - Table
03:12 What can SQL do?
04:11 DBMS - database management system
06:14 Relational DB model
07:54 What is SQL query?
12:58 Structure of relational DB
13:59 Primary key
15:40 Table relationships
17:10 A. 1-to-1 relationship
19:25 B. 1-to-many relationship
21:57 C. many-to-many relationship
25:00 SELECT command intro
32:03 Part 2: Demo
32:18 Tool: Database Navigator (PyCharm plugin) & SQLiteStudio
37:50 CURD operations
39:23 Read / Query - connect to SQLite DB
41:28 Comment line
43:06 1) SELECT command - SELECT values & call function
01:05:01 SELECT aggregate() FROM … GROUP BY …
01:11:28 Join tables - SELECT … FROM … WHERE …
01:24:40 Sub-query
01:28:59 2) CREATE TABLE command
01:30:20 Create table by SQL (person & department)
01:37:04 Foreign key integrity - ON DELETE …
01:49:21 3) INSERT INTO command
01:53:26 Cascade delete record test
01:56:33 Create table by tool (room)
02:05:07 Column affinity (SQLite only)
02:07:59 SQLite storage
02:13:37 Datetime function (SQLite)
02:19:42 Parse timestamp with Python
02:20:48 4) UPDATE command
02:27:14 Multiple update statement - transaction (all or nothing)
02:32:21 5) DELETE & DROP TABLE command
02:35:51 Summary & conclusion

Python入門:第1課 - PyCharm + Data Types https://youtu.be/s9toTBXQSPE
Python入門:第2課 - Python containers (1): List, Tuple https://youtu.be/7hm0zHgEGZ4
Python入門:第3課 - Python containers (2): Dictionary & Set https://youtu.be/7Jvfd6qFLzU
Python入門:第4課 - If-Else, Looping, Try-except https://youtu.be/sXdh5L5rcX0
Python入門:第5課 - Function + File https://youtu.be/rk8kU3no5No
Python入門:第6課 - Class and Object https://youtu.be/HPb0Lg3FQfM
Python入門:第7課 - URL, JSON, Sqlite https://youtu.be/93lOZTxJtrs
Python入門:第8課 - 用Flask進行Web開發 https://youtu.be/Z4CR3rwVkGc
Python入門:第9課 - Flask + DB ORM https://youtu.be/ZQoBdEH1zow
Python入門:第10課 - Flask補充1 https://youtu.be/AC23QWvFNWI
Python入門:第11課 - Flask補充2 https://youtu.be/-PkZ8sGhm-U
Python入門:Project 2 - Password generator 密碼生成器 https://youtu.be/5miejVDO9_w
Python入門:Apache 安裝Flask app - mod_wsgi https://youtu.be/E6dqWawzc14
Python入門:第12課 - GUI (Tkinter) + PyInstaller 打包EXE https://youtu.be/_-LKQvmG8Uc1
Python入門:第13課 - More loops - Iterable Vs Iterator https://youtu.be/xKPK6CRnBT4
Python入門:第14課 - More loops - Generator https://youtu.be/sl3seUetRkA

Database初級:SQL入門 https://youtu.be/OtM74u3Fbw0
Database初級:JOIN連接 https://youtu.be/tpDvgr7qHsw
Database初級:MongoDB入門 https://youtu.be/XTqW3oOt3Ps

Python初級:第15課 - Web Scraping 靜態網頁抓取 https://youtu.be/_LRfuctPLds
Python初級:第16課 - Web Scraping 動態網頁抓取 https://youtu.be/lXwgSweHf5Q
Python初級:第17課 - Pygame貪食蛇遊戲 https://youtu.be/kaDEcF5LTWU
Python初級:第18課 - if __name__ == '__main__' 入口點 https://youtu.be/ihDNLQOQrSk
Python初級:第19課 - Type hints 類型提示 https://youtu.be/Z_AF3K-BMBs
Python初級:第20課 - Decorator 裝飾器 https://youtu.be/mAyJI-proks
Python初級:第21課 - Multi-threading 多線程 https://youtu.be/mHp7bfDZOSU
Python初級:第22課 - Multi-processing 多進程 https://youtu.be/yFdGhaxW_5o

Python初級:Django 入門 1 - Model + Admin Site https://youtu.be/en6NXFI6CsQ
Python初級:Django 入門 2 - Template + View https://youtu.be/en6NXFI6CsQ
Python初級:Django 入門 3 - 部署 https://youtu.be/GfMiJvbYk2k

Python初級:openpyxl - 讀寫 MS Excel 文件 https://youtu.be/tjcJV2fur5g
Python初級:python-docx - 讀寫 MS Word 文件 https://youtu.be/PEKWb5R3sSU

Python入門 - 數據科學 - Jupyter Lab & Notebook 安裝+入門教程 https://youtu.be/niWD8kxgpH0
Python入門 - 數據科學 - Anaconda + PyCharm 安裝 https://youtu.be/H4ihRvtdY7M
Python初級 - 數據科學 - Numpy入門 https://youtu.be/t7ygnafk760
Python初級 - 數據科學 - Pandas入門 https://youtu.be/ZYjhM7J9eFQ
Python初級 - 數據科學 - Pandas入門 (第二版 更新column部分) https://youtu.be/w76oa7YzvkY
Python初級 - 數據科學 - Pandas時間 + 圖表 https://youtu.be/jrd8shHEVFQ
Python初級 - 數據科學 - Pandas類別 + 樣式 https://youtu.be/4ntwbAWnKbg

Python初級 - 機器學習 - Scikit-learn 入門 https://youtu.be/3m8Bb01uNNE
Python初級 - 機器學習 - Scikit-learn - Regression 回歸 https://youtu.be/QyYZT8o-f3U
Python初級 - 機器學習 - Scikit-learn - Classification 分類 https://youtu.be/JKn0OoHSoRo
Python初級 - 機器學習 - Scikit-learn - Clustering 聚類+降維 https://youtu.be/UgXyK-k-CgM
150 chances to become an millionaire

150 chances to become an millionaire


#big wins#winners#games#casinos

About 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

By using our services, you agree to our Privacy Policy.
Alternative random YouTube videos generator: YouTuBeRandom
vTomb © 2024
By using our services, you agree to our Privacy Policy.