陳擎文 Teaching Website: E-commerce
☎1.【7 Types of E-commerce Development Models】:
Third-party platform sales, D2C self-built e-commerce platform,
Social e-commerce, WeChat business,
Subscription-based e-commerce, Dropshipping model, Affiliate marketing

☎2.【Common Development Paths for Taiwanese E-commerce Businesses】
(1) Initial stage, small-scale operation: Start by operating on 【Third-party e-commerce platforms: Momo, Amazon, Shopee】, Advantage: Third-party platforms can bring in traffic.
(2) Mid-stage, with increasing transactions and larger volumes leading to higher 【sales commission】 rates ➜ Build your own e-commerce website to 【divert traffic】. Advantage: Utilize traffic from third-party platforms to 【redirect】 customers to your own website.
(3) Long-term: Once business performance is stable, focus on your 【self-built e-commerce website】 while using 【third-party e-commerce platforms (Shopee/Momo)】 as a supplement.

☎3.【Two E-commerce Related News】:
Air Space, a women's fashion e-commerce brand, becomes a billion-dollar empire through data analysis
Two key factors that enable liberal arts graduates to earn a monthly income of 100,000 after five years of work
Overcoming challenges! The turnaround weapon for brick-and-mortar stores: data application

☎4.【SHEIN's Successful Business Model】:
1. Strong Supply Chain Management: Exclusive design team and dedicated supply chain
2. Trendy and fast-changing styles, with new designs available online in just 3 days
4. Utilizes AI/Data-driven business model to predict the latest fashion trends and customer demands, and designs new products accordingly
5. Leverages social media, influencers, and KOLs for marketing
6. Massively recruits "Shein Girls" and utilizes affiliate programs for distribution

☎5.【The Successful Business Model of Xiaohongshu (RED)】:
1. Fully integrates the interactive functions of 【social media】 and 【e-commerce】
2. Uses user-generated content (UGC) to recommend and share products, creating a highly trusted community shopping platform
3. Unique UGC (tutorial-based video content) has made it a must-have search platform for young women seeking trendy information
4. Brands leverage influencers to build "mall" profits, utilizing 【social media/influencers/KOL】 for marketing
5. Effectively uses 【AI/data-driven business models】 to recommend products by analyzing browsing history, likes, favorites, and shared content

☎6.【The Successful Business Model of Lin Ruiyang's TST Tingmi Secret】:
1. Adopts WeChat's 【micro-business】 multi-level marketing (MLM) model
2. O2O (Online-to-Offline) business model

☎7.【Temu's Successful Business Model】:
1. Fully Managed Business Model: Temu handles supply chain management, warehousing, logistics, and after-sales services. Merchants are only responsible for design and production.
2. Pricing Strategy: Implements a low-price/high cost-performance strategy, frequently offering promotional discounts. The ability to maintain low prices is also related to the fully managed model, as it eliminates middlemen commissions, enabling direct sales at factory prices.
3. Product Diversity, Comprehensive Department Store Model
4. Group Purchase Mechanism: Allows for group buying or sharing invitations to reach a certain quantity for discounts, thereby reducing the selling price.
5. Small e-commerce platforms receive the same exposure as large ones: Temu focuses on products, not the company size. As long as the product has a high cost-performance ratio, it can receive a certain level of exposure and traffic.
6. Social Media Marketing and Extensive Online Advertising

8. Methods of Data Collection:
◉(1). Traditional Methods: 【Surveys, Interviews】
◉(2). Advanced Methods: 【Website Traffic Collection and Analysis (GA), Tracking Customer Online Browsing Behavior on Webpages/Apps (GTM)】
◉(3). Latest Methods: 【AI-based Automated Customer Behavior Identification and Real-time Product Recommendations】

9. Methods of Quantitative Data Analysis:
◉(1). Traditional Methods: Use 【SPSS】 for statistical data analysis.
◉(2). Advanced Methods: Use 【Python (Scipy)/R programming languages】 for statistical data analysis.
◉(3). Latest Methods: Use 【Generative AI (ChatGPT 4.0, Gemini Pro)】 for statistical data analysis.


資源(Resource)

Chp0. Course Introduction

【1. Seven Development Models of E-Commerce】

Chp1. Introduction to E-Commerce

