Learn how the ability to combine results from related rows in different tables is a fundamental quality of a relational database.
- The ability to combine results…from related rows in different tables…is an important part of using…a relational database system.…In SQL, this is accomplished with the join clause.…Here, we're going to be using the test database…and I've already pasted some SQL in here…from our chapter four example file.…So, I've created two tables, one called left,…one called right, and they're very simple.…They have an ID column and a description column.…You notice that I'm populating the ID column manually here.…
As I insert data into it, you can see that…we have left oh-one through oh-nine and…right oh-six through eleven and…all the way up to 14 on the right.…The point of this is that these overlap some.…The IDs overlap some.…It's just going to make it so that we can…demonstrate some interesting stuff with the join.…I'm going to press go here, and you see that…here's our select from left and our select from right.…
Now, I'm gonna type in a select…statement with the join clause…so you can get an idea of how this looks.…I'll say select L dot description as left…
- 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.