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.

XAMPP Downloads

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:

• Windows XAMPP: xampp-win32-1.7.1-installer.exe

If you are using a Mac, please download the file corresponding to the course you are taking:

• Mac XAMPP for SQL Course: xampp-macosx-0.7.4.dmg
• Mac XAMPP for MySQL Course: xampp-macosx-1.0.1.dmg

Note: Either of these will work for either course. The installation is subtly different, so if you are following the installation instructions you'll want to choose the file that corresponds to the course you're taking.

More explanation

Both of my SQL courses, SQL Essential Training and MySQL Essential Training, 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.

Other downloads

Some people are having trouble downloading Notepad++ from the sourceforge web site. Here's a copy just in case you need that:

• Notepad++ (editor for Windows) • npp.5.5.1.Installer.exe

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.)

• Fixup SID/CRUD permissions (shell script) • fixup-sid-crud.zip

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.

• SID and CRUD 1.3 • SID-CRUD-1.3.0.zip
• SID and CRUD 2.2 • SID-CRUD-2.2.0.zip

Asking for help

The help request form on lynda.com is designed to help you by collecting the necessary information as you submit your request. If you choose to write directly to me for help please be sure to include the following information:

• What course are you taking?
• What lesson are you on?
• What platform and version are you using (e.g., Mac OSX 10.6.3, or Windows XP SP3)?
• What browser and version are you using?
• You may copy/paste this browser user-agent string:
  CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
• What version of XAMPP did you install?
• A full detailed description of the problem.

Please know that I strive to provide the best courses I can and I want to help you succeed in your learning adventure. I will do everything I can to help you, with the information and resources I have available.