MySQL

Module 3 Overview

In module three, the programming language covered was Structured Query Language (SQL). The module consisted of tutorials and assignments from New Bostion MySQL, Zend: PHP 101, and W3Schools. In the tutorials, we created databases in MySQL, created tables, updated and deleted tables, alter and dropped tables, sorting columns from tables, and creating functions. There were also an assignment from the textbook which detailed how to connect PHP to the MySQL database which was stressed to be one of the most important topics in the course. The W3Schools PHP quiz provided practice of basic syntax and PHP knowledge.

Learning Narrative

The tutorial from New Bostion MySQL or Bucky's tutorial was the most helpful in aiding me to understand SQL. The tutorial provided short videos with examples that were easy to follow along to and comprehend. He also used Hostgator which made the SQL tutorial even more simple to grasp. After Bucky's videos, the other turorials and assignments made more sense and I was able to breeze through them without trouble. The W3Schools SQL quiz provided a good way to test myself and prepare for the exam for this module. My best assignments from module three are below.

Selected Assignments

I created a registration form in this assignment. The images and live links are below.

The image below is a screenshot of the register users example from the textbook.

Here is the live website to Register Users.

The image below is a screenshot of the change password example from the textbook.

Here is the live website to Change Passwords.

The image below is a screenshot of the view users example from the textbook.

Here is the live website to View Users.

Here is the Homepage.

---