Course Information
Schedules
- 20 Feb 2025 (Thu) - 6 Mar 2025 (Thu) 7:00 PM - 9:30 PM
Registration period
25 Nov 2024 (Mon) - 30 Jan 2025 (Thu)
Price
HKD 2,800
Course Level
Study Mode
Duration
3 Day(s)
Language
Cantonese
Location
Room 603 Dominion Centre, 43-59 Queen's Road East Wanchai, Hong Kong
6 views
Course Overview
SQL (Structured Query Language) is a powerful tool for managing and analyzing data. In this comprehensive course, you will learn how to leverage SQL to extract, manipulate, and analyze data for effective decision-making. Throughout the course, you will dive into various topics, including data retrieval, filtering and sorting, aggregating data, joining multiple tables and subqueries and nested queries.
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.
Whether you are a data analyst, business intelligence professional, or aspiring data scientist, this course will equip you with the necessary SQL skills to unlock insights from complex datasets.
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
