Course Information

  • Sessions 1 day
  • Duration 7.5 hrs
  • Level Beginner
  • Assessment NA

Venue

12 Woodlands Square #07-85/86/87 Woods Square Tower 1, Singapore 737715. 5 mins walk from Woodlands (NS9) MRT station.

The venue is disabled-friendly.

Course Brochure

Prerequisite

This course is for beginners. No prerequisite is required.

Certification

  • Certificate of Achievement from Tertiary Infotech Academy Pte Ltd - Upon meeting at least 75% attendance and passing the assessment(s), participants will receive a Certificate of Achievement from Tertiary Infotech Academy Pte Ltd.

SQL Masterclass

Course Code: C024
Share

What's This Course About

SQL Masterclass gives you the practical skills to store, query, analyse and transform data using Structured Query Language, the universal language of relational databases. Whether you work with MySQL, PostgreSQL, SQL Server or a cloud data platform, SQL lets you answer business questions directly from the data instead of waiting for reports. The masterclass is designed for analysts, developers, business users and anyone who wants a solid, hands-on foundation in working with databases.

You will begin with data modelling, learning how relational databases are structured, how to design tables, choose data types and define primary keys, foreign keys and relationships. Next you will move into data processing and analysis, writing queries to create, read, update and delete records, filter and sort results, and use aggregate functions with GROUP BY and HAVING. You will then join multiple tables, write subqueries and use common table expressions to answer more complex questions.

The course continues with data transformation, covering string, date and conditional functions, views and techniques for cleaning and reshaping data for reporting. Finally, you will get an introduction to data warehousing, including fact and dimension tables, star schemas and how SQL supports business intelligence and dashboards. Every topic includes guided exercises on a real database. By the end, you will be able to design simple databases and write efficient SQL queries to turn raw data into reliable insights.

Why Take This Course?

  • Hands-On Learning Learn by doing. Every topic is practised hands-on, so you leave with skills you can use at work straight away.
  • Live Coaching Experienced instructors coach you live, answer your questions and guide you step by step.
  • Free Post-Course Consultation Stuck after class? Message your trainer any time for guidance as you apply what you have learned.
  • Always-Updated Materials Materials are refreshed to stay relevant. Log in to our LMS any time to get the latest version.

Funding Options

No funding is available for this course

For WSQ funding, please checkout the details at WSQ - SQL Fundamental for Beginners

Course Fee

$350.00 (GST-exclusive)
$381.50 (GST-inclusive)

Course Date

Course Time

* Required Fields

Additional Note

Please bring your own laptop for hands-on training. If you don't have laptop, we can provide spare laptop for training use.

Post-Course Support

  • We provide free consultation related to the subject matter after the course.
  • Please email your queries to enquiry@tertiaryinfotech.com and we will forward your queries to the subject matter experts.

Cancellation & Reschedule Policy

  • You can register your interest without upfront payment. There is no penalty for withdrawal of the course before the class commences.
  • We reserve the right to cancel or re-schedule the course due to unforeseen circumstances. If the course is cancelled, we will refund 100% for any paid amount.
  • Note the venue of the training is subject to changes due to availability of the classroom.

Course Details

Course Details

What You'll Learn

Topic 1: Data Modeling

Topic 2: Data Processing and Analysis

Topic 3: Data Transformation

Topic 4: Introduction to Data Warehouse

Course Info

Minimum Entry Requirement

Knowledge and Skills

  • Able to operate using computer functions
  • Minimum 3 GCE ‘O’ Levels Passes including English or WPL Level 5 (Average of Reading, Listening, Speaking & Writing Scores)

Attitude

  • Positive Learning Attitude
  • Enthusiastic Learner

Experience

  • Minimum of 1 year of working experience.

Target Age Group: 18-65 years old

Minimum Software/Hardware Requirement

Software:

You will need the following for this course:

Hardware: Windows PC or Mac laptop

Job Roles

Job Roles

  • Database Administrator
  • Data Analyst
  • Business Analyst
  • Systems Analyst
  • IT Support Specialist
  • Back-End Developer
  • Report Developer
  • Data Scientist (beginner level)
  • Financial Analyst (working with databases)
  • CRM Administrator
  • ERP Specialist
  • Marketing Analyst
  • HRIS Specialist
  • Product Manager (data-driven products)
  • Technical Project Manager

Trainers

