Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Interface MySQL with PLC
Introduction
Welcome
What is Database- Part 1 (17:44)
What is Database- Part 2 (2:55)
Installing database software- MySQL (12:20)
How to create your first database and table? (8:43)
Understanding basic MySQL commands
Let's learn the basics of MySQL
How to INSERT values in the database via query (5:20)
How to SELECT values in the database via query (8:31)
How to UPDATE values in the database via query (5:18)
How to DELETE values in the database via query (4:20)
Want to practice MySQL queries?
Database Management with Node-RED
Node-RED Flow for Dashboard
MySQL Dashboard in Node-RED- Part 1 (13:35)
MySQL Dashboard in Node-RED- Part 2 (5:07)
MySQL Dashboard in Node-RED- Part 3 (6:36)
MySQL Dashboard in Node-RED- Part 4 (7:16)
MySQL Dashboard in Node-RED- Part 5 (6:28)
Project- 1: Tank Level - Loggin PLC data into MySQL database
Lots of exercises
Exercise 1- How to store PLC data in the database (13:57)
Exercise 2- Making UI (12:26)
Exercise 3- Adding timestamp to the database values (9:57)
Exercise 4- Adding timestamp from PLC Controller
Exercise 5- Logging only when value changes using 'Subscription' (11:29)
Exercise 6- Logging only when value changes via 'rbe' node (3:23)
Exercise 7- Logging Only When Value Changes -Industrial Example (27:14)
Exercise 8- Making a chart from the database values- Industrial Example (20:38)
Exercise 9- Adding another values in 'cm' in Chart- Industrial Example (5:17)
Exercise 10- Comparing values from two processes in a Graph (4:26)
Exercise 11- Showing a graph of two tank levels with MySQL data (4:26)
Exercise 12- Sorting values based on timestamp (20:22)
Node-RED flow
Synchronise data between PLC and MySQL
Sneak Preview (2:35)
Exercise 1- Sync data from Database to PLC (19:05)
Exercise 2- Sync data from PLC to Database (13:53)
Exercise 3- Sync data from Database to PLC (17:00)
Node-RED flow
Project- 2: 3D Camera/RFID- Log real world data into MySQL
Exercise 1 - Understanding the project of object measurement and RFID tag reading (10:56)
Exercise 2 - Write PLC data to MySQL Database- 1 (16:23)
Exercise 3- Write PLC data to MySQL Database- 2 (9:05)
Node-RED flow and PLC Program
Learn more about 3D Camera and RFID
Login/Logout application using database
Introduction to the Login/Logout Project (9:47)
Understanding Password Encryption (10:30)
User registration (12:05)
User login (13:21)
User management (13:16)
Interlocking screens (11:18)
Node-RED flow
How to generate reports in Node-RED?
Understanding the Project (6:13)
How to make a simple pdf file (9:33)
How to generate reports of real time values in PDF (18:43)
Node-RED flow
How to read/Write PLC data with Google SQL?
Understanding the Project (4:49)
Setting up database in Google cloud (5:36)
Interfacing Google Cloud MySQL with Node-RED (8:36)
Understanding the Project - 1 (7:59)
Understanding the Project - 2 (10:48)
Node-RED flow
Course Wrap up
Congratulations
How to DELETE values in the database via query
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock