Link to the coursework

https://github.com/CodeYourFuture/Module-SQL/tree/main/Big-Spender

Why are we doing this?

Often at work, people are going to ask you things. It’s a good skill to be able to take natural/human language questions and express them as database queries.

How to get help

Share your blockers in your class channel https://programming.codeyourfuture.io/guides/getting-help/asking-questions/

How to submit

1. Fork to your Github account.
2. Make a branch for this project.
3. Make regular small commits in this branch with clear messages.
4. When you are ready, open a PR to the CYF repo, following the instructions in the PR template.

There are several projects in this repo. Make a new branch based on main for each project.

Link to the coursework

https://github.com/CodeYourFuture/Module-SQL/tree/main/E-Commerce

Why are we doing this?

This project is about really understanding your database by representing it in a diagram. How do the tables relate to each other? How do references work? What is the primary key? What is a foreign key? Drawing a simple schema will clear this all up.

Remember, simple is better. Use a pencil and paper.

You should both draw the schema and write the queries.

Maximum time in hours

6

How to submit

1. Fork to your Github account.
2. Make a branch named after the project.
3. Make regular small commits with clear messages.
4. When you are ready, open a PR to the CYF repo, following the instructions in the PR template.
5. Make sure to include your schema visualisation (either as a digital format, or as a photograph), as well as the queries.

https://sqlbolt.com/

You can try out SQL right in your browser with this interactive tutorial. This means you can do it away from your development environment.

Complete all of the remaining lessons.