資訊科技產業專案設計作業三

# 資訊科技產業專案設計作業三 ## [Google : Cloud Database Migration Engineer, Professional Services](https://careers.google.com/jobs/results/130132888034124486-cloud-database-migration-engineer-professional-services/?distance=50&q=database) ### Minimum qualifications: + Bachelor's degree in Computer Science, Mathematics or related field, or equivalent practical experience. + Experience writing software in Java, C++, Python, Go, and/or JavaScript. + Experience with database technologies such as PostgreSQL, MySQL, SQL Server, Oracle. + Experience with database administration techniques. ### Preferred qualifications: + Experience working with cloud databases such as RDS, Aurora, DynamoDb, ElastiCache, CloudSQL, Datastore, Firestore, or Cloud Spanner. + Experience developing ELT or ETL workflows. + Experience with data migration strategies and moving large scale production systems either in on-premise/data center environments or migration to cloud scenarios. + Experience in technical consulting. + Experience with database performance tuning and database management tools for backups, recovery, snapshot management, partitioning. + Knowledge in Query troubleshooting such as isolating blocks of poor performing SQL, determining root cause, and developing remediation actions ## [Qualcomm : Data Analytics Engineer | US CITIZENSHIP](https://qualcomm.wd5.myworkdayjobs.com/zh-CN/External/details/Data-Analytics-Engineer---US-CITIZENSHIP_3041732?q=database&timeType=5ebcee80aebb017408ba0a98c2495a00) ### Minimum Qualifications: * Bachelor's degree in Engineering, Information Systems, Computer Science, or related field and 4+ years of Software Engineering or related work experience. OR * Master's degree in Engineering, Information Systems, Computer Science, or related field and 3+ years of Software Engineering or related work experience. * OR * PhD in Engineering, Information Systems, Computer Science, or related field and 2+ years of Software Engineering or related work experience. * 2+ years of experience with Programming Language such as C, C++, Java, Python, etc. * Bachelor’s Degree in a technical discipline * 8+ years’ experience in data/software engineering * Professional experience in the following: * Programming skills in at least one language, e.g. Python * Relational database technology * Cloud technology and deployments ## [2022 IRO-5G/LTE SW Engineer - Data](https://qualcomm.wd5.myworkdayjobs.com/zh-CN/External/details/XMLNAME-2022-IRO-5G-LTE-SW-Engineer---Data_3044522-1?q=database&timeType=5ebcee80aebb017408ba0a98c2495a00) ### Minimum Qualifications: * Bachelor's degree in Engineering, Information Systems, Computer Science, or related field. ### Preferred Qualifications: * 1+ year of experience with Programming Language such as C, C++, Java, Python, etc. * 1+ year of experience with Database Management Software. * 1+ year of experience with API. * 1+ year of experience working in a large matrixed organization. ## 自身評估 * Have experience with Programming Language such as C. * Have experience with database technologies such as MySQL. * lack of developing ELT or ETL workflows. * lack of cloud technology and deployments ## 模擬面試 :face_with_monocle: : Interviewer :nerd_face: : Interviewee :face_with_monocle: :你好，我是今天負責你面試的人，可以請先你簡短的簡介一下你的經歷嗎，以及為什麼會想要投這份工作嗎? :nerd_face: : 你好，我大學跟研究所都是就讀資訊工程學系的，所以一些相關的背景知識都有一定程度的了解，因為個人對於使用資料庫系統有過一些經驗，而且對於這部分也相當的有興趣，所以想學習到更多有關於這方面的知識。 :face_with_monocle: : 那可以簡單說明你有過什麼資料庫系統相關的經驗嗎? :nerd_face: : 我之前在大學時有修過資料庫系統的課程，對於使用MySQl對資料庫進行操作有一定的了解，而且也有學習如何對應需求設計ER-diagram，在目前碩士也有做一些資料庫系統相關的開發工作。 :face_with_monocle: : 好，談談你對index的理解？ :nerd_face: : index是資料列裡面關鍵字或是代表字的列表，主要功能就是可以讓在對資料進行查詢的時候更加快速的找到所要查詢的資料。 :face_with_monocle: : 那是不是index建立得越多越好？ :nerd_face: : 不是，index可以加快查詢的速度，但是index變多也會導致輸入資料時所需要插入的值也變多，所以最好的方法是適量的使用適合的index。 :face_with_monocle: :那可以請你簡單的用SQL寫出下列搜尋語句嗎? 請依照學號排序出數學分數大於80的學生名子。 :nerd_face: : ```sql SELECT Name FROM Students WHERE Math > 80 ORDER BY SID ``` :face_with_monocle: : 請解釋以下不同類型JOIN的差別。 ![](https://i.imgur.com/ekhlCTP.png) :nerd_face: : INNER JOIN 是產生出來的表格不管原先是左表還是右表，符合ON條件的列表會被合併且只會有共同存在原先兩個表的欄位會顯現。 FULL JOIN 是產生出來的表格不管原先是左表還是右表，符合ON條件的列表會被合併且原先兩個表的欄位都會顯現。 LEFT JOIN 是產生出來的表格不管原先是左表還是右表，符合ON條件的列表會被合併且只會有存在原先左表的欄位會顯現。 RIGHT JOIN 是產生出來的表格不管原先是左表還是右表，符合ON條件的列表會被合併且只會有存在原先右表的欄位會顯現。 :face_with_monocle: :好，今天的面試到此為止，謝謝你的配合。 ## 參考資料 1.[Database Engineer Frequently Asked Interview Questions](https://www.gushiciku.cn/pl/gA8z/zh-tw) ## 檢討在看完各種職缺的要求過後，更讓我知道自己未來應該要先往哪個方向去進行前進，先找好一個目標擬定策略，這樣才比較好去提升自己，如果只是各方面都看一點那對未來找工作的效益沒有到很大。