PostgreSQL 9 with PHP Essential Training
MOV | AVC 72kbps | English | 960x540 | 15fps | 4h 45mins | AAC stereo 96kbps | 452 MB
Genre: Video Training
In this course, author Bill Weinman shows how to architect PostgreSQL databases and integrate them into web applications using PHP. The course covers the basics of creating tables, storing data with data types, and working with expressions, operators, and strings. The course also explores the differences between the PDO and pgsql interfaces and demonstrates managing a database in PHP. Exercise files accompany the course.
Topics include:
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
Format : QuickTime
Format/Info : Original Apple specifications
File size : 5.89 MiB
Duration : 4mn 49s
Overall bit rate : 171 Kbps
Encoded date : UTC 2011-11-05 01:22:40
Tagged date : UTC 2011-11-05 01:22:40
Writing library : Apple QuickTime
Copyright : lynda.com
Video #1
ID : 1
Format : AVC
Format/Info : Advanced Video Codec
Format profile : Main@L3.1
Format settings, CABAC : Yes
Format settings, ReFrames : 3 frames
Codec ID : avc1
Codec ID/Info : Advanced Video Coding
Duration : 4mn 49s
Bit rate mode : Variable
Bit rate : 72.0 Kbps
Width : 960 pixels
Height : 540 pixels
Display aspect ratio : 16:9
Frame rate mode : Constant
Frame rate : 15.000 fps
Resolution : 24 bits
Colorimetry : 4:2:0
Scan type : Progressive
Bits/(Pixel*Frame) : 0.009
Stream size : 2.48 MiB (42%)
Encoded date : UTC 2011-11-05 01:22:40
Tagged date : UTC 2011-11-05 01:22:40
Audio #2
ID : 2
Format : AAC
Format/Info : Advanced Audio Codec
Format version : Version 4
Format profile : LC
Format settings, SBR : No
Format settings, PS : Yes
Codec ID : 40
Duration : 4mn 49s
Bit rate mode : Variable
Bit rate : 96.0 Kbps
Maximum bit rate : 99.7 Kbps
Channel(s) : 2 channels
Channel positions : Front: L R
Sampling rate : 48.0 KHz
Resolution : 16 bits
Stream size : 3.31 MiB (56%)
Encoded date : UTC 2011-11-05 01:22:40
Tagged date : UTC 2011-11-05 01:22:40
No mirrors please