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