Этот материал находится в платной подписке. Оформи премиум подписку и смотри или слушай Practice advanced SQL queries with MySQL 5.7+, а также все другие курсы, прямо сейчас!
Премиум
  1. Урок 1. 00:03:14
    2018 update
  2. Урок 2. 00:05:37
    S01-L01 Introduction & kick-off
  3. Урок 3. 00:04:36
    S01-L02 How to get most out of this course?
  4. Урок 4. 00:03:31
    S01-L03 Environment setup
  5. Урок 5. 00:05:25
    S01-L04 Sample database
  6. Урок 6. 00:03:19
    S01-L05 What can I really do BEFORE the course?
  7. Урок 7. 00:03:33
    S01-L06 Checklist before jumping on section S02
  8. Урок 8. 00:06:09
    S02-L01 Intro: Coding style and conventions
  9. Урок 9. 00:12:49
    S02-L02 How to write a beautiful query? (Video part 1/2)
  10. Урок 10. 00:07:51
    S02-L02 How to write a beautiful query? (Video part 2/2)
  11. Урок 11. 00:18:31
    S02-L03 My personal best practices (Video part 1/3)
  12. Урок 12. 00:18:45
    S02-L03 My personal best practices (Video part 2/3)
  13. Урок 13. 00:13:01
    S02-L03 My personal best practices (Video part 3/3)
  14. Урок 14. 00:12:16
    S03-L01 Intro: Indexes & why to use them?
  15. Урок 15. 00:11:06
    S03-L02 Unique index
  16. Урок 16. 00:12:23
    S03-L03 Composite index
  17. Урок 17. 00:07:51
    S03-L04 Partial index
  18. Урок 18. 00:07:04
    S03-L05 Index hints (Use, Force, Ignore)
  19. Урок 19. 00:03:48
    S03-L06 Functions on indexed columns
  20. Урок 20. 00:05:52
    S03-L07 Using two indexes in one query for the same table
  21. Урок 21. 00:09:05
    S04-L01 Intro: Partitions & why to use them?
  22. Урок 22. 00:13:20
    S04-L02 How to work with partitions?
  23. Урок 23. 00:06:00
    S05-L01 Intro: Variables & why to use them?
  24. Урок 24. 00:18:29
    S05-L02 Session variable
  25. Урок 25. 00:03:49
    S06-L01 Intro: Analytic (window) functions
  26. Урок 26. 00:13:18
    S06-L02 ROW_NUMBER()
  27. Урок 27. 00:04:54
    S07-L01 Intro: Functions & why to use them?
  28. Урок 28. 00:08:56
    S07-L02 Relevant coding standards
  29. Урок 29. 00:07:49
    S08-L01 Intro: Procedures & why to use them?
  30. Урок 30. 00:11:09
    S08-L02 How to write procedures?
  31. Урок 31. 00:08:50
    S08-L03 Events
  32. Урок 32. 00:07:56
    S09-L01 Intro: Cursors & why to use them?
  33. Урок 33. 00:09:27
    S09-L02 Cursor in a procedure
  34. Урок 34. 00:02:50
    What can I really do AFTER the course?
  35. Урок 35. 00:02:28
    Course review
  36. Урок 36. 00:02:53
    Next steps & conclusion