Trainers

Dr. Alvin Ang is a data scientist and data science educator with a PhD in Operations Research, an MSc in Logistics and a BEng in Mechatronics, Robotics and Automation Engineering, all from Nanyang Technological University. Operations research is the mathematics of better decisions, and his published work on Kanban production-control systems at IEEE conferences reflects the quantitative rigour he brings to every class. He has served as an IBM Data Science Instructor, a Research Fellow at NUS, a Principal Consultant in data science and an Assistant Professor of Mathematics at SP Jain School of Global Management, where he was named Mathematics Professor of the Year, and he lectured undergraduates in statistics and quantitative methods at SUSS. Since 2021 he has trained professionals at Tertiary Infotech in Python, R, SQL, statistics, Excel analytics, Tableau, Power BI, Apache Spark, machine learning and deep learning, and he founded DataFrens.sg, a community for data scientists in Singapore. An ACLP-certified adult educator, he is known for connecting technical concepts to practical, real-world applications, a strength echoed in hundreds of learner recommendations.

In SQL Masterclass, Dr. Ang teaches SQL the way data scientists use it every day: designing and querying relational databases, filtering, sorting and aggregating data, joining tables, writing subqueries and building the clean datasets that analysis and dashboards depend on. Having taught SQL alongside Python, R and statistics, he shows learners how to ask good questions of their data and write clear, efficient queries.

Ken Hiong is a ACTA certified trainer. Ken has over 20 years of work experience in the healthcare and pharmaceutical industry, having assumed various functional and managerial roles in sales, marketing, business development, finance, business analysis and planning. With an interest and experience in scripting, Ken has worked on projects using HTML, CSS, PHP, MySQL, WordPress, MS Office, VBA, Power BI, etc. Notably, Ken is a proven expert Excel user at work who has made efficient many work processes, improved data analysis and enhanced the quality of business planning and reporting for organizations. Ken graduated with a Pharmacy degree, holds a Master of Business Administration from the National University of Singapore and a Master of Applied Finance from the University of Adelaide. An ardent advocate of lifelong learning, Ken is ACTA trained and seeks to continually upgrade his IT skills through various channels of learning and Microsoft certifications. With MS Office Master qualification, Ken looks forward to assisting individuals and corporations improve their computer skills, productivity and business outcomes.

Peter Goh is a ACTA certified trainer. Peter Goh is the Technology Evangelist at Disruptive Digital, a full-service digital agency based in Singapore, offering innovative & effective web and native mobile application development. He specializes in bleeding edge software development and have more than 10 years' experience in developing customized applications for desktop, web and mobile platforms. He has extensive domain knowledge in .Net and Java programming, iOS development and has helped many to create e-commerce web sites on Amazon AWS and Microsoft Azure.

Mohamed Afiq is a ACTA certifed trainer. Mohamed Afiq startup CTO for 3 years building proprietary delivery system from scratch and then managing a team of 20 developers. He builted multiple web apps using MEAN or similar stacks. He is also a founder and sole developer for PlayTours: https://playtours.app/ . He leads instructor at CodeNinja, teaching coding to kids 9-16 years old and teach adults front-end and back-end for web development.

Review

Customer Reviews (35)

Will Recommend Review by Course Participant/Trainee
1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment
. (Posted on 7/29/2019)
Will Recommend Review by Course Participant/Trainee
1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment
. (Posted on 4/8/2019)
Will Recommend Review by Course Participant/Trainee
1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment
Trainer exceeds my expectation. He shares valuable knowledge.

A more conducive venue (Posted on 3/29/2019)
Will Recommend Review by Course Participant/Trainee
1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment
The training facilities need to be improved. There was a lot of ants on the table and the laptop provided was not prepared before hand hence there was a slight delay as the trainer needs to uninstall and install a fresh copy of software application.

Might consider recommending if the trainer is good. Deen is good and very knowledgable. (Posted on 2/26/2019)
Might Recommend Review by Course Participant/Trainee
1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment
More examples (Posted on 12/21/2018)

Items 21 to 25 of 35 total

per page
Page:
  1. 1
  2. ...
  3. 3
  4. 4
  5. 5
  6. 6
  7. 7

Write Your Own Review

You're reviewing: SQL Masterclass

How do you rate this product? *

  1 star 2 stars 3 stars 4 stars 5 stars
1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment