Targeted Training

商業分析-數據庫查詢

在12小時內學懂以數據庫操作進行商業分析

以更快速及安全的方式處理和分析大數據

隨著數據主導的世界來臨，每天企業也會收集大量商業數據並儲存在數據庫。善長文書處理的 Excel 電子表格是很好的小型數據分析工具，卻不足以應付大數據分析。在課程中，你會學習如何以 SQL 與數據庫溝通，並進行數據分析及預測客戶行為，供貨需求，最後向別人展示分析結果。完成課程後，你會懂得在數據庫中抽取數據以解答不同的商業問題。

以大數據進行商業分析的必備技能

課程編號： de04
單元總數： 單元
教學語言： 廣東話

價錢： $1,800/6 節
自習時間： 每星期1至2小時
適合： 追求以大數據進行不同商業分析如預測客戶行為，供貨需求

立即報名

聯絡我們

學生評語

課程大綱

我們傳授的不只是知識，而且是在職場上極具價值的編程技能

SQL數據庫操作

介紹關聯式數據庫
學習在數據庫建立及修改數據
學習在數據庫更新及刪除數據

SQL數據查詢

學習用 SELECT 及 WHERE 語句選取數據
學習用 DISTINCT 語句選取唯一數據
學習用 BETWEEN , LIKE 及 ORDER BY 語句篩選及排列數據

SQL聚合函數 (Aggregate functions)

學習用 COUNT , SUM , MAX 及 MIN 語句比較及計算數據
學習用 GROUP BY 語句根據指定特質把數據分組

多表格 (tables) 操作

學習用 INNER JOINS 及 LEFT JOINS 語句組合不同表格
學習用 CROSS JOIN 及 UNION 語句連接不同表格

課程結構

最高價值的6節課堂

講課

在講課中你會學習所有必需的概念。講課聽起來很沉悶，DANGER 的講課卻是例外! 上課時請帶備你的電腦，在每一節課90%時間你都需要在所學的知識上動手指。

親自動手

你會在我們設計的行業實例上練習講課所學的技能。要真正學懂數據科學，你必需經歷這些難題。

考試

完成一系列的講課和練習後，讓大家通過考核認識自己的成就及考取相關證書。

課程特色

超越網上課程及你的預期

即時交流

網上課程預先為你提供沒有錯誤的程式。我們的教學團隊則為你提供即時指導去解決編程時遇上的錯誤及難題。透過緊密交流，我們確保每位學生都能跟上進度 (即使你是遙距上課）

運算思維

在學習編程的過程中，思維方式比熟讀語法更為重要。我們認為運算思維是編程中最高價值的元素。我們以運算思維為主的課程會帶領你以正確的方式學習數據科學及編程。

電腦是非常快速、準確和愚蠢。人類是非常緩慢、失誤多和聰明。兩者的結合是一股無法估計的力量。

Leo Cherne

現正招生

哪個時段比較適合你?

暫無排程，請留意我們的開班公布。

立即報名

Through participating in Danger Education’s courses such as Python Explorer and Python Practitioner, I can learn some basic Python programming knowledge and how to manipulate python libraries to analyse data. The teachers are patient and willing to teach us to solve our problems.

Tony Or - Python Student since Dec 2020

Being someone who have no background in programming and computer science, It's hard to figure out how to make a career switch into data science. Danger education provides the "Zero to Hero" pathway at an affordable rate.

Anthony Leung - Python and SQL Student since Feb 2021

As a HR professional, with growth of HR cloud applications, people analytics are becoming vital for all aspects of operational improvement to drive business goals. With my knowledge of Python instructed by Danger, I am able to analyse people's data moving away from Excel. Courses from Python Explorer, Python Practitioner and Python Machine Learning prepared me with real life examples on how we analyse data from scratch. Instructors are friendly and nice like friends which provide a comfortable environment to learn coding even though I had absolutely no idea on coding. I am happy to have joined the world of Python with Danger Education.

Coco Mak - Python and Machine Learning Alumni since Aug 2020

Jason is a professional instructor who is knowledgeable and patient enough to walk me through the coding process. The course consolidated my mathematical foundation, as well as practical coding fundamentals (like how to use python to call on different functions), which are all deemed to be the stepping stones to become a successful data scientist. I sincerely recommend this course to those who are interested in learning data science.

Cathy Kam - Python and Machine Learning Alumni since Aug 2020

Pretty awesome tutorial, start from the basics concept, broad and expounds the necessary knowledge with a specific framework and sufficient reference content, case studies, and project for students to practice. Suitable for beginners to find directions here.

Ar Chu - Python Student since Jan 2021

Having completed all courses in Danger Education, I become an experienced data analyst. The teachers are so helpful and well prepared. They gave us thorough and comprehensive notes and practice. In addition, they presented so well that even some complicated concepts could be well digested. The machine learning course help me further understand what data scientists’ work. This course is recommended for all people who are just beginners or even junior data analysts/programmers to better gain knowledge of data science.

Charlie Yeung - Python and Machine Learning Alumni since Apr 2020

Danger teaches me the skills in coding, but more importantly, it provides capable tools to discover another side of language. As a researcher in humanities, I had a preliminary understanding of Natural Language Processing through the Machine Learning Explorer course. Now I’m planning to apply my Python skills to my linguistic research.

Max Lee - Python and Machine Learning Alumni since Sep 2019

The series of Data Science courses in Danger Education is well-structured and organized. The trainers are knowledgeable and manage to provide valuable insights of coding skills and data science world in practice. The courseware contents are very rich and can pinpoint the key learning areas of different topics with real life applications. The excellent quality of teaching is of the greatest attraction. Thank you again for offering such a high quality of Data Science journey!

Steven To - Python and Machine Learning Alumni since Oct 2020

This course is well designed to let students understand the basic syntax of Python in 8-week. Lecture materials with weekly hands-on projects are well prepared and developed for practicing. The instructor gave clear explanation and care students’ progress all the way along the lecture, enable us not to get loss during the time. I will highly recommend the course to those who wish to learn about the data analysis tools using Python.