Chp2. E-Commerce Technology Basics
【Internet, Front-end and Back-end Web Development, Databases, E-Payments, Financial Flow, Logistics, Website Security, Data Encryption Protection】

◉Chp3. Common Paths for Taiwanese E-commerce Businesses to Develop E-commerce Platforms

Chp4. E-commerce Platforms and Tools

◉Chp6. 【Mobile Commerce and Cross-border E-commerce】 - Two Major Trends in E-commerce
➜ Examples: SHEIN, Temu, Amazon

Chp7. E-commerce Law and Ethics

◉Chp8. 【Supply Chain Management】 - The Key to Competitiveness in 【Fast Fashion E-commerce】
➜ Examples: Zara, SHEIN

Chp9. E-commerce Customer Relationship Management
【Data Analysis, Customer Segmentation, Personalized Marketing and Service, Customer Support, After-sales Service】

Chp10. E-commerce Entrepreneurship Preparation
【1- Business Plan, 2- Fundraising and Management】

◉Chp11. Big Data Analysis in E-commerce
【Real-time Transaction Data Analysis, Customer Browsing Behavior Analysis, Precise Recommendations, Market Demand Analysis, Risk Management】
➜ Examples: Netflix, SHEIN, Amazon

◉Chp12. Social Commerce and Influencer Economy: UGC Marketing as a New Trend
➜ Examples: Xiaohongshu, SHEIN

◉Chp13. Summary of Seven E-commerce Development Models and Future Trends
【Third-party Platform Sales, Direct-to-Consumer (D2C) Platforms, Social Commerce, Micro-business, Subscription E-commerce, Drop-shipping, Affiliate Marketing】

【2. Practical Exercise: Developing an E-commerce Website – Practice Website Architecture, Using JavaScript to Track Customer Behavior, Applying SEO Techniques, and RWD Design to Improve Search Engine Ranking, and Using Google Analytics for Traffic Analysis】

Frontend Hosting

Link: Log in to GitHub Pages

Presentation: How to Use GitHub Pages

URL Format: username.github.io/repository, Example: user1.github.io/hw1


☎Backend Hosting

Link: Log in to Byethost Cpanel

Link: Register for Byethost



☎ Step 1 of SEO: Google Search Console (GSC): Let Google recognize your website: GSC Link


Sitemap Tool: XML Sitemap Generator, generate sitemap (sitemap.xml)


☎ Step 2 of SEO: TDK: Refers to Title, Description, and Keywords,
These three elements are the most basic and crucial parts of SEO optimization for a webpage.
◉<title>陳擎文作業1 - Program Assignment Display</title>
◉<meta name="description" content="This is 陳擎文作業1, containing code and related explanations.">
◉<meta name="keywords" content="陳擎文, Assignment 1, SEO, TDK">


☎ The first step to detect website traffic: URL: Google Analytics (GA)


☎ The second step to detect website traffic: URL: Google Tag Assistant (GTA) to check if the GA4 code is installed successfully

☎The world's largest web editing and design tool

URL: Visual Studio Code (VSCode)

Google Drive download old version (1.93.exe): Visual Studio Code (VSCode)

Google Drive download old version (1.93.zip): Visual Studio Code (VSCode)


☎Recommended 2 assisting web design tools

URL: w3school (English)

URL: w3school (Chinese)

URL: ChatGPT

Simple example

22-1. Example Results

22-2. Example 2 Assignment

22-3. Download Web Template

22-4. Three-element Structure Diagram of Client Side Website

22-5. Client and Server Side Structure Diagram for E-commerce Website

22-6. Development Trends of Client/Server Side Programming Languages


22-7. Why can't the hw1 Assignment 1 website be found on the Google Search engine?
Example 1: Assignment 1/hw1 (110570053 Liu Shu-Ru)
Search your website's title on Google: 110570053 Liu Shu-Ru
Search your website's URL on Google: site:acupun.site/lecture/ (Illustration)
Search your website's URL on Google: site:acupun.site/lecture/ (URL)


22-8. The First Step of SEO: Let Google Know About Your Website:
How can you ensure that Google Search has already indexed your website? (2 Methods)

(1) Method 1: Build Backlinks:
◉ Acquire external links: Links from other high-authority websites (backlinks) can significantly improve your website's ranking in Google and help Google find and index your website faster.
◉ Social Media Promotion: Share your website link on social media platforms.

