An Introduction to MySQL 5: Views
“The MySQL 5 series introduced quite a few changes. Triggers and stored procedures were two of the big ticket items. One of the lesser known additions, at least from the amount of writing on the subject, is the introduction of views. While after a quick look at MySQL views, you might not see the obvious advantages, they’re there if you dig into them just a bit.”
Quick Tip: Working with MySQL and INNER JOIN
“In today’s video quick tip, we’ll go over when and why to use JOINs when working with your databases.”
Quick Tip: A Fast Overview of Querious (MySQL Manager)
“In today’s video quick tip, we’ll have a quick (not sponsored) overview of a Mac database manager for MySQL that I came across yesterday, called Querious. As I mention in the screencast, I particularly like this one, because it just works — without being too complicated or overwhelming in the way that PHPMyAdmin might be for some.”
Introduction to MySQL Triggers
“Chances are, you know what a database trigger is, at least in conceptual terms. Chances are even greater that you know that MySQL supports triggers and has supported them for quite some time. I would guess, even armed with this knowledge, that a good many of you are not taking advantage of triggers with MySQL. They’re one of those things which should absolutely be in your development toolbox, as they can really change the way that you look at your data.”
Visual Database Creation with MySQL Workbench
“In today’s tutorial, you’ll learn how to use a visual database modeling utility to draw a database diagram and automatically generate SQL. Specifically, we’ll review how to use MySQL Workbench, a cross-platform, visual database design tool.”
How to Create a PHP/MySQL Powered Forum from Scratch
“In this tutorial, we’re going to build a PHP/MySQL powered forum from scratch. This tutorial is perfect for getting used to basic PHP and database usage. Let’s dive right in!”
