Этот материал находится в платной подписке. Оформи премиум подписку и смотри или слушай SQL & MySQL Subqueries: Understanding the weird parts, а также все другие курсы, прямо сейчас!
Премиум
  • Урок 1. 00:05:32
    Importance of Subquery
  • Урок 2. 00:11:26
    Beginning Subquery - With Example I
  • Урок 3. 00:07:00
    Beginning Subquery - With Example II
  • Урок 4. 00:05:30
    Beginning Subquery - With Example III
  • Урок 5. 00:06:12
    Nested Subquery - SubQuery with LIKE
  • Урок 6. 00:10:22
    Nested Subquery - Mangers of Employee SubQueries
  • Урок 7. 00:05:25
    Nested Subquery - Employee Territories
  • Урок 8. 00:03:37
    Nested Subquery - CategoryName
  • Урок 9. 00:03:24
    Nested Subquery - Suppliers
  • Урок 10. 00:02:40
    Nested Subquery - Product Ordered
  • Урок 11. 00:02:45
    Nested Subquery - Employee Without Orders
  • Урок 12. 00:03:10
    Nested Subquery - Employees with same region
  • Урок 13. 00:02:35
    Nested Subquery - Territories not assigned to employee
  • Урок 14. 00:02:24
    Nested Subquery - Freight of orders
  • Урок 15. 00:04:38
    Nested Subquery - Supplied categories of seafood
  • Урок 16. 00:02:46
    Nested Subquery - customers in the same city
  • Урок 17. 00:03:43
    Nested Subquery - Employees with same manager
  • Урок 18. 00:04:14
    Nested Subquery - Products with reorderLevel
  • Урок 19. 00:15:08
    Nested Subquery - Employee under managers who have managers
  • Урок 20. 00:05:52
    Nested Subquery - Supplier who live in Spain
  • Урок 21. 00:04:33
    Nested Subquery - Territories names Assigned to Employees
  • Урок 22. 00:02:49
    Nested Subquery - Products Supplied by Same Company
  • Урок 23. 00:05:49
    Nested Subquery - Customers who placed orders
  • Урок 24. 00:02:21
    Nested Subquery - Products never ordered
  • Урок 25. 00:02:58
    Nested Subquery - Territories never assign to Employees
  • Урок 26. 00:02:37
    Nested Subquery - Customers Who Never Placed Orders
  • Урок 27. 00:01:42
    Nested Subquery - Employees not assigned to Territories
  • Урок 28. 00:03:32
    Nested Subquery - Order Placed in 2008
  • Урок 29. 00:03:30
    Nested Subquery - Employees who have the same territories
  • Урок 30. 00:01:50
    Nested Subquery - Products ordered by customers
  • Урок 31. 00:03:06
    Nested Subquery - Employees Managed by Funk
  • Урок 32. 00:04:50
    Nested Subquery - Suppliers who supplied products to a customers
  • Урок 33. 00:03:00
    Nested Subquery - Customers who placed order more than 30
  • Урок 34. 00:03:03
    Nested Subquery - Employees with same territory
  • Урок 35. 00:04:30
    Nested Subquery - Customer Ordered Beverages Products
  • Урок 36. 00:03:23
    Nested Subquery - Suppliers for London Customers
  • Урок 37. 00:00:43
    Question - Product Never Order by Retails - Subquery
  • Урок 38. 00:07:14
    Solution - Product Never Order by Retails - Subquery
  • Урок 39. 00:00:53
    Question - Category of Products Ordered in Germany
  • Урок 40. 00:02:36
    Solution - Category of Products Ordered in Germany
  • Урок 41. 00:00:24
    Question - Territories Assigned to Sale Rep Employees
  • Урок 42. 00:02:23
    Solution - Territories Assigned to Sale Rep Employees
  • Урок 43. 00:00:15
    Question - Customers who ordered beverages products
  • Урок 44. 00:03:01
    Solution - Customers who ordered beverages products
  • Урок 45. 00:00:16
    Question - Employees in Charge of Seattle
  • Урок 46. 00:03:10
    Solution - Employees in Charge of Seattle
  • Урок 47. 00:00:22
    Question - Products Ordered By Customers Who are Owners of Business
  • Урок 48. 00:02:38
    Solution - Products Ordered By Customers Who are Owners of Business
  • Урок 49. 00:00:22
    Question - Products Ordered By Customers From Germany - Subquery
  • Урок 50. 00:02:39
    Solution - Products Ordered By Customers From Germany - Subquery
  • Урок 51. 00:00:22
    Question - Supplier Who Supplied to Customer in WA Region - Subquery
  • Урок 52. 00:01:49
    Solution - Supplier Who Supplied to Customer in WA Region - Subquery
  • Урок 53. 00:00:30
    Question - Supplier Who Supplied to Customer in WA Region & Cost Above 4000
  • Урок 54. 00:04:52
    Solution - Supplier Who Supplied to Customer in WA Region & Cost Above 4000
  • Урок 55. 00:00:17
    Question - Customers Ordered UK Suppliers Products
  • Урок 56. 00:01:31
    Solution - Customers Ordered UK Suppliers Products
  • Урок 57. 00:02:59
    Introduction to JOIN
  • Урок 58. 00:06:20
    Introduction to Inner Join by Example
  • Урок 59. 00:00:45
    Rearranging your query
  • Урок 60. 00:03:58
    Indicating Source of Columns
  • Урок 61. 00:05:14
    Alias with Join
  • Урок 62. 00:02:19
    "USING" with Join
  • Урок 63. 00:04:09
    Inner Join - ProductName, UnitPrice and SupplierName
  • Урок 64. 00:03:06
    Inner Join - ProductName and Categories
  • Урок 65. 00:03:03
    Inner Join - Product Name, Supplier and Category
  • Урок 66. 00:06:18
    Inner Join - Quantity of Product, ProductName and Suppliers
  • Урок 67. 00:07:04
    HAVING - Understanding Having for Join and Subquery
  • Урок 68. 00:02:42
    HAVING - Understanding Having Example
  • Урок 69. 00:03:21
    Customers, Employee and Orders
  • Урок 70. 00:02:47
    Number of Orders per Employee Exercise with Solution
  • Урок 71. 00:04:25
    Suppliers, Products and Total Quantity
  • Урок 72. 00:01:17
    Question - Join - CategoryName and TotalQuantity
  • Урок 73. 00:02:02
    Solution - Join - CategoryName and TotalQuantity
  • Урок 74. 00:00:37
    Question - Join - Customer Purchased above 100 dollars
  • Урок 75. 00:02:53
    Solution - Join - Customer Purchased above 100 dollars
  • Урок 76. 00:01:07
    Question - Customers Who Ordered from a Specific Supplier
  • Урок 77. 00:02:13
    Solution - Customers Who Ordered from a Specific Supplier
  • Урок 78. 00:00:14
    Question - Customer, Supplier, Quantity and Total Price
  • Урок 79. 00:02:51
    Solution - Customer, Supplier, Quantity and Total Price
  • Урок 80. 00:00:30
    Question - AveragePrice, Products and Customers
  • Урок 81. 00:02:34
    Solution - AveragePrice, Products and Customers
  • Урок 82. 00:00:31
    Question - customers, products, supplier in Germany
  • Урок 83. 00:02:02
    Solution - customers, products, supplier in Germany
  • Урок 84. 00:00:53
    Question - Total Quantity of Products for Customer and Supplier in Same Country
  • Урок 85. 00:02:05
    Solution - Total Quantity of Products for Customer and Supplier in Same Country
  • Урок 86. 00:00:21
    Question - List of Customers, Products, Categories & Suppliers
  • Урок 87. 00:06:05
    Solution - List of Customers, Products, Categories & Suppliers
  • Урок 88. 00:00:32
    Question - Employees and a Specific Supplier
  • Урок 89. 00:01:01
    Solution - Employees and a Specific Supplier
  • Урок 90. 00:01:48
    Question - Employees Who Managed More than 10 Orders
  • Урок 91. 00:04:30
    Solution - Employees Who Managed More than 10 Orders
  • Урок 92. 00:00:16
    Question - Average UnitPrice, Supplier and Customers from France
  • Урок 93. 00:02:18
    Solution - Average UnitPrice, Supplier and Customers from France
  • Урок 94. 00:00:33
    Question - Total Quantity of Product, Suppliers sold more than 1200 units
  • Урок 95. 00:00:20
    Solution - Total Quantity of Product, Suppliers sold more than 1200 units
  • Урок 96. 00:00:33
    Final Join Question
  • Урок 97. 00:00:46
    Final Join Solution
  • Урок 98. 00:00:38
    NEXT?
  • Урок 99. 00:10:54
    Question & Solution 1 - Join & Subquery
  • Урок 100. 00:04:49
    Question & Solution 2 - Join & Subquery
  • Урок 101. 00:09:22
    Question & Solution 3 - Join & Subquery
  • Урок 102. 00:02:28
    Question & Solution 4 - Join & Subquery
  • Урок 103. 00:02:20
    Question & Solution 5 - Join & Subquery
  • Урок 104. 00:08:29
    Question & Solution 6 - Join & Subquery
  • Урок 105. 00:02:43
    Question & Solution 7 - Join & Subquery
  • Урок 106. 00:02:57
    Question & Solution 8 - Join & Subquery
  • Урок 107. 00:02:52
    Question & Solution 9 - Join & Subquery
  • Урок 108. 00:04:01
    Question & Solution 10 - Join & Subquery
  • Урок 109. 00:03:29
    Introduction to Single-Row Subquery
  • Урок 110. 00:04:43
    Example 1 - Employee who has been with the company the longest
  • Урок 111. 00:03:50
    Example 2 - Customer Who Placed the latest Order
  • Урок 112. 00:02:17
    Example 3 - Product with highest unitPrice
  • Урок 113. 00:01:28
    Example 4 - Order with Highest Freight Value
  • Урок 114. 00:04:12
    Example 5 - Number of OrderID by Customer With Most Orders
  • Урок 115. 00:04:21
    Exmaple 6 - Most Expensive Products Per Category
  • Урок 116. 00:01:58
    Introduction to CTE
  • Урок 117. 00:04:37
    CTE Subquery by Example
  • Урок 118. 00:05:08
    CTE - Retrieve all Customers with Total Ordeer Amount
  • Урок 119. 00:02:37
    CTE - Product Sales Per Category
  • Урок 120. 00:02:03
    CTE - Top Selling Products
  • Урок 121. 00:03:08
    CTE - Average unit price per category
  • Урок 122. 00:10:37
    CTE - Total and Average Sales
  • Урок 123. 00:04:37
    CTE - TotalSales and RegionSales
  • Урок 124. 00:02:23
    CTE - Top Five Customers
  • Урок 125. 00:01:59
    CTE - Discontinued Products
  • Урок 126. 00:02:09
    CTE - Average Order Value
  • Урок 127. 00:02:14
    CET - Top Five Products By Sales
  • Урок 128. 00:03:58
    Understanding Inline View Subquery
  • Урок 129. 00:05:08
    Inline View - Discount Amount for Products
  • Урок 130. 00:12:10
    Inline View - Average Order Value Per Customer
  • Урок 131. 00:04:46
    Inline View - Top 5 Customers By Total Orders
  • Урок 132. 00:06:32
    Inline View - Product Ordered By Largest Number of Customers
  • Урок 133. 00:06:00
    Inline View - Top 10 By Quantity Sold
  • Урок 134. 00:02:01
    Understanding Scalar Subquery
  • Урок 135. 00:04:28
    Scalar Subquery - Customers with Orders More than 20
  • Урок 136. 00:04:54
    Scalar Subquery - Employees who sold more than 100k
  • Урок 137. 00:02:09
    Scalar Subquery - Orders shipped by the most recent Employee
  • Урок 138. 00:02:48
    Scalar Subquery - Categories where average unit price greater than $30
  • Урок 139. 00:05:05
    Scalar Subquery - Orders of employees with fewest orders
  • Урок 140. 00:03:52
    Understanding Multiple-Row Subquery
  • Урок 141. 00:02:18
    Multiple-Rows Subquery - Products Ordered More Than 50 Times
  • Урок 142. 00:00:58
    Multiple-Rows Subquery - Customers who placed orders in 2008
  • Урок 143. 00:00:44
    Multiple-Rows Subquery - Employees that have made at least one sales
  • Урок 144. 00:00:57
    Multiple-Rows Subquery -Categories with at least 10 products
  • Урок 145. 00:01:04
    Multiple-Rows Subquery - Suppliers with product more than 100
  • Урок 146. 00:01:35
    Multiple-Rows Subquery - Products that have UnitPrice greater than its category
  • Урок 147. 00:05:04
    Multiple-Rows Subquery - More exercise and solution
  • Урок 148. 00:04:13
    Understanding Correlated Subquery I
  • Урок 149. 00:02:41
    Understanding Correlated Subquery II
  • Урок 150. 00:01:42
    EXISTS for Correlated Subquery
  • Урок 151. 00:03:26
    Correlated Subquery - At one order in Beverages category
  • Урок 152. 00:01:25
    Correlated Subquery - Customers who have not placed any order in condiments
  • Урок 153. 00:01:47
    Correlated Subquery - Products not ordered by customers from Germany
  • Урок 154. 00:00:52
    Correlated Subquery - Customers Placed Orders for Discontinued products
  • Урок 155. 00:01:34
    Correlated Subquery - More Exercise with Solution
  • Урок 156. 00:01:08
    Selecting all columns
  • Урок 157. 00:01:27
    Selecting a Specific Column
  • Урок 158. 00:01:30
    Selecting Multiple columns
  • Урок 159. 00:01:00
    Selecting Multiple columns II
  • Урок 160. 00:01:37
    How to use DISTINCT
  • Урок 161. 00:02:25
    Distinct on multiple columns
  • Урок 162. 00:01:57
    Distinct on multiple columns II
  • Урок 163. 00:04:35
    Understanding WHERE (Filter)
  • Урок 164. 00:01:52
    Where and = by Example
  • Урок 165. 00:01:13
    Where and <> By Example
  • Урок 166. 00:00:56
    Where and != By Example
  • Урок 167. 00:01:35
    Where and > By Example
  • Урок 168. 00:00:46
    Where and >= By Example
  • Урок 169. 00:00:17
    Where and < By Example
  • Урок 170. 00:00:22
    Where and <= By Example