New Video- ADAM-250PN - Full Walkthrough with TIA Portal, Node-RED & MQTT → Watch now
Learn MySQL from the basics, store Siemens PLC data through Node-RED, build dashboards and reports, and read and write PLC data with Google Cloud SQL.
“An exciting course with delightful pieces of information.”
From your first query to PLC data in the cloud, with industrial projects along the way.
Understand databases and the basic MySQL commands.
Connect Node-RED to MySQL, send queries and build a dashboard from the data.
Read data from a Siemens PLC and store it in a MySQL database.
Synchronise data between the PLC and MySQL.
Log RFID and 3D camera data, and build a login and logout application with a database.
Generate reports in Node-RED, and read and write PLC data with Google Cloud SQL.
An introduction to databases, basic MySQL commands and database management with Node-RED.
A tank level project logging PLC data into MySQL, and synchronising data between the PLC and MySQL.
Logging 3D camera and RFID data, and a login and logout application using a database.
Generating reports in Node-RED, reading and writing PLC data with Google SQL, and the course wrap-up.
See how Rajvir teaches, from database basics to your first MySQL dashboard in Node-RED.
Learn the database basics the rest of the course builds on.
Show database data on a Node-RED dashboard.
Find the MySQL course resources and software links on the Code and Compile Wiki.
“I recommend him for eveyone who works on automation !”
“Rajvir is an exceptional teacher who simplifies complex topics effortlessly. He’s always available in comments or even via TeamViewer to help you understand. Truly dedicated and teaches straight from the heart.”
“I’m a software engineer at NASA Ames, and Rajvir’s videos greatly help me interface PLCs for testing heat shield systems on reentry vehicles, truly contributing to space exploration and innovation.”
He is a skilled Automation and IIoT Specialist, dedicated to achieving goals with precision. His passion lies in making learning accessible and enjoyable through the use of cutting-edge educational tools.
Take this course on its own, or unlock every Code and Compile course with PRO.
Practice flashcards. Test yourself on automation and IIoT concepts at beginner, medium and advanced levels on cards.codeandcompile.com.
You will be redirected to Code and Compile School for payment.
No. A PLC is optional, and you can practise with PLCSIM. You will use Node-RED, MySQL Server and MySQL Workbench, plus a Google Cloud account for the cloud lessons.
Yes. Every lesson has a comment section for your questions. If a query cannot be resolved there, Rajvir offers free screen-sharing sessions.
Yes. Use the Teachable app on Android or iOS, sign in with your account and save videos for offline access.
Yes. You receive a unique completion certificate when you finish the course.
You can request a refund within 72 hours of purchase by emailing info@codeandcompile.com.
Learn at your own pace, with an instructor who helps you when you get stuck.
Start the courseMaster Industrial Automation and Industrial Internet of Things
