IIoT Course Level- 3

Interface MySQL with PLC via
Node-RED

With Subtitles
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

    From Shop-floor to the Cloud

    Write your awesome label here.
    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 to an external database like MySQL with the help of Node-RED

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

    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

    Course Lessons

    The course is offered through video lessons, text documents, exercises, quizzes, and solutions. Furthermore, some LIVE webinars are offered exclusive to the Code and Compile student community. 

    Top review

    Omar Ali
    Software Engineer
    A really interesting course with delightful pieces of information 📝. I really appreciate your efforts in making such a course. It really helped me a lot in my graduation project. Deep thanks for the bottom of my heart ❤️

    Our students love us

    I joined many courses on the internet but I have never seen like this course before it's complete, easy and so funny also the teacher of these courses Eng. Rajivir so friendly and helpful
    Mohammad Alharbi
    I am a student from a greek university , and i had some problems with my factory io project . I saw that mr rajvir had a youtube channel based on plc etc . I ask his help and this man is amazing to his job . He helped regardless of the time , without asking me for anything . I recommend him for eveyone who works on automation !
    Σωτηρης Χαραλαμπιδης
    It was a great course and got platform to take automation and skill to next level. Mr. Rajvir has helped and supported me to a problem I'm facing while commissioning and executing tasks. thank you rajvir for your support.
    Rupesh
    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.