Targeted Training

Business Analytic: Database Query

Explore the power of asking the database directly on what you want and discover insights, in 12 hours

Manage and visualize big data in a quicker and safer way

With the advent of a data-driven world, the amount of data continues to increase, many businesses store their information inside a large relational database/data-warehouse. Excel Spreadsheet is good for presentations and small analyses but it is inadequate for Big Data analysis. In this course, you will learn basic database language and the mechanism of database. At the end of the course, you will be capable of retrieving data from databases and discovering insights with handy analysis tools as a data analyst.

Navigate and visualize the database for big data analysis

Course Code: de04
Total unit: units
Medium of teaching: Cantonese

Price: $1800/6 sessions
Homework time: 1 to 2 hours per week
For who: Analyst who would like to retrieve and visualize data directly from database for big data analysis

Apply Now

Talk to us

Student Review

Curriculum

We teach you employable Programming skills, not just knowledge, step by step

SQL database manipulation

Concept of relational database
CREATE and ALTER the data in database
UPDATE and DELETE the data in database

SQL data queries

SELECT the data WHERE we want
Identify DISTINCT values
Filter values BETWEEN a range, LIKE similar values and ORDER BY particular order

SQL aggregate functions

Find COUNT, SUM, MAX and MIN values
GROUP BY data by certain characteristics

Multiple tables operations

Combine the tables with INNER JOINS and LEFT JOINS
Combine the tables with CROSS JOIN and UNION

Course Structure

High value 6 lessons package

3 Lectures

You will learn all the essential concepts during these lectures. Lectures sound boring, but not in DANGER! Come with your laptop, you will need to move your fingers over what you have learnt 90 percent of the time in lectures.

2 Hands-on exercises

You will practice what you have learnt on the real-world industry use cases and case studies we have designed for you. You can never actually learn programming before you try these challenges.

1 Exam

After completing a series of lectures and hands-on exercises, let us review how much you have achieved and earn the Certificate to prove your success.

Course Features

More than online course and Exceed your expectation

Real-Time Interaction

Online course provides you with scripted code without any bugs. Our teaching team provides you with immediate feedback to fix the bugs and difficulties encountered during programming. Through frequent interaction, we ensure every student is on track (even if you attend the lecture remotely!)

Computational Thinking

To master programming, the way of thinking is more important than memorizing language syntax. Focusing on Computation Thinking, the most valuable element in programming we believe, our course will lead you to the right way of learning programming.

The computer is incredibly fast, accurate, and stupid. Man is incredibly slow, inaccurate, and brilliant. The marriage of the two is a force beyond calculation.

Leo Cherne

Recent Openings

What is your next availability?

No upcoming class schedule, stay tuned!

Apply now

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.