v

您的位置:VeryCD教育计算机


《PostgreSQL和PHP数据库管理基础教程》(PostgreSQL 9 with PHP Essential Training)[光盘镜像]

  • 状态: 精华资源
  • 摘要:
    发行日期2011年
    对白语言英语
    文字语言英文
  • 时间: 2011/12/01 00:57:05 发布 | 2011/12/01 09:37:06 更新
  • 分类: 教育  计算机 

MTina

精华资源: 3862

全部资源: 3863

相关: 分享到新浪微博   转播到腾讯微博   分享到开心网   分享到人人   分享到QQ空间   订阅本资源RSS更新   美味书签  subtitle
该内容尚未提供权利证明,无法提供下载。
中文名PostgreSQL和PHP数据库管理基础教程
英文名PostgreSQL 9 with PHP Essential Training
资源格式光盘镜像
发行日期2011年
地区美国
对白语言英语
文字语言英文
简介

IPB Image

语言:英语
网址: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 :/
: wearenowhere@hush.ai :
. /:
.

正在读取……

这里是其它用户补充的资源(我也要补充):

暂无补充资源
正在加载,请稍等...

点击查看所有31网友评论

 

(?) [公告]留口水、评论相关规则 | [活动]每日签到 轻松领取电驴经验

    小贴士:
  1. 类似“顶”、“沙发”之类没有营养的文字,对勤劳贡献的楼主来说是令人沮丧的反馈信息。
  2. 提问之前请再仔细看一遍楼主的说明,或许是您遗漏了。
  3. 勿催片。请相信驴友们对分享是富有激情的,如果确有更新版本,您一定能搜索到。
  4. 请勿到处挖坑绊人、招贴广告。既占空间让人厌烦,又没人会搭理,于人于己都无利。
  5. 如果您发现自己的评论不见了,请参考以上4条。