(2) Method 2: Add your website to Google Search Console (GSC, also known as Google Webmaster Tools, Google Search Dashboard, or Google Search Console), so Google knows your website exists:
◉ Google Search Console is an essential tool for running a website and optimizing for SEO.
◉ Often abbreviated as GSC in marketing circles.
◉ It's a free service provided by Google, enabling us to understand the overall status of the website, including: SEO performance analysis – confirming website ranking, visibility, and clicks, and optimizing search ranking.
◉ [Video Tutorial]: Is my website showing on Google Search?
◉ [Video Tutorial]: Add a website to Google Search Console (Google Webmaster Tools) to quickly increase content indexing
◉ [Video Tutorial]: Google Search Console Tutorial | Google Webmaster Tools | Google Search Console
[Web Tutorial]: GSC Setup, Complete Feature Guide
[Web Tutorial]: Google Search Console Guide: From Installation to Feature Setup


22-9. How to add your website to Google Search Console, so that Google knows your website exists:
(0). Purpose of the example: Submit your two websites: https://ccwntut.github.io/hw1-ec/
and https://ccwntut.github.io/hw2/
to Google Search Console and request Google to crawl the websites and index them.

(1). Step 1: Log in to your Google Search Console account
Login to Google Search Console using your Google account
If it's your first time using the tool, click "Start Now" and log in with your Google account.
Illustration

(2). Step 2: Add property
Click "Start Now" (or, after logging in, click on "Add Property" in the top right corner).
Choose the right option [URL Prefix]: Enter the website URL: https://ccwntut.github.io/hw1-ec/
Illustration 1, Illustration 2

(3). Step 3: Verify website ownership
To let Google verify that you own the website, you need to complete ownership verification. There are 4 common methods to verify, and you can choose any:
The most commonly used method is: HTML tag verification:
Google will provide an HTML tag code. You need to add this code to the <head> section of your website.
Add the HTML tag to your index.html file and push it to GitHub.
After submission, return to Search Console and click "Verify".
Illustration 3, Illustration 4, Illustration 5, Illustration 6, Illustration 7,
Outcome: Data processing, please check back after about a day.
Illustration 8


(4). Step 4: Submit a sitemap
(4-1). A sitemap helps Google understand your website structure more quickly and allows it to crawl all pages.
Since your website is static, you can manually create a sitemap.xml file and upload it to the root directory of your website.

(4-2). Create a sitemap (sitemap.xml): You can use the XML Sitemap Generator tool to generate the sitemap (sitemap.xml)
Illustration 1, Illustration 2, Illustration 3,

(4-3). Upload the sitemap.xml file to the root directory of your GitHub website.
Illustration 1, Illustration 2,

(4-4). Go back to Google Search Console and click on "Sitemaps" in the left-hand menu.
Enter the sitemap URL (sitemap.xml) and click "Submit".
Illustration 1, Illustration 2, Illustration 3,
If it shows that no capture was taken, indexing is not affected. See Illustration 4,
You can query the website using site search the next day. See Illustration 5,
The site was indexed by Google the next day. See Illustration 6,


(5). Step 5: Request Google to crawl your website (you can use this method to have Google Search instantly index any new webpage you create)
The steps above will gradually allow Google Search to index your website.
【Use Case】: If you want Google to index a specific webpage immediately, you can manually request Google to crawl your website to speed up the indexing process.

In Google Search Console, use the "URL Inspection" tool.
Enter your website URL in the textbox at the top: https://ccwntut.github.io/hw1-ec/
Illustration 1, Illustration 2, Illustration 3,
Click "Request Indexing." Google will queue up to crawl your website content, and it will be indexed within a few days. Illustration 4, Illustration 5, Illustration 6, Illustration 7, Illustration 8,


Example 2-1: HTML - Table

Example 2-2: CSS - Text Color, Font Size, Text Alignment

Example 2-3: JavaScript Display Text

Example 2-4: JavaScript Display Text at a Specific Location

23-1. Example Results

23-2. Example 3 Assignment

23-3. Download Web Template

23-4.【URL】Google Analytics (GA) Homepage

23-5.【PPT】GA Tutorial (1)

23-6.【URL】Use Google Tag Assistant to Verify GA4 Code Installation

23-4. Three-element Structure Diagram of Client Side Website


