Nex 內推系統
台灣社群建立的科技業內推平台,方便找到願意幫忙內推的前輩。
歹晚郎互助網絡
由「半路工程師在矽谷」於 2022 年創立,專為在美台灣人整理科技公司內推資訊。開放式的內推表單,包含來自不同產業、職位、公司的台灣人內推資源。
Google XYZ Resume 撰寫法介紹
利用 XYZ 結構展現具體成果,幫助你在履歷中凸顯價值。
STAR 面試回應技巧
一種結構化回答面試問題的方法:Situation、Task、Action、Result。
常見行為面試問題與回答範例
影片說明(英語)
一畝三分地
美國科技業面試經驗與筆試分享論壇。不管是準備 techical interviews、還是想知道面試氣氛,運用 篩選器 或直接 搜關鍵字 就能看到前人經驗,超適合拿來模擬練習!
👉 面經專區
臨場應變訓練資源
關鍵字搜尋:「思考更敏捷,說話更機智」提升表達能力與反應速度。
Complex JOINs and Subqueries
Combine data across multiple tables using JOINs, with subqueries for filtering.
Example: Retrieve the top N customers by purchase amo
unt in the last 30 days by joining tables like orders and customers with subqueries.
Window Functions
Use functions like ROW_NUMBER(), RANK(), DENSE_RANK() to calculate rankings, moving averages, etc.
Example: Rank the top three products by sales within each product category.
Aggregations & GROUP BY
Perform grouped statistics with aggregate functions like SUM(), AVG(), COUNT() and use ROLLUP, CUBE, or GROUPING SETS for hierarchical totals to create a new table.
Example: Calculate total monthly sales and average order values by region.
JOINs, Aggregations, Subqueries & Window Functions
Classic problems include finding the most frequently charting artists or sorting based on conditions.
Example: From artists, songs, and global_song_rank tables, find the Top 5 most frequent charting artists.
Analyzing User Behavior Data
Combine techniques like JOINs, aggregations, and window functions to uncover streaming data patterns.
Basic and Advanced SQL Questions
Cover GROUP BY, ORDER BY, WHERE vs HAVING, JOIN types, CTEs, and window functions.
Example: Explain JOIN differences or use CTE for hierarchical queries.
SELECT, WHERE, ORDER BY, GROUP BY, JOIN types, UNION vs UNION ALL, DISTINCT, subqueries, CTEs.ROLLUP, CUBE, multi-level aggregation, advanced segmentation.ROW_NUMBER, RANK), moving averages, LAG/LEAD analysis.WHERE vs HAVING, CASE WHEN logic, date operations.