Course Information
Schedules
- 23 Jul 2024 (Tue) - 24 Jul 2024 (Wed)
- 23 Aug 2024 (Fri) - 6 Sep 2024 (Fri)
- 24 Aug 2024 (Sat) - 7 Sep 2024 (Sat)
Registration period
16 Feb 2024 (Fri) - 24 Aug 2024 (Sat)
Price
HKD 2,800
Course Level
Study Mode
Duration
7.50 Hour(s)
Language
Cantonese
Location
Room 603 Dominion Centre, 43-59 Queen's Road East Wanchai, Hong Kong
3 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
- An Overview of Relational Databases
- Introducing SQL
- Retrieving Data with SQL: First Steps
- Using WHERE to Filter Results
- Getting Results From Multiple Tables
- Using Standard SQL Functions
- Grouping and Summarizing Results
- Inserting, Updating and Deleting Data
