Course Information
Schedules
- 22 Jan 2025 (Wed) - 23 Jan 2025 (Thu) 2:00 PM - 2:30 PM
Registration period
21 Nov 2024 (Thu) - 1 Jan 2025 (Wed)
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
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
