Workshop: Introduction to Database with Python

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