Are you in the right region?
These are the sessions we offer for Introduction to SQL in Asia.
We also have sessions for this course in:
Australia
New Zealand
27 - 28 Jul, 2023
8am - 1pm SGT
What is the course like?
Do you need to analyse and work with large volumes of data?
For anyone looking to improve their knowledge of SQL (Structured Query Language) this course will teach you how to write SQL SELECT statements to retrieve and analyse your data from a relational database.
You'll learn
During this course you will learn about:
- Writing SQL SELECT statements in a structure way, starting with visualising the desired output.
- Ordering the data according to your needs.
- Filtering the records to get only the relevant information.
- Using expressions and scalar functions to transform the data.
- Using inner joins to read data from multiple tables simultaneously.
- Finding unmatched records with outer joins.
- Using aggregate functions to summarise your data
- Reclassifying your data with new criteria.
Great for
Anyone who needs to be able to access relational data using SQL, including:
- Developers.
- Test analysts and engineers.
- Business and systems analysts.
- Data analysts.
You'll need
There are no prerequisites for this course.
Pricing
Need more information?
Meet the course trainers
Here's what our customers are saying:
This course provided a sound knowledge of SQL. It was very informative and provided lots of exercises which helped to expand the theory.
- Teresa Glen, Victoria University
I feel a lot more confident with SQL now - not only do I know how to do things, but also why.
- Cara Marshall, Kiwibank
Colin was excellent in his presentation and enthusiasm for the subject matter and communicated extremely well.
- Tim Jones, ANZ
Absolutely fantastic! I would recommend both this course and SoftEd to anyone.
- Tamara Bardell, MSD
I thought the course was extremely beneficial for my needs.
- Tony Hardy, AGL