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

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