中文名: PostgreSQL和PHP數據庫管理基礎教程
英文名: PostgreSQL 9 with PHP Essential Training
資源格式: 光盤鏡像
發行日期: 2011年
地區: 美國
對白語言: 英語
文字語言: 英文
簡介:

語言：英語
網址：http://www.lynda.com/PHP-5-tutorials/PostgreSQL-9-with-PHP-Essential-Training/73930-2.html
類別：教程
lynda.com 出品的PostgreSQL和PHP數據庫管理基礎教程，由Bill Weinmann主講。教程時長4小時45分。
Bill Weinmann展示了如何構建PostgreSQL數據庫，並融入使用PHP的Web應用程序。課程內容包括創建表的基礎知識，數據類型存儲數據，並與表達式，運算符和字符串工作。課程還探討了PDO和pgsql接口之間的差異，並演示如何在PHP數據庫管理。練習文件伴隨著課程。
PostgreSQL是自由的對象-關系數據庫服務器（數據庫管理系統），在靈活的BSD-風格許可證下發行。它在其他開放源代碼數據庫系統（比如MySQL和Firebird），和專有系統比如Oracle、Sybase、IBM的DB2和Microsoft SQL Server之外，為用戶又提供了一種選擇。PostgreSQL是一個歷史悠久的對象關系數據庫管理系統，由美國Great Bridge公司開發的，支持幾乎所有SQL功能，包括subselects、transactions以及用戶自定義類和功能。
Course name: PostgreSQL 9 with PHP Essential Training
Author: Bill Weinman
Duration: 04h 45m
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
下載鏈接來自TLF
未經過安裝測試與安全檢測，使用者後果自負與本論壇無關
軟體版權歸原作者及其公司所有，如果你喜歡，請購買正版
目錄:
Introduction
Welcome 00m 58s
Using the exercise files 00m 58s
Prerequisites 03m 19s
Installing PostgreSQL on a Mac 14m 49s
Installing PostgreSQL on a PC 11m 16s
Installing PostgreSQL on Ubuntu Linux 22m 17s
Installing XAMPP and SID on a Mac 08m 32s
Installing XAMPP and SID on a PC 13m 34s
44m 17s
1. Quick Start Getting the most out of the Quick Start 03m 52s
Creating a database 05m 28s
Creating a table 07m 01s
Inserting data into a table 08m 25s
Getting data from a table 04m 37s
Updating data in a table 04m 29s
Deleting data from a table 03m 05s
Creating a database library 07m 20s
29m 31s
2. Creating a Database Understanding databases and tables in PostgreSQL 01m 15s
Creating a database 07m 14s
Defining a table in SQL 05m 35s
Creating a table in PHP 06m 41s
Creating indexes 05m 20s
Indexing ID fields 03m 26s
23m 45s
3. Data Types Understanding data types 02m 53s
Storing numbers with INTEGER 03m 07s
Storing decimal numbers with NUMERIC 01m 59s
Storing floating-point numbers with REAL 05m 29s
Storing text 03m 17s
Storing Boolean values 02m 11s
Storing dates and times 04m 49s
15m 01s
4. Storing and Reading Data Storing and deleting data with INSERT, UPDATE, and DELETE 05m 21s
Reading data with SELECT 05m 24s
Reading with JOIN 04m 16s
08m 07s
5. SQL Expressions Understanding SQL expressions 01m 07s
Matching patterns with LIKE 02m 51s
Choosing from multiple conditions with the CASE expression 01m 43s
Using casts to force type 02m 26s
07m 46s
6. Mathematical Functions and Operators Using operators for simple arithmetic 04m 44s
Using math functions 03m 02s
12m 19s
7. String Functions and Operators Finding the length of a string 03m 43s
Concatenating strings 01m 34s
Returning parts of a string 01m 01s
Replacing strings within strings 01m 24s
Trimming and padding strings 02m 49s
Converting numbers 01m 48s
09m 37s
8. Date and Time Functions and Operators Getting the current time and date 02m 24s
Specifying a specific time zone with AT TIME ZONE 04m 58s
Performing date and time arithmetic 01m 01s
Getting parts of a timestamp with EXTRACT 01m 14s
34m 24s
9. PHP Interfaces Choosing an interface 01m 39s
Using the PHP PostgreSQL extension interface 11m 33s
Using the PDO interface 09m 53s
Creating a library 11m 19s
24m 01s
10. Web Applications Defining CRUD 04m 18s
Using PHP to insert, read, update, and delete rows in a PostgreSQL database 07m 42s
Installing the testimonials database 03m 03s
An overview of the testimonials application 03m 07s
Managing the database in PHP 03m 29s
Displaying the testimonials using PHP 02m 22s
00m 31s
Conclusion Goodbye 00m 31s
代碼

