Course Details
Course Details
What You'll Learn
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
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
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
is an accomplished IT and data specialist with over 20 years of experience in academia, ICT leadership, and professional training, with a strong focus on data analytics and Excel-based solutions. He has developed and delivered specialized training programs on Statistical Data Analysis with Excel and Visual Basic for Applications (VBA) for Excel, equipping learners with advanced data manipulation, automation, and reporting skills. His expertise extends to automating institutional reporting systems, where he successfully streamlined academic records management through Excel-based tools, integrating macros and automation to improve efficiency and accuracy. As a trainer and consultant, Dr. Siraj has taught Excel to diverse audiences, including university staff, administrative teams, and professionals in banking, security, and education, ensuring they can apply Excel for decision-making, statistical modeling, and process automation. His practical mastery of Excel is complemented by his deep knowledge of office automation and ICT project management, making him a highly sought-after trainer in data analysis and productivity tools. With his blend of hands-on technical expertise and instructional experience, Dr. Siraj stands out as a credible authority in leveraging Excel to drive organizational efficiency and data-driven strategies
Review
Customer Reviews (5)
- Engaging trainer Review by Course Participant/Trainee
-
The training was very practical and hands-on. I could apply what I learned to my work immediately. (Posted on 12/24/2025)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 - Very useful course Review by Course Participant/Trainee
-
Very informative and interactive. The small class size meant we got a lot of personal attention. (Posted on 11/28/2025)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 - Great learning experience Review by Course Participant/Trainee
-
The course content was comprehensive and up to date. The practical exercises were the best part. (Posted on 8/8/2025)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 - Knowledgeable trainer Review by Course Participant/Trainee
-
Good hands-on training with plenty of examples. I feel much more confident applying these skills now. (Posted on 1/4/2025)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 - Fantastic experience Review by Course Participant/Trainee
-
Well organised course with clear objectives. The step-by-step approach made it easy to follow. (Posted on 10/6/2024)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
Write Your Own Review
- Recommended Courses