This article aims to explain how to learn SQL using Mode’s SQL tutorial and Kevin Li’s method, combined with an engaging Hacker News discussion. I started learning SQL using Mode's SQL tutorials and discovered the efficient learning strategies proposed by Kevin Li. His approach emphasizes three key points:
- Quickly identify the basics.
- Build a personal learning course to become an expert and avoid the trap of becoming a "beginner expert".
- Concentrate your study for the first 15-20 hours to strengthen your initial memory, and then slow down the pace and proceed step by step.
To build my personal SQL learning course, I used Mode’s SQL tutorials. I added an ID (MST) to track my progress and used Beautiful Soup for web scraping to quickly create a file containing the course number and title. This approach allowed me to organize study materials efficiently and monitor my study progress easily.
Python code and explanation
Initial setup and HTML parsing: We first import the necessary libraries and get the HTML content from Mode’s SQL tutorial page.
<code class="language-python">import requests from bs4 import BeautifulSoup url = "https://www.php.cn/link/a188af0bc920853d3673ab71c5f2a440" response = requests.get(url) soup = BeautifulSoup(response.text, 'html.parser')</code>
Extract title:
Next, we find all <h4>
elements that contain the course title.
<code class="language-python">titles = [title.get_text() for title in soup.find_all('h4')]</code>
Create a file with formatted titles: Finally, we create a file for each title, format the title and add an index.
<code class="language-python">for i, title in enumerate(titles): file_name = title.strip().replace(' ', '-').replace('/', '_') + '.md' # 将空格替换为连字符,并添加.md扩展名 file_name = f"{i:02d}-{file_name}" # 在索引前添加前导零(2位数字) open(file_name, 'a').close() # 以追加模式打开文件以创建或更新访问时间戳</code>
This code ensures:
Using this script, I can quickly generate well-organized files in my file system and add content as I learn. This approach aligns with Kevin Li's strategy and helps me track my progress and stay motivated to learn.
https://www.php.cn/link/0a90c1fdd4b06c0822b0cbfae4bb0c06
https://www.php.cn/link/a188af0bc920853d3673ab71c5f2a440
The above is the detailed content of How to Build Personal Curicullum Locally in Python. For more information, please follow other related articles on the PHP Chinese website!