Introduction to Database with Python

**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

Prerequisite

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