A VIEW can be a simple straight query, or it can be a more complex joined query. Learn how the technique is the same.
- [Instructor] A view can be a simple, straight query…or it can be a more complex joined query.…The technique is the same.…Here in the album database, I have pasted in a nice little…joined query from our chapter eleven exercise file.…And it's a simple joined query with…columns from the track and album tables.…We're getting artist, title as album, from the album table…and title as track and track number…and minutes and seconds from the track table.…
When I press go, you see we get this nice joined result…with all of the tracks with album information…in them from both of these tables.…Now, if I want to save this, if I want to use…this query over and over again,…all I have to do is say, CREATE VIEW joined album,…I'll name it that, AS and leave the query there.…And when I press go, we've created a view.…And so I can say, SELECT everything FROM our joined album…view, like that, and we get our nice, joined query.…
We can use this joined view just like it were a table.…I can say, WHERE artist equals, say Jimi Hendrix.…
- 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.