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