• Home
  • Blog
  • The Community College of Baltimore County Design a Store Database MySQL Task

The Community College of Baltimore County Design a Store Database MySQL Task

0 comments

Complete the SQL Basics Tutorial through “Project: Design a store database“.

Why?

This will give you a good introduction to the SQL language and walk you through the basics to help build a foundation.

Procedure
  1. Click here to access the SQL Basics Tutorial
  2. Complete all the sections, they include:
    1. Welcome to SQL
    2. Creating a table and inserting data
    3. Challenge: Book list database
    4. Querying the table
    5. Challenge: Box office hits database
    6. Aggregating data
    7. Challenge: TODO list database stats
    8. S-Q-L or SEQUEL?
    9. Project: Design a store database
  3. Once you finish the “Design a Store Database” take several screenshots of your work and compile into one document (docx, pdf). Attach it to this assignment. (20 points)

Here’s a screenshot of my work as an example – note: the solution isn’t 100% correct on purpose. I’m nice but I’m not that nice. 🙂

About the Author

Follow me


{"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}