Python

Level 3

Students can have an insight on how the programming world works and get familiar with the concepts of coding using Python language. With the fundamental knowledge and concept learned in Beginners and Intermediate Level, student can explore to real programming idea on how the application and various system built. For Advanced level, student will unlock the power of Python on creation of user-friendly graphical interfaces in this hands-on course, with real-world IT industry questions. Whether you’re a beginner or an intermediate Python enthusiast, this course is designed to elevate your programming / coding skills to the next level.

Objectives

  • Study Tkinter modules with various of widgets for Graphical User Interface (GUI).
  • Learn to different widgets and skills of applying geometry managers on widgets.
  • Learn to develop interactive interfaces that respond to user input, making programs dynamic and engaging.
  • Gain foundational knowledge of working with databases using SQLite.
  • Understand real-world industry use case and business needs scenario with Database systems with Python coding.

Course Info

Platform used:
Python Editor

Lessons:
24 lessons

Duration:
8 months, 24 weeks

Skills:

  • Understand Graphical User Interface using Tkinter module
  • Learn front-end and back-end concepts, integrate Tkinter with SQLite
  • Integrate Python with SQLite for efficient data storage, retrieval and manipulation

Lesson Plan:

No Lesson Description / Skills
1 Classes and Objects
  • Concept of object-oriented programming
  • Define Classes and Objects in Python
  • Access Object’s attribute and method
2 Application of Object Class
  • Application of classes
  • Examples of usage of classes
3 Introduction to Tkinter
  • Introduction to Tkinter Module
  • Working with basic widgets
  • Understand operations of Entry widgets
4 Tkinter Frame Operations
  • Introduction to Frame in Tkinter
  • Application of Frame
  • Develop simple name search system
5 Geometry Manager – pack and place layout
  • Understand Geometry Managers in Tkinter
  • Learning parameters of Pack layout
  • Understand Place layout
6 Geometry Manager – grid layout
  • Introduction to Grid layout
  • Grid layout customizations
  • Using nested-for loop for Grid layout
7 Application of Geometry Manager
  • Applying multiple geometry manager in developing application
  • Using .pack(), .place() and .grid() functions
8 Event & Event Handler
  • Understand what is Event and Event handler – Button events configuration
  • Apply mouse hover effects
9 Interactive Applications with Events
  • Common event types in Tkinter
  • Applications of multiple event types
10 Advanced Widgets in Tkinter
  • Understand Radiobutton
  • Understand Checkbutton
  • Applying both types of button in Tkinter
11 Using Menu and Dialog Box functions
  • Understanding how to apply Menu to window
  • Learn different options of Dialog box
  • Apply Menu and Dialog box in Tkinter applications
12 Applications of Tkinter – 1
  • Building a stopwatch using Tkinter
  • Understand concept of local variable vs. global variable
13 Applications of Tkinter – 2
  • Revision of nested-for loop in Grid geometry manager
  • Understand usage of Lambda function
  • Advanced Application: Numberpad in Tkinter
14 Introduction to SQLite
  • Introduction to SQLite library
  • Concept of SQL Database
  • Establish Connection to Database using SQLite
  • Creating Table with schema
15 Basic SQL query in Python
  • Basic SQL query (insert, select, update, delete)
  • Writing SQL statement for Database
  • Using dictionary for data row insertion
16 Relational Database Concept
  • Primary Key and Foreign Key
  • Concept of Relational Database
  • Creation of table with PK and FK
17 Common SQLite Statement – Function
  • Understand common SQLite statements
  • Convert regularly used statements into function
  • Create simple SQLite application
18 SQLite Common Statements – Data Extraction
  • SQL Statement (ORDER BY, GROUP BY)
  • Understand aggregate function in SQL
  • Application of aggregate function with ORDER BY
19 SQLite Common Statements – JOIN Tables
  • Understand concept of joining 2 or more tables
  • Using JOIN… ON… SQL statement
  • Example usage of JOIN tables in SQL
20 Solving Problem for SQL Statements
  • Using multiple databases to generate expected data
  • Application of SQL advanced clause
21 SQLite Subquery – WHERE
  • Introduction to Subquery in SQLite
  • Introduction of use case example of subquery
  • Subquery Basic Exercise
22 SQLite Subquery – SELECT, FROM
  • Different ways of creating subquery
  • Using DISTINCT keyword in subquery
  • Subquery Advanced Exercise
23 Application of SQLite Subquery
  • Subquery challenge questions
  • Scenario of creating subquery in Applications
24 SQLite Database Design Concept in Application
  • Practice Question on real-world Database use-cases
  • Understand how to design Database’s relationship
  • Drawing Database diagram using tools
25-32 Final Project – Student Management Application
  • Using Tkinter and SQLite module to develop an application consists of front-end and back end functionality
  • Practical hands-on in creating Python applications

 

Estimated Duration: 24 weeks + 8 weeks for final project

*For final project, students will be provided with the project requirements and objectives to develop a real world application with integration of GUI and Database concept, which GUI will be act as front-end and Database will be the application back-end.

Give Your Child
the Confidence to
Think, Learn, and Succeed

Whether online or in-class, our enrichment programmes help children grow into confident, capable, and future-ready learners.

Start Now!