23-5. After completing the Google Search Console setup assignment 1 (hw1) last week, test if site:https://ccwntut.github.io/hw1 has been indexed by Google.
Diagram 1


23-6. Enter the title of assignment 1 (陳擎文作業1) in the Google search engine. Can you find your website?
Diagram 1


23-7. If you still cannot find the website when searching for the keyword "陳擎文作業1", possible reasons and solutions are as follows:
(23-7-1). Reason 1: The keyword appears too few times, insufficient keyword optimization
Why can't you find your website when entering the keyword:
◉ The keyword appears too few times,
◉ Other webpages are better optimized for similar keywords, so Google has not yet prioritized displaying your website
Solution:
◉ Ensure that your keyword "陳擎文作業1" not only appears in the page title but also reasonably appears in the page content (e.g., headings, paragraphs) to enhance keyword relevance.
◉ Check whether the page includes an appropriate Meta description and incorporate the keyword in the Meta tag.


(3). Learn the TDK of a webpage:
TDK helps improve the SEO ranking of search engines and promotes online marketing.
What does TDK of a webpage refer to:
☎ T stands for: webpage title,
☎ D stands for: webpage description name=description,
☎ K stands for: webpage keywords name=keywords
◉<meta name="description" content="This is 陳擎文作業1, containing code and related explanations.">
◉<meta name="keywords" content="陳擎文, 作業1, SEO, TDK">


(4). About: webpage keywords name=keywords
Google announced in 2009 that Meta keywords are no longer a ranking factor. However, some smaller search engines may still reference them. Therefore, you can add Meta keywords tags, but they have limited impact on SEO.



(23-7-2). Reason 2: Google's ranking algorithm considers external website backlinks and overall traffic. Since your website may be new, it may lack sufficient backlinks or traffic to improve search rankings.
◉ Solution: Build backlinks:
◉ Obtain external links
: Links from other high-authority websites (backlinks) can significantly improve your website's ranking on Google and help Google discover and index your website faster.
◉ Social media promotion: Share your website link on social media platforms.



(23-7-3). Reason 3: Time issue, generally it takes 【several weeks】 for Google to provide keyword searches
Google indexing and ranking may take some time to adjust. Even if the website has been indexed, it usually takes several weeks to appear in search results for relevant keywords.
Solution:
◉ Be patient and continue optimizing content and SEO.



23-8. View 【Performance】 ➜ 【Add Filter】 ➜ 【Country/Region】
Diagram 1
United States, Diagram
Taiwan, Diagram
Comparison: United States vs Taiwan, Diagram



23-9. View 【Performance】 ➜ 【Add Filter】 ➜ 【Device】
Comparison: Desktop vs Mobile Device, Diagram



23-10. View 【Performance】 ➜ 【4 Indicators】 ➜ Used to evaluate the performance of the website in Google search results
The 4 indicators of performance, Diagram
◉ 1. Total Clicks
Definition: This represents the total number of times users 【clicked on your website link】 in Google search results.
Explanation: This is a direct reflection of website traffic, indicating how many people entered your website from Google search. A high number of clicks means that the ranking of search results is good, or the title and summary (Meta description) are attractive.
◉ 2. Total Impressions
Definition: This represents the number of times your website 【was displayed on the Google search results page】. Whether or not the user clicks the link, as long as it appears in the search results, it counts as an impression.
Explanation: Impressions reflect your website's visibility under different keywords. If the number of impressions is high but the number of clicks is low, it may indicate a need to optimize the page title or Meta description to attract more clicks.
◉ 3. Average CTR (Click-Through Rate)
Definition: This represents the percentage relationship between clicks and impressions, that is, how many impressions are converted into clicks. The calculation formula is:

Explanation: A high CTR means that your search result is attractive to users. Conversely, it may indicate a need to improve the title or description in the search results to increase click-through rates.
◉ 4. Average Position
Definition: This represents your website's 【average ranking in Google search results】. 1 means that your website is at the top of the search results, and higher numbers represent lower rankings.
Explanation: The higher the average ranking, the better your website performs in search engines. Higher rankings are usually accompanied by more impressions and clicks. If the average ranking is not ideal, further SEO strategy optimization may be required.



