Join Bill Weinman for an in-depth discussion in this video Using the exercise files, part of SQL Essential Training (2014).
The exercise files for this course are included with your basic lynda.com membership. If you are a lynda.com member, you have access to the exercise files used for this title. Copy the exercise files to a location where you can find them on your system. I've copied them to the desktop on this system. Wherever you put it, just make sure you can find it. The SID and CRUD folders contain php applications that are used for demonstrating the exercises. When you follow the installation movie for your platform, you 'll be given directions for installing them on your system and this is what they look like.
This is SID. The place to type your SQL or place to select your database and this is CRUD, with a little album and track database that we'll be using later in the course. The SQL folder contains the SQL source for each of the databases and the databases themselves. The test database has a small set of sales data and three tables for customer item and sale data. The album database has albums and tracks for a few nice recordings from my collection.
And the world database is a large public domain database from the 1990s with information about countries and capitals from that era. It's old data but it's very useful for experimenting with S.Q.L. Each of the chapter folders contains just one file with the SQL that's used in that chapter. You may type directly into SID, or for some of the larger statements, you might want to copy and paste them from this file instead. The exercise files are here to make your learning experience easier and more powerful. Take your time, experiment a lot, and happy learning.
- Understanding SQL terminology and syntax
- Creating new tables and records
- Inserting and updating data
- Writing basic SQL queries
- Sorting and filtering
- Accessing related tables with JOIN
- Working with strings
- Finding the numeric type of a value
- Using aggregate functions and transactions
- Updating a table with triggers
- Creating views
Skill Level Beginner
Q: For Mac OS X: When I try to start the Apache Web Server from the XAMPP control panel, it doesn't start, and when I open "localhost" in my web browser, I see a white screen that says "It Works!" instead of the XAMPP page.
sudo apachectl stop
Q: I'm on a Mac, and I get an error in SID that says "attempt to write a read only database." How can I fix this?
A: This usually means that the database folder does not have sufficient permissions for writing by the web user. This can happen if you create the SQL folder new, rather than copying it from the Exercise Files. Here's how to fix this:
- Open a Finder window and Navigate to /Applications/XAMPP/htdocs/SQL
- Control-click on the SQL folder and select "Get Info" from the context menu.
- Under "Sharing and Permissions" (you may need to open the disclosure triangle), in the "everyone" row, select "Read & Write."Then you can close the Info window.
- Now repeat the process for the three *.db files inside the folder.