All courses delivered remotely. Instructor-led, live online.

SQL Header

SQL Intermediate Course - Hong Kong

Take your SQL skills up a level

Our Intermediate SQL course builds upon the skills learnt in our SQL Beginner course.

In this SQL course, you will move beyond using basic SELECT clauses for retrieving data. Learn to work with many different types of functions and expressions that modify the way data is returned in the result set. Students will use built-in T-SQL functions for working with string, date and numeric data types and will calculate moving averages, running totals and percentages using window functions. 

Learn to use subqueries to perform more complex querying and to use views to to simplify querying. Students will also create their own user-defined functions to encapsulate business logic and improve efficiency. Read our course outline below.

SQL Intermediate Course - Hong Kong

Take your SQL skills up a level
HK$3,190
10 max
1 day

Hong Kong

Upcoming Courses:
Hong Kong
Date
Course
City
Status
Tue 24 Jan 23
Tue
24
Jan
SQL Intermediate
Hong Kong
Status: Scheduled
Scheduled
Thu 23 Feb 23
Thu
23
Feb
SQL Intermediate
Hong Kong
Status: Scheduled
Scheduled
Fri 24 Mar 23
Fri
24
Mar
SQL Intermediate
Hong Kong
Status: Scheduled
Scheduled
Mon 24 Apr 23
Mon
24
Apr
SQL Intermediate
Hong Kong
Status: Scheduled
Scheduled
Tue 23 May 23
Tue
23
May
SQL Intermediate
Hong Kong
Status: Scheduled
Scheduled
Wed 21 Jun 23
Wed
21
Jun
SQL Intermediate
Hong Kong
Status: Scheduled
Scheduled
Scheduled
Taking enrollments.
Confirmed
Taking enrollments.
Few Seats left
Book Now.
Sold Out
Try another date.

Frequently Asked Questions

Meet your Developer

Tamara Shatar holds a PhD in Agricultural Data Science. She has extensive experience, including many years working as a research scientist focused on data analysis, modelling using machine learning, simulation and other techniques. While working in both academia and at the CSIRO, part of her role included teaching a variety of data analysis skills.

What is Remote Training?

Remote training at Nexacu, means our team of experienced trainers will deliver your training virtually. With remote learning students can access our usual classroom training courses via video conferencing, ask questions, participate in discussion and share their screen with the trainer if they need help at any point in the course. Students have the same level of participation and access to the trainer as they would in classroom training sessions.

SQL Intermediate Hong Kong Course Details

Price
HK$3,190
Duration
1 day
Times
9am - 4pm ( approx )
Class Size (max)
10
Class Size (avg)
5
Reference Materials
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Live Online
Address
16F & 17F
700 Nathan Road
Kowloon
Hong Kong
microsoft_gold
deloite_logo

SQL Course Outlines

Other Courses
Microsoft Power BI Training Courses
Microsoft Excel Training Courses
Microsoft Office 365 Training Courses
Excel Specialist Training Courses
Microsoft Project Training Courses
R Programming Training Courses
Python Training Courses
Power Apps Training Courses
SharePoint Training Courses
Power Automate Training Courses
Microsoft Teams Training Courses
Microsoft Visio Training Courses
Microsoft PowerPoint Training Courses
Microsoft Word Training Courses
Other Courses
Course Rating
SQL Training Courses

4.72 5 SQL Training Courses
4.72 out of 5
48289 Student Reviews

Skills Test


Try our short skills tests and
find out which course is right for you.

Skills Test Icon

 skills test

 

Contact Us


What do I need to know to attend?

This course builds on the knowledge gained and skills taught in our SQL Beginner course.
Students must be familiar with writing SQL queries.

SQL Intermediate Hong Kong Learning Outcomes

In this course, you will:

  • work with an Azure SQL database
  • write queries in Transact-SQL (T-SQL)



  • learn to use T-SQL built-in functions
  • learn to create user-defined functions
  • learn to write subqueries and create views

SQL Intermediate Hong Kong Course Content

  • Introduction
  • SQL and T-SQL
  • Data Types
  • Conversion between data types
  • CAST, CONVERT and PARSE
  • Functions in SQL
  • Built-in Functions
  • Aggregate Functions
  • Scalar Functions
  • Ranking Functions
  • User-defined functions
  • Aggregate Functions and Group By Extensions
  • GROUP BY CUBE, ROLLUP and GROUPING SETS
  • CASE and CASE alternatives
  • COALESCE
  • NULLIFF
  • String Functions
  • Concatenate, replace and format
  • Date and Time Functions
  • Get today's date
  • Calculate date/time differences
  • Calculate a new date
  • Extracting date components
  • Creating dates
  • Logical Functions
  • IIF
  • CHOOSE
  • GREATEST and LEAST
  • Mathematical Functions
  • ROUND, CEILING and FLOOR
  • Writing More Complex Queries
  • Subqueries
  • Local Variables
  • Views
  • Window (Analytic) Functions
  • OVER clause
  • PARTITION BY
  • ORDER BY
  • ROWS or RANGE
  • Calculate group totals, averages, percentages, and running totals
  • LAG and LEAD
  • FIRST_VALUE, LAST_VALUE
  • Ranking Functions
  • ROW_NUMBER
  • RANK and DENSE RANK
  • NTILE
  • User-Defined Functions
  • Create, use, and modify scalar user-defined functions
  • Schemas

Contact Us

Why Nexacu? 

Valued by Individuals

4.72 / 5
Over 48289 Reviews

Trusted by Business

Awards and Accreditations

Follow us