23-11. View 【Performance】 ➜ 【Add Filter】 ➜ Purpose of the 【Page】 filter:
Diagram 1,
Diagram 2,
Purpose: The 【Page】 filter is used to filter 【specific URLs (or webpages)】 for performance data.
For example, you can filter the URL "https://ccwntut.github.io/hw1" to view its impressions, clicks, CTR, and average ranking in Google search results.



23-12. View 【Performance】 ➜ 【Add Filter】 ➜ Purpose of the 【Query】 filter:
Diagram 1,
Diagram 2,
Purpose: The 【Query】 filter allows you to see 【specific keywords】, which search queries brought in the most clicks and impressions. This helps you understand which keywords effectively drive traffic to your website.
For example, you can filter the query "陳擎文 作業1" to see how your website performs in terms of impressions, clicks, CTR, and average ranking when users search for this keyword in Google search results.


Example 3-2: CSS Style Class

Example 3-3: Change Image on Mouse Hover

Example 3-4: JavaScript Directly Setting Style

CSS Padding, Margin

24-1. Example Results

24-2. Example 4 Assignment

24-3. Download Web Template

24-4.【URL】Google Analytics (GA) Homepage

24-5. 【PPT】GA Tutorial (1)

24-6. 【PPT】GA Tutorial (2) - Custom Events, Setting Important Events (Conversions)

24-7.【URL】Use Google Tag Assistant to Verify GA4 Code Installation

24-8. 【Results】Tracking Website Traffic with Google Analytics (GA)

24-9. 【Results】Verifying GA4 Code Installation with Google Tag Assistant

24-10. Three-element Structure Diagram of Frontend Website


Example 4-1: HTML - Lists (ul, li)

Example 4-2: CSS - External Stylesheet Links

Example 4-3: JavaScript - Adding Numbers

Example 4-4: JavaScript - Comparing Numbers


1. Google Analytics (GA) is a free and powerful website traffic analysis tool launched by Google. It is widely used in 【website management, digital marketing, SEO execution】.

2. Google provides a 【demo account】 for users to practice. You can find this demo account using the account selection tool in Analytics (where you link the organization and account).

3. Each Google account has a limit on the number of Analytics accounts it can create, currently capped at 2000 accounts per Google account. The demo account will count toward this limit.



4. The demo account includes three resources that can be accessed via the account selector at any time:
◉Google Analytics 4 Resource: Google Merchandise Store (website data)
◉Google Analytics 4 Resource: Flood-It! (App and website data)
◉Universal Analytics Resource: Google Merchandise Store (data from the previous version of the website)



5. How GA Works:
◉Google Analytics collects data using page tags (tracking code) embedded in each page of your website. When users visit a page, their browsing data is captured and sent to Google Analytics' database, which is then visualized in various reports.
◉The Google Analytics tracking code should be placed in the <HEAD> section of your webpage to track visitor behavior.

◉For example, if you want to track whether visitors are clicking a specific hyperlink, you can set up custom behavior tracking in GA.



6. Key Features of Google Analytics 4:
◉Tracking Visitor Profiles: GA tracks various visitor characteristics and behaviors.
◉Visitor Behavior Analysis: GA provides key dimensions and metrics to analyze visitor behavior.
◉Data Suggestions: GA provides specific recommendations based on visitor behavior to optimize website performance.
◉Traffic Source Reports: GA supports analyzing different traffic sources (e.g., search engines, social media, ads).
◉User Behavior Analysis: GA provides insights into user behavior on different pages, such as time spent and bounce rate.



7. Understanding GA Reports:
Google Analytics offers four main reports:
◉Audience
◉Acquisition
◉Behavior
◉Conversion



8. Key Report Components: Dimensions and Metrics
◉Dimensions: Categories such as visitor language, location, or system used.
◉Metrics: Values associated with dimensions, such as number of visitors or sessions.



9. Audience Report: Helps answer questions like "Who is visiting my site?" and provides insights into visitor profiles, browser types, and geographic data.



10. Acquisition Report: Shows which channels brought visitors to your site (e.g., Facebook, search engines, Google Ads).



11. Example Question: If a user clicks a link to your website from Facebook, which traffic source does this fall under?
◉Answer: Referral Traffic.



12. Why is this categorized as referral traffic instead of social traffic?
◉Social traffic refers to visitors coming through social media content like posts or videos, while referral traffic is tracked through external links, such as from a Facebook message or ad.



