Data analytics made easy

Industry data plays a significant role in decision-making. It is essential to know how to retrieve data from the shop floor and convert it into information. There are thousands of sensors on the shop floor that are reading data from the process every millisecond.

As PLC Programmers, we know we cannot store all information in PLC memory because it has limitations. To store and analyze data from the past 5-10 years or more, we require an external database.

What will you learn?

• Basics of MySQL
• How to connect Node-RED to MySQL to send queries
• How to create a dashboard on Node-RED using MySQL data
• How to read data from a Siemens PLC and store it in a MySQL database
• How to synchronize data between PLC and MySQL
• Industrial Example: Logging data into a MySQL database from RFID data
• Industrial Example: Login/Logout using a database
• How to generate from database information on Node-RED
• How to read/write PLC data with Google SQL.
  
  

Top reviews:

Omar Ali
Software Engineer

An exciting course with delightful pieces of information 📝. I really appreciate your efforts in making such a course. It greatly helped me with my graduation project—deep thanks from the bottom of my heart.

Σωτηρης Χαραλαμπιδης
Student

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 !

Read more