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 for SQL or MySQL Course: xampp-win32-1.7.1-installer.exe
• Windows XAMPP for SQLite or PostgreSQL: xampp-win32-1.7.3-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
• Mac XAMPP for SQLite or PostgreSQL Course: xampp-macosx-1.7.3.dmg

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.

More explanation

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.

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

Other help

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.