mysql-data-raspberry-pi

This is a simple project that explains how you can use a Raspberry Pi collect sensor data and save this data to a MySQL database.

Also shows you how you can access data from a MySQL database in Jupyter Notebook.

Learning Objectives:

Lesson 1: Configure Raspberry Pi to Collect Data from Temperature Sensor

1. Create IoT device that collects temperature and humidity data from sensor
2. Learn how to wire DHT temperature sensors to GPIO on Raspberry Pi
3. Write Python code to interact with DHT sensor

Lesson 2: Setup Jupyter Notebook for Data Analysis

1. Create Python tools for data analysis using Jupyter Notebooks
2. Learn how to access data from MySQL databases for data analysis

Lesson 3: Create MySQL Database Table for Sensor Data

1. Learn how to access MySQL from Jupyter Notebook to create tables and users
2. Prepare location to store data collected from IoT devices

Lesson 4: Save Raspberry Pi Sensor Data to MySQL Database

1. Model how IoT device can save sensor data to back end database server for later analysis
2. Learn how to access data from MySQL databases from a Raspberry Pi Python program