Join Bill Weinman for an in-depth discussion in this video Understanding databases and tables in PostgreSQL , part of PostgreSQL 9 with PHP Essential Training.
As a starting point, it's good to understand how a Postgres database works. In Postgres a database is a general container. It stores both data and metadata. It includes the tables related to the database, as well as metadata describing permissions and other attributes related to the database. An application communicates with a database driver that knows how to talk to the Postgres server. This allows the application to log in to the server with the appropriate credentials, and to send SQL statements and receive replies, including rows of data from the tables in the database.
The driver then communicates with the server on behalf of the application, exchanging the credentials, statements, and data responses with the server. The database in turn contains tables, among other things. Those tables contain the rows and columns of data that make your application do that thing it does. So in order to create a database application, you must create the database, design and code the tables, using rows and columns of relevant data designed to interact and express the intention of the application.
In this chapter, we'll look at how to create databases and tables in Postgres.
- 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.