Bill’s courses SQL Essential Training and MySQL Essential Training are available on both the lynda.com and Linkedin Learning platforms. This page has support files and other information about Bill’s SQL courses.
New MySQL (2019) Titles
My new MySQL titles for 2019 no longer require XAMPP. Please follow the instructions in MySQL Installation and Configuration to install and configure the MySQL Server and Workbench on your workstation.
My current MySQL titles include:
- MySQL Installation and Configuration · July 2019
- MySQL Essential Training · July 2019
- MySQL Advanced Topics · Nov 2019
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 Essential Training 2018: xampp-win32-7.2.1-0-VC15-installer.exe
- Windows XAMPP for MySQL Essential Training 2014: please see the latest edition of this course
If you are using a Mac, please download this file:
- Mac XAMPP for SQL Essential Training 2018: xampp-osx-7.2.4-0-installer.dmg
- Mac XAMPP for MySQL Essential Training 2014: please see the latest edition of this course
Note Bene: 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 (from Apache Friends) for running the examples. For the purposes of this course, please download XAMPP from this page instead of the Apache Friends web site.
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.
Note bene: If you are having trouble installing XAMPP, please make sure you are using an installer from this page before asking for help.
For the adventurous user who wants to install things independently, this is the latest version of SID, my SQL Interactive Demonstrator. This version includes support for MySQL, SQLite, and PostgreSQL titles. If you are following one of my lynda.com/Linkedin courses, PLEASE use the version included in the exercise files. I cannot offer any support for this version.
- SID and CRUD 3.6.5: SID-CRUD-3.6.5.zip
The help request form on lynda.com or Linkedin Learning 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.