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

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