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

  1. Урок 1. 00:04:33
    01. Introduction to this course
  2. Урок 2. 00:05:12
    02. Introduction to SQLite
  3. Урок 3. 00:03:04
    03. SQLite is safe
  4. Урок 4. 00:03:17
    04. It's just a file
  5. Урок 5. 00:02:56
    05. Running SQLite locally
  6. Урок 6. 00:06:23
    06. Good uses for SQLite
  7. Урок 7. 00:03:52
    07. SQLite's limitations
  8. Урок 8. 00:02:28
    08. The documentation
  9. Урок 9. 00:04:39
    09. SQLite's structure
  10. Урок 10. 00:03:52
    10. SQLite's file format
  11. Урок 11. 00:09:22
    11. Dot commands
  12. Урок 12. 00:06:10
    12. Pragmas
  13. Урок 13. 00:03:48
    13. Virtual tables
  14. Урок 14. 00:05:43
    14. Flexible types
  15. Урок 15. 00:10:26
    15. Types
  16. Урок 16. 00:05:41
    16. Strict types
  17. Урок 17. 00:07:59
    17. Dates
  18. Урок 18. 00:01:02
    18. Booleans
  19. Урок 19. 00:07:27
    19. Floating point
  20. Урок 20. 00:11:02
    20. Rowid tables
  21. Урок 21. 00:06:47
    21. Auto increme
  22. Урок 22. 00:03:26
    22. Without rowid
  23. Урок 23. 00:06:49
    23. Generated columns
  24. Урок 24. 00:04:30
    24. Locking
  25. Урок 25. 00:04:16
    25. Rollback mode
  26. Урок 26. 00:04:13
    26. WAL mode
  27. Урок 27. 00:05:37
    27. WAL vs Journal benchmarks
  28. Урок 28. 00:04:29
    28. Busy timeout
  29. Урок 29. 00:04:21
    29. Transaction modes
  30. Урок 30. 00:06:48
    30. Vacuum
  31. Урок 31. 00:05:16
    31. Analyze & Optimize
  32. Урок 32. 00:05:23
    32. Suggested pragmas
  33. Урок 33. 00:01:32
    33. Faster inse
  34. Урок 34. 00:05:33
    34. Introduction to indexes
  35. Урок 35. 00:05:01
    35. B+ trees
  36. Урок 36. 00:08:07
    36. Primary, secondary, and clustered indexes
  37. Урок 37. 00:01:56
    37. Without rowid tables
  38. Урок 38. 00:07:04
    38. Benchmarking without rowid tables
  39. Урок 39. 00:03:24
    39. Imposter tables
  40. Урок 40. 00:04:02
    40. Primary key data types
  41. Урок 41. 00:11:43
    41. Where to add indexes
  42. Урок 42. 00:09:14
    42. Index selectivity
  43. Урок 43. 00:11:38
    43. Composite indexes
  44. Урок 44. 00:03:01
    44. Composite ordering
  45. Урок 45. 00:09:33
    45. Covering indexes
  46. Урок 46. 00:08:07
    46. Partial indexes
  47. Урок 47. 00:05:02
    47. Indexes on expressions
  48. Урок 48. 00:04:23
    48. Automatic indexes
  49. Урок 49. 00:06:17
    49. Duplicate indexes
  50. Урок 50. 00:08:32
    50. Indexing joins
  51. Урок 51. 00:06:14
    51. Explain
  52. Урок 52. 00:03:47
    52. Index obfuscation
  53. Урок 53. 00:09:01
    53. Joins
  54. Урок 54. 00:11:38
    54. Subqueries
  55. Урок 55. 00:06:37
    55. Unions
  56. Урок 56. 00:03:48
    56. CTEs
  57. Урок 57. 00:09:26
    57. Recursive CTEs
  58. Урок 58. 00:10:53
    58. Window functions
  59. Урок 59. 00:03:36
    59. Dealing with NULLs
  60. Урок 60. 00:10:12
    60. Row value syntax
  61. Урок 61. 00:06:12
    61. Indexed sorting
  62. Урок 62. 00:07:56
    62. Upse
  63. Урок 63. 00:03:34
    63. Returning
  64. Урок 64. 00:09:59
    64. Aggregates
  65. Урок 65. 00:05:29
    65. Triggers
  66. Урок 66. 00:10:57
    66. Altering schema
  67. Урок 67. 00:04:24
    67. Altering schema with tools
  68. Урок 68. 00:02:20
    68. Multi-database
  69. Урок 69. 00:11:34
    69. Multi-tenancy
  70. Урок 70. 00:04:26
    70. Backups
  71. Урок 71. 00:05:37
    71. Expo
  72. Урок 72. 00:03:04
    72. How to corrupt SQLite
  73. Урок 73. 00:03:40
    73. Intro to JSON
  74. Урок 74. 00:05:07
    74. JSON vs. JSONB
  75. Урок 75. 00:09:19
    75. Argument types- path, value, JSON
  76. Урок 76. 00:03:20
    76. JSON5
  77. Урок 77. 00:07:13
    77. Valid JSON
  78. Урок 78. 00:02:43
    78. Creating JSON obje + arrays
  79. Урок 79. 00:06:47
    79. JSON Extraction
  80. Урок 80. 00:07:11
    80. Updating JSON
  81. Урок 81. 00:05:14
    81. JSON aggregates
  82. Урок 82. 00:07:43
    82. JSON table functions
  83. Урок 83. 00:07:49
    83. Indexing JSON
  84. Урок 84. 00:13:56
    84. Creating tables
  85. Урок 85. 00:10:45
    85. Performing searches
  86. Урок 86. 00:05:58
    86. Ranking resu
  87. Урок 87. 00:05:52
    87. Highlighting matches
  88. Урок 88. 00:54:00
    88. DHH discusses SQLite in Ruby on Rails
  89. Урок 89. 00:54:37
    89. Distributed SQLite with Litestream and LiteFS
  90. Урок 90. 01:21:25
    90. Offline-first, multiplayer SQLite
  91. Урок 91. 01:02:53
    91. Production SQLite with Turso and libSQL
  92. Урок 92. 00:54:00
    92. DHH discusses SQLite in Ruby on Rails
  93. Урок 93. 01:22:39
    93. Ruby on Rails with SQLite