Following are a few screenshots from the fantastic Lynda.com video: Up and Running with phpMyAdmin. phpMyAdmin is a fantastic tool. Not only is it helpful to troubleshoot and update your site but to test SQL entries as well. Highly recommend this video.
Finding Version Information
Setting Up a User Account
Defining a Table
Importing Data From Excel or a CSV File
Setting Up Foreign Key Constraint
QBE Setting Multiple Conditions in Where Clause
Create a Stored Procedure
Analyzing Table Structure
UP AND RUNNING WITH MYSQL DEVELOPMENT
Following are a few screenshots from a great SQL learning video by Lynda.com: Up and Running My SQL Development. I felt SQL was going to be my strength in coding but after other videos I felt inundated. This video brought everything into perspective. Highly recommended.