13. Behavior Report: Shows what visitors do on your website, including the pages they visit, time spent, and page performance.



14. Conversion Report: Tracks the completion of website goals, such as registrations or purchases.



15. Google offers a free GA certification exam that can be taken online. It consists of 70 questions, and a score of 80% is required to pass.
【GA Certification Exam Link】



16. Google provides GA learning resources with courses for different levels:
101: Getting Started with Google Analytics 4 (Beginner)
102: Managing GA4 Data and Reports (Beginner)
201: Advanced GA4 Data and Reports (Intermediate)
301: Using GA4 with Other Tools and Data Sources (Advanced)
【GA Learning Center Link】

28-1. Example Results

28-2. Example 8 Assignment

28-3. Download Web Template

28-4. Download and Install XAMPP from the Official Website

28-5. Download and Install Discuz - The World's Largest Forum Software


1. Three-layer Architecture of E-commerce Websites (e.g., Taobao, Momo, Shopee):
A. Client-side App (Frontend): HTML, JavaScript
B. Server-side Webpage (Backend): PHP, JSP, ASP.NET
C. Database: MySQL, SQL Server

2. Four Key Tasks in Building an E-commerce Website:
A. Create Frontend Pages (HTML, CSS, JavaScript)
B. Web Server Setup (Apache)
C. Create Database (MySQL)
D. Create Backend Pages (PHP)

Web Server Software 1: Download XAMPP from the Official Site XAMPP Installation Tutorial (Windows) XAMPP Installation Tutorial (MAC) How to Find the htdocs Directory on Mac
Download Homework 1: bitter_sweet Download Web Animation: Walking Cat
How to Find Your Computer's IP Address (Method 1): Type "myip" in Chrome How to Find Your Computer's IP Address (Method 2): Use Command Prompt (cmd), type "ipconfig", and find the IP4 Address (e.g., 192.168.68.101)
Tutorial on Installing Two MySQL Databases Simultaneously
Installing both MySQL Workbench and XAMPP can cause port conflicts (port 3306), resulting in errors.
Image
Solution: Change XAMPP's port to a different number (e.g., 3307). You need to modify 3 files, which is complicated. Follow the tutorial.

(1) First Modification: Apache ➜ config ➜ phpMyAdmin (config.inc.php)
$cfg['Servers'][$i]['host'] = 'localhost:3307';
Image, Image, Image


(2) Second Modification: MySQL ➜ config ➜ My.ini
port=3307
Image


(3) Third Modification: config ➜ Service and Port Settings ➜ mysql:3307
Image


(4) Restart XAMPP Control Panel: The red warning should disappear.
Apache ➜ Start
MySQL ➜ Start
Image


(5) Open MySQL Database: MySQL ➜ Admin
Image

Web Server Software 2: Download WAMP from the Official Site
World's Largest Forum Backend Software: Download Discuz (PHP) from the Official Site
(1) PHP + MySQL: Extract the "upload" folder to "www", then access http://localhost/upload/ to install (MySQL account: root, password: admin/admin).
Test: Local Discuz Forum

(2) Create a Forum Section:
Admin Center ➜ login as admin ➜ left menu ➜ Forum ➜ Manage Sections ➜ Create Structure:
Discuz ➜ Food Discussions, Travel Sharing, Second-hand Sales

(3) Post a Thread as Admin: "Where are the best late-night snacks in Da'an District?"

(4) Register a New Member Account:
Log out of admin
Register: Username, Password (at least 6 characters)
No email verification required

(5) Reply to the Thread with the New Account:
"Tonghua Night Market has a lot of great late-night snacks."

(6) Add IP Address (IP4): http://192.168.68.101/upload/

How to Convert IP4 Address to a Domain?
(1) Paid Domain Registration: Bluehost
(2) Paid Domain Registration: AwardSpace
(3) Paid Domain Registration: AgilityHoster
(4) Free Domain Registration: Freenom
Freenom Registration Tutorial
Paid Domain Registration: GoDaddy
GoDaddy Official Site
(1) Download Database (ch09.sql)
(2) Query ch09 Database, Books Table:
SELECT * FROM `books`;
(3) Practice Queries:
1. Query all book records.
2. Query book names and prices.
3. Query books with prices over 400.
4. Query books with "design" in the name.
5. Query books managed by employee ID 1.
6. Query books with prices between 300 and 500, sorted by price descending.
7. Query the most expensive book.
8. Query the cheapest book.
9. Query the average price.
10. Query books with names starting with "A".
11. Query books with names ending with "tech".
12. Query books managed by employee IDs 1 and 2.
13. Query books with prices not equal to 350.
14. Query all books, sorted by price ascending, then by name descending if prices are the same.
15. Query the number of books managed by each employee.
16. Query the number of books for each price.
17. Query the second most expensive book.
18. Query the third cheapest book.

