Этот материал находится в платной подписке. Оформи премиум подписку и смотри или слушай Master Mysql, Javascript, Laravel 5.8 and e-commerce project, а также все другие курсы, прямо сейчас!
Премиум
  1. Урок 1. 00:03:39
    Introduction & Installation
  2. Урок 2. 00:02:56
    Create first database
  3. Урок 3. 00:00:00
    Create first table
  4. Урок 4. 00:13:03
    Analyse users table
  5. Урок 5. 00:00:00
    Add unique key and more columns to users table
  6. Урок 6. 00:00:00
    Retrieve data from users table with select command
  7. Урок 7. 00:02:42
    Learn how to delete users
  8. Урок 8. 00:00:00
    Learn simple and advanced ways of updating tables
  9. Урок 9. 00:00:00
    Learn foreign key and how to connect tables
  10. Урок 10. 00:00:00
    Learn how to join tables and get more complex data
  11. Урок 11. 00:00:00
    Learn how to use views for more complex queries
  12. Урок 12. 00:00:00
    Create ecommerce database and countries table
  13. Урок 13. 00:00:00
    Create users table
  14. Урок 14. 00:00:00
    Learn one to many relationship
  15. Урок 15. 00:00:00
    Create categories table
  16. Урок 16. 00:00:00
    Create products table
  17. Урок 17. 00:06:16
    Create product_categories table
  18. Урок 18. 00:08:52
    Learn many to many relationship
  19. Урок 19. 00:04:28
    Create ratings table
  20. Урок 20. 00:07:26
    Create orders and order_items tables
  21. Урок 21. 00:06:47
    Create profiles table and learn one to one relationship
  22. Урок 22. 00:04:19
    Prepare database with massive data
  23. Урок 23. 00:02:44
    Get total number of users for each country
  24. Урок 24. 00:05:17
    Get total number of users and total amount of orders for each country
  25. Урок 25. 00:03:24
    Get total number and total amount of orders for each user
  26. Урок 26. 00:02:33
    Get total quantity of ordered products for each user
  27. Урок 27. 00:04:45
    Get each user ordered products with total sold count and total amount of pur...
  28. Урок 28. 00:04:38
    Get each user with ordered categories along with total sold count and total a...
  29. Урок 29. 00:01:46
    Get total number of products for each category
  30. Урок 30. 00:02:19
    Get total number and total amount of orders for each country
  31. Урок 31. 00:04:31
    Get each user's ratings count, ratings total and ratings average
  32. Урок 32. 00:02:44
    Get ratings count, ratings total and ratings average given to each product
  33. Урок 33. 00:01:54
    Get total number and total amount of orders for each month
  34. Урок 34. 00:01:45
    Get ten most popular products
  35. Урок 35. 00:11:16
    Get most popular product for each month
  36. Урок 36. 00:02:44
    Get ten best seller products
  37. Урок 37. 00:10:40
    Get best seller product for each month
  38. Урок 38. 00:01:41
    Get best order of each user
  39. Урок 39. 00:30:47
    Part 1. Introduction
  40. Урок 40. 00:06:36
    Part 2. Preparing application
  41. Урок 41. 00:06:37
    Part 3. Header
  42. Урок 42. 00:09:10
    Part 4. Header
  43. Урок 43. 00:12:51
    Part 5. Header
  44. Урок 44. 00:06:41
    Part 6. Header
  45. Урок 45. 00:03:17
    Part 7. Footer
  46. Урок 46. 00:07:41
    Part 8. Footer
  47. Урок 47. 00:08:15
    Part 9. Roles
  48. Урок 48. 00:08:32
    Part 10. User panel
  49. Урок 49. 00:00:00
    Part 11. User panel
  50. Урок 50. 00:07:41
    Part 12. Repositories
  51. Урок 51. 00:09:15
    Part 13. Data filters
  52. Урок 52. 00:11:11
    Part 14. Data filters
  53. Урок 53. 00:07:24
    Part 15. Brands management
  54. Урок 54. 00:12:04
    Part 16. Brands management
  55. Урок 55. 00:12:15
    Part 17. Brands management
  56. Урок 56. 00:00:00
    Part 18. Brands management
  57. Урок 57. 00:13:01
    Part 19. Brands management
  58. Урок 58. 00:09:07
    Part 20. JS request component
  59. Урок 59. 00:09:57
    Part 21. JS ajax form component
  60. Урок 60. 00:13:18
    Part 22. Js ajax form component
  61. Урок 61. 00:06:32
    Part 23. JS ajax form component
  62. Урок 62. 00:12:13
    Part 24. JS list component
  63. Урок 63. 00:12:14
    Part 25. JS data list component
  64. Урок 64. 00:07:36
    Part 26. JS data list component
  65. Урок 65. 00:10:53
    Part 27. JS data list component
  66. Урок 66. 00:14:09
    Part 28. JS data list component
  67. Урок 67. 00:11:59
    Part 29. JS data list component
  68. Урок 68. 00:10:05
    Part 30. JS data list component
  69. Урок 69. 00:06:42
    Part 31. JS data list component
  70. Урок 70. 00:08:57
    Part 32. Brands management
  71. Урок 71. 00:00:00
    Part 33. More methods for repositories
  72. Урок 72. 00:17:21
    Part 34. Brands management
  73. Урок 73. 00:13:45
    Part 35. Brands management
  74. Урок 74. 00:19:16
    Part 36. Brands management
  75. Урок 75. 00:22:56
    Part 37. Brands management
  76. Урок 76. 00:09:31
    Part 38. Categories management
  77. Урок 77. 00:15:44
    Part 39. Categories management
  78. Урок 78. 00:00:00
    Part 40. JS selectable list component
  79. Урок 79. 00:11:48
    Part 41. JS selectable list component
  80. Урок 80. 00:00:00
    Part 42. Categories management
  81. Урок 81. 00:19:59
    Part 43. Categories management
  82. Урок 82. 00:20:36
    Part 44. Categories management
  83. Урок 83. 00:09:48
    Part 45. Categories management
  84. Урок 84. 00:00:00
    Part 46. Filters management
  85. Урок 85. 00:20:47
    Part 47. Filters management
  86. Урок 86. 00:05:56
    Part 48. Filters management
  87. Урок 87. 00:00:00
    Part 49. JS modal component
  88. Урок 88. 00:16:38
    Part 50. Options management
  89. Урок 89. 00:06:09
    Part 51. Options management
  90. Урок 90. 00:15:08
    Part 52. Options management
  91. Урок 91. 00:10:14
    Part 53. Options management
  92. Урок 92. 00:14:43
    Part 54. Options management
  93. Урок 93. 00:18:04
    Part 55. Options management
  94. Урок 94. 00:15:47
    Part 56. Options management
  95. Урок 95. 00:00:00
    Part 57. Category filters management
  96. Урок 96. 00:14:33
    Part 58. Category filters management
  97. Урок 97. 00:12:52
    Part 59. Category filters management
  98. Урок 98. 00:17:55
    Part 60. Category filters management
  99. Урок 99. 00:06:11
    Part 61. Category filters management
  100. Урок 100. 00:12:00
    Part 62. Category filters management
  101. Урок 101. 00:11:05
    Part 63. Products management
  102. Урок 102. 00:00:00
    Part 64. Products management
  103. Урок 103. 00:08:38
    Part 65. Products management
  104. Урок 104. 00:14:06
    Part 66. Products management
  105. Урок 105. 00:19:42
    Part 67. Products management
  106. Урок 106. 00:11:28
    Part 68. Products management
  107. Урок 107. 00:20:52
    Part 69. Products management
  108. Урок 108. 00:00:00
    Part 70. Products management
  109. Урок 109. 00:19:05
    Part 71. Product categories management
  110. Урок 110. 00:06:17
    Part 72. product categories management
  111. Урок 111. 00:09:50
    Part 73. Product categories management
  112. Урок 112. 00:14:24
    Part 74. Product categories management
  113. Урок 113. 00:18:38
    Part 75. Product options management
  114. Урок 114. 00:15:44
    Part 76. Product options management
  115. Урок 115. 00:11:34
    Part 77. Product options management
  116. Урок 116. 00:20:55
    Part 78. Product options management
  117. Урок 117. 00:07:28
    Part 79. Product options management
  118. Урок 118. 00:10:05
    Part 80. Products management
  119. Урок 119. 00:09:33
    Part 81. Products management
  120. Урок 120. 00:14:38
    Part 82. Products management
  121. Урок 121. 00:16:22
    Part 83. Reviews management
  122. Урок 122. 00:13:39
    Part 84. Reviews management
  123. Урок 123. 00:10:48
    Part 85. Fixing products problems
  124. Урок 124. 00:13:14
    Part 86. Adding header functionalities
  125. Урок 125. 00:14:08
    Part 87. Product repository new methods
  126. Урок 126. 00:20:53
    Part 88. Category page
  127. Урок 127. 00:13:06
    Part 89. Category page
  128. Урок 128. 00:19:57
    Part 90. Adding methods to php helpers file
  129. Урок 129. 00:13:39
    Part 91. Category page
  130. Урок 130. 00:12:09
    Part 92. Category page
  131. Урок 131. 00:08:25
    Part 93. Category page
  132. Урок 132. 00:13:02
    Part 94. Category page
  133. Урок 133. 00:06:10
    Part 95. Category page
  134. Урок 134. 00:09:46
    Part 96.Category page
  135. Урок 135. 00:11:32
    Part 97. Category page
  136. Урок 136. 00:10:01
    Part 98. Category page
  137. Урок 137. 00:15:20
    Part 99. Product filter new methods
  138. Урок 138. 00:12:18
    Part 100. Showing list of products
  139. Урок 139. 00:10:26
    Part 101. Showing list of products
  140. Урок 140. 00:10:04
    Part 102. Product searching
  141. Урок 141. 00:10:29
    Part 103. Products search page
  142. Урок 142. 00:10:46
    Part 104. Products search page
  143. Урок 143. 00:08:01
    Part 105. Products search page
  144. Урок 144. 00:06:22
    Part 106. Products search page
  145. Урок 145. 00:13:04
    Part 107. Products search page
  146. Урок 146. 00:06:22
    Part 108. Products search page
  147. Урок 147. 00:07:38
    Part 109. Product details
  148. Урок 148. 00:11:12
    Part 110. Product details
  149. Урок 149. 00:12:00
    Part 111. Product details page
  150. Урок 150. 00:00:00
    Part 112. Product details page
  151. Урок 151. 00:08:47
    Part 113. Product details page
  152. Урок 152. 00:14:45
    Part 114. Product details page
  153. Урок 153. 00:11:39
    Part 115. Product details page
  154. Урок 154. 00:08:38
    Part 116. Product details page
  155. Урок 155. 00:12:22
    Part 117. Product details page
  156. Урок 156. 00:16:09
    Part 118. Product details page
  157. Урок 157. 00:13:32
    Part 119. Product reviews
  158. Урок 158. 00:00:00
    Part 120. Product reviews
  159. Урок 159. 00:05:17
    Part 121. Product reviews
  160. Урок 160. 00:09:45
    Part 122. Cart component
  161. Урок 161. 00:00:00
    Part 123. Cart component
  162. Урок 162. 00:00:00
    Part 124. Cart controller
  163. Урок 163. 00:10:36
    Part 125. Cart page
  164. Урок 164. 00:11:03
    Part 126. Cart page
  165. Урок 165. 00:08:14
    Part 127. Cart page
  166. Урок 166. 00:09:33
    Part 128. Cart page
  167. Урок 167. 00:09:25
    Part 129. Coupon management
  168. Урок 168. 00:09:58
    Part 130. Coupon management
  169. Урок 169. 00:08:35
    Part 131. Coupon management
  170. Урок 170. 00:12:40
    Part 132. Coupon management
  171. Урок 171. 00:15:53
    Part 133. Coupon management
  172. Урок 172. 00:12:45
    Part 134. Coupon management
  173. Урок 173. 00:13:47
    Part 135. Coupon management
  174. Урок 174. 00:08:52
    Part 136. Coupon management
  175. Урок 175. 00:08:45
    Part 137. Application settings
  176. Урок 176. 00:10:39
    Part 138. Application settings
  177. Урок 177. 00:10:33
    Part 139. Order model and controller
  178. Урок 178. 00:12:01
    Part 140. Order checkout
  179. Урок 179. 00:13:03
    Part 141. Order checkout page
  180. Урок 180. 00:12:01
    Part 142. Order checkout page
  181. Урок 181. 00:15:27
    Part 143. Order coupon apply
  182. Урок 182. 00:12:28
    Part 144. Orders and user_coupons tables
  183. Урок 183. 00:24:07
    Part 145. Order register
  184. Урок 184. 00:11:37
    Part 146. Order track
  185. Урок 185. 00:18:11
    Part 147. Orders management
  186. Урок 186. 00:06:31
    Part 148. Orders management
  187. Урок 187. 00:22:47
    Part 149. Order details page
  188. Урок 188. 00:16:16
    Part 150. Order items
  189. Урок 189. 00:12:20
    Part 151. My orders
  190. Урок 190. 00:12:26
    Part 152. Order filter
  191. Урок 191. 00:08:31
    Part 153. Review filter
  192. Урок 192. 00:16:19
    Part 154 A. Wish model and component
  193. Урок 193. 00:06:21
    Part 154 B. Wish controller
  194. Урок 194. 00:09:38
    Part 154 C. Wish list page
  195. Урок 195. 00:17:13
    Part 155. Wish list page
  196. Урок 196. 00:09:34
    Part 156. Product quick look
  197. Урок 197. 00:13:11
    Part 157. Adding wish to header
  198. Урок 198. 00:14:08
    Part 158. Recommender system
  199. Урок 199. 00:12:51
    Part 159. Recommender system
  200. Урок 200. 00:12:55
    Part 160. Recommender system
  201. Урок 201. 00:11:45
    Part 161. Recommender system
  202. Урок 202. 00:13:54
    Part 162. JS slider component
  203. Урок 203. 00:11:00
    Part 163. JS slider component
  204. Урок 204. 00:09:43
    Part 164. Recommender system
  205. Урок 205. 00:08:10
    Part 165. Recommender system
  206. Урок 206. 00:09:52
    Part 166. Product reviews
  207. Урок 207. 00:00:00
    Part 167. Home content management
  208. Урок 208. 00:15:09
    Part 168. Home content management
  209. Урок 209. 00:15:38
    Part 169. Home content management
  210. Урок 210. 00:06:16
    Part 170. Home content management
  211. Урок 211. 00:07:29
    Part 171. Home content management
  212. Урок 212. 00:00:00
    Part 172. Home content management
  213. Урок 213. 00:11:27
    Part 173. Product repository new methods
  214. Урок 214. 00:11:23
    Part 174. Home product slider
  215. Урок 215. 00:09:04
    Part 175. Home best sellers
  216. Урок 216. 00:11:56
    Part 176. Home product slider
  217. Урок 217. 00:00:00
    Part 177. Personalized recommendations
  218. Урок 218. 00:05:56
    Part 178. Personalized recommendations
  219. Урок 219. 00:06:09
    Part 179. Reporting
  220. Урок 220. 00:09:39
    Part 180. Reporting
  221. Урок 221. 00:13:36
    Part 181. Reporting
  222. Урок 222. 00:09:11
    Part 182. Reporting
  223. Урок 223. 00:16:07
    Part 183. Reporting
  224. Урок 224. 00:05:11
    Part 184. Reporting
  225. Урок 225. 00:10:53
    Part 185. Reporting
  226. Урок 226. 00:11:14
    Part 186. Promos management
  227. Урок 227. 00:10:00
    Part 187. Promos management
  228. Урок 228. 00:14:33
    Part 188. Promos management
  229. Урок 229. 00:14:34
    Part 189. Pomos management
  230. Урок 230. 00:11:25
    Part 190. Promos management
  231. Урок 231. 00:11:47
    Part 191. Promos
  232. Урок 232. 00:10:48
    Part 192. Promos
  233. Урок 233. 00:11:00
    Part 193. Order payment
  234. Урок 234. 00:09:46
    Part 194. Order payment
  235. Урок 235. 00:03:32
    Part 195. Order payment
  236. Урок 236. 00:04:14
    Part 196. Fixing problems
  237. Урок 237. 00:22:57
    Part 197. Fixing reports problem
  238. Урок 238. 00:02:40
    Part 198. Fixing problems
  239. Урок 239. 00:02:04
    Part 199. Fixing problems
  240. Урок 240. 00:02:52
    Part 200. Fixing problems
  241. Урок 241. 00:04:59
    Part 201. Fixing problems
  242. Урок 242. 00:01:31
    Part 202. Fixing problems
  243. Урок 243. 00:01:12
    Part 203. Fixing problems
  244. Урок 244. 00:02:14
    Part 204. Fixing problems
  245. Урок 245. 00:01:25
    Part 205. Fixing problems