𝗖𝗿𝗮𝗰𝗸 𝗬𝗼𝘂𝗿 𝗡𝗲𝘅𝘁 𝗗𝗮𝘁𝗮 𝗘𝗻𝗴𝗶𝗻𝗲𝗲𝗿 𝗜𝗻𝘁𝗲𝗿𝘃𝗶𝗲𝘄 𝘄𝗶𝘁𝗵 ...
Topics Covered: SELECT, INSERT, UPDATE, DELETE WHERE, AND, OR, NOT ORDER BY & LIMIT Aggregate Functions (COUNT, SUM, AVG, MIN, MAX) GROUP BY & HAVING JOINS (INNER, LEFT, RIGHT, FULL) Subqueries Keys & ...
基于巴西 Olist 电商数据集(~100K 订单),构建 CSV + MySQL 数仓双模式 供应链分析平台。支持标准数仓分层 (ODS → DWD → DWS → ADS),覆盖交付时效、库存周转、满意度归因、销售趋势四大维度。
A console-based Restaurant Management System developed using Python and MySQL. The project helps restaurant staff manage food items, customer records, orders, and sales through an interactive menu- ...