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