Crazy about Arduino: Your End-to-End Workshop - Level 3

1. Course Introduction

Introduction to Level 3.

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.

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.

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.

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.

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.

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.

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!