Join Bill Weinman for an in-depth discussion in this video Reading data with SELECT, part of PostgreSQL 9 with PHP Essential Training.
- View Offline
- Exercise Files
The SELECT statement is at the heart of the SQL language and Postgres supports…all its various functions.…Let's take a look at the basics.…Here I've selected the album database from the database selector over here,…and here's some SELECT statements operating on the album table from the album database.…The first one you've seen, it's very common,…this is just select everything from the table, so that will select the entire table.…The second one selects just a few columns from the table.…And the third one is the same as the second one, but it's actually giving us…human readable names for the various columns,…Artist, Album and Release Date.…
And you'll notice that in Postgres you need to put quotes around these if you…don't want it to fold everything to lowercase.…So even though there's no spaces within this string, it still needs to have quote marks.…And you'll notice that there are double quote marks, they are not the single…quote marks that represent an SQL string, because this is not an SQL string,…
- 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
PHP with MySQL Beyond the Basicswith Kevin Skoglund10h 26m Intermediate
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?
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.