Skip to main content Start main content

Introduction to Database with Python

Workshop/ Training/ Webinar

  • Date

    23 - 30 Jan 2024

  • Organiser


  • Time

    14:30 - 16:30

  • Venue

    Online via Zoom  


**Participants are required to join both sessions (2 hrs x 2)**

Date: 23 Jan 2024 (Tue) & 30 Jan 2024 (Tue) 

Time: 14:30 - 16:30

Venue: Online via Zoom

Target Audience: All Students

Medium of Instruction: English



Basic knowledge in NumPy and Pandas


What you will learn

  • We will learn MySQL and MongoDB, import the data from a CSV file into a Pandas dataframe, create databases and tables using a Python driver, and perform queries and updates on the databases.
  • After the workshop, you will have a general understanding of MySQL and MongoDB.
  • You will gain hands-on experience with MySQL databases using the Python driver mysql.connector.
  • You will gain hands-on experience with MongoDB using the Python driver pymongo


Course Outline

1.  Introduction to SQL database

  • Connect to MySQL server
  • Create database/ schema
  • Create table
  • Input data from CSV to table
  • Query data from table
  • Insert, update, and delete records

2.  Introduction to NoSQL database

  • Connect to MongoDB
  • Working with database, collection, and document

Your browser is not the latest version. If you continue to browse our website, Some pages may not function properly.

You are recommended to upgrade to a newer version or switch to a different browser. A list of the web browsers that we support can be found here