中文名: PostgreSQL數據庫教程
英文名: VTC.COM POSTGRESQL
資源格式: 光盤鏡像
主講人: Dima Kassab
發行日期: 2012年02月06日
地區: 美國
對白語言: 英語
文字語言: 英文
簡介:

網址：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..."
▲