Get an overview of the exercise files, which allow you to follow along on your computer.
- [Narrator] The exercise files for this course are included…with your basic Lynda.com or LinkedIn Learning membership.…If you are a Lynda.com or LinkedIn Learning 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.…In the Chapters folder,…you'll find one file for each chapter.…To follow along with the lessons,…make a working copy of this file,…choose the corresponding database,…and refer to or copy and paste each SQL command into SID.…
For example here on Windows, open the exercise files.…I go to Chapters, and I hold down the control key…and I just drag the file a little bit,…and now I have a copy of this exercise file for chapter two.…I can now open this in Notepad++…and I can open up my browser and open up SID,…which is where we will be doing the exercises,…and now I simply copy and paste.…
So I'll copy this command here, pressing Ctrl+C to copy,…
- Understanding SQL terminology and syntax
- Creating new tables
- Inserting and updating data
- Writing basic SQL queries
- Sorting and filtering
- Accessing related tables with JOIN
- Working with strings
- Understanding numeric types
- Using aggregate functions and transactions
- Automating data with triggers
- Creating views
- Defining functions in PHP
Skill Level Beginner
2. SQL Overview
3. Fundamental Concepts
7. Dates and Times
Dates and times1m 52s
11. Views and Subselects
12. Defined Functions
13. 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.