Course Details
Day 1
Topic 1: Python Fundamental
Topic 1.1 Get Started on Python
- Overview of Python
- Install Python
- Install Python IDE
- Code Your First Python Script
- Comment
Topic 1.2: Data Types
- Number
- String
- List
- Tuple
- Dictionary
- Set
Topic 1.3 Operators
- Arithmetic Operators
- Compound Operators
- Comparison Operators
- Membership Operators
- Logical Operators
Topic 1.4 Control Structure, Loop and Comprehension
- Conditional
- Loop
- Iterating Over Multiple Sequences
- Comprehension
Topic 1.5 Function
- Function Syntax
- Return Values
- Default Arguments
- Variable Arguments
- Lambda, Map, Filter
Topic 1.6 Modules & Packages
- Import Modules and Packages
- Python Standard Packages
- Third Party Packages
Day 2
Topic 2: Python Intermediate
Topic 2.1 Comprehensions & Generators
- Comprehension Syntax
- Types of Comprehension
- Generator Syntax
- Types of Generators
Topic 2.2 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 2.3 Object Oriented Programming
- Introduction to Object Oriented Programming
- Create Class and Objects
- Method and Overloading
- Initializer & Destructor
- Inheritance
- Polymorphism
Topic 2.4 Database
- Setup SQLite3 Database
- Apply CRUD Operations on SQLite3
- Integration to External Databases
Topic 2.5 Error Handling Using Exception
- Exceptions versus Syntax Errors
- Handle Exceptions with Try and Except Blocks
- The Else Clause
- Clean Up with Finally
Day 3
Topic 3: Python Data Analytics and Visualization
Topic 3.1 Data Preparation
- Data Analytics with Pandas
- Pandas DataFrame and Series
- Import and Export Data
- Filter and Slice Data
- Clean Data
Topic 3.2 Data Transformation
- Join Data
- Transform Data
- Aggregate Data
Topic 3.3 Data Visualization
- Data Visualization with Matplotlib and Seaborn
- Visualize Statistical Relationships with Scatter Plot
- Visualize Categorical Data with Bar Plot
- Visualize Correlation with Pair Plot and Heatmap
- Visualize Linear Relationships with Regression
Topic 3.4 Data Analysis
- Statistical Data Analysis
- Time Series Analysis
Topic 3.5 Advanced Data Analytics
- Data Piping
- Groupby and Apply Custom Functions
- Linear Regression
Topic 1 Descriptive Statistics
- Mean & Medium
- Standard Deviation & Variance
- Percentiles
- Summary
Topic 2.1: Data Visualization with Seaborn
- What is Seaborn
- Visualizing Statistical Relationships with Scatter Plot
- Visualizing Categorical Data with Bar Plot
- Visualizing Correlation with Pair Plot and Heatmap
- Visualizing Linear Relationships with Regression
Topic 2.3 Hypothesis Testing with SciPy
- What is Hypothesis Testing
- T Statistics
- Student's t-test
Day 4
Topic 4: Python Statistical Analysis
Topic 4.1 Descriptive Statistics
- Mean & Medium
- Standard Deviation & Variance
- Percentiles
- Summary
Topic 4.2: Data Visualization with Seaborn
- What is Seaborn
- Visualizing Statistical Relationships with Scatter Plot
- Visualizing Categorical Data with Bar Plot
- Visualizing Correlation with Pair Plot and Heatmap
- Visualizing Linear Relationships with Regression
Topic 4.3 Hypothesis Testing with SciPy
- What is Hypothesis Testing
- T Statistics
- Student's t-test
Topic 4.4 Statistical Modeling with StatsModel
- What is Statistical Modeling
- Statistical Modeling with StatsModel
- Goodness of Fit
- ANOVA
Topic 4.5 Bayesian Inference with PyMC3
- Bayesian Inference
- Using PyMC3 for Bayesian Inference
Day 5
Topic 5: Python Web API with Flask
Topic 5.1 Get Started on Flask API
- What is Flask?
- Request Response Cycle
- Create a Simple Flask API
- Debug Mode
- Routing
- Testing the API on Postman
Topic 5.2 Returned Data from API
- JSON Format
- Jsonify the Data
- HTTP Methods and Status Code
- Add Status Code to the Data
- Variable Rules
- Test Out URL Rules on Postman
Topic 5.3: Working with Database
- Database
- ORM and SQLAlchemy
- Define Table and Data
- Serialize Data with Marshmallow
Topic 5.4: API Security
- Create a Register Form
- Login
- Authentication with JSON Web Token (JWT)
Topic 5.5: Read, Create, Update and Delete
- Read Data
- Add Data
- Update Data
- Delete Data
Course Info
Prerequisite
The learner must meet the minimum requirement below :
- Read, write, speak and understand English
Target Audience
- NSF
- Full Time Students
- Data Analysts
Software Requirement
This course will use Google Colab for training. Please ensure you have a Google account.
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
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.
Terence Ee: Terence Ee is a ACTA certified trainer that has delivered IT training in Singapore and Myanmar. He has also facilitated faith formation courses for Christians in Singapore and Myanmar. As a trainer, his mission is to co-create insightful and actionable learning experiences with his learners.His current areas of focus include project management, information security management, quality management and office productivity applications.
Terence has more than 25 years of corporate IT experience. He has held senior management roles in the public and private sectors. He holds a Master of Science in Technology Management, a Bachelor of Science in Computer and Information Sciences, a Diploma in Family Education, and the Advanced Certificate in Training and Assessment (ACTA). Part of his spare time goes towards tutoring his children in their studies (while learning a thing or two along the way). He is also imparting to them the essential skills for thriving in a digital world.
Customer Reviews (7)
- Dr Alvin is a very knowledeable trainer. Really enjoyed the course. 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 trainer has a very friendly disposition and engages his students in and out of class. 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 - 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 - Alvin is a great trainer! 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 - Great Learning Experience 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 - Dr Alvin provided a very all-rounded explanation on the topics 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 - 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