0(0 Ratings)
MySQL database with Node Red
What I will learn?
- Embark on a comprehensive journey into database management with this course on MySQL Integration with Node-RED! Learn to create and manage databases, execute essential CRUD operations (Create, Read, Update, Delete), and efficiently organize your data. Discover seamless integration techniques to connect MySQL databases with Node-RED, enabling you to store PLC data effectively. Explore user management strategies, master the creation of PDF reports, and delve into interfacing PLCs via cloud databases. This course equips you with the essential skills to build robust and data-driven IoT applications.
Course Curriculum
Welcome
-
Welcome
00:00
Basics of MySQL
-
What is a database
20:50 -
Installation Mysql
08:03 -
Create a new database
16:12 -
Insert data
12:42 -
Select data
08:15 -
Update
09:30 -
Delete
07:46
Connecting MySQL with Node-RED
-
Mysql with Node-red
11:58 -
Node-red insert and select data
13:35 -
Node-red Insert data form
14:46 -
Node-red view data
09:57 -
Node-red update 1
19:08 -
Node-red Update 2
28:00 -
Node-red-Delete
09:16 -
Node red -feedback
10:48 -
Node red -feedback 2
04:57 -
Node-red organize data
15:32 -
Node red -mysql status
19:18 -
Node-Red -mysql status 2
07:40 -
Node-red-analytics
10:05
Connecting Mysql with PLC Siemens
-
Mysql with plc
18:04 -
Mysql Node red -timestamp
06:09 -
Mysql with plc -level control
28:24 -
Mysql level view data
05:39 -
Mysql with plc -delete
05:03 -
Mysql with plc -chart
22:31 -
Mysql with plc -multi chart
07:41 -
Mysql with plc -sorting data
18:16 -
Mysql with plc -sorting data -2
22:37
Privilege and user management
In this section I will show you how you can establish effective privilege and user management practices to secure your system and protect sensitive data from unauthorized access
-
Mysql with plc -user management
33:54 -
Mysql with plc -user login
32:13 -
Mysql with plc -screen interlock
22:24 -
Mysql with plc -user update password
28:38
How to generate a PDF report
In this section we will learn how to create PDF reports dynamically within Node-RED, allowing you to automate the process of generating reports based on real-time data or events.
-
Pdf report-overview
05:59 -
Pdf Report-text
24:15 -
Pdf report-table
10:41 -
Pdf report-table
10:41 -
Pdf report-links
03:59 -
Pdf report
07:43
Control PLC via Google cloud
-
Google cloud settings
13:34 -
Connection cloud database with node red
12:47 -
Control level via google cloud
23:42 -
Control plc from internet via cloud
14:10
Earn a certificate
Add this certificate to your resume to demonstrate your skills & increase your chances of getting noticed.
Student Ratings & Reviews
No Review Yet
$50.00
$70.00
-
LevelIntermediate
-
Total Enrolled2
-
Duration10 hours 30 minutes
-
Last UpdatedAugust 4, 2024
-
CertificateCertificate of completion
Hi, Welcome back!
A course by
othmane nayfali
Automatician
Tags
Target Audience
- Beginners: Individuals new to database management and IoT development who want to learn the fundamentals of MySQL integration with Node-RED.
- IoT Enthusiasts: Those interested in building IoT applications and automating processes using Node-RED and MySQL databases.
- Programmers and Developers: Professionals seeking to enhance their skills in database management, data storage, and integration techniques.
- Engineers: PLC engineers and automation specialists aiming to learn how to efficiently store and manage PLC data in databases for analysis and reporting.
- Students: Students studying computer science, engineering, or related fields who want to explore practical applications of database management and IoT technologies.
- Entrepreneurs and Innovators: Individuals looking to develop innovative IoT solutions or projects that require database integration and management.
- Tech Hobbyists: Enthusiasts interested in tinkering with IoT devices and databases as a hobby or side project.