The first few videos go over introducing databases and creating them. Without a database, you cannot properly use SQL since it involves communicating with said database. It is important to understand how to create and add users to a database before working with acutal SQL code.
The next several videos go over how to manipulate the information in the database. Specifically, the videos show how to use SQL commands to display data meeting specific criteria. This can be done by limiting how many columns are displayed, sorting the results, filtering results with WHERE, and others.
Further along in the videos, Bucky introduces some more topics including functions, subqueries, and joining tables. Functions and subqueries show more ways to manipulate and order the information in the database. Joining tables together allows SQL to get information from more than one table in the database, and this information can be used to create an entirely new table or used as is.
The final videos show how to create new tables, inserting and updating information into tables, and removing tables from the database. These, along with the rest of the videos in Bucky's SQL tutorial, show how you can get information from users, store it, and retrieve that information later. This allows for creating more interactive webpages with features like a log-in system or an auction site like in Bucky's videos.
