Это пробный урок. Оформите подписку, чтобы получить доступ ко всем материалам курса. Премиум

  1. Урок 1. 00:01:07
    Course Introduction
  2. Урок 2. 00:02:18
    Installing PostgreSQL on Mac
  3. Урок 3. 00:06:01
    Installing PostgreSQL on Windows
  4. Урок 4. 00:02:02
    Configure pgAdmin 4 client
  5. Урок 5. 00:03:55
    Creating a Database User
  6. Урок 6. 00:02:31
    Creating a Database
  7. Урок 7. 00:02:12
    Running a query in pgAdmin tool
  8. Урок 8. 00:02:32
    Install sample data files on server
  9. Урок 9. 00:02:22
    Install Human Resources (hr) database
  10. Урок 10. 00:02:05
    Install sample stocks market data
  11. Урок 11. 00:05:04
    Install northwind database
  12. Урок 12. 00:03:28
    Drop a database
  13. Урок 13. 00:03:39
    Movie Database Structure
  14. Урок 14. 00:06:19
    Creating the movie database and a actors table
  15. Урок 15. 00:03:30
    Creating the directors table
  16. Урок 16. 00:05:55
    Creating the movies table with a foreign key
  17. Урок 17. 00:03:45
    Creating the movies_revenues table
  18. Урок 18. 00:04:25
    Creating a Junction table with movies and actors tables
  19. Урок 19. 00:05:51
    Install sample data for 'movies' database
  20. Урок 20. 00:05:37
    Using pgAdmin - Create and modify a table
  21. Урок 21. 00:05:29
    Using pgAdmin - View table structure, and create column
  22. Урок 22. 00:06:45
    Using pgAdmin - Rename, delete and change the data type of a column
  23. Урок 23. 00:02:49
    Deleting tables from a database
  24. Урок 24. 00:04:47
    Insert a data into table
  25. Урок 25. 00:02:36
    Insert multiple records into a table
  26. Урок 26. 00:02:02
    Insert a data that had quotes
  27. Урок 27. 00:02:52
    Use RETURNING to get info on added rows
  28. Урок 28. 00:03:26
    Update data in a table
  29. Урок 29. 00:02:14
    Updating a row and returning the updated row
  30. Урок 30. 00:03:11
    Updating all records in a table
  31. Урок 31. 00:03:08
    Delete data from a table
  32. Урок 32. 00:10:00
    Using UPSERT
  33. Урок 33. 00:06:32
    Select all data from a table
  34. Урок 34. 00:03:44
    Selecting specific columns from a table
  35. Урок 35. 00:09:24
    Adding Aliases to columns in a table
  36. Урок 36. 00:03:16
    Using SELECT statement for expressions
  37. Урок 37. 00:07:55
    Using ORDER BY to sort records
  38. Урок 38. 00:03:15
    Using ORDER BY with alias column name
  39. Урок 39. 00:03:09
    Using ORDER BY to sort rows by expressions
  40. Урок 40. 00:03:20
    Using ORDER BY with column name or column number
  41. Урок 41. 00:05:54
    Using ORDER BY with NULL values
  42. Урок 42. 00:05:28
    Using DISTINCT for selecting distinct values
  43. Урок 43. 00:02:20
    Comparison, Logical and Arithmetic operators
  44. Урок 44. 00:07:27
    AND operator
  45. Урок 45. 00:03:24
    OR operator
  46. Урок 46. 00:04:44
    Combining AND, OR operators
  47. Урок 47. 00:02:49
    What goes before and after WHERE clause
  48. Урок 48. 00:01:54
    Execution order with AND, OR operators
  49. Урок 49. 00:02:21
    Can we use column aliases with WHERE?
  50. Урок 50. 00:01:34
    Order of execution of WHERE, SELECT and ORDER BY clauses
  51. Урок 51. 00:16:16
    Using Logical operators
  52. Урок 52. 00:16:52
    Using LIMIT and OFFSET
  53. Урок 53. 00:09:47
    Using FETCH
  54. Урок 54. 00:10:15
    Using IN, NOT IN
  55. Урок 55. 00:11:32
    Using BETWEEN and NOT BETWEEN
  56. Урок 56. 00:17:19
    Using LIKE and ILIKE
  57. Урок 57. 00:12:37
    Using IS NULL and IS NOT NULL keywords
  58. Урок 58. 00:08:21
    Concatenation techniques
  59. Урок 59. 00:04:37
    Concatenation with ||, CONCAT and CONCAT_WS
  60. Урок 60. 00:13:15
    Boolean
  61. Урок 61. 00:18:20
    CHAR, VARCHAR and TEXT
  62. Урок 62. 00:10:15
    NUMERIC
  63. Урок 63. 00:09:54
    DECIMALS
  64. Урок 64. 00:05:52
    Selecting Numbers data types
  65. Урок 65. 00:03:44
    Date/Time data types
  66. Урок 66. 00:06:20
    DATE
  67. Урок 67. 00:14:58
    TIME
  68. Урок 68. 00:12:50
    TIMESTAMP and TIMESTAMPTZ
  69. Урок 69. 00:11:39
    UUID
  70. Урок 70. 00:07:08
    Array
  71. Урок 71. 00:08:01
    hstore
  72. Урок 72. 00:12:30
    JSON
  73. Урок 73. 00:14:01
    Network Addresses
  74. Урок 74. 00:04:39
    Creating sample database 'mydata', adding columns
  75. Урок 75. 00:09:00
    Modify Table Structures, Add/Modify Columns
  76. Урок 76. 00:10:28
    Add constraints to columns
  77. Урок 77. 00:05:47
    What is a data type conversion
  78. Урок 78. 00:11:34
    Using CAST for data conversions
  79. Урок 79. 00:04:13
    Implicit to Explicit conversions
  80. Урок 80. 00:07:16
    Table data conversion
  81. Урок 81. 00:08:07
    to_char
  82. Урок 82. 00:05:19
    to_number
  83. Урок 83. 00:05:34
    to_date
  84. Урок 84. 00:04:48
    to_timestamp
  85. Урок 85. 00:06:46
    CREATE DOMAIN - Create a DOMAIN data type, create an address
  86. Урок 86. 00:02:17
    CREATE DOMAIN - Create a data type for a positive number
  87. Урок 87. 00:03:01
    CREATE DOMAIN - Create a postal code validation data type
  88. Урок 88. 00:03:46
    CREATE DOMAIN - Create a domain data type for an email validation
  89. Урок 89. 00:04:36
    CREATE DOMAIN - Create a Enum or Set of values domain data type
  90. Урок 90. 00:02:18
    CREATE DOMAIN - Get the list of all DOMAIN data types
  91. Урок 91. 00:04:45
    CREATE DOMAIN - How to drop a domain data type
  92. Урок 92. 00:06:45
    CREATE TYPE - Create a composite address object
  93. Урок 93. 00:04:34
    CREATE TYPE - Create a composite inventory_item data type
  94. Урок 94. 00:04:34
    CREATE TYPE - Create an ENUM data type and see how to drop a data type
  95. Урок 95. 00:04:18
    ALTER TYPE - Alter a composite data type, change schema and more..
  96. Урок 96. 00:03:23
    ALTER TYPE - Alter an ENUM data type
  97. Урок 97. 00:08:14
    Update an ENUM data in production server
  98. Урок 98. 00:03:40
    An ENUM with a DEFAULT value in a table
  99. Урок 99. 00:02:00
    Create a type if not exists using a PL/pgSQL function
  100. Урок 100. 00:04:17
    Introduction to constraints
  101. Урок 101. 00:11:31
    NOT NULL constraint
  102. Урок 102. 00:15:18
    UNIQUE constraint
  103. Урок 103. 00:05:35
    DEFAULT constraint
  104. Урок 104. 00:21:45
    PRIMARY KEY Constraints
  105. Урок 105. 00:13:49
    PRIMARY KEY Constraints on multiple columns
  106. Урок 106. 00:06:13
    FOREIGN KEY Constraints
  107. Урок 107. 00:07:43
    Tables without foreign key constraints
  108. Урок 108. 00:07:50
    Creating foreign key constraints
  109. Урок 109. 00:07:45
    Foreign keys maintains referential data integrity
  110. Урок 110. 00:02:14
    Drop a constraint
  111. Урок 111. 00:03:06
    Add or update foreign key constraint on existing table
  112. Урок 112. 00:01:33
    CHECK constraint - An Introduction
  113. Урок 113. 00:10:13
    CHECK constraint - Add to new table
  114. Урок 114. 00:10:34
    CHECK constraint - Add, Rename, Drop on existing table
  115. Урок 115. 00:07:21
    Create a sequence, advance a sequence, get current value, set value
  116. Урок 116. 00:04:19
    Restart, rename a sequence, and use pgAdmin to alter a sequence
  117. Урок 117. 00:03:17
    Create a sequence with START WITH, INCREMENT, MINVALUE and MAXVALUE
  118. Урок 118. 00:02:43
    Create a sequence using a specific data type
  119. Урок 119. 00:04:45
    Creating a descending sequence, and CYCLE sequence
  120. Урок 120. 00:01:29
    Delete a sequence
  121. Урок 121. 00:08:54
    Attach a sequence to a table column
  122. Урок 122. 00:01:27
    List all sequences in a database
  123. Урок 123. 00:04:16
    Share one sequence between two tables
  124. Урок 124. 00:07:51
    Create an alphanumeric sequence
  125. Урок 125. 00:04:38
    UPPER, LOWER and INITCAP
  126. Урок 126. 00:08:08
    LEFT and RIGHT
  127. Урок 127. 00:02:09
    REVERSE
  128. Урок 128. 00:06:22
    SPLIT_PART
  129. Урок 129. 00:06:39
    TRIM, BTRIM, LTRIM and RTRIM
  130. Урок 130. 00:05:54
    LPAD and RPAD
  131. Урок 131. 00:03:53
    LENGTH
  132. Урок 132. 00:03:20
    POSITION
  133. Урок 133. 00:04:56
    STRPOS
  134. Урок 134. 00:03:52
    SUBSTRING
  135. Урок 135. 00:02:29
    REPEAT
  136. Урок 136. 00:04:10
    REPLACE
  137. Урок 137. 00:07:36
    Counting results via COUNT function
  138. Урок 138. 00:09:13
    Sum with SUM function
  139. Урок 139. 00:13:33
    MIN and MAX functions
  140. Урок 140. 00:05:09
    GREATEST AND LEAST functions
  141. Урок 141. 00:12:53
    Average with AVG function
  142. Урок 142. 00:11:07
    Combining Columns using Mathematical operators
  143. Урок 143. 00:09:39
    Datetimes data types
  144. Урок 144. 00:03:08
    System Month Date settings
  145. Урок 145. 00:06:10
    Time of day formats and inputs
  146. Урок 146. 00:11:19
    Strings to Dates conversions
  147. Урок 147. 00:09:44
    Using TO_TIMESTAMP function
  148. Урок 148. 00:10:34
    Formatting Dates
  149. Урок 149. 00:06:29
    Date construction functions
  150. Урок 150. 00:06:35
    Using MAKE_INTERVAL function
  151. Урок 151. 00:09:37
    Using MAKE_TIMESTAMPTZ function
  152. Урок 152. 00:05:56
    Date Value Extractors functions
  153. Урок 153. 00:09:25
    Using math operators with dates
  154. Урок 154. 00:04:04
    OVERLAPS Operator
  155. Урок 155. 00:05:02
    Date / Time Functions
  156. Урок 156. 00:04:24
    PostgreSQL Date / Time Functions
  157. Урок 157. 00:03:38
    AGE function
  158. Урок 158. 00:01:19
    CURRENT_DATE function
  159. Урок 159. 00:03:52
    CURRENT_TIME function
  160. Урок 160. 00:07:03
    Date accuracy with EPOCH
  161. Урок 161. 00:08:15
    Using Date, time, timestamp in tables
  162. Урок 162. 00:03:30
    View and set timezones
  163. Урок 163. 00:10:43
    How to handle timezones
  164. Урок 164. 00:10:44
    date_part function
  165. Урок 165. 00:08:58
    date_trunc function
  166. Урок 166. 00:11:55
    Using GROUP BY
  167. Урок 167. 00:14:46
    Using GROUP BY with multiple columns, ORDER BY
  168. Урок 168. 00:01:34
    Order of execution in GROUP BY clause
  169. Урок 169. 00:11:38
    Using HAVING
  170. Урок 170. 00:01:07
    Order of execution in HAVING clause
  171. Урок 171. 00:05:40
    HAVING vs WHERE
  172. Урок 172. 00:10:10
    Handling NULL values with GROUP BY
  173. Урок 173. 00:20:19
    INNER joins
  174. Урок 174. 00:08:56
    INNER joins with USING
  175. Урок 175. 00:10:19
    INNER joins with filter data Part 1
  176. Урок 176. 00:03:59
    INNER joins with filter data Part 2
  177. Урок 177. 00:05:29
    INNER joins with filter data Part 3
  178. Урок 178. 00:05:12
    INNER joins with different data type columns
  179. Урок 179. 00:09:34
    LEFT joins Part 1
  180. Урок 180. 00:07:28
    LEFT joins Part 2
  181. Урок 181. 00:08:02
    LEFT joins Part 3
  182. Урок 182. 00:05:50
    LEFT joins Part 4
  183. Урок 183. 00:09:44
    RIGHT joins
  184. Урок 184. 00:03:15
    RIGHT joins Part 2
  185. Урок 185. 00:05:05
    FULL Joins
  186. Урок 186. 00:09:05
    Joining multiple tables
  187. Урок 187. 00:08:30
    Self Joins Part 1
  188. Урок 188. 00:02:59
    Self Joins Part 2
  189. Урок 189. 00:10:35
    CROSS Joins
  190. Урок 190. 00:05:24
    Natural Joins Part 1
  191. Урок 191. 00:02:15
    Natural Joins Part 2
  192. Урок 192. 00:13:44
    Append tables with different columns
  193. Урок 193. 00:11:06
    Combine results sets with UNION
  194. Урок 194. 00:10:27
    UNION with filters and conditions
  195. Урок 195. 00:03:29
    UNION tables with different number of columns
  196. Урок 196. 00:04:27
    INTERSECT with tables
  197. Урок 197. 00:05:49
    EXCEPT with tables
  198. Урок 198. 00:06:09
    What is a Schema?
  199. Урок 199. 00:07:25
    Schema Operations (Add/Alter/Delete schemas)
  200. Урок 200. 00:06:22
    Schema Hierarchy
  201. Урок 201. 00:02:54
    Move a table to a new schema
  202. Урок 202. 00:14:11
    Schema search path
  203. Урок 203. 00:02:08
    Alter a schema ownership
  204. Урок 204. 00:06:20
    Duplicate a schema along with all data
  205. Урок 205. 00:05:21
    What is a system catalog schema?
  206. Урок 206. 00:07:41
    Compare tables and columns in two schemas
  207. Урок 207. 00:06:30
    Schemas and Privileges
  208. Урок 208. 00:07:23
    Constructing arrays and ranges
  209. Урок 209. 00:07:44
    Using comparison operators
  210. Урок 210. 00:04:17
    Using inclusion operators
  211. Урок 211. 00:05:15
    Array constructions
  212. Урок 212. 00:08:42
    Array metadata functions
  213. Урок 213. 00:06:33
    Array search functions
  214. Урок 214. 00:06:47
    Array modification functions
  215. Урок 215. 00:13:03
    Array comparison with IN, ALL, ANY and SOME
  216. Урок 216. 00:09:04
    Formatting and converting an array
  217. Урок 217. 00:04:34
    Using arrays in tables
  218. Урок 218. 00:05:51
    Insert data into arrays
  219. Урок 219. 00:07:10
    Query array data
  220. Урок 220. 00:03:08
    Modifying array data
  221. Урок 221. 00:04:12
    Array Dimensions are ignored!
  222. Урок 222. 00:03:53
    Display all array elements
  223. Урок 223. 00:10:38
    Using Multi-dimensional arrays
  224. Урок 224. 00:14:04
    Array vs JSONB
  225. Урок 225. 00:04:22
    What is JSON?
  226. Урок 226. 00:09:07
    JSON Syntax
  227. Урок 227. 00:04:10
    JSON and JSONB data types
  228. Урок 228. 00:06:31
    Exploring JSON objects
  229. Урок 229. 00:07:49
    Create our first table with JSONB data type
  230. Урок 230. 00:12:47
    Update and Delete JSON Data
  231. Урок 231. 00:05:05
    Create JSON from tables
  232. Урок 232. 00:05:24
    Use json_agg to aggregate data
  233. Урок 233. 00:04:40
    Build a JSON array
  234. Урок 234. 00:06:17
    Creating a document from data
  235. Урок 235. 00:05:05
    Null Values in JSON documents
  236. Урок 236. 00:06:26
    Getting information from JSON documents
  237. Урок 237. 00:02:55
    The Existence Operator
  238. Урок 238. 00:04:07
    The Containment Operator
  239. Урок 239. 00:04:09
    JSON search with PostgreSQL functions
  240. Урок 240. 00:11:30
    Indexing on JSONB
  241. Урок 241. 00:03:57
    What is an index?
  242. Урок 242. 00:15:48
    Create an index
  243. Урок 243. 00:11:11
    Create unique indexes
  244. Урок 244. 00:04:18
    List all indexes
  245. Урок 245. 00:05:19
    Size of the table index
  246. Урок 246. 00:04:35
    List counts of all indexes
  247. Урок 247. 00:03:35
    Drop a index
  248. Урок 248. 00:04:36
    SQL Statement execution process
  249. Урок 249. 00:06:36
    SQL statement execution stages
  250. Урок 250. 00:09:31
    The query optimizer
  251. Урок 251. 00:05:50
    Optimizer node types
  252. Урок 252. 00:06:24
    Sequential Nodes
  253. Урок 253. 00:07:52
    Index Nodes
  254. Урок 254. 00:06:47
    Join Nodes
  255. Урок 255. 00:04:48
    Index Types - B-Tree Index
  256. Урок 256. 00:04:45
    Hash Index
  257. Урок 257. 00:02:23
    BRIN index
  258. Урок 258. 00:01:56
    GIN Index
  259. Урок 259. 00:14:32
    The EXPLAIN statement
  260. Урок 260. 00:02:56
    EXPLAIN output options
  261. Урок 261. 00:09:11
    Using EXPLAIN ANALYZE
  262. Урок 262. 00:13:45
    Understanding query cost model
  263. Урок 263. 00:12:04
    Index are not free
  264. Урок 264. 00:08:52
    Indexes for sorted output
  265. Урок 265. 00:07:52
    Using multiple indexes on a single query
  266. Урок 266. 00:07:03
    Execution plans depends on input values
  267. Урок 267. 00:20:11
    Using organized vs random data
  268. Урок 268. 00:04:08
    Try to use index only scan
  269. Урок 269. 00:11:08
    Partial indexes
  270. Урок 270. 00:16:26
    Expression Index
  271. Урок 271. 00:03:12
    Adding data while indexing
  272. Урок 272. 00:07:55
    Invalidating an index
  273. Урок 273. 00:07:10
    Rebuilding an index
  274. Урок 274. 00:07:21
    Introduction to views
  275. Урок 275. 00:10:53
    Creating a view
  276. Урок 276. 00:04:29
    Rename a view
  277. Урок 277. 00:01:55
    Delete a view
  278. Урок 278. 00:07:09
    Using filters with views
  279. Урок 279. 00:04:09
    A view with UNION of multiple tables
  280. Урок 280. 00:07:18
    Connecting multiple tables with a single view
  281. Урок 281. 00:03:01
    Re-arrange columns in a view
  282. Урок 282. 00:01:52
    Delete a column in a view
  283. Урок 283. 00:02:19
    Add a column in a view
  284. Урок 284. 00:02:37
    Regular views are dynamic
  285. Урок 285. 00:03:55
    What is an updatable view?
  286. Урок 286. 00:05:28
    An updatable view with CRUD operations
  287. Урок 287. 00:07:54
    Updatable views using WITH CHECK OPTION
  288. Урок 288. 00:09:28
    Updatable views using WITH LOCAL and CASCADED CHECK OPTION
  289. Урок 289. 00:09:30
    What is a Materialized View
  290. Урок 290. 00:04:41
    Creating a materialized view
  291. Урок 291. 00:03:21
    Drop a materialized view
  292. Урок 292. 00:06:41
    Changing materialized view data
  293. Урок 293. 00:02:46
    How to check if a materialized view is populated or not?
  294. Урок 294. 00:06:35
    Refreshing data in materialize views
  295. Урок 295. 00:04:16
    Why not use a table instead of materialized view?
  296. Урок 296. 00:03:25
    The downsides of using materialized views
  297. Урок 297. 00:11:25
    Using materialized view for websites page analysis
  298. Урок 298. 00:01:34
    List all materialized views by a SELECT statement
  299. Урок 299. 00:03:49
    List materialized views with no unique index
  300. Урок 300. 00:13:09
    Subqueries with WHERE Clause
  301. Урок 301. 00:04:50
    Subquery with IN operator
  302. Урок 302. 00:08:38
    Subquery with JOINs
  303. Урок 303. 00:04:13
    Order entries in UNION without using ORDER BY
  304. Урок 304. 00:01:24
    Subquery with an alias
  305. Урок 305. 00:02:42
    A SELECT without a FROM
  306. Урок 306. 00:11:59
    Correlated Queries
  307. Урок 307. 00:07:04
    SELECT.. IN (Subquery)
  308. Урок 308. 00:07:45
    Using ANY with subquery
  309. Урок 309. 00:08:16
    Using ALL with subquery
  310. Урок 310. 00:04:52
    Subquery using EXISTS
  311. Урок 311. 00:05:45
    Introduction to CTEs
  312. Урок 312. 00:15:45
    CTE query examples
  313. Урок 313. 00:07:00
    Combine CTE with a table
  314. Урок 314. 00:08:18
    Simultaneously DELETE INSERT via CTE
  315. Урок 315. 00:04:46
    Recursive CTEs
  316. Урок 316. 00:19:48
    Parent-child relationship via recursive CTE
  317. Урок 317. 00:03:32
    Introduction to summarization
  318. Урок 318. 00:12:00
    Subtotals on group sets
  319. Урок 319. 00:07:34
    Adding subtotal with ROLLUP
  320. Урок 320. 00:13:55
    Using GROUPING with ROLLUP
  321. Урок 321. 00:03:36
    Introduction to Window Functions
  322. Урок 322. 00:08:23
    Analyze Global Trades Data
  323. Урок 323. 00:09:01
    Using aggregate functions
  324. Урок 324. 00:05:25
    GROUP BY ROLLUP
  325. Урок 325. 00:04:10
    ROLLUP - Grouping multiple columns
  326. Урок 326. 00:05:06
    GROUP BY CUBE
  327. Урок 327. 00:03:37
    GROUP BY GROUPING SETS
  328. Урок 328. 00:05:08
    Query performance check
  329. Урок 329. 00:05:27
    Using FILTER clause
  330. Урок 330. 00:04:44
    Using Window Functions
  331. Урок 331. 00:04:38
    Partitioning the data
  332. Урок 332. 00:02:45
    Set data into millions format
  333. Урок 333. 00:08:19
    Ordering inside window
  334. Урок 334. 00:08:06
    Sliding dynamic windows
  335. Урок 335. 00:21:41
    Understanding window frames
  336. Урок 336. 00:11:00
    ROWS and RANGE indicators
  337. Урок 337. 00:08:43
    Using WINDOW
  338. Урок 338. 00:03:22
    Using WINDOW with ROWS BETWEEN
  339. Урок 339. 00:05:01
    RANK and DENSE_RANK functions
  340. Урок 340. 00:09:01
    NTILE function
  341. Урок 341. 00:14:25
    LEAD and LAG functions
  342. Урок 342. 00:14:28
    FIRST_VALUE, LAST_VALUE and NTH_value functions
  343. Урок 343. 00:09:57
    ROW_NUMBER function
  344. Урок 344. 00:05:52
    Finding Correlations
  345. Урок 345. 00:09:46
    ROW_NUMBER() - Window with Partition datasets
  346. Урок 346. 00:02:24
    ROW_NUMBER() - Reverse fields with order by
  347. Урок 347. 00:03:17
    ROW_NUMBER() - Find Nth record
  348. Урок 348. 00:05:01
    ROW_NUMBER() - Find DISTINCT with subquery
  349. Урок 349. 00:06:29
    ROW_NUMBER() - Pagination technique
  350. Урок 350. 00:06:01
    Using OVER() to calculate percentage
  351. Урок 351. 00:05:52
    Calculate difference compared to average
  352. Урок 352. 00:05:09
    Calculating cumulative totals
  353. Урок 353. 00:05:37
    Using LEAD to compare with next values
  354. Урок 354. 00:09:34
    Comparing with least number
  355. Урок 355. 00:04:24
    Window Function Summary
  356. Урок 356. 00:06:52
    Planning tips on using Window Functions
  357. Урок 357. 00:03:01
    Difference between RANK and DENSE_RANK
  358. Урок 358. 00:04:59
    Getting RANK to compute group and global ranks
  359. Урок 359. 00:06:22
    Using PARTITION BY for group averages
  360. Урок 360. 00:04:16
    Using WITH clause to create your own data
  361. Урок 361. 00:06:40
    Using WITH clause to set ORDER BY values
  362. Урок 362. 00:05:23
    DELETE and INSERT in one query using WITH
  363. Урок 363. 00:06:19
    Text to structured data
  364. Урок 364. 00:09:01
    Regular expressions notations table
  365. Урок 365. 00:06:43
    SIMILAR TO operator
  366. Урок 366. 00:04:57
    POSIX regular expressions
  367. Урок 367. 00:17:54
    SUBSTRING with regular expressions
  368. Урок 368. 00:09:53
    REGEXP_MATCHES Function
  369. Урок 369. 00:08:01
    REGEXP_REPLACE Function
  370. Урок 370. 00:01:30
    REGEXP_SPLIT_TO_TABLE Function
  371. Урок 371. 00:02:45
    REGEXP_SPLIT_TO_ARRAY function
  372. Урок 372. 00:09:08
    The Good Ol' Text Search
  373. Урок 373. 00:11:38
    Introducing tsvector
  374. Урок 374. 00:15:46
    Using tsquery with operators
  375. Урок 375. 00:14:39
    Full text search within a table
  376. Урок 376. 00:07:41
    Setup presidents speeches data
  377. Урок 377. 00:07:45
    Analyzing presidents speeches text data
  378. Урок 378. 00:05:33
    Ranking and Normalizing text results
  379. Урок 379. 00:05:50
    What is a partition
  380. Урок 380. 00:18:25
    When a partition can be used?
  381. Урок 381. 00:16:12
    Table inheritance
  382. Урок 382. 00:02:41
    Partition types
  383. Урок 383. 00:19:23
    Partition by Range
  384. Урок 384. 00:23:32
    Partition by List
  385. Урок 385. 00:13:58
    Partition by Hash
  386. Урок 386. 00:06:46
    DEFAULT Partition
  387. Урок 387. 00:13:57
    Multi-level partitioning
  388. Урок 388. 00:05:07
    Partition maintenance
  389. Урок 389. 00:09:23
    ALTERing the partition bounds
  390. Урок 390. 00:07:12
    Partition Indexes
  391. Урок 391. 00:03:59
    Partition pruning
  392. Урок 392. 00:07:43
    Determining a field for partition over
  393. Урок 393. 00:05:57
    Sizing the partition
  394. Урок 394. 00:04:55
    Partitioning Advantages
  395. Урок 395. 00:04:43
    Common partitioning mistakes
  396. Урок 396. 00:09:48
    PostgreSQL as a development platform?
  397. Урок 397. 00:05:20
    Procedural languages
  398. Урок 398. 00:05:48
    Keep the data on the server!
  399. Урок 399. 00:03:53
    Functions vs stored procedures
  400. Урок 400. 00:03:31
    User-defined functions
  401. Урок 401. 00:02:36
    Structure of a function
  402. Урок 402. 00:10:02
    Creating our first SQL function
  403. Урок 403. 00:03:47
    Introducing dollar quoting
  404. Урок 404. 00:05:07
    Function returning no values
  405. Урок 405. 00:12:24
    Function returning a single value
  406. Урок 406. 00:05:38
    Function returning a single value Part 2
  407. Урок 407. 00:03:43
    Function returning a single value Part 3
  408. Урок 408. 00:14:04
    Function using parameters
  409. Урок 409. 00:05:21
    Function using parameters Part 2
  410. Урок 410. 00:14:43
    Function using parameters Part 3
  411. Урок 411. 00:13:19
    Function using parameters Part 4
  412. Урок 412. 00:13:10
    Function returning a composite
  413. Урок 413. 00:10:23
    Function returning multiple rows
  414. Урок 414. 00:03:10
    Function - order matters!
  415. Урок 415. 00:02:55
    Function returning a table
  416. Урок 416. 00:10:38
    Function as a table source
  417. Урок 417. 00:03:10
    Function parameter modes
  418. Урок 418. 00:11:20
    Function parameters with default values
  419. Урок 419. 00:06:57
    Function based on views
  420. Урок 420. 00:04:19
    Drop a function
  421. Урок 421. 00:02:10
    Introduction to PL/pgSQL language
  422. Урок 422. 00:02:41
    PL/pgSQL vs SQL
  423. Урок 423. 00:05:16
    Structure of a PL/pgSQL function
  424. Урок 424. 00:02:19
    PL/pgSQL block structure
  425. Урок 425. 00:06:03
    Declaring variables
  426. Урок 426. 00:01:41
    Declaring variables via ALIAS FOR
  427. Урок 427. 00:05:40
    Declaring variables in function
  428. Урок 428. 00:02:28
    Variable initializing timing
  429. Урок 429. 00:03:08
    Copying data types
  430. Урок 430. 00:10:03
    Assigning variables from query
  431. Урок 431. 00:04:36
    Using IN, OUT without RETURNS
  432. Урок 432. 00:04:51
    Variables in block and subblock
  433. Урок 433. 00:05:49
    How to return query results
  434. Урок 434. 00:09:07
    Control Structures - IF statement
  435. Урок 435. 00:06:06
    Using IF with table data
  436. Урок 436. 00:12:38
    CASE Statement
  437. Урок 437. 00:12:12
    Searched CASE statement
  438. Урок 438. 00:06:20
    LOOP statement
  439. Урок 439. 00:05:50
    FOR Loops
  440. Урок 440. 00:04:28
    FOR Loops iterate over result set
  441. Урок 441. 00:05:20
    CONTINUE statement
  442. Урок 442. 00:04:08
    FOREACH loop with arrays
  443. Урок 443. 00:13:39
    WHILE loop
  444. Урок 444. 00:11:37
    Using RETURN QUERY
  445. Урок 445. 00:04:38
    Returning a table
  446. Урок 446. 00:14:49
    Using RETURN NEXT
  447. Урок 447. 00:06:29
    Error and exception handling
  448. Урок 448. 00:05:40
    Exception - Too many rows
  449. Урок 449. 00:04:20
    Using SQLSTATE codes for exception handling
  450. Урок 450. 00:07:22
    Exception with data exception errors
  451. Урок 451. 00:05:37
    Functions vs Stored Procedures
  452. Урок 452. 00:08:16
    Create a transactions
  453. Урок 453. 00:05:09
    Understanding the use of stored procedures
  454. Урок 454. 00:04:11
    Returning a value
  455. Урок 455. 00:01:55
    Drop a procedure
  456. Урок 456. 00:10:41
    What is a trigger
  457. Урок 457. 00:02:35
    Types of triggers
  458. Урок 458. 00:02:55
    Trigger table
  459. Урок 459. 00:10:44
    Pros and Cons of triggers
  460. Урок 460. 00:02:46
    Trigger key points
  461. Урок 461. 00:05:29
    Steps to create a trigger
  462. Урок 462. 00:11:41
    Data auditing with a trigger
  463. Урок 463. 00:08:39
    Bind a function to a table with trigger
  464. Урок 464. 00:11:57
    Modify data at INSERT event
  465. Урок 465. 00:04:54
    View triggers variables
  466. Урок 466. 00:10:08
    Disallow DELETE on a table
  467. Урок 467. 00:05:18
    Disallow TRUNCATE on a table
  468. Урок 468. 00:20:43
    Creating an audit trigger
  469. Урок 469. 00:15:06
    Creating conditional triggers
  470. Урок 470. 00:05:37
    Disallow data change on primary key
  471. Урок 471. 00:03:31
    Use triggers very cautiously
  472. Урок 472. 00:01:51
    What is an event trigger
  473. Урок 473. 00:03:22
    Event triggers usage scenarios
  474. Урок 474. 00:04:37
    Creating event triggers
  475. Урок 475. 00:04:26
    Event trigger events and variables
  476. Урок 476. 00:14:58
    Creating an audit event trigger
  477. Урок 477. 00:08:53
    Prevent schema changes
  478. Урок 478. 00:00:58
    Dropping a trigger
  479. Урок 479. 00:06:41
    Understanding row by row operations
  480. Урок 480. 00:04:31
    Cursors and procedural languages
  481. Урок 481. 00:02:47
    Steps to create a cursor
  482. Урок 482. 00:08:39
    Creating a cursor
  483. Урок 483. 00:09:40
    Opening a cursor
  484. Урок 484. 00:06:34
    Using a cursor
  485. Урок 485. 00:01:43
    Updating data
  486. Урок 486. 00:01:23
    Closing a cursor
  487. Урок 487. 00:10:32
    Creating a PL/PGSQL Cursor
  488. Урок 488. 00:14:04
    Using a parametric cursor via function
  489. Урок 489. 00:04:03
    What is a crosstab report
  490. Урок 490. 00:01:54
    Installing the tablefunc extension
  491. Урок 491. 00:14:39
    Creating a crosstab report - Student Rankings
  492. Урок 492. 00:03:03
    Orders matters in crosstab reports
  493. Урок 493. 00:11:03
    Pivoting with Rainfalls data
  494. Урок 494. 00:04:03
    Pivoting rows and columns
  495. Урок 495. 00:09:57
    Matrix report via a query
  496. Урок 496. 00:05:49
    Aggregate over filter
  497. Урок 497. 00:06:51
    Static to dynamic pivots
  498. Урок 498. 00:06:59
    Dynamic pivot query via JSON
  499. Урок 499. 00:17:17
    Dynamic pivot table columns
  500. Урок 500. 00:06:06
    Interactive client-side pivot
  501. Урок 501. 00:10:32
    Handling missing values
  502. Урок 502. 00:10:15
    Global Character Set Support
  503. Урок 503. 00:11:55
    Client and Server Encoding
  504. Урок 504. 00:08:36
    What is a transaction?
  505. Урок 505. 00:05:21
    How SQL protect database during transaction
  506. Урок 506. 00:08:41
    ACID Database
  507. Урок 507. 00:02:22
    Transaction setup
  508. Урок 508. 00:13:45
    Transaction analysis
  509. Урок 509. 00:03:45
    How to fix aborted transaction
  510. Урок 510. 00:05:33
    How to fix transactions on crash
  511. Урок 511. 00:03:37
    Partial transaction rollback with savepoints
  512. Урок 512. 00:05:41
    Using SAVEPOINT with transaction
  513. Урок 513. 00:01:12
    Using Northwind database
  514. Урок 514. 00:02:09
    Orders shipping to USA or France
  515. Урок 515. 00:01:49
    Total numbers of orders shipped to USA or France
  516. Урок 516. 00:03:22
    Orders shipped to latin america
  517. Урок 517. 00:04:02
    Show total order amount for each order
  518. Урок 518. 00:02:27
    First the oldest and latest order date
  519. Урок 519. 00:03:56
    Total products in each categories
  520. Урок 520. 00:03:42
    List products that needs re-ordering
  521. Урок 521. 00:10:01
    Freight analysis
  522. Урок 522. 00:05:53
    Customers with no orders
  523. Урок 523. 00:04:59
    Top customers with total orders amount
  524. Урок 524. 00:02:50
    Orders with many lines of ordered items
  525. Урок 525. 00:10:17
    Orders with double entry line items
  526. Урок 526. 00:10:53
    Late shipped orders by employees
  527. Урок 527. 00:02:51
    Countries with customers or suppliers
  528. Урок 528. 00:06:16
    Countries with customers or suppliers - Using CTE
  529. Урок 529. 00:07:23
    Customers with multiple orders
  530. Урок 530. 00:07:49
    First order from each country
  531. Урок 531. 00:03:15
    Human Resources Database Structure
  532. Урок 532. 00:05:32
    Quick overview of all tables
  533. Урок 533. 00:03:21
    Quick overview of all tables Part 2
  534. Урок 534. 00:03:50
    Get highest, lowest, total, and average salaries of employees
  535. Урок 535. 00:01:26
    Difference b/w highest and lowest salaries by job_id
  536. Урок 536. 00:02:16
    Get lowest paid salaries by each manager
  537. Урок 537. 00:02:37
    Average salary for each department with more than 10 employees.
  538. Урок 538. 00:02:00
    Average salary for each post excluding programmer
  539. Урок 539. 00:02:29
    Maximum salary for each post where salary is at or above $5000
  540. Урок 540. 00:01:41
    Using an alias name with columns
  541. Урок 541. 00:02:53
    Compute 15% of salary for all employees
  542. Урок 542. 00:01:23
    To list all employees IDs within each job_id group
  543. Урок 543. 00:05:43
    Discard characters from employees email address
  544. Урок 544. 00:03:13
    List all employees with first_name starts with letters "A", "C" or "M"
  545. Урок 545. 00:02:06
    String manipulation with upper, lower and initcap functions
  546. Урок 546. 00:00:53
    Using SUBSTRING to get portion of string data
  547. Урок 547. 00:02:10
    Get unique designations in employees table
  548. Урок 548. 00:02:16
    Select employees with particular department id only
  549. Урок 549. 00:03:22
    Select employees not in range
  550. Урок 550. 00:02:37
    Find Letter "C" in last_name at 3rd or greater position
  551. Урок 551. 00:02:58
    Update phone_number with your strings
  552. Урок 552. 00:02:12
    Get the monthly salary of each employees
  553. Урок 553. 00:01:52
    Calculate average salary with total number of employees
  554. Урок 554. 00:02:30
    find employees whose names contains exactly six characters
  555. Урок 555. 00:03:50
    Select first or last records in a table
  556. Урок 556. 00:04:17
    Get first or last record per each group
  557. Урок 557. 00:01:56
    How to calculate cube root in PostgreSQL?
  558. Урок 558. 00:04:19
    Security concepts and and levels
  559. Урок 559. 00:05:38
    Instance Level Security
  560. Урок 560. 00:04:31
    Instance Level Security - Add users to roles
  561. Урок 561. 00:04:08
    Use pgAdmin to create roles
  562. Урок 562. 00:05:34
    Database Level Security
  563. Урок 563. 00:11:14
    Schema Level Security
  564. Урок 564. 00:11:06
    Table Level Security
  565. Урок 565. 00:08:33
    Column Level Security
  566. Урок 566. 00:14:54
    Row Level Security
  567. Урок 567. 00:06:15
    Using CURRENT_USER with RLS
  568. Урок 568. 00:05:04
    Row level policy for application users
  569. Урок 569. 00:02:22
    DROP a policy
  570. Урок 570. 00:02:51
    Inspecting permissions
  571. Урок 571. 00:04:17
    Row Level Security Performance
  572. Урок 572. 00:07:20
    Encrypted data in columns
  573. Урок 573. 00:04:08
    Connect to local or remote database
  574. Урок 574. 00:01:46
    Switch connection to a new database
  575. Урок 575. 00:03:25
    List all databases and tables
  576. Урок 576. 00:03:33
    List all table space, schemas, and indices
  577. Урок 577. 00:07:12
    List all sequences, roles, data types, domain data types
  578. Урок 578. 00:01:02
    Describe a table
  579. Урок 579. 00:01:18
    Edit SQL commands in editor
  580. Урок 580. 00:03:06
    Display command history, run commands from a file
  581. Урок 581. 00:01:06
    Built-in syntax reference for commands
  582. Урок 582. 00:03:51
    Represent NULL values on psql terminal
  583. Урок 583. 00:02:11
    Make table layout funkey!
  584. Урок 584. 00:01:42
    Repeatedly Execute a Query
  585. Урок 585. 00:03:51
    Represent NULL Visibly
  586. Урок 586. 00:02:45
    Turn on query execution time
  587. Урок 587. 00:04:11
    List database users, and database sizes with and without indexes
  588. Урок 588. 00:04:21
    List all database and schemas
  589. Урок 589. 00:08:25
    List all tables and views
  590. Урок 590. 00:02:47
    List all columns from a table
  591. Урок 591. 00:02:34
    View system metadata via system information functions
  592. Урок 592. 00:08:16
    View privileges information across tables
  593. Урок 593. 00:05:25
    Using system Administration functions
  594. Урок 594. 00:04:17
    Show all running queries
  595. Урок 595. 00:02:55
    Terminate running and IDLE process
  596. Урок 596. 00:01:50
    How to check live and dead rows in tables
  597. Урок 597. 00:09:22
    File layout of PostgreSQL Tables
  598. Урок 598. 00:12:07
    Using SELECT INTO to create a new table with joins
  599. Урок 599. 00:03:09
    Duplicate a table with or without data
  600. Урок 600. 00:07:00
    Import data from CSV files
  601. Урок 601. 00:02:43
    Export Data to CSV files
  602. Урок 602. 00:07:27
    Deleting duplicate records
  603. Урок 603. 00:05:58
    Database operations and table size
  604. Урок 604. 00:07:27
    Tracking table size
  605. Урок 605. 00:10:29
    PostgreSQL autovacuum proces
  606. Урок 606. 00:09:56
    Recovering unused space with VACUUM
  607. Урок 607. 00:10:46
    Generated Columns
  608. Урок 608. 00:22:37
    Create a custom index method
  609. Урок 609. 00:10:57
    Create a user-defined aggregate function
  610. Урок 610. 00:00:49
    Thank You!