Главная страницаКатегория sqlSQL и подзапросы в MySQL: Понимание сложных частей

SQL и подзапросы в MySQL: Понимание сложных частей

Name: SQL и подзапросы в MySQL: Понимание сложных частей
Price: 13 USD

SQL & MySQL Subqueries: Understanding the weird parts

udemy

SQL и подзапросы в MySQL: Понимание сложных частей

Начать Сейчас

Продолжительность

8 ч 53 мин

Категория

SQL

Количество уроков

170 Видео

Дата добавления

22 июл. 2024 г., 18:16

Язык

Английский

Дата выхода

1 июл. 2024 г., 01:00

В этом курсе вы погрузитесь в различные типы подзапросов, включая вложенные, коррелированные, скалярные, строковые, столбцовые и подзапросы во встроенных представлениях. Вы также изучите важные техники SQL, такие как JOIN, EXISTS, WHERE, HAVING, GROUP BY и многие другие. Наш эксперт-инструктор покажет вам, как использовать эти техники для решения реальных задач и как сочетать подзапросы с другими техниками SQL для максимальной эффективности.

К концу этого курса вы будете глубоко понимать, как работают подзапросы и как использовать их для извлечения необходимой информации из ваших баз данных. Вы сможете создавать сложные и мощные запросы для анализа и управления данными, как никогда раньше.

Курс предназначен для пользователей всех уровней, от начинающих до опытных пользователей SQL, и охватывает широкий спектр баз данных, включая MySQL, PostgreSQL, Microsoft SQL Server и Oracle Database. Наш пошаговый подход начинается с основ и переходит к более продвинутым техникам, предоставляя вам всестороннее понимание подзапросов в SQL.

Посмотреть больше

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

Урок 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

Автор - udemy

udemy

Udemy - одна из самых больших площадок в мире по доставке обучающего контента от разных авторов всего мира. Присутсвуют курсы практически на любую тему.

+195