Home
SQL Masterclass

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.

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

35 Review(s) | Add Your Review

Unlock the secrets of database management with our SQL Masterclass. This comprehensive training is designed to equip you with the essential SQL skills needed for effective data management. You'll learn how to create, read, update, and delete data records in a database. The course also covers key SQL syntax, joins, and data retrieval techniques, providing you with a strong foundation for future learning and practical application.

But this course is about more than just the basics. You'll also explore important aspects of database design, including normalization and indexing. Learn how to write complex SQL queries to solve real-world data problems and gain insights into data analysis. These additional skills ensure that you can take full advantage of SQL's capabilities, making you a valuable asset in any data-driven organization.

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)

Mode of Training

Physical Classroom Training
Synchronised Teaching using ZOOM
Corporate Training at Company Premise

Course Date * Course Date

Course Time * Course Time: No. of Participants

Sponsorship

Self-Sponsored
Employer-Sponsored

Additional Message

* Required Fields

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

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.

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

Topic 1: Data Modeling

Data Sources

Data Modeling

SQL Data Types

Create and Manage Databases

Topic 2: Data Processing and Analysis

SQL Queries

SQL Operators

Topic 3: Data Transformation

Aggregate Data

Join Data

Group Data

Topic 4: Introduction to Data Warehouse

Overview of Data Warehouse

Relational Databases

Stored Procedure

Course Info

Promotion Code

Your will get 10% discount voucher for 2nd course onwards if you write us a Google review.

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:

Please down and install MySQL Community Server from the link below

https://dev.mysql.com/downloads/mysql/

Hardware: Window or Mac Laptops

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

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.

Dr. Alvin Ang is a ACTA certified trainer. Dr. Alvin Ang did his Ph.D., Masters and Bachelors from NTU, Singapore. Previously he was a Principal Consultant (Data Science) as well as an Assistant Professor. He was also 8 years SUSS adjunct lecturer. His focus and interest is in the area of real world data science. Though an operational researcher by study, his passion for practical applications outweigh his academic background. He owns a startup externally.

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 9/25/2018)

Bimala was very patient and knowledgeable. She was able to give us examples that cater to the context we gave. 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 classroom needs whiteboard markers that are working (Posted on 7/30/2018)

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

It's a good introductory class, unfortunately there's no further advanced class on this topic. (Posted on 5/28/2018)

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

More exercise on Joining tables

Students experience issues installing MySQL in macbook (Posted on 3/22/2018)

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

Provide step-by-step instructions to install the software into our personal laptops.
Print handouts before lesson starts so that even if instructor over-writes the handout, we can follow the exercise with less unnecessary mistakes. (Posted on 3/23/2017)