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

  1. Урок 1. 00:03:21
    Introduction
  2. Урок 2. 00:03:21
    Introduction to schema
  3. Урок 3. 00:06:31
    Integers
  4. Урок 4. 00:05:23
    Decimals
  5. Урок 5. 00:07:51
    Strings
  6. Урок 6. 00:04:52
    Binary strings
  7. Урок 7. 00:04:13
    Long strings
  8. Урок 8. 00:05:06
    Enums
  9. Урок 9. 00:09:19
    Dates
  10. Урок 10. 00:07:13
    JSON
  11. Урок 11. 00:06:12
    Unexpected types
  12. Урок 12. 00:09:54
    Generated columns
  13. Урок 13. 00:01:51
    Recap
  14. Урок 14. 00:06:23
    Introduction to indexes
  15. Урок 15. 00:05:41
    B+ trees
  16. Урок 16. 00:12:23
    Primary keys
  17. Урок 17. 00:04:46
    Secondary keys
  18. Урок 18. 00:05:08
    Primary key data types
  19. Урок 19. 00:12:04
    Where to add indexes
  20. Урок 20. 00:09:39
    Index selectivity
  21. Урок 21. 00:06:30
    Prefix indexes
  22. Урок 22. 00:18:40
    Composite indexes
  23. Урок 23. 00:10:33
    Covering indexes
  24. Урок 24. 00:09:53
    Functional indexes
  25. Урок 25. 00:13:56
    Indexing JSON columns
  26. Урок 26. 00:06:29
    Indexing for wildcard searches
  27. Урок 27. 00:09:45
    Fulltext indexes
  28. Урок 28. 00:02:58
    Invisible indexes
  29. Урок 29. 00:04:20
    Duplicate indexes
  30. Урок 30. 00:10:38
    Foreign keys
  31. Урок 31. 00:01:04
    Introduction to queries
  32. Урок 32. 00:11:40
    Explain overview
  33. Урок 33. 00:07:39
    Explain access types
  34. Урок 34. 00:06:57
    Explain analyze
  35. Урок 35. 00:04:00
    Index obfuscation
  36. Урок 36. 00:06:18
    Redundant and approximate conditions
  37. Урок 37. 00:08:05
    Select only what you need
  38. Урок 38. 00:09:46
    Limiting rows
  39. Урок 39. 00:09:29
    An overview of joins
  40. Урок 40. 00:08:45
    Cursor pagination
  41. Урок 41. 00:13:21
    Indexing joins
  42. Урок 42. 00:09:44
    Subqueries
  43. Урок 43. 00:09:12
    Common table expressions
  44. Урок 44. 00:11:49
    Recursive CTEs
  45. Урок 45. 00:05:41
    Unions
  46. Урок 46. 00:09:23
    Window functions
  47. Урок 47. 00:06:06
    Sorting and limiting
  48. Урок 48. 00:08:38
    Sorting with indexes
  49. Урок 49. 00:05:54
    Sorting with composite indexes
  50. Урок 50. 00:05:24
    Counting resu
  51. Урок 51. 00:06:58
    Dealing with NULLs
  52. Урок 52. 00:00:58
    Introduction to examples
  53. Урок 53. 00:06:48
    MD5 column
  54. Урок 54. 00:06:08
    MD5 over multiple columns
  55. Урок 55. 00:09:35
    Bitwise operations
  56. Урок 56. 00:03:49
    Timestamps versus booleans
  57. Урок 57. 00:05:49
    Claiming rows
  58. Урок 58. 00:05:22
    Summary tables
  59. Урок 59. 00:06:04
    Meta tables
  60. Урок 60. 00:08:31
    Offset limit pagination
  61. Урок 61. 00:06:09
    Deferred joins
  62. Урок 62. 00:07:12
    Geographic searches
  63. Урок 63. 00:03:49
    Thank you