Join Bill Weinman for an in-depth discussion in this video Using the exercise files, part of SQL Essential Training.
- View Offline
- Exercise Files
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
1. SQL Quick Start
Understanding joins2m 23s
Dates and times1m 59s
10. Subselects and Views
11. A Simple CRUD Application
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.