Interface MySQL with PLC

Interface MySQL with PLC

📖

Get access to more than 50+ HQ videos with quiz and resources tp learn how to store PLC data in MySQL database via Node-RED

🗒️ Introduction

The industry data is playing a significant role in the decision-making process. It is very important to know how to fetch data from the shop floor and convert it into information.

There are thousands of sensors on the shop floor which are reading data from the process every millisecond. As a PLC Programmer, we know we cannot store all the information in the PLC memory as it has some limitations. To store the data from the last 5-10 years or more, we need an external database.

image

In this course, you will learn how to store the data from Siemens S7-1200 PLC or any other controller in an external database like MySQL with the help of Node-RED.

You will learn how to search, insert, update, or delete data from the database via Node-RED programming.

📚 Curriculum

Section 1: Introduction

Course Content

Section 2: Understanding basic MySQL commands

Course Content

Section 3: Database management via Node-RED

Course Content

Section 4: MySQL Dashboard on Node-RED

Course Content

Section 5: Project 1: Tank Level - Log PLC data in MySQL database

Course Content

Section 6: Synchronize Data between PLC and MySQL

Course Content

Section 7: Project 2: 3D Camera/RFID - Log real world data in MySQL database

Course Content

Section 8: Project 3: Login/Logout using database

Course Content

Section 9: How to generate reports in Node-RED

Course Content

Section 10: How to read/write PLC info with Google SQL

Course Content

Preview

👨🏻‍💻 Hardware & Software

The following is the recommended hardware and software to use along with this course:

List

NameTypeRemarks
Computer or Laptop
Hardware
Well, I hope you would be having it 😎
S7-1200 PLC
Hardware
It's optional. If you do not have a PLC, you can also use PLCSIM from TIA Portal and interface with OPC UA inside Siemens PLC via Net2PLC. You can also use any other PLC which supports OPC UA or MODBUS
Node-RED
Software
An open-source software
FACTORY I/O
Software
3D Simulation software to visualize industrial control system
MySQL Workbench
Software
To store the PLC or controller information in the database

Check the web-links for hardware and software at this page

💲 Price and Enrollment

💰

Get 10% off by using the coupon code WIKI while checking out

📚 Resources

📌

The students get access to all the presentation, project and Node-RED code used in the lessons