Join Bill Weinman for an in-depth discussion in this video Reading with JOIN, part of PostgreSQL 9 with PHP Essential Training.
The Join keyword is used as a clause and select for retrieving data from two or…more tables in one query.…This can be a little bit confusing, so let's look at an example.…I'm going to select the world database. I am just going to go ahead and run this…query, and you'll see that I've got a list of country names and languages that…are spoken in those countries, and this is the query that produces that, and it…produces it from two different tables.…There is a countryLanguage table and there is a country table, so let's take a…look at these two tables.…We're just going to look at the first five rows from each of them, so the…countryLanguage table just has country code and the language, whether or not…it's the official language and the percent of the population that speaks that language.…
The country table on the other hand has a lot of stuff, but you'll notice…that it has a corresponding code and it's got the name of the country, and these…are the things that we're interested in.…So when we look at this Join query here, we see we are selecting From…
- Installing PostgreSQL
- Understanding database architecture
- Inserting, updating, and deleting data in a table
- Creating a database library
- Indexing ID fields
- Storing numbers, text, and Boolean values
- Reading data
- Using casts to force type
- Using mathematical functions
- Concatenating strings
- Working with date and time functions and operators
- Defining CRUD
- Using PHP to insert, read, update, and delete rows in a database
Skill Level Beginner
1. Quick Start
2. Creating a Database
3. Data Types
4. Storing and Reading Data
5. SQL Expressions
6. Mathematical Functions and Operators
Using math functions3m 2s
7. String Functions and Operators
8. Date and Time Functions and Operators
9. PHP Interfaces
10. Web Applications
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
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.