From the course: Advanced MySQL Database Administration
Join today to access over 24,900 courses taught by industry experts.
Solution: Final project - MySQL Tutorial
From the course: Advanced MySQL Database Administration
Solution: Final project
Play video to see the transcript
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.
Download the exercise files for this course.
Get started with a free trial today.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.
Watch this course anytime, anywhere.
Get started with a free trial today.
Contents
-
-
(Locked)
MySQL installation overview1m 45s
-
(Locked)
Mac download: Community Server4m 53s
-
(Locked)
Mac download: MySQL Workbench2m 50s
-
PC Download: Community Server plus Workbench7m 39s
-
(Locked)
Connecting Workbench to the server2m 11s
-
(Locked)
MySQL Workbench interface10m 42s
-
(Locked)
Preparing Workbench4m 41s
-
(Locked)
-
-
(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)
-
-
(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)
-
-
(Locked)
Review: Triggers basics8m 37s
-
(Locked)
Triggers deep dive34m 17s
-
(Locked)
Challenge: Creating and updating orders2m 7s
-
(Locked)
Solution: Creating and updating orders6m 35s
-
(Locked)
Challenge: Triggers2m 19s
-
(Locked)
Solution: Triggers5m 10s
-
(Locked)
Challenge: Testing your trigger system2m 9s
-
(Locked)
Solution: Testing your trigger system4m 4s
-
(Locked)