Assignment: My SQL Online Tutorial

In this MySQL tutorial, Bucky Roberts uses a HostGator account similar to your own. Consequently, the software, such as cPanel and MySQL Admin, that Bucky demonstrates will work the same way for you as it does in Bucky’s tutorial. Though, he does use a different skin on his cPanel so while your and his cPanels will work the same way, their interface will appear different.

You can find Bucky’s MySql tutorial online at: Bucky's Tutorials

In his tutorials, Bucky utilizes some specific SQL data. You will want to download that data and work along with Bucky.

You can download the sql code in ascii text format from:
customers.sql and
items.sql
Note: Should you get an error message when you attempt to run the above, you should first check for an invissible character in your SQL Window. That is, if the first character shows as a red dot after you paste in this code, you will need to delete that character in order to run the code.

To use this data, first set up a new database, like we did in class. Then, using phpMyAdmin paste the SQL code into the SQL Window and run it. You should first create each table and then load the data into the table.

Note that Bucky's MySQL Tutorial consists of 33 separate videos. Each video is only a few minutes long… While you don’t need to complete them all by the next class, it would be prudent to complete them prior to the next exam.

1 - Introduction to Databases
2 - Getting a MySQL Server
3 - Creating a Database
4 - SHOW and SELECT
5 - Basic Rules for SQL Statements
6 - Getting Multiple Columns
7 - DISTINCT and LIMIT
8 - Sorting Results
9 - Sort Direction
10 - Basic Data Filtering and WHERE
11 - Advanced Filtering Using AND and OR
12 - Are you IN or are you NOT IN?
13 - How Search Engines Work
14 - More on Wildcards
15 - Regular Expressions
16 - Creating Custom Columns
17 - Functions
18 - More on Aggregate Functions
19 - GROUP BY
20 - Subqueries
21 - Another Subquery Example
22 - How to Join Tables
23 - Outer Joins
24 - UNION
25 - Full-Text Searching
26 - INSERT INTO
27 - How to Insert Multiple Rows
28 - UPDATE and DELETE
29 - CREATE TABLE
30 - NOT NULL and AUTO INCREMENT
31 - ALTER / DROP / RENAME TABLE
32 - Views
33 - Final Video!

Deliverable
As you go through these tutorials, take a few screen shots. Once you have completed them, you should place those images in a portfolio web page. Add sufficient text so that your portfolio visitor can understand what MySQL, how it relates to web development, and why it is important.

Be brief but communicate well!