-
1-9月11-course introduction
-
2-9月18-chp2. Four Ways to Install and Use MySQL Databases: MySQL Package, WorkBench, Azure MySQL, Python
-
3-9月25-chp3-3-Conditional Query: Querying the List of Students Failing Math, Querying the List of Male Students Failing Math
-
4-10月02-chp3-4-Keyword Query,chp3-5- Querying a Range of Values (between),chp3-6-Sorting Query,chp3-7-Specific Value Extraction
-
5-10月09-chp4. Creating New Fields 1: Basic Mathematical Calculations, Date Extraction, String Manipulation
-
6-10月16-chp5. Creating New Fields 2: CASE...WHEN...THEN...ELSE...END
-
7-10月23-chp7. Three Types of Table Merging: Horizontal Merge with JOIN, Vertical Merge with UNION, and Relational Merge with JOIN (Merging Related Columns)
-
8-10月30-chp8. Grouping Analysis (Group by...Having...), Frequency Analysis, Single Grouping, Double Grouping (Cross Analysis, Pivot Analysis)
-
9-11月13日-chp8-2 Field Calculation Analysis After Grouping: select..aggregate()....Group by..
-
10-11月20日-chp10-1. Enterprise 'Purchasing, Sales, Inventory, and Orders' Relational Databases
-
11-11月27日-chp10-4: Two methods to identify customers with or without orders. Method 1: `JOIN..ON`. Method 2: Using `EXISTS (Subquery)`.
-
12-12月4日-Example 10-13: Intermediate Data Analysis
-
13-12月11日-chp10-4.Enterprise Database for "Purchasing, Sales, Inventory, and Orders" (4): Advanced Data Analysis
-
14-12月18日-chp10-4.Enterprise Database for "Purchasing, Sales, Inventory, and Orders" (4): Advanced Data Analysis
