Interface MySQL with PLC via Node-RED

Learn how to store PLC data in MySQL database via Node-red

  Enroll in Course

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.

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.

The following are the pre-requisite for this course:

  • Basics of Node-RED
  • Node-RED interfacing with PLC, Arduino, or Raspberry pi
  • Node-RED and MySQL installation in the computer with internet
  • Any controller- Arduino, Raspberry pi, or PLC to read the real-world data or FACTORY IO

Course Curriculum

  Wrap up
Available in days
days after you enroll

Your Instructor

Rajvir Singh
Rajvir Singh

Rajvir is a Mechatronics Engineer & passionate educator. As an engineer, he is involved in control circuit designing and flexible course designing in various elements of automation like PLC, PID, HMI & Drives- VFD & Servo, Connect I/O, Home I/O, and Factory Automation.

As a teacher, he loves to implement innovative 3D-Learning methods to make education easy & interesting. He teaches Industrial Automation to almost 167+ countries across the world.

He loves to meet professors, teachers, educators, instructors to discuss & share Innovative tools of learning technology.
You can contact him at [email protected] if you share a similar interests & would like to work for a social mission of creating a better education system

Frequently Asked Questions

When does the course start and finish?
The course starts now and never ends! It is a completely self-paced online course - you decide when you start and when you finish.
How long do I have access to the course?
How does lifetime access sound? After enrolling, you have unlimited access to this course for as long as you like - across any and all devices you own.
What if I am unhappy with the course?
We would never want you to be unhappy! If you are unsatisfied with your purchase, contact us in the first 30 days and we will give you a full refund.
Do I get a certificate after course completion?
Yes, as soon as you finished 100% of the course, a downloadable certificate of completion will be issued.

Get started now!