v

您的位置:VeryCD教育计算机


《PostgreSQL数据库教程》(VTC.COM POSTGRESQL)[光盘镜像]

  • 状态: 精华资源
  • 摘要:
    主讲人Dima Kassab
    发行日期2012年02月06日
    对白语言英语
    文字语言英文
  • 时间: 2012/02/14 00:41:01 发布 | 2012/02/14 11:57:05 更新
  • 分类: 教育  计算机 

MTina

精华资源: 3862

全部资源: 3863

相关: 分享到新浪微博   转播到腾讯微博   分享到开心网   分享到人人   分享到QQ空间   订阅本资源RSS更新   美味书签  subtitle
该内容尚未提供权利证明,无法提供下载。
中文名PostgreSQL数据库教程
英文名VTC.COM POSTGRESQL
资源格式光盘镜像
主讲人Dima Kassab
发行日期2012年02月06日
地区美国
对白语言英语
文字语言英文
简介

IPB Image

网址:http://www.vtc.com/products/PostgreSQL-Tutorials.htm
类别:教程

VTC出品的教程:PostgreSQL数据库教程,主讲Dima Kassab。

开源和免费的数据库管理系统PostgreSQL的介绍。Dima Kassab介绍包括创建数据库和数据库对象所需的基本知识。当然假设没有先验知识的数据库概念。它设置为更高级的主题,如数据库管理和开发的基础。内容包括:安装,数据类型,主数据库运营商/功能,并创建/修改数据库对象如表,视图,索引和序列。

Course: PostgreSQL
Author: Dima Kassab
SKU: 34298
ISBN: 978-1-61866-033-6
Release Date: 2012-02-06
Duration: 8 hrs / 95 tutorials
Work Files: Yes
Captions: No

下载链接来自TLF
未经过安装测试与安全检测,使用者后果自负与本论坛无关
软体版权归原作者及其公司所有,如果你喜欢,请购买正版



目录

About the Course (02:32)
About PostgreSQL (03:31)
Resources (05:17)
Installation
Installing Locally (05:11)
Regarding Installation on a Server (03:37)
Stop and Start the Service Locally (02:22)
Create / Drop / Connect to a Database pt. 1 (05:12)
Create / Drop / Connect to a Database pt. 2 (02:51)
Psql Help (06:04)
Keywords and Identifiers (02:42)
Comments (03:03)
Data Types
Numeric Types (05:39)
Character Types (03:26)
Date / Time Types pt. 1 (06:22)
Date / Time Types pt. 2 (04:53)
Boolean Types (03:24)
Enumerated Types (03:08)
Geometric Types (05:24)
Arrays (04:20)
Defining Tables
Create / Drop a Table Using Command Line (04:25)
Primary Key Constraint (05:40)
Foreign Key Constraint pt. 1 (04:33)
Foreign Key Constraint pt. 2 (03:39)
Foreign Key Constraint pt. 3 (06:13)
Check Constraints pt. 1 (06:10)
Check Constraints pt. 2 (03:56)
Not Null Constraint (03:58)
Unique Constraint (03:34)
Create a Table Using pgadmin (03:50)
Creating Constraints Using pgadmin pt. 1 (06:35)
Creating Constraints Using pgadmin pt. 2 (04:34)
Default Values (04:54)
Drop Table Cascade (03:26)
Working with Tables
Insert pt. 1 (04:31)
Insert pt. 2 (05:28)
Update (04:59)
Delete (04:22)
Cascade Option (07:22)
Truncate (03:18)
Working with Tables Using pgadmin pt. 1 (07:09)
Working with Tables Using pgadmin pt. 2 (05:05)
Queries
Simple Query (03:01)
Retrieving a Portion of the Rows (03:23)
Sorting Queries (04:57)
Table and Column Aliases (04:30)
Limit and Offset Options (04:09)
Combining Queries (05:31)
Aggregate Functions (04:54)
Group By and Having pt. 1 (05:51)
Group By and Having pt. 2 (03:31)
Inner Joins Between Tables pt. 1 (06:04)
Inner Joins Between Tables pt. 2 (05:49)
Outer Joins Between Tables (05:11)
Cross and Self Joins (04:25)
Subquery Expressions pt. 1 (03:57)
Subquery Expressions pt. 2 (06:51)
Accessing Data Using pgadmin pt. 1 (04:27)
Accessing Data Using pgadmin pt. 2 (04:02)
Creating Views Using Command Line (04:03)
Creating Views Using pgadmin (03:33)
Transactions
Starting and Ending a Transaction (06:00)
Savepoints (05:26)
DeadLocks (05:18)
System Columns (05:24)
Modifying Tables
Changing a Column Data Type and Default Value (05:21)
Adding / Removing a Column (04:59)
Adding / Removing a Constraint (06:21)
Renaming a Column / Table (03:03)
Modifying Tables Using pgadmin (04:53)
Main Operators and Functions
Logical Operators (05:10)
Comparison Operators (06:08)
Mathematical Operators (03:12)
Mathematical Functions (06:32)
String Functions pt. 1 (06:49)
String Functions pt. 2 (03:09)
String Functions pt. 3 (06:03)
Pattern Matching pt. 1 (07:26)
Pattern Matching pt. 2 (07:07)
Date and Time Operators (05:08)
Date and Time Functions (06:52)
Sequences (06:56)
Conditional Expressions (06:46)
Schemas / Privileges
Create / Drop Schemas (06:25)
Grant / Revoke Privileges on Tables (06:03)
Grant / Revoke Privileges on Columns (06:52)
Grant / Revoke Privileges Using pgadmin (04:02)
Indexes
Index Usage and Benefits (03:02)
Index Types (02:52)
Create and Drop an Index (05:23)
Multi-Column Index (04:10)
Indexes on Expressions (05:09)
Unique Index and Partial Index (02:52)
Create and Drop Index Using pgadmin (03:52)
Conclusion
Course Wrap Up (04:30)
Credits
About the Author (01:59)

