Contact me:

Email

MySQL Online Tutorial

In this assignment, I followed Bucky's 33-part MySQL tutorial on thenewboston.com. MySQL is a program that can understand SQL that Bucky recommends. Understanding MySQL is important, because it allows you to group similar data together in a databse, rather than random files and allows you to design applications where the user can interact with that data.

I followed along with his tutorials by creating the "youtube" database on HostGator'cPanel. I then created a Customers table in the database and populated it with data by running a customers.sql script. I did the same afterwards to create an Items table by running the items.sql script. Bucky's tutorials began with basic lessons about database principles before he taught simple SQL statements, functions and logical operations, such as:

  • SHOW and SELECT to show data in a table
  • DISTINCT and LIMIT to limit query results
  • Sorting with ORDER BY
  • Wildcards and Regular Expressions to customize a query
  • INSERT INTO, UPDATE, and DELETE to modify table data with a query
Using a combination of those functions and keywords, I created more complex queries that would be useful in real internet database applications. Below are a few screenshots of the results of several of Bucky's tutorials:

Using customers.sql on phpAdmin to create Customers table:



Customers table after running customers.sql:



A union query that shows all items that have 190+ bids or cost $1,000+