Computer Academy

SQL FOR DATA ANALYSIS

Enquire Now

Course Information

Schedules
  • 10 Aug 2021 (Tue) - 11 Aug 2021 (Wed) 10:00 AM - 12:30 PM
Registration period
18 Apr 2021 (Sun) - 20 Jul 2021 (Tue)
Price
HKD 2,800
Course Level
Study Mode
Duration
2 Day(s)
Language
Cantonese
Location
Room 603 Dominion Centre, 43-59 Queen's Road East Wanchai, Hong Kong
7 views

Course Overview

This SQL training course will teach students how to write SQL statements to speed up the data analysis process. SQL is the standard language for relational database management systems and is used to communicate with a database. Most of the data processing tasks done under Excel, such as joining tables, calculation, extracting data or data query, can also be accomplished well with SQL. It can even outperform Excel in the context of large volume of data.

Students will be guided through a series of exercises starting from writing simple SQL statements to more complex statements at the end of the course. They will learn how to query data from multiple tables using inner or outer joins methods.

This is an ideal course for analysts who are looking for more efficient ways to analysis and managing data or tools to work in conjunction with Excel.

 

What you'll learn

What you’ll learn

  • An Overview of Relational Databases
  • Getting Results From Multiple Tables
  • Using Standard SQL Functions
  • Introducing SQL
  • Grouping and Summarizing Results
  • Retrieving Data with SQL: First Steps
  • Grouping and Summarizing Results
  • Inserting, Updating and Deleting Data
  • Using WHERE to Filter Results


We use cookies to enhance your experience on our website. Please read and confirm your agreement to our Privacy Policy and Terms and Conditions before continue to browse our website.

Read and Agreed