代码
▄▄▄
▄▄▄▄▄▄▄▀▀▀▀▀▀▀ █▓▄
▄▄▄▄▄▄▄▀▀▀▀▀▀▀ ███▓
█ █▓ ████
█ █ ▓███░
█ █ ▄ ░███▓
▄▄▄█▀▀▀▀▀▀▀▀▀▀▀▀█▄▄▄▄ ▓ █░ ▀ ▄▄▄▄▄▄▄▄██▓▀▀ ████
▄▒▓▀▄▄▄████████████▄▄▄▓▀▓▓▓▄▄ ░ █▓ ▀███ ▀██ ██ ████
░▒▓██▀▀▀██▀███▀██▀█▀██▓█▓▓▓▒▒░ █ █ ██▓ ██ ▀▓█ ██ ▓███░
░▒▓██ ▀▄█ █ █ █ █ ▀▄██▓█▓▓▓▒▒░ █ █ ███ ▀██ ▄▀ ▀▀▓▄ ░███▓
░▒▓██ ▀ █▄▀▄█▄▀▄█ █ ██▓█▓▓▓▒▒░ █ █░ ▄▀▀ ▀▀ ▀ ████
░▒▓███████████████████▓█▓▓▓▒▒░ ░ █ ▓ JUDGEMENT ████
░▒▓██ █▀█ █▀▄▀█ ▄▀█ █▓█▓▓▓▒▒░ ░ █ █ ▓███░
░▒▓██▄▀▄▀▄█ ▄ █ ▄▀█ ▀█▓█▓▓▓▒▒░ ░ █ █ ░██ ▓
░▒▓██▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀██▓█▓▓▓▒▒░ ░ ▓ █░ █ ██
░▒▓██▀▀▀█▀▀▀▀▀▀█▀█▀▀██▓█▓▓▓▒▒░ ░ ░█ ▓ ██ █
▄▀░▒▓██▀▀▀▀▀▀█▀▀▀▀▀█▀▀██▓█▓▓▓▒▒░ ░▄ █ █ ▓ ██░
▒ ▓░▒▓██▀▀▀█▀▀▀▀▀▀▀▀▀▀▀██▓█▓▓▓▒▒░ ░▒ █ █ ░█ █▓
▒ ░▒▓██▀▀▀▀▀▀█▀▀▀▀▀▀█▀██▓█▓▓▓▒▒░ ░▒ ▓ █░ Loyalty. Pride. Tradition ██ █
▒░▒▓████▀█▀████████████▓█▓▓▓▒▒░ ░▒ ░█ ▓ Since 1998 A.D. ░█ ██
░▒▓███▀▀▀▀▀▀▀▀▀▀▀▀▀▀██▓█▓▓▓▒▒░ ░▒▓ █ █ ▄▄▄▄▓██ █
░▀▀▄▄▄▀▀▀▀▀▀▀▀▀▀▀▀▀▀▄▄▄▄▀▀▀▒▒░░█▓▓▀▀▄█ ▄▄▄▄▄▄▄▄▀█▀█▀█▀▀▀█▀▄▀▄▀▄▀██
▄▀▀▄▄▄▓▓▓▓▓▓▓▓▓▓▓▓▓▓▄▄▄▄▀▀▀▄▄▀░▀▄▄ ▀▄▀█▀█▀█▀▄▀▄▀▄▀▄▀▄█▄█▄█▄▀▀▀▀▀▀▀▀▀ ▀
▓▓▀▀▀▄▄▄▄▄ ▄▄▀▀▀▀ ▀▀▀▀▓▓▓▄▄▀▓▀▄▄█▄ ▀▄█▄█▄█▀▀▀▀▀▀▀▀
░░░ ▒ █▀▀▄▄▀▀ ░░░░░░░░ ▀▀▓▓█▀▀ ░░ ░ ░░░░░░░░░░░░░░░░░░░░░░░░░
▒▒▒▒ ▒▄█▀ ▄▒▒▒▒▒▒▒▒▀ ▄▄▄ ▀▒▒▒ ▄▄▄▓▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒
▓▓▓▓▓▄▄▄▄▓▓▓▓▓▓▓▓▓█ ██▓▓▓ ▓▓▓▀ ▄▓▄▄▄▄▄ ▄▄▄▄▄ ▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀█ ▀▀▀ █▀▀▄▓██████████▓▀███▓▓ █▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
▀███▀▀▀▀▀▀▀▀▀▀▀▀▀ ███▓▓▀ ▄▓ ▀▀▀█▀▀ ▀█████ ▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀███▀
▓▀ ████▀ ███░ ▄▓█ ▄ ███████▓▒░ ▀▓
▀ ▄▄▄▄▄ ████ ███▓▓ ████▌▀▓▀████▓ ▄▄▄▄▄ ▀
▓████ ████ ▓████░ ▄▓▄ ████▄ █████ ████▓
███▓▓ ████▄ ▓███▓ ▀ ▄█▓▓███▄ ▀▓██ ▓▓███
▄████▀ █████ █████ ▄█▀ ▀███▓▓ ▀██ ▀████▄
▓████ ▀▄█████ ███▓▓▀ ▀█████ ██▄ ████▓
▀████ ▄▓▄ ▐█████ ▀▀▀ ▄ ████▀ ██▌ ▄▓▄ ████▀
▄ ▀▀▓█▄▀ ████▓ ▄▄ ▀▓▀ ▓▓█▀ ▄▓█▀ ▀▄█▓▀▀ ▄
▄▄▓▀ ▀▀▓████▓▀ ▀▀█▓▄▄▄██▀ ▓▓█████▓▀▀ ▀█▄▄
▓███ ▀▀▄▄ ░░▀▀▀ ▀▀ ▄▄▀▀ ██▓▓
▀▓██▄▄▄ ▀ ░ ▒▒ ░ ▀ ▄▄▄██▓▀
▀▄▄ ▀▀▀▓██████▄▄▄▄▄▄▄▄ ▀▄▒ ▓▓ ▒▄▀ ▄▄▄▄▄▄▄▄██████▓▀▀▀
▓▓▄ ▄ ▀▀▀▀▀▀▀▓▓███████▓█████▓ ██ ▓█████▓███████▓▓▀▀▀▀▀▀▀
██▓ ▄▓▄ ▀
███ ▀ * Title..: VTC.COM POSTGRESQL
███ * Date...: February 8th, 2012
▄ ███ * Type...: Bookware
▀▓███▓▓ █ * Disks..: 8x50mb
▄▄▄▓ ▄ ▄
▄▄▄ ▄ ▀▓▓█████████████████████████████████████████████▓▀
▓▓▓ ▄ ▀▄ ▀▀▓▄
▀▀▀▀ █ ▓▓ ▄ ▀
░▒▓██████▀ ▄▀ ▀▓▀ Release notes:
▄▄▄
███ ♀
███ This VTC course is an introduction to the popular open
███ source and free database management system PostgreSQL.
███ Author Dima Kassab covers the basics needed to create
███ databases and database objects. The course assumes no
███ prior knowledge of database concepts. It sets the
███ groundwork for more advanced topics such as database
███ administration and development. Topics covered include:
███ installations, data types, main database operators/functions,
███ and creating/modifying database objects such as tables,
███ views, indexes, and sequences.
███
███
███ More info:
███ http://www.vtc.com/products/PostgreSQL-Tutorials.htm
███
███ Install notes:
███♀
███ 1.) Unrar
███ 2.) Burn/Mount
███ 3.) Enjoy!
███
▓▓▓
▒▒▒
░░░
▄▄▄ ▄ ▀▓▓█████████████████████████████████████████████▓▀
▓▓▓ ▄ ▀▄ ▀▀▓▄
▀▀▀▀ █ ▓▓ ▄ ▀ GREETINGS:
░▒▓██████▀ ▄▀ ▀▓▀
▄▄▄ AOD, CLASS, CROSSFiRE, JiOO, SAC, BBL
███ EVILISO, 4KIDS, SHOCK, MAGE, DYNAMiCS
███
███▄▀ ▄▀ Big thanks to all JGT sites, and
███▌ ██ ▒ sites accepting us!
▓██▓▄ ▀▄ ▄▄▄▄▄▄▄
▀ ▀██▓▓▄▄▄▄ ████▓▓
▀▀▀▀████▓▓▄▄▄▄▄ ▄██████
▀▀▀▀▀█████▓▓▄▄▄▄▄ ▄▄▄▄▓████▓▀
█▓▓ ▄ ▀▀▀▀▀▓▓████████████████▓▀▀
███ ▀▀▀▓▓▄▄▄ ▀▀▀▀▀▀▀▀▀▀▀▀
░▒▓█▀▄▀▄ ▀▓███████▓▀ ▄▀▄▀▄▀▄▀ ▄ ▀▀██▓▄ ▀▄▄ ▀▀▀▄▀▄▀▄▀▄▀▄█▀▓▓▓▒▒▒ ▒▒░░ ░
███ ▄▓▄ ██▓▓ ▓▓ ▀
███ in memory of ▀ ▄█▀▀ ▄▀ drawn by the honored
███ THEPROF ▀ FX/SAC
▄▓██
▀▀▄

"judgement day is near..."

正在读取……

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

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

点击查看所有22网友评论

 

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

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