19. Insert a new book with ID 36, name "Python Programming for Beginners", price 420, managed by employee ID 2.
INSERT INTO books (book_id, book_name, price, employee_id)
VALUES (36, 'Python Programming for Beginners', 420, 2);
20. Delete book with ID 36.
21. Delete books priced under 300.
22. Update the price of book with ID 37 to 520.
23. Update books with "design" in the name, changing employee ID to 1.
SQL Practice Solutions

資源
上課工具 線上黑板( Online blackboard) 廣播教學 上課錄影影片 Goole輸入法(Input:exe)
證照考試:商用數據應用師 考試題庫 (從中約抽70題) 報名證照相關說明與方法 考試方式:100題單選題,每題1分,70分及格 考試指定用書
數據集,資料集,dataset UCI的各種資料集 Kaggle的各種資料集 考試方式:100題單選題,每題1分,70分及格 考試指定用書
上課參考教材 書籍:跨領域學 Python:資料科學基礎養成 書籍:Python 資料科學與人工智慧應用實務 書籍:一行指令學Python:用機器學習掌握人工智慧
書籍:用Pandas掌握商務大數據分析 進階書籍:Python商業數據分析:零售和電子商務案例 pandas官網(英文) w3schools的pandas教學(英文)
pandas參考教材 w3Cschool的pandas教學(中文) Steam教學網-python 蓋若pandas 教程 pandas的df的操作函數
colab繪圖如何顯示中文,方法1 ☎#colab顯示繁體中文,方法1 問題:matplotlib繪圖,會發生中文無法顯示的問題
參考:colab繪圖如何顯示中文
程式碼
#--------------------------------
# colab繪圖顯示繁體中文
#--------------------------------
import matplotlib
# 先下載台北黑體字型
!wget -O taipei_sans_tc_beta.ttf https://drive.google.com/uc?id=1eGAsTN1HBpJAkeVM57_C7ccp7hbgSz3_&export=download import matplotlib
# 新增字體
matplotlib.font_manager.fontManager.addfont('taipei_sans_tc_beta.ttf')
# 將 font-family 設為 Taipei Sans TC Beta
# 設定完後,之後的圖表都可以顯示中文了
matplotlib.rc('font', family='Taipei Sans TC Beta')
colab繪圖如何顯示中文,方法2 ☎#colab顯示繁體中文,方法2 ☎程式碼
#--------------------------------------
# 課本的中文處理
#--------------------------------------
import matplotlib as mpl
import matplotlib.font_manager as fm

!wget "https://www.wfonts.com/download/data/2014/06/01/simhei/simhei.zip"
!unzip "simhei.zip"
!rm "simhei.zip"

fm.fontManager.addfont('SimHei.ttf')
mpl.rc('font', family='SimHei')
# 這一行能讓字體變得清晰
%config InlineBackend.figure_format = 'retina'
windows的spyder繪圖如何顯示中文 ☎解決:windows的spyder,會發生中文無法顯示的問題
參考:windows繪圖如何顯示中文
程式碼
#在windows 10 的spyder,繪圖如何顯示中文
#使用微軟正黑體(Microsoft JhengHei)
plt.rcParams['font.sans-serif'] = ['Microsoft JhengHei']

#有些中文字體在碰到負號時,會無法正常顯示,尤其是內建的字體,加入以下語法就可以解決『負號無法顯示』問題
plt.rcParams['axes.unicode_minus'] = False
在colab如何更改目錄 ☎解決:在colab如何更改目錄的問題
程式碼
import os
os.chdir("/content/drive/MyDrive/Colab Notebooks")
!ls
解決簡體字csv造成亂碼 ☎解決簡體字csv,打開後都是亂碼的問題:

