© 1972–2013 BHG LLC
Bill Weinman on lynda.com · SQL and MySQL
This is where you will find support files for Bill's SQL and MySQL Essential Training courses on lynda.com.
If you are taking one of my SQL courses on lynda.com, please download XAMPP from this page, instead of from apachefriends.org, according to the course you are taking:
If you are using Windows, please download this installer:
If you are using a Mac, please download the file corresponding to the course you are taking:
Note: The differences between these versions of XAMPP may be subtle, so if you want to follow along with the installation and be sure that the instructions work the same for you as they did for me in the videos, please use the file that cooresponds to the course you are taking.
All of my SQL courses, use the XAMPP package for running the examples. Originally the courses directed students to download the XAMPP package from the Apache Friends web site. That was a mistake. Please don't do that.
The good folks at Apache Friends update their packages frequently, and normally this would be a good thing. There have, however, been two unfortunate side effects of this otherwise exemplary behavior: 1) Some releases have introduced bugs that effect the lessons in the courses; and 2) The installation procedure has changed such that it becomes hard to follow the installation lessons.My solution is this page. Please download the XAMPP installation files from here. This will ensure that you have an experience that matches that in the movies for the courses.
Please note: If you are having trouble installing XAMPP, please make sure you are using an installer from this page before asking me for help.
Some people are having trouble downloading Notepad++ from the sourceforge web site. Here's a copy just in case you need that:
Occasionally a Mac user has reported permissions problems with SID and CRUD after unzipping the exercise files. If you are getting "Access Forbidden" errors, this is likely the cause. I have written a script to fix the problem. Download this file, open it, and follow the instructions in the README.txt file. (This applies to Mac users only.)
The versions of SID and CRUD distributed with SQL Essential Training do not work with PHP warnings enabled. This was fixed before MySQL Essential Training was recorded. The 1.3 version here is the fixed version. (If you have the files from MySQL Essential Training, you already have this.)
With the recording of SQLite 3 with PHP Essential Training I released SID and CRUD 2.2 with a number of new features including support for SQLite 3 databases (MySQL is still supported too). This version of SID also supports multiple statements and trigger definitions.
The help request form on lynda.com is designed to help you by collecting the necessary information as you submit your request. Please do not write to me directly for help with my lynda.com courses. I am not able to provide support directly.