IIoT Course Level- 3

Interface MySQL with PLC via
Node-RED

Learn how to store PLC data in MySQL database via Node-red and further send this data to the Google Cloud
  • Learn from Scratch

    Start with basics of MySQL queries
  • Free database software

    MySQL is free to download and use in your projects
  • Resources

    Download presentations, codes for the lessons
  • Technical support

    Free technical support related to the lessons
    Node-Red logo, S7-1200 PLC, a document icon, a google cloud and a laptop screen displaying charts

    Learners

    Videos

    Hours

    Resource
    Code
    Drag to resize

    Course preview

    Write your awesome label here.

    #1 Introduction to the database?

    In this lesson, you will understand what is a database and how we can use it in Industrial application.
    Write your awesome label here.

    #2 How to create a table in database?

    In this lesson, you will understand how to create a table in the database using MySQL workbench
    Write your awesome label here.

    #3 Insert Query in MySQL database

    In this lesson, you will understand how to use insert query to add the information in the MySQL database
    Write your awesome label here.

    #4 PLC data with MySQL sync

    In this lesson, you will see how using Node-RED its easy to move the data between the PLC and MySQL database

    From Shop-floor to the Cloud

    The industry data plays 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 and analyze 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.

    Furthermore, you will learn how to move the PLC data from local database to cloud database


    Write your awesome label here.

    Course Lessons

    In the 21st century, the database is the marketplace

    Take this course and start organizing your controller's data in the database

    Frequently asked questions

    Can I get a refund if I'm unhappy with my purchase?

    If you are unsatisfied with your purchase, reach out to us within next 3 days of enrollment to see if your purchase is eligible for a refund.

    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.

    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. 

    What software do I need to practice this course

    You need Node-RED and MySQL Workbench to practice the course. Both are free to download and use. The download links are given in the course

    Do I need any hardware to practice the course?

    In this course, we explain how to read data from PLC and store it in MySQL database. If you have a PLC, it would be great. Else you can also communicate to PLC Simulator like PLCSIM to read the PLC data. You can also read data from Raspberry Pi and store in the database. The course is more focused on data modelling to store the data in MySQL database.
    Created with