From the course: Advanced MySQL Database Administration
Unlock this course with a free trial
Join today to access over 24,900 courses taught by industry experts.
Challenge: Import remaining 2012 data - MySQL Tutorial
From the course: Advanced MySQL Database Administration
Challenge: Import remaining 2012 data
- [Instructor] All right, you're ready for another assignment. This time, you're going to be importing the remaining data for the 2012 calendar year. Sally's come to you with two data sets, one representing the order_items from May through December, another representing the order_item_refunds from May through December. You've already created these tables. You're familiar with uploading the data. This assignment should just reinforce those concepts, which we'll be using, again, throughout the course. I'd recommend you go ahead and start with the order_items data, get that imported, take a look and see if everything looks good to you. Then, import the order_item_refunds data. Give this a shot on your own, then come back and watch the solution video. Good luck.
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
(Locked)
Overview of create, insert, and delete1m 48s
-
(Locked)
Review: Creating a schema3m 24s
-
(Locked)
Review: Creating a table7m 7s
-
Review: Inserting records into a table10m 19s
-
(Locked)
Review: Deleting records10m 40s
-
(Locked)
Importing data from a file10m 21s
-
(Locked)
Challenge: Importing order item data1m 11s
-
(Locked)
Solution: Importing order item data10m 56s
-
(Locked)
Challenge: Importing refund data1m 32s
-
(Locked)
Solution: Importing refund data5m 1s
-
(Locked)
Challenge: Deleting records1m 36s
-
(Locked)
Solution: Deleting records4m 40s
-
(Locked)
Challenge: Import remaining 2012 data45s
-
(Locked)
Solution: Import remaining 2012 data5m 37s
-
(Locked)
Bonus: Load data4m 44s
-
(Locked)
-
-
-
-
-
-
-
-
-
-