Booking options
£93.99
£93.99
On-Demand course
4 hours 4 minutes
All levels
Learn to build a complete Internet of Things solution with Arduino, a SQL Database, and a web server
The best way to find out whether this course is really for you is by asking yourself a few basic questions: • Do you like building things yourself?
• Are you looking for ways to easily combine software and hardware components?
• Did you ever wonder how electronic devices really work?
• Do you have a creative idea and are just looking for ways to easily prototype it? If your answer to most of the questions above is "Yes," then you're in the right place. The Arduino is probably one of the most amazing developments and prototyping platforms today with endless possibilities for Do-It-Yourself hobbyists looking for ways to express their creativity and technical capabilities. This course is LEVEL 3 and is part of a larger comprehensive training program divided into levels that are all about the Arduino and its surrounding ecosystem. Each course covers a specific group of subjects to lets you develop and grow your skills step-by-step while enjoying the journey. Join us and learn to build a complete data-logger solution including a web server and a database to store and analyze the collected data. All the code and supporting files for this course are available at -
https://github.com/PacktPublishing/Crazy-about-Arduino-Your-End-to-End-Workshop---Level-3
Build an end-to-end Internet of Things (IoT) data logger
Collect data using multiple sensors: DHT11, LDR, and ultrasonic
Set up a personal web and database server (MySQL)
Connect the Arduino to the Internet using the Ethernet module
Design and use a web API to send sensor data from the Arduino to the webserver
Analyze data logger data
This course is for technology innovators, electronics hobbyists, and beginners with a basic knowledge of Electronics and Arduino who are interested in building a complete Internet of Things solution with Arduino.
This complete course, packed with step-by-step instructions, working examples, and helpful advice, is clearly divided into small chunks to help you understand each part individually and learn at your own pace.
A complete and well-organized course * Build an interesting IoT project with sensors, an Apache web server, and a MySQL database * Design and program a smart sketch code to run the overall project
https://github.com/packtpublishing/crazy-about-arduino-your-end-to-end-workshop---level-1
Idan Gabrieli has worked in various engineering positions in Israel's high-tech industry. Idan has gained extensive experience with hundreds of business companies, transforming their challenges and opportunities into practical use cases and leveraging cutting-edge technologies. Idan's expertise spans multiple domains, including cloud computing, machine learning, data science, and electronics. Since 2014, Idan has created and published online courses on various topics worldwide. Idan is recognized as a high-rated instructor by leading educational providers. Idan simplifies complex technology and provides high-quality educational content with specific learning objectives that are well-structured, combining various multimedia teaching options.
1. Getting Started
1. Course Introduction Introduction to Level 3. |
2. Step 1 - Setting the Sensors - Let's Measure Something
1. Introduction An overview of the section and topics covered. |
2. What is a Sensor? Starting with the basic definition of sensor. |
3. Sensors are Everywhere Now what kind of things can be detected by sensors? well there many types of sensors that can detect different physical properties. |
4. Measuring Temperature and Humidity Measuring temperature and humidity with the DHT11 sensor. |
5. Measuring Light Changes Measuring light changes with the LDR sensor. |
6. Measuring Distance Measuring distance with the Ultrasonic sensor. |
7. Wiring All Sensors to the Arduino How to connect each sensor to the Arduino Uno board. |
8. Hardware Setup - All Sensors Demonstrating the hardware setup and the circuit design using Fritzing. |
9. Project Demo Demonstrating how the project is working so far with the three sensors. |
10. Code Review Detailed analysis of the Arduino sketch. |
3. Step 2 - Ethernet Shield - Get Connected!
1. Introduction An overview of the section and topics covered. |
2. IP Address IP and MAC Addresses. |
3. MAC Address IP and MAC Addresses. |
4. Client-Server Communication A large part of network communication is based on client-server communication model, where a server is designed to be a centralized system that serves many clients. |
5. TCP/UDP Ports Ports numbers are used to separated data streams to the relevant applications. |
6. Network Socket Network socket is basically some endpoint of a logical connection and this is managed dynamically by the operation system |
7. TCP Session Connection oriented that established with the remote socket. |
8. HTTP and HTML HTTP functions as a request-response protocol in the client-server computing model.where HTML is a markup language for creating web pages and web applications. |
9. The Ethernet Shield W5100 This is the type of Ethernet module we will use in our project. It is called Ethernet Shield W5100. This shield enables our small Arduino to be connected to the internet and by doing so opens endless amounts of possibility by allowing us to connect our projects to the internet. |
10. The Ethernet Library For the Ethernet shield there is a dedicated library that is used to setup the MAC and IP address, initiate connection as client to a remote server and accept connections as server from remote clients. |
11. Hardware Setup - Ethernet Shield W5100 Demonstrating how the project is working with the Ethernet shield. |
12. Project Demo - connecting to remote server Demonstrating how the project is working with the Ethernet shield. |
13. Code Review Detailed analysis of the Arduino sketch. |
4. Step 3 - WampServer - Hosting your own Web Server!
1. Introduction An overview of the section and topics covered. |
2. Apache, PHP and MySQL WampServer is a free web development environment for windows that enables us to setup and run a web server on our computer to host web sites. It is basically a package of three main building blocks: Apache2, PHP and MySQL. |
3. Download & Install Download and install the WampServer application. |
4. Getting started with WampServer How to setup, test and use the WampServer application. |
5. Basic Server Configuration Performing the basic server configuration. |
5. Step 4 - MySQL Database - Storing Data Somewhere
1. Introduction An overview of the section and topics covered. |
2. What is a Database? A database is basically a logical container for storing data in a very structured way. |
3. MySQL Tools To be able to manage and access the database there two main options such as MySQL simple command line window and phpMyAdmin web client graphical. |
4. Using phpMyAdmin Console Introduction to the phpMyAdmin tool. |
5. SQL Statements Overview of SQL statements, zooming on SELECT and INSERT. |
6. Testing our Project Database Performing few simple database testings. |
6. Step 5 - PHP - Running Scripts at the Server
1. Introduction An overview of the section and topics covered. |
2. What is PHP? Introduction to the PHP server-side scripting language. |
3. Basic PHP Syntax Basic review to the relevant PHP syntax we will need to create our scripts. |
4. PHP Extension to MySQL - Introduction We are going to use the new PHP extension to MySQL, called PHP MySQLi that stands for PHP MySQL improved. |
5. mysqli - Establish Database Connection Before any PHP script can perform an action on the MySQL database, it must first hold a connection to the database. |
6. Insert Data Building the needed scripts for inserting data into the database. |
7. Insert Data - PHP Scripts Testing Performing scripts testing. |
8. Query Data Building the needed script for querying data from the database. |
9. Query Data - PHP Scripts Testing Performing scripts testing. |
10. MySQL Error Handling Errors are almost unavoidable as in some point of time you will encounter a situation that your script is not really working and will require some level of debugging to understand the problem root cause |
11. MySQL Errors Simulation Simulating some errors related to the MySQL database. |
7. Step 6 - Final Project - Web-based Datalogger
1. Introduction An overview of the section and topics covered. |
2. Connecting the Arduino to the Web Server Now we have our own web server up and running, configured and it time to connect the Arduino to our web server. |
3. Final Project - Checklist and Demo There are few simple steps or checklist that are needed to be able to bring up the system. |
8. Course Summary
1. What did we covered? Quick course summary, what have we learn in Level 3.... |
2. What Next? Level 4! Thanks!!! and I hope to see you in the next level! |