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

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

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

SQL & MySQL Subqueries: Understanding the weird parts

udemy

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

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

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 - одна из самых больших площадок в мире по доставке обучающего контента от разных авторов всего мира. Присутсвуют курсы практически на любую тему.

+194

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

Ограничение времени просмотра

Автор - udemy

udemy

Другие материалы в этой категории

Высокопроизводительный SQLite

Курс по SQL для начинающих

Быстрый старт в SQL

SQL-инъекции - веб-атаки SQLi

SQL и проектирование баз данных: MS SQL Server + PostgreSQL

Симулятор «SQL для анализа данных»

Освойте SQL-запросы: от основ до продвинутого уровня