Index my Medium

For indexing my articles of Medium

Interview

• 整理面試常見問題 — Kubernetes

Job Tasks

• GCP Billing Analytics
• Migrate Google Cloud Functions to Airflow
• Migrate Google Cloud Functions to Kubernetes
• Customer Data Platform 是如何煉成的
• Customer Data Platform 是如何煉成的 (二)
• Customer Data Platform 是如何煉成的 (三)

Python3 Practices

Concurrency

• [Python3] asyncio

LeetCode Practices

Concurrency

• [leetcode][Python][Concurrency][Medium] 1115. Print FooBar Alternately
• [leetcode][Python][Concurrency][Medium] 1188. Design Bounded Blocking Queue
• [leetcode][Python][Concurrency][Medium] 1195. Fizz Buzz Multithreaded
• [leetcode][Python][Concurrency][Medium] 1226. The Dining Philosophers
• [leetcode][Python][Concurrency][Medium] 1242. Web Crawler Multithreaded
• [leetcode][Python][Concurrency][Easy] 1279. Traffic Light Controlled Intersection

Sets

• [leetcode][Database][Hard] 1892. Page Recommendations II
• [leetcode][Database][Hard] 1917. Leetcodify Friends Recommendations
• [leetcode][Database][Hard] 1919. Leetcodify Similar Friends
• [leetcode][Database][Hard] 2010. The Number of Seniors and Juniors to Join the Company II

Window function

• [leetcode][Database][Hard] 185. Department Top Three Salaries
• [leetcode][Database][Hard] 569. Median Employee Salary
• [leetcode][Database][Hard] 571. Find Median Given Frequency of Numbers
• [leetcode][Database][Hard] 579. Find Cumulative Salary of an Employee
• [leetcode][Database][Hard] 601. Human Traffic of Stadium
• [leetcode][Database][Hard] 1097. Game Play Analysis V
• [leetcode][Database][Hard] 1159. Market Analysis II
• [leetcode][Database][Hard] 1194. Tournament Winners
• [leetcode][Database][Hard] 1225. Report Contiguous Dates
• [leetcode][Database][Hard] 1369. Get the Second Most Recent Activity
• [leetcode][Database][Hard] 1412. Find the Quiet Students in All Exams
• [leetcode][Database][Hard] 1635. Hopper Company Queries I
• [leetcode][Database][Hard] 1645. Hopper Company Queries II
• [leetcode][Database][Hard] 1651. Hopper Company Queries III
• [leetcode][Database][Hard] 1767. Find the Subtasks That Did Not Execute
• [leetcode][Database][Hard]1972. First and Last Call On the Same Day
• [leetcode][Database][Hard] 2474. Customers With Strictly Increasing Purchases

knapsack Problem

• [leetcode][Database][Hard] 2004. The Number of Seniors and Juniors to Join the Company
• [leetcode][Database][Hard] 2153. The Number of Passengers in Each Bus II

Pivot table

• [leetcode][Database][Hard] 262. Trips and Users
• [leetcode][Database][Hard] 615. Average Salary: Departments VS Company
• [leetcode][Database][Hard] 618. Students Report By Geography
• [leetcode][Database][Hard] 1127. User Purchase Platform
• [leetcode][Database][Hard] 1336. Number of Transactions per Visit
• [leetcode][Database][Hard] 1384. Total Sales Amount by Year
• [leetcode][Database][Hard] 1479. Sales by Day of the Week
• [leetcode][Database][Hard] 2252. Dynamic Pivoting of a Table
• [leetcode][Database][Hard]2253. Dynamic Unpivoting of a Table

Group

• [leetcode][Database][Hard] 2118. Build the Equation
• [leetcode][Database][Hard] 2173. Longest Winning Streak
• [leetcode][Database][Hard] 2199. Finding the Topic of Each Post
• [leetcode][Database][Hard] 2362. Generate the Invoice

Others

• Google Certified 與 Cloud
• ETL | ELT 與 IoT Device Alive Check