Job Ready SQL

Lesson 14Pulling It All Together: Adding Data to the Vinyl Record Shop Database

In this lesson, you will pull together what you've learned into an application. Specifically, you will return to the record shop database that you saw in past lessons. This time, you will add and manage data in the database for the shop.

Learning Objectives

By the end of this lesson, you will be able to:

• Add data to the vinyl record shop database
• Describe a flat file and a CSV file
• Manually add data to a database using INSERT
• Explain what needs to be done prior to importing data from a CSV file
• Import data into a database from an existing file
• Create a script to load data into a database

Before starting, execute the vinylerecordshop‐schema.sql script, which can be found in the downloaded files for this book, which can be downloaded from wiley.com/go/jobreadysql. This will provide you with the tables that will store the data. These are the tables and fields required for this lesson.

You should run this script even if you built the database earlier in the book. You may run the script again if you want to start this lesson over again for any reason. Note that running the script will overwrite the database named vinylrecordshop.

You will also use data files that can be found with the download files for this book. The data files are included in the zipped folder called vinylrecordshop‐data. Save this file to your computer and extract the .csv files it contains.

IMPORTANT!  This script will ...