From the course: Advanced MySQL Database Administration
Unlock this course with a free trial
Join today to access over 25,300 courses taught by industry experts.
Challenge: Import 2013 Q1 data - MySQL Tutorial
From the course: Advanced MySQL Database Administration
Challenge: Import 2013 Q1 data
- [Instructor] All right, you're ready for your next assignment, which is going to be importing 2013 Q1 data. Sally's coming to you with two files representing the order items and the order item refunds for the first three months of 2013, and she wants you to get those loaded into the database. This one shouldn't be too challenging for you. You've done this a few times before. It should just reinforce the concept. Take a look at the record counts here, which will help you figure out if you've done it correctly. Give this a shot on your own. Then come back and you can watch the solution video and I'll walk you through. 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 alter, update, and key relationships1m 29s
-
(Locked)
Review: Altering tables5m 24s
-
Review: Updating records7m 55s
-
(Locked)
Review: Table relationships and cardinality4m 55s
-
(Locked)
Challenge: Introducing a new product1m 8s
-
(Locked)
Solution: Introducing a new product4m 18s
-
(Locked)
Challenge: Adding a product to order items55s
-
(Locked)
Solution: Adding a product to order items1m 45s
-
(Locked)
Challenge: Updating product data in order items1m 19s
-
(Locked)
Solution: Updating product data in order items2m 20s
-
(Locked)
Challenge: Primary key to foreign key mapping1m 17s
-
(Locked)
Solution: Primary key to foreign key mapping4m 17s
-
(Locked)
Challenge: Import 2013 Q1 data37s
-
(Locked)
Solution: Import 2013 Q1 data3m 28s
-
(Locked)
-
-
-
-
-
-
-
-
-