My name is Bucky Roberts. I am a computer programmer and web developer. I started working for Google in 2008 and also have a YouTube channel "thenewboston" that has over 700,000 subscribers. I make tutorials on computer programming, Adobe software, computer science and many other topics!
Go from Beginner to Pro in MySQL Databases with Bucky Roberts.
Introduction to Databases
Getting a MySQL Server
Creating a Database
SHOW and SELECT
Basic Rules for SQL Statements
Getting Multiple Columns
DISTINCT and LIMIT
Basic Data Filtering and WHERE
Advanced Filtering Using AND and OR
Are you IN or are you NOT IN?
How Search Engines Work
More on Wildcards
Creating Custom Columns
More on Aggregate Functions
Another Subquery Example
How to Join Tables
I'm not that new with SQL but this course helped refresh my memory. If you are new and want to learn some basic SQL then go for it. Absolutely awesome job Bucky!
Shameless HostGator plug that uses the phpMySQL interface. Slams the command line (Windows, of course) as the domain of 60 year olds. Great if you want to play with a simple, browser based interface, but hardly the domain of someone who wants to gain a real understanding of SQL.
I am not new to MySQL or databases in general but decided to fly through this course as a refresher and to see how MySQL would be thought. First of all .. this is NOT a course about MySQL databases, it is about how to write SQL queries on MySQL databases. It teaches the basics quite quickly and in an entertaining way. I had no difficulties watching video after video - it never got boring. Each video is less than 10 minutes which makes this a really quick course. Some examples are not very logic (eg using the 'customer data' to present 'seller data') but the principles are explained correctly. The negatives: the course is clearly no longer maintained. The course stops after lecture 22 but off-site it is available and comprises 33 videos in total. Also the course materials are appended to the course, and the suggested download location is no longer available. Google was my friend tho and I have added the new locations to the comments.
Awesome: Covers from the real basics to advanced MySQL. Fast: I've managed to complete it in 2 days (or less). Cool: Mr. Bucky Roberts is a really funny dude. Simply Amazing! (Oh, did I mentioned its FREE?!) :B
Well done. Easy to follow, no wasting time.