1. Урок 1. 00:05:05
    Introduction
  2. Урок 2. 00:02:48
    Installing PostgreSQL on Mac and Windows
  3. Урок 3. 00:08:12
    Installing PostgreSQL on Ubuntu
  4. Урок 4. 00:03:17
    Install Northwind Database
  5. Урок 5. 00:03:43
    Selecting All Data From a Table
  6. Урок 6. 00:02:24
    Selecting Specific Fields
  7. Урок 7. 00:02:38
    Selecting Distinct Values
  8. Урок 8. 00:02:49
    Counting Results
  9. Урок 9. 00:01:39
    Combining Fields in SELECT
  10. Урок 10. 00:01:03
    What If You Don't Want All Records
  11. Урок 11. 00:02:19
    Searching For Specific Text
  12. Урок 12. 00:01:59
    Searching Numeric Fields
  13. Урок 13. 00:02:04
    Searching Date Fields
  14. Урок 14. 00:02:46
    WHERE Using Logical AND Operator
  15. Урок 15. 00:02:58
    WHERE Using Logical OR Operator
  16. Урок 16. 00:01:20
    WHERE Using Logical NOT Operator
  17. Урок 17. 00:02:27
    WHERE Combining AND, OR, and NOT
  18. Урок 18. 00:02:02
    Using BETWEEN
  19. Урок 19. 00:01:49
    Using IN
  20. Урок 20. 00:03:13
    Schema Basics
  21. Урок 21. 00:03:40
    Connecting With psql
  22. Урок 22. 00:05:39
    Eliminate Typing Connection Parameters
  23. Урок 23. 00:01:46
    Databases In psql
  24. Урок 24. 00:02:23
    Schemas In psql
  25. Урок 25. 00:03:15
    ORDER BY
  26. Урок 26. 00:02:08
    Using MIN and MAX Functions
  27. Урок 27. 00:02:06
    Using AVG and SUM
  28. Урок 28. 00:04:02
    LIKE to Match Patterns
  29. Урок 29. 00:03:25
    Renaming Columns With Alias
  30. Урок 30. 00:03:22
    LIMIT to Control Number of Records Returned
  31. Урок 31. 00:02:24
    NULL Values
  32. Урок 32. 00:03:11
    Diagramming Table Relationships
  33. Урок 33. 00:05:51
    Grabbing Information From Two Tables
  34. Урок 34. 00:05:08
    Grabbing Information From Multiple Tables
  35. Урок 35. 00:03:26
    Left Joins
  36. Урок 36. 00:03:18
    Right Joins
  37. Урок 37. 00:02:26
    Full Joins
  38. Урок 38. 00:06:03
    Self Joins
  39. Урок 39. 00:01:40
    USING To Reduce Typing
  40. Урок 40. 00:04:20
    Even Less Typing With NATURAL
  41. Урок 41. 00:08:19
    Group By
  42. Урок 42. 00:05:33
    Use HAVING to Filter Groups
  43. Урок 43. 00:07:01
    Grouping Sets
  44. Урок 44. 00:06:17
    Rollup
  45. Урок 45. 00:06:56
    Cube - Rollup On Steroids
  46. Урок 46. 00:03:25
    Union
  47. Урок 47. 00:04:25
    Intersect
  48. Урок 48. 00:03:54
    Except
  49. Урок 49. 00:08:45
    Subquery Using EXISTS
  50. Урок 50. 00:07:34
    Subquery Using ANY and ALL
  51. Урок 51. 00:01:42
    IN Using Subquery
  52. Урок 52. 00:08:00
    INSERT INTO
  53. Урок 53. 00:03:30
    UPDATE
  54. Урок 54. 00:02:12
    DELETE
  55. Урок 55. 00:02:50
    SELECT INTO
  56. Урок 56. 00:02:40
    INSERT INTO SELECT
  57. Урок 57. 00:07:57
    Returning Data From Update, Delete, and Insert
  58. Урок 58. 00:02:33
    What Are Indexes?
  59. Урок 59. 00:04:24
    CREATE INDEX
  60. Урок 60. 00:02:02
    DROP INDEX
  61. Урок 61. 00:03:05
    How To Kill Runaway Queries
  62. Урок 62. 00:09:13
    Using Explain To See Query Plan
  63. Урок 63. 00:03:27
    Use Analyze To Update Table Statistics
  64. Урок 64. 00:12:18
    How Is Query Plan Cost Calculated
  65. Урок 65. 00:05:40
    Using Indexes On More Than One Field
  66. Урок 66. 00:06:06
    Expression Indexes
  67. Урок 67. 00:05:05
    Types Of Indexes
  68. Урок 68. 00:04:36
    Speeding Up Text Matching
  69. Урок 69. 00:07:53
    Design Process Overview
  70. Урок 70. 00:08:35
    Database Terminology
  71. Урок 71. 00:05:16
    A Design Process
  72. Урок 72. 00:03:33
    Finding Mission Statement And Ojectives
  73. Урок 73. 00:03:36
    Analyzing Current Systems
  74. Урок 74. 00:05:45
    Create Table Structure
  75. Урок 75. 00:03:21
    Establishing Keys
  76. Урок 76. 00:04:18
    Specifying Fields
  77. Урок 77. 00:04:53
    Relationships Between Tables
  78. Урок 78. 00:02:48
    Business Rules
  79. Урок 79. 00:01:54
    Establish Needed Views
  80. Урок 80. 00:02:41
    Double Checking Data Integrity
  81. Урок 81. 00:10:00
    CREATE TABLE
  82. Урок 82. 00:03:47
    ALTER TABLE - Part One
  83. Урок 83. 00:04:49
    ALTER TABLE - Part Two
  84. Урок 84. 00:02:57
    ALTER TABLE - Part Three
  85. Урок 85. 00:01:35
    DROP TABLE
  86. Урок 86. 00:05:16
    NOT NULL Constraint
  87. Урок 87. 00:03:46
    UNIQUE Constraint
  88. Урок 88. 00:05:55
    PRIMARY KEY Constraint
  89. Урок 89. 00:07:01
    FOREIGN KEY Constraint
  90. Урок 90. 00:05:30
    CHECK Constraint
  91. Урок 91. 00:02:44
    DEFAULT Values
  92. Урок 92. 00:03:52
    Changing a Column's Default Value
  93. Урок 93. 00:10:24
    Adding and Removing a Column's Constraint
  94. Урок 94. 00:14:32
    Create A Sequence
  95. Урок 95. 00:05:23
    Alter and Delete Sequences
  96. Урок 96. 00:04:08
    Using Serial Datatypes
  97. Урок 97. 00:08:59
    WITH Queries
  98. Урок 98. 00:01:07
    Creating Hierarchical Data To Use For Recursive WITH Queries
  99. Урок 99. 00:10:55
    Using Recursion in CTEs
  100. Урок 100. 00:09:14
    Views - How To Create
  101. Урок 101. 00:05:04
    Views - How To Modify
  102. Урок 102. 00:08:13
    Creating Updatable Views
  103. Урок 103. 00:06:44
    With Check Option
  104. Урок 104. 00:01:36
    Deleting Views
  105. Урок 105. 00:11:01
    CASE WHEN
  106. Урок 106. 00:02:26
    COALESCE
  107. Урок 107. 00:04:24
    NULLIF
  108. Урок 108. 00:12:42
    Date, Time, and Timestamp Data Types
  109. Урок 109. 00:08:13
    Time Zones
  110. Урок 110. 00:09:50
    Interval Data Type
  111. Урок 111. 00:12:29
    Date Arithmetic
  112. Урок 112. 00:03:48
    Pulling Out Parts of Dates and Times
  113. Урок 113. 00:03:21
    Converting One Data Type Into Another
  114. Урок 114. 00:09:10
    Basic Window Function Example
  115. Урок 115. 00:12:55
    Using Window Functions With Subqueries
  116. Урок 116. 00:07:13
    Using Rank() To Find The First N Records In Join
  117. Урок 117. 00:08:09
    Composite Type Basics
  118. Урок 118. 00:08:51
    Using Composite Types
  119. Урок 119. 00:06:49
    Write Your First Function
  120. Урок 120. 00:04:36
    Write A Function That Returns A Single Value
  121. Урок 121. 00:09:39
    Functions With Parameters
  122. Урок 122. 00:06:29
    Functions That Have Composite Parameters
  123. Урок 123. 00:05:55
    Functions That Return A Composite
  124. Урок 124. 00:04:52
    Functions With Output Parameters
  125. Урок 125. 00:04:44
    Functions With Default Values
  126. Урок 126. 00:02:30
    Using Functions as Table Source
  127. Урок 127. 00:15:57
    Functions That Return More Than One Row
  128. Урок 128. 00:04:36
    Procedures - Functions That Don't Return Anything
  129. Урок 129. 00:03:00
    ACID Transactions
  130. Урок 130. 00:05:18
    Simple Transaction Control
  131. Урок 131. 00:06:14
    Rollbacks & Savepoints
  132. Урок 132. 00:04:05
    SQL Transaction Isolation
  133. Урок 133. 00:03:34
    PostgreSQL Transaction Isolation
  134. Урок 134. 00:04:10
    Declaring Arrays
  135. Урок 135. 00:05:22
    Inputting Array Values
  136. Урок 136. 00:04:05
    Accessing Arrays
  137. Урок 137. 00:05:39
    Modifying Arrays
  138. Урок 138. 00:03:17
    Searching Arrays
  139. Урок 139. 00:06:31
    Array Operators
  140. Урок 140. 00:06:38
    Build Your First PL/pgSQL Function
  141. Урок 141. 00:05:00
    Handling Functions With Output Variables
  142. Урок 142. 00:06:26
    Returning Query Results
  143. Урок 143. 00:11:30
    Declaring Variables
  144. Урок 144. 00:13:29
    Looping Through Query Results
  145. Урок 145. 00:08:11
    Using If-Then Statements
  146. Урок 146. 00:10:51
    Returning Query Results Continued
  147. Урок 147. 00:05:55
    Loop and While Loops
  148. Урок 148. 00:10:38
    Looping Over Array Elements
  149. Урок 149. 00:11:08
    Build Your First Trigger
  150. Урок 150. 00:21:31
    Statement Triggers
  151. Урок 151. 00:13:34
    Importing CSV
  152. Урок 152. 00:07:03
    What Is JSON And How To Store In Database
  153. Урок 153. 00:12:05
    Create JSON From Tables
  154. Урок 154. 00:07:39
    Aggregating JSON Fields
  155. Урок 155. 00:08:29
    Building airports_json Table
  156. Урок 156. 00:06:09
    Selecting Information Out of JSON Fields
  157. Урок 157. 00:06:05
    Searching JSON Data
  158. Урок 158. 00:09:40
    Updating And Deleting Information Inside JSON Fields
  159. Урок 159. 00:03:03
    CREATE DATABASE
  160. Урок 160. 00:03:10
    DROP DATABASE
  161. Урок 161. 00:08:52
    Basic Import/Export With Copy
  162. Урок 162. 00:04:07
    Basic pg_dump And Restore
  163. Урок 163. 00:06:37
    Custom Format Dumps
  164. Урок 164. 00:03:16
    Overview of Roles and Users
  165. Урок 165. 00:05:53
    Instance Level Security
  166. Урок 166. 00:02:37
    Database Level Security
  167. Урок 167. 00:03:49
    Schema Level Security
  168. Урок 168. 00:02:15
    Table Level Security
  169. Урок 169. 00:05:05
    Column Level Security
  170. Урок 170. 00:08:32
    Row Level Security
  171. Урок 171. 00:01:11
    Install PostGIS on Ubuntu (Not needed for Windows/Mac)
  172. Урок 172. 00:09:27
    Converting Airport Data
  173. Урок 173. 00:08:43
    Your First Geographical Query
  174. Урок 174. 00:00:27
    Thank you