| 課程編碼 Course Code | 中文課程名稱 Course Name (Chinese) | 英文課程名稱 Course Name (English) | 總學分數 Credits | 總時數 Hours |
|---|---|---|---|---|
| 5705513 | SQL數據分析與商業智能 | MySQL for Data Analytics and Business Intelligence | 3.0 | 3 |
| 中文概述 Chinese Description | 根據 Kaggle Survey2020（全球資料科學家調查），SQL在資料科學家使用的程式語言中，排名第二，僅次於 Python。SQL 是用來查詢與操作資料庫的語言，是數據分析與商業智能的重要工具。本課程以mySQL資料庫為對象，來學習關聯式資料庫的操作與各種SQL語法，它是整體商業智能分析體系的重要技術。在現代商業智慧領域，經常利用SQL資料庫、雲平臺和機器學習等新技術，將資料轉換為有用的見解，提出解決方案以改進企業決策，其應用包括零售葉在內的各種經營管理領域。本課程將幫助同學具有SQL分析數據的能力，此將有助於後續做好商情預測，提出改善方案以輔助企業能抓住市場脈動，進而分析消費者的需求。 | |||
| 英文概述 English Description | According to Kaggle Survey2020, SQL ranks second among the programming languages used by data scientists, second only to Python. SQL is a language used to query and operate databases, and is an important tool for data analysis and business intelligence. This course takes the mySQL database as the object to learn the operation of the relational database and various SQL syntax, which is an important technology of the overall business intelligence analysis system. In the field of modern business intelligence, new technologies such as SQL databases, cloud platforms, and machine learning are often used to convert data into useful insights and propose solutions to improve corporate decision-making. It is applied to various business management fields including retail leaflets. This course will help students have the ability to analyze data with SQL, which will help to make good business forecasts in the future, propose improvement plans to assist enterprises to grasp the pulse of the market, | |||
| 核心能力指標 | 1.獲取基礎性的商業知識及相關能力 2.應用有效的口語及書寫溝通 4.能夠在團隊合作中有生產性的合作及有效率的運作 | |||
備註：