You have no items in your shopping cart.
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
h2>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:
TBD
Hardware: Window or Mac Laptops
/p>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.
Write Your Own Review
You May Be Interested In These Courses
GraphQL Query Language: Mastering Data Retrieval and Manipulation
$300.00 (GST-exclusive)
$327.00
(GST-inclusive)
