New Bostion MySQL Tutorials

In this tutorial instructed by Bucky, I learned the basis of MySQL functions/statments and syntax. The tutorial consisted of 33 videos and walked viewers through MySQL through Hostgator. The videos were easy to follow and perfect for beginners to follow to comprehend and understand. Bucky's tutorial taught me how to create databases, tables, and views. Along with creating, the tutorial showed users how to update, alter, modify, and delete columns as well as other ways to edit the database and it's components. I also learned how to use functions and operators provided in SQL. The images below are a few screenshots of the examples I worked out along with Bucky.

The image below is the users table that I created. I displayed the table with the 'SELECT * FROM users' syntax.

The image below is an example of the SQL syntax to view the city, state, and name columns from the customers table ordered by state then name.

The image below is an example of the SQL syntax to insert new rows to the items table by giving values to columns.

The image below is a screenshot of a VIEW I created which I named "mostbids" that is ordered from most bids or ascending order.

Here is the link to Bucky's Tutorials.