如何開始入門軟體工程領域 - 名詞解釋（長期更新）現在應該開始有很多人想要踏入軟體工程的領域，但在進入這個領域之前，覺得先了解一些名詞，可以在入門時更有方向也更知道要用什麼關鍵字去找尋有用的資訊。這篇文章就是想要幫助想要入門的人理解一些軟體工程裡的專有名詞。 作業系統 這一區塊主要解釋跟作業系統層面相關的名詞 英文中文解釋 Operation system 簡稱 OS | 作業系統 | 就是電腦的作業系統，是三大作業系統分別是：Linux、Windows、macOS | | Linux | | 自由和開放原始碼的 UNI...May 10, 2023
LeetCode Solution, Easy, 1158. Market Analysis I1158. Market Analysis I 題目敘述 SQL Schema > Create table If Not Exists Users (user_id int, join_date date, favorite_brand varchar(10)) Create table If Not Exists Orders (order_id int, order_date date, item_id int, buyer_id int, seller_id int) ...Mar 12, 2023
LeetCode Solution, Easy, 1050. Actors and Directors Who Cooperated At Least Three Times1050. Actors and Directors Who Cooperated At Least Three Times 題目敘述 SQL Schema > Create table If Not Exists ActorDirector (actor_id int, director_id int, timestamp int) Truncate table ActorDirector insert into ActorDirector (actor_id, dir...Feb 2, 2023
LeetCode Solution, Easy, 182. Duplicate Emails182. Duplicate Emails 題目敘述 SQL Schema > Create table If Not Exists Person (id int, email varchar(255)) Truncate table Person insert into Person (id, email) values ('1', 'a@b.com') insert into Person (id, email) values ('2', 'c@d.com')...Feb 2, 2023
LeetCode Solution, Easy, 511. Game Play Analysis I511. Game Play Analysis I 題目敘述 SQL Schema: Create table If Not Exists Activity (player_id int, device_id int, event_date date, games_played int) Truncate table Activity insert into Activity (player_id, device_id, event_date, games_played) values ('1'...Feb 2, 2023
LeetCode Solution, Easy, 1729. Find Followers Count1729. Find Followers Count 題目敘述 SQL Schema > Create table If Not Exists Followers(user_id int, follower_id int) Truncate table Followers insert into Followers (user_id, follower_id) values ('0', '1') insert into Followers (user_id, follower_id) value...Jan 30, 2023
LeetCode Solution, Easy, 1693. Daily Leads and Partners1693. Daily Leads and Partners 題目敘述 SQL Schema > Create table If Not Exists DailySales(date_id date, make_name varchar(20), lead_id int, partner_id int) Truncate table DailySales insert into DailySales (date_id, make_name, lead_id, partner_id) values...Jan 30, 2023