You have no items in your shopping cart.
Course Details
Topic 1 Data Modeling
- Data Sources
- Data Modeling
- SQL Data Types
- Install MySQL and Workbench
- 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: 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: 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: 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: 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.
Customer Reviews (35)
- Will Recommend Review by Course Participant/Trainee
-
. (Posted on 7/30/2019)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 - Will Recommend Review by Course Participant/Trainee
-
. (Posted on 4/8/2019)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 - Will Recommend Review by Course Participant/Trainee
-
Trainer exceeds my expectation. He shares valuable knowledge.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
A more conducive venue (Posted on 3/29/2019) - Will Recommend Review by Course Participant/Trainee
-
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.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
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
-
More examples (Posted on 12/21/2018)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 - Will Recommend Review by Course Participant/Trainee
-
. (Posted on 12/16/2018)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 - Will Recommend Review by Course Participant/Trainee
-
Longer duration1. 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
Very insightful and gives me an appreciation of data management systems. (Posted on 10/25/2018) - Might Recommend Review by Course Participant/Trainee
-
. (Posted on 10/25/2018)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 - Might Recommend Review by Course Participant/Trainee
-
. (Posted on 10/25/2018)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 - Will Recommend Review by Course Participant/Trainee
-
nothing much to say1. 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 lecture explains us in details clearly and patiently. All the time she is engaging with us. I had enjoyed the course and gain much knowledge about the data from the course.
The training center staff are kind and friendly and helpful. (Posted on 9/28/2018) - Will Recommend Review by Course Participant/Trainee
-
. (Posted on 9/25/2018)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 - 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
-
the classroom needs whiteboard markers that are working (Posted on 7/31/2018)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 - Will Recommend Review by Course Participant/Trainee
-
It's a good introductory class, unfortunately there's no further advanced class on this topic. (Posted on 5/28/2018)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 - Will Recommend Review by Course Participant/Trainee
-
More exercise on Joining tables1. 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
Students experience issues installing MySQL in macbook (Posted on 3/22/2018) - Might Recommend Review by Course Participant/Trainee
-
Provide step-by-step instructions to install the software into our personal laptops.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
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)