第2 種方式:
(1)先執行Excel 軟體,新增空白活頁簿,
(2)然後在上方功能選項中點選「資料」➜「取得外部資料」➜ 「從文字檔」 → 「選擇csv文件」,
選擇你的CSV 檔,
在「匯入字串精靈」對話框中選擇檔案原始格式65001:Unicode(UTF-8) 即可。

若是utf-8還是有亂碼,再改成
在「匯入字串精靈」對話框中選擇檔案原始格式54986:簡體中文(GB18080) 即可。

(3)打勾:我的資料有標題
(4)分隔符哈:逗號

程式模板 ☎存入excel檔案,並且畫柱狀圖
程式模板chp8-6.樞紐分析表的必要指令:展開 ☎輸出excel檔案:建立3個資料表sheet(英文成績,數學成績,中文成績)
打開chrome網頁線上英文字典功能 ☎如何安裝google chrome的網頁線上英文字典工具:
➜google chrome的右上角工具➜更多工具➜擴充功能
➜左上角主選單➜開啟chrome線上應用程式商店
➜勾選:google製作,免費
➜搜尋:google dictionary➜安裝
➜到chrome右上擴充功能➜點按google dictionary的『詳細資料』➜擴充功能選項
➜my language=chinese
➜打勾2個:Pop-up definitions:
(1)反白單字翻譯:Display pop-up when I double-click a word
(2)ctrl+拖曵整段翻譯: Display pop-up when I select a word or phrase

上課用excel 學生成績-chinese 學生成績-有缺值-chinese 學生成績-物理歷史-chinese 學生成績-amy-simon-chinese
學生成績-生日-chinese 學生成績-分組-chinese 人事資料-chinese 男女時薪-chinese
學生成績-english 學生成績-有缺值-english 學生成績-分組-english 圖書資料-chinese
上課用csv 小費tips-chinese 小費tips-english 學生成績-chinese 學生成績-english
圖書資料-chinese
上課用其它資料庫 mySQL-ch09 SQLite-student json-學生成績 xml-personnel
課本商業範例資料庫 商業銷售分析-sales csv 系所生源分析-excel 股市分析-台積電聯發科股票線型-excel 問卷資料分析-excel
pandas參考教材 十分鐘入門 Pandas(英文) 十分鐘入門 Pandas(英文) 10分鐘的Pandas入門-繁中版 十分鐘入門 Pandas(中文)
pandas參考教材 pandas官網全部章節翻譯 pandas官網全部章節翻譯
pandas參考教材(英文) kaggle pandas教學 100 pandas tricks to save you time and energy 官網0.22.0:pandas documentation
pandas參考教材(中文) Pandas 101:資料分析的基石 資料科學家的pandas 實戰手冊:掌握40 個實用 簡明 Python Pandas 入門教學 資料分析必懂的Pandas DataFrame處理雙維度資料方法
pandas速查手冊 pandas 速查手册 - 盖若 Pandas速查手冊中文版 - 知乎專欄 Pandas速查手冊中文版- 騰訊雲開發者社區
pandas速查手冊 Pandas中DataFrame基本函數整理(全) Pandas 魔法筆記(1)-常用招式總覽 pandas的df的操作函數
資料集dataset 小費資料集Tips Dataset(csv) kaggle小費資料集範例A Waiter's Tips example 【視覺化】小費(tips)資料集分析 小費(tips)資料集提取和檢視相應資料
SQL語法 SQL語法教程 pandas vs SQL
資料分析4大模組(runoob) numpy pandas matplotlib scipy
w3c、w3school、w3cschool、runoob、w3capi比較 runoob流量監控儀表板
w3school vs runoob 1.w3school中文版是直接google翻譯英文版
2.runoob.com翻譯自英文版w3schools,但重新排版
3.runoob = run + noob(菜鳥,小白)
4.runoob是python,html,javascript中文版最好的教學網
官網 python官網 vscode官網    
python 教學網站 python 3(官網手冊中文) python 3教學(中文) python 3教學(中文) 簡易1小時教學
w3school(英文版)      
線上執行python online

https://www.python.org/shell/(建議用這個)

https://repl.it/languages/python3


https://www.onlinegdb.com/online_python_compiler

https://www.tutorialspoint.com/execute_python_online.php

用Anacond寫python(*建議使用)

到Anacond官網下載安裝