For results from related tables, you may combine results from more than one table by using the JOIN clause in your query.
- It's the nature of a relational database that some tables … contain information related to other tables. … Using the join clause, SQL may easily perform queries … on related data from multiple tables. … Typically, unique ID columns are used … to create relationships. … All modern database systems support automatic generation … of these ID columns, and they work well for creating … and managing simple or complex relationships between tables. … When you need a result that includes related rows … from multiple tables, you'll need to use a joined query. … You can visualize a joined query as a Venn diagram, … where each of your tables are represented … by intersecting shapes. … The intersection of the shapes where the tables overlap … are the rows where a condition is met. … ID columns are often used for this purpose, … where the condition to be met is matching … of the IDs of rows. … The simplest and most common form of a join … is the inner join. … This is the default and it's the join you get when you use …
This course was created by Bill Weinman. We are pleased to offer this training in our library.
- How databases are organized
- Selecting rows and columns
- Creating new tables
- Inserting and updating data
- 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
- Using CRUD functions
Skill Level Beginner
2. SQL Overview
3. Fundamental Concepts
7. Dates and Times
Dates and times2m 6s
11. Views and Subselects
12. 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.