© 1972–2018 BHG LLC
Bill Weinman on lynda.com · SQL Courses
This is where you will find support files for Bill's SQL 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:
Note for Internet Explorer and Edge users: There is a known issue with the latest versions of Microsoft's web browsers. They flag any code signed before 2016 as invalid. These files are not corrupt and you may download and install them. If you wish to avoid the error message, I recommend Google Chrome or another third-party browser.
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 corresponds 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.
XAMPP and the Heartbleed vulnerabilityThe versions of XAMPP distributed on this site are not at risk from the Heartbleed vulnerability. Using XAMPP for development is recommended only on a dedicated development machine, with a firewall that blocks access to ports 80, 443, 3306, (HTTP, HTTPS, and MySQL respectively), as well as any other ports you are using for development, from the public-facing network. You should never expose your development machine to the public internet.
The versions of SID and CRUD distributed with my earliest SQL courses do not work with PHP warnings enabled. The 1.3 version here fixes that.
With the 2014 releases of updated SQL Essential Training and MySQL Essential Training, I released SID and CRUD 2.6.9 with a number of new features including support for MySQL, SQLite, and PostgreSQL. This version of SID also supports multiple statements, triggers, and stored procedures.
If you experience trouble downloading Notepad++ from their web site, here's a recent version:
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.