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.
Lesson 1: Configure Raspberry Pi to Collect Data from Temperature Sensor
- Create IoT device that collects temperature and humidity data from sensor
- Learn how to wire DHT temperature sensors to GPIO on Raspberry Pi
- Write Python code to interact with DHT sensor
Lesson 2: Setup Jupyter Notebook for Data Analysis
- Create Python tools for data analysis using Jupyter Notebooks
- Learn how to access data from MySQL databases for data analysis
Lesson 3: Create MySQL Database Table for Sensor Data
- Learn how to access MySQL from Jupyter Notebook to create tables and users
- Prepare location to store data collected from IoT devices
Lesson 4: Save Raspberry Pi Sensor Data to MySQL Database
- Model how IoT device can save sensor data to back end database server for later analysis
- Learn how to access data from MySQL databases from a Raspberry Pi Python program