Skip to main content Start main content

Workshop: Introduction to Database with Python

Workshop/ Training/ Webinar

  • Date

    20 - 27 Oct 2022

  • Organiser


  • Time

    14:30 - 17:00

  • Venue

    Online (MS Teams)  


Introduction to Database with Python (2 lessons)

Date: 20 Oct and 27 Oct

Time: 14:30 - 17:00

Target Audience: All Students

Medium of Instruction: English

Pre-requisite: Basic knowledge in NumPy and Pandas

What you will learn

  • We will install MySQL server and MongoDB in our machine. Import the data from csv file to pandas dataframe, create database, tables by python driver. Performing queries and update to the database
  • After the workshop you will have general understanding on MySQL and MongoDB
  • Get hands-on experience with MySQL database by using python driver for MySQL: mysql.connector
  • Get hands-on experience with MongoDB by using python driver for MongoDB: pymongo


Course outline

  1. Introduction to SQL database
    1. MySQL Installation
    2. Connect to MySQL server
    3. Create database/schema
    4. Create table
    5. Input data from CSV to table
    6. Query data from table
    7. Insert, update, and delete records
  2. Introduction to NoSQL database
    1. MongoDB installation
    2. Connect to MongoDB
    3. 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