Course Details
Course Details
What You'll Learn
Topic 1 Get Started with Python
Overview
Install Python
Install Sublime Text & PyCharm
First Python Script
Comment
Topic 2 Data Types
Number
String
List
Tuple
Dictionary
Set
Topic 3 Operators
Arithmetic Operators
Compound Operators
Comparison Operators
Membership Operators
Logical Operators
Identity Operators
Topic 4 Control Structure
Conditional
Loop
Iterating Over Multiple Sequences
Break & Continue
Loop with Else
Topic 5 Function
Function Syntax
Return Single Value
Return Multiple Values
Passing Arguments
Default Arguments
Variable Arguments
Decorator
Lambda, Map, Filter
Topic 6 Modules & Packages
Modules
Packages
Python Standard Libraries
Install Third Party Packages
Anaconda Packages
Topic 7 Comprehensions & Generators
Comprehension Syntax
Types of Comprehension
Generator Syntax
Types of Generators
Topic 8 File and Directory Handling
Read and Write Data to Files
Manage File and Folders with Python OS Module
Manage Paths with Python Pathlib Module
Topic 9 Object Oriented Programming
Introduction to Object Oriented Programming
Create Class and Objects
Method and Overloading
Initializer & Destructor
Inheritance
Polymorphism
Topic 10 Database
Setup SQLite3 database
Apply CRUD operations on SQLite3
Integrate to external databases
Topic 11 Error Handling Using Exception
Exceptions versus Syntax Errors
Handle Exceptions with Try and Except blocks
The Else clause
Clean up with Finally
Topic 12 Intro to Useful Packages (Optional)
Numpy
Matplotlib
Pandas
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: 21-65 years old
Minimum Software/Hardware Requirement
Software:
Download and Install the following software
Sign up free Google Colab account
Hardware: Window or Mac Laptops
Job Roles
Job Roles
- Aspiring Software Developer
- Data Analyst
- Web Developer
- Automation Engineer
- Data Scientist
- System Administrator
- Bioinformatics Specialist
- Research Scientist
- Finance Professional
- Machine Learning Enthusiast
- GIS (Geographic Information System) Specialist
- IT Consultant
- Network Engineer
- Database Administrator
- Tech Entrepreneur.
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)
- Very useful course Review by Course Participant/Trainee
-
Good hands-on training with plenty of examples. I feel much more confident applying these skills now. (Posted on 11/14/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 - Superb training Review by Course Participant/Trainee
-
Very engaging session. The trainer patiently answered all our questions and gave useful tips. (Posted on 5/7/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 - Well structured course Review by Course Participant/Trainee
-
The course materials were detailed and easy to reference afterwards. Great value for money. (Posted on 4/5/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 - Excellent course Review by Course Participant/Trainee
-
Really enjoyed the training. The examples were relevant and the pace was just right. (Posted on 11/23/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 - Very useful course Review by Course Participant/Trainee
-
The course content was comprehensive and up to date. The practical exercises were the best part. (Posted on 8/12/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