PostgreSQL Tutorials [2012, ENG] torrent

Обучающие видео » Компьютерные видеоуроки и обучающие интерактивные DVD » Программирование (видеоуроки)

PostgreSQL Tutorials

Год выпуска: 2012
Производитель: VTC.com
Автор: Dima Kassab
Продолжительность: 8 ч
Тип раздаваемого материала: Видеоурок
Язык: Английский
Описание: 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.
[spoiler="Содержание"]
Introduction
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:05)
Defining Tables
Create / Drop a Table Using Command Line (04:10)
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 (05:46)
Check Constraints pt. 2 (03:56)
Not Null Constraint (03:42)
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:05)
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 (05:35)
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:39)
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 (06:39)
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:24)
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)
[/spoiler]
Файлы примеров: присутствуют
Формат видео: MOV
Видео: AVC 800x600 15fps ~60Kbps
Аудио: AAC 44,1kHz 1ch 64Kbps
[spoiler="Скриншоты"]

[/spoiler]