Этот материал находится в платной подписке. Оформи премиум подписку и смотри или слушай The Complete SQL Bootcamp: Go from Zero to Hero, а также все другие курсы, прямо сейчас!
Купить сейчас
  • Урок 1. 00:02:16
    Introduction
  • Урок 2. 00:01:42
    Course Curriculum Overview
  • Урок 3. 00:07:38
    Overview of Databases
  • Урок 4. 00:21:10
    Windows Installation - PostGreSQL and PgAdmin with Database Setup
  • Урок 5. 00:23:07
    MacOS Installation - PostgreSQL and PgAdmin with First Query
  • Урок 6. 00:09:45
    pgAdmin Overview
  • Урок 7. 00:01:37
    Overview of Challenges!
  • Урок 8. 00:00:43
    SQL Statement Fundamentals
  • Урок 9. 00:08:41
    SELECT Statement
  • Урок 10. 00:04:30
    Challenge: SELECT
  • Урок 11. 00:05:39
    SELECT DISTINCT
  • Урок 12. 00:01:55
    Challenge: SELECT DISTINCT
  • Урок 13. 00:07:24
    COUNT
  • Урок 14. 00:04:31
    SELECT WHERE - Part One
  • Урок 15. 00:07:05
    SELECT WHERE - Part Two
  • Урок 16. 00:05:36
    Challenge: SELECT WHERE
  • Урок 17. 00:08:12
    ORDER BY
  • Урок 18. 00:05:07
    LIMIT
  • Урок 19. 00:05:02
    Challenge: ORDER BY
  • Урок 20. 00:06:58
    BETWEEN
  • Урок 21. 00:04:56
    IN
  • Урок 22. 00:09:37
    LIKE and ILIKE
  • Урок 23. 00:09:55
    General Challenge 1
  • Урок 24. 00:00:58
    Introduction to GROUP BY
  • Урок 25. 00:08:00
    Aggregation Functions
  • Урок 26. 00:07:49
    GROUP BY - Part One
  • Урок 27. 00:10:43
    GROUP BY - Part Two
  • Урок 28. 00:04:06
    GROUP BY - Challenge
  • Урок 29. 00:06:26
    HAVING
  • Урок 30. 00:02:49
    HAVING - Challenge Tasks
  • Урок 31. 00:01:09
    Overview of Assessment Test 1
  • Урок 32. 00:01:15
    Introduction to JOINs
  • Урок 33. 00:07:49
    AS Statement
  • Урок 34. 00:14:50
    Inner Joins
  • Урок 35. 00:14:23
    Full Outer Joins
  • Урок 36. 00:11:19
    Left Outer Join
  • Урок 37. 00:04:22
    Right Joins
  • Урок 38. 00:02:28
    UNION
  • Урок 39. 00:12:16
    JOIN Challenge Tasks
  • Урок 40. 00:00:48
    Overview of Advanced SQL Commands
  • Урок 41. 00:07:39
    Timestamps and Extract - Part One
  • Урок 42. 00:10:07
    Timestamps and Extract - Part Two
  • Урок 43. 00:03:40
    Timestamps and Extract - Challenge Tasks
  • Урок 44. 00:05:01
    Mathematical Functions and Operators
  • Урок 45. 00:08:25
    String Functions and Operators
  • Урок 46. 00:15:12
    SubQuery
  • Урок 47. 00:10:56
    Self-Join
  • Урок 48. 00:07:27
    Setting up New Database for Assessment Exercises
  • Урок 49. 00:23:46
    Solutions to Assessment Test 2
  • Урок 50. 00:01:13
    Introduction to Section
  • Урок 51. 00:06:28
    Data Types
  • Урок 52. 00:09:05
    Primary Keys and Foreign Keys
  • Урок 53. 00:05:18
    Constraints
  • Урок 54. 00:18:29
    CREATE Table
  • Урок 55. 00:09:06
    INSERT
  • Урок 56. 00:07:59
    UPDATE
  • Урок 57. 00:03:13
    DELETE
  • Урок 58. 00:06:48
    ALTER Table
  • Урок 59. 00:03:19
    DROP Table
  • Урок 60. 00:07:05
    CHECK Constraint
  • Урок 61. 00:00:44
    Conditional Expressions and Procedures Introduction
  • Урок 62. 00:22:40
    CASE
  • Урок 63. 00:03:10
    CASE - Challenge Task
  • Урок 64. 00:05:36
    COALESCE
  • Урок 65. 00:07:08
    CAST
  • Урок 66. 00:10:35
    NULLIF
  • Урок 67. 00:07:08
    Views
  • Урок 68. 00:13:31
    Import and Export
  • Урок 69. 00:10:25
    Psycopg2 Example Usage