. \ .
–:–––\\–––––––––––––––––––––––––––/\–––––:–
: \ :
. :
: \ .
: \\ :
_ __/\__ _______:___ ________\ __/\__ _______:__
\\____// . / | \ \____/ /ˆ . / ________._
______/ : /–––––––| _ \ _______/ _ :/ /ˆ |
./ / _, / _, | \ \/ˆ / /_____.___/ _, |.
// / \ \ / | \ \ /______ / / ||
–/–––––/_____/\ \––––––'––––––\______\–––' / '____._/–––––––––––'–/–
–:–––––––––––/\\___.___\\–––– – _._________._ –//______//––:–––––––––––––––:–
: _ ___ _ ___ _ :__ _ ___ _\ /_ ___ _ ___ : ___ _ ___ _ :
–|__\___\__\___\__\:__\__\___\_\__ iRONiSO __/_/___/__/___/:_/___/__/___/__|–
: `–––––––––––/––\__._.__/––\–––––––––––––' :
\\
\
TiTLE: Lynda.com.PostgreSQL.9.With.PHP.Essential.Training–iRONiSO
TYPE : BOOKWARE CRACKER : iRONiSO
FiLE : 32 X 15MB PACKAGER : iRONiSO
TOTAL : CD SUPPLiER : iRONiSO
PLATFORM : WINDOWS FORMAT : Bin/Cue
RLS DATE : 2011.11.29 PROTECTiON : NONE
. . .
_ _ ___ _ ___ _ :__ _ ___ __._ _/'\_ _.__ ___ _ ___ : ___ _ ___ _ _
\__\___\__\___\__\:__\__\___\_\___\\___//___/_/___/__/___/:_/___/__/___/__/
: `––/––\__._.__/––\––' :
Course Outline
Description
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
. . .
_ _ ___ _ ___ _ :__ _ ___ __._ _/'\_ _.__ ___ _ ___ : ___ _ ___ _ _
\__\___\__\___\__\:__\__\___\_\___\\___//___/_/___/__/___/:_/___/__/___/__/
: `––/––\__._.__/––\––' :
For Additional info
http://www.lynda.com/PHP–5–tutorials/PostgreSQL–9–with–PHP–Essential–Training/73
_ _ ___ _ ___ _ :__ _ ___ __._ _/'\_ _.__ ___ _ ___ : ___ _ ___ _ _
\__\___\__\___\__\:__\__\___\_\___\\___//___/_/___/__/___/:_/___/__/___/__/
: `––/––\__._.__/––\––' :
GROUP NEWS
Web access Training Libraries / Education video's
Online Training Library Access
Anything if u think can be helpful in e–Learning
Exclusive team dump on 100 Mbit with 500 GB disk
_ _ ___ _ ___ _ :__ _ ___ __._ _/'\_ _.__ ___ _ ___ : ___ _ ___ _ _
\__\___\__\___\__\:__\__\___\_\___\\___//___/_/___/__/___/:_/___/__/___/__/
: `––/––\__._.__/––\––' :
NOTICE
You Like The Release Please Purchase As It Is Required For
All As It Got Lot Of Balls To Make It Online For People Like
You And Me As They Deserves The Best. :)
. . _._________._ . .
: _ ___ _ ___ _ :_ _____ __ _\ /_ __ _____ __ : ___ _ ___ _ :
–|__\___\__\___\__\__\\__ \\ \\__ iRONiSO __// // __//__/__/___/__/___/__|–
: : – ––\_// /––\__._.__/––\ \\_/–– – : :
. –zfr– \ : \_/ \_/ : / 2o! .
`––––––––––––––\\–:– – – –:–//––––––––––––'
\ : Contact Information :/
: [email protected] :
. /:
.