Этот материал находится в платной подписке. Оформи премиум подписку и смотри или слушай SQL & Database Design A-Z™: Learn MS SQL Server + PostgreSQL, а также все другие курсы, прямо сейчас!
Премиум
  1. Урок 1. 00:02:18
    Intro Video
  2. Урок 2. 00:00:20
    Welcome to this section! This is what you wil learn
  3. Урок 3. 00:10:03
    Installation: PostgreSQL & PgAdmin 4 for Windows
  4. Урок 4. 00:03:08
    Installation: PostgreSQL & PgAdmin 4 for MAC OS
  5. Урок 5. 00:08:02
    Installation: MS SQL Server & MS SQL Server Management Studio (SSMS) for Windows
  6. Урок 6. 00:00:21
    Welcome to this section! This is what you will learn
  7. Урок 7. 00:02:43
    The challenge: Investigating Consumer Complaints
  8. Урок 8. 00:06:04
    Upload Consumer Complaints
  9. Урок 9. 00:07:30
    Getting To Know The PGADMIN
  10. Урок 10. 00:09:16
    Upload COnsumer COmplaints MS SQL
  11. Урок 11. 00:04:27
    Getting to know MS SQL SERVER
  12. Урок 12. 00:00:29
    Welcome to this section! This is what you will learn
  13. Урок 13. 00:03:52
    Theory Select Query
  14. Урок 14. 00:07:41
    Time to write your first query in PostgreSQL
  15. Урок 15. 00:06:16
    Adding a filter using WHERE in PostgreSQL
  16. Урок 16. 00:08:11
    Logical conditions AND, OR in PostgreSQL
  17. Урок 17. 00:10:40
    Using wildcards % and _ (advanced tutorial)
  18. Урок 18. 00:04:41
    Comments in SQL
  19. Урок 19. 00:11:03
    Getting to write your first query MS SQL
  20. Урок 20. 00:09:52
    Where MS SQL
  21. Урок 21. 00:11:10
    Logical conditions, AND OR MS SQL
  22. Урок 22. 00:10:11
    Using wildcards MS SQL
  23. Урок 23. 00:05:07
    Comments in SQL MS SQL
  24. Урок 24. 00:00:40
    Welcome to this section! This is what you will learn
  25. Урок 25. 00:03:31
    The challenge: Analyzing Console Games Sales
  26. Урок 26. 00:03:56
    Uploading Console Games Dataset
  27. Урок 27. 00:10:38
    Working with arithmetic data types
  28. Урок 28. 00:05:58
    ORDER BY
  29. Урок 29. 00:04:29
    WORKING WITH VARCHARS
  30. Урок 30. 00:17:38
    WORKING WITH DATES
  31. Урок 31. 00:06:02
    Implicit Data Conversion in SQL
  32. Урок 32. 00:10:56
    WORKING WITH NULL
  33. Урок 33. 00:04:59
    Uploading Console Games DATASET MS SQL
  34. Урок 34. 00:11:08
    Working with arithmetic data types MS SQL
  35. Урок 35. 00:07:25
    ORDER BY MS SQL
  36. Урок 36. 00:04:40
    Working with VARCHAR MS SQL
  37. Урок 37. 00:09:26
    Working with Dates MS SQL
  38. Урок 38. 00:03:13
    Implicit DATA conversion MS SQL
  39. Урок 39. 00:00:21
    Welcome to this section! This is what you will learn
  40. Урок 40. 00:05:32
    Structured vs Unstructured Data
  41. Урок 41. 00:02:56
    Elements Of a Database
  42. Урок 42. 00:05:01
    Relational Keys
  43. Урок 43. 00:03:17
    Relational Database
  44. Урок 44. 00:05:34
    Functional Dependency
  45. Урок 45. 00:00:38
    Welcome to this section! This is what you wil learn
  46. Урок 46. 00:06:19
    Types of Joins
  47. Урок 47. 00:02:33
    Duplicates in Joins
  48. Урок 48. 00:05:22
    Joining on multiple fields
  49. Урок 49. 00:02:22
    The challenge: The Vet's Clinic
  50. Урок 50. 00:05:28
    Upload the data
  51. Урок 51. 00:08:56
    Your First Left Outer Join
  52. Урок 52. 00:09:47
    Joins Tips & Tricks
  53. Урок 53. 00:11:45
    Inner Join
  54. Урок 54. 00:04:53
    Full Outer join
  55. Урок 55. 00:11:10
    Joining on Multiple Fields (Practice)
  56. Урок 56. 00:09:51
    Complex Joins
  57. Урок 57. 00:07:28
    Cleaning up your Join
  58. Урок 58. 00:11:12
    Cross Join (advanced tutorial)
  59. Урок 59. 00:08:16
    Upload The Data - MS SQL
  60. Урок 60. 00:09:52
    Your First Left Outer Join - MS SQL
  61. Урок 61. 00:11:03
    Joins Tips & Tricks - MS SQL
  62. Урок 62. 00:12:27
    Inner Join - MS SQL
  63. Урок 63. 00:03:23
    Full Outer Join - MS SQL
  64. Урок 64. 00:12:02
    Joining on Multiple Fields (Practice) - MS SQL
  65. Урок 65. 00:08:40
    Complex Joins - MS SQL
  66. Урок 66. 00:07:57
    Cleaning Up Your Join - MS SQL
  67. Урок 67. 00:11:30
    Cross Join (advanced tutorial) - MS SQL
  68. Урок 68. 00:00:23
    Welcome to this section! This is what you will learn
  69. Урок 69. 00:04:05
    Create Database
  70. Урок 70. 00:13:13
    Create Table
  71. Урок 71. 00:13:30
    Insert Data
  72. Урок 72. 00:09:25
    Alter Table
  73. Урок 73. 00:07:28
    Drop Table
  74. Урок 74. 00:02:54
    Create Database MS SQL
  75. Урок 75. 00:06:03
    Create Table MS SQL
  76. Урок 76. 00:07:47
    Insert Data MS SQL
  77. Урок 77. 00:06:15
    ALTER TABLE MS SQL
  78. Урок 78. 00:02:14
    DROP TABLE MS SQL
  79. Урок 79. 00:00:53
    Welcome to this section! This is what you wil learn
  80. Урок 80. 00:07:15
    MS SQL Server: What is Database Normalization?
  81. Урок 81. 00:10:06
    Prime and non-prime attributes
  82. Урок 82. 00:07:55
    First Normal Form (1NF)
  83. Урок 83. 00:16:06
    Second Normal Form (2NF)
  84. Урок 84. 00:19:14
    Third Normal Form (3NF)
  85. Урок 85. 00:04:33
    The challenge: Online Clothing Store (OLTP Database)
  86. Урок 86. 00:03:36
    Upload the data
  87. Урок 87. 00:07:55
    Normalization 1NF Investigation
  88. Урок 88. 00:15:42
    Normalization 2NF Investigation
  89. Урок 89. 00:12:54
    Normalization 2NF Modification
  90. Урок 90. 00:17:24
    Normalization 3NF Investigation
  91. Урок 91. 00:18:26
    Normalization 3NF Modification
  92. Урок 92. 00:04:31
    Upload The Data - MS SQL
  93. Урок 93. 00:07:10
    Normalization 1NF Investigation - MS SQL
  94. Урок 94. 00:15:22
    Normalization 2NF Investigation - MS SQL
  95. Урок 95. 00:16:38
    Normalization 2NF Modification - MS SQL
  96. Урок 96. 00:17:23
    Normalization 3NF Investigation - MS SQL
  97. Урок 97. 00:19:27
    Normalization 3NF Modification - MS SQL
  98. Урок 98. 00:02:41
    THANK YOU Video