🏷️ backlog

Module-Databases πŸ”—

[TECH ED] Coursework feedback πŸ”— Clone

https://github.com/CodeYourFuture/Module-Databases/issues/

Why are we doing this?

The CYF curriculum is an open source project. Like all software, it is continually revised and improved in iterations.

Help improve the curriculum by giving quick emoji feedback on any assignment.

Feedback on this assignment by pressing the emoji reaction button on the top comment.

Emoji Key

πŸ‘ = Useful πŸ‘Ž = Not useful

πŸš€ = Way too much time given πŸ˜• = Not enough time given

You are invited to give feedback on any assignment in this way. Do this on the CYF issue, not your copy, so CYF can track it using the GitHub reactions API.

Maximum time in hours

.05

How to submit

Click the emoji button on the first post on any coursework assignment.

  • 🎯 Topic Iteration
  • 🎯 Topic Teamwork
  • 🏝️ Priority Stretch
  • πŸ¦” Size Tiny
  • πŸ“… Databases
  • πŸ“… Week 3
[PD] Practice job interviews πŸ”— Clone

Coursework content

  • Practice your interview with someone in the community using the JD you found in the previous exercise.
  • Record yourself using a computer camera if you are meeting online or a phone camera if you are meeting in person.
  • Watch the video and self-evaluate. Your community partner should give you feedback as well.
  • Write a 200-word reflection based on the feedback and explain how you will apply that in the following interviews.

Estimated time in hours

3

What is the purpose of this assignment?

  • To practice job interviews.

How to submit

  • Upload the reflection as a link on this ticket for review. If you have written it in a Google doc, make sure it is open for comments.

Anything else?

  • 🏝️ Priority Stretch
  • πŸ‚ Size Medium
  • πŸ“… Databases
  • πŸ“… Week 3
[PD] Professional statement on LinkedIn πŸ”— Clone

Coursework content

Prepare a professional statement for your Linkedin profile (“About” section).

Estimated time in hours

1

What is the purpose of this assignment?

This assignment will help you to refine your professional statement on Linkedin.

How to submit

Share your professional statement with the group in Slack and help each other out to create the best, most impactful, honest, and exciting statement. Share the screenshot of your post on your coursework ticket.

  • πŸ‡ Size Small
  • πŸ”‘ Priority Key
  • πŸ“… Databases
  • πŸ“… Week 3
[TECH ED] Check the prep πŸ”— Clone

https://curriculum.codeyourfuture.io/databases/sprints/3/prep/

Why are we doing this?

Are you prepared for the Saturday class? It is essential to start learning new concepts and ideas before Saturday’s session. During the week, we expect you to get stuck and form questions about the new content so you can address misconceptions during Saturday’s session. Double check you’ve done the prep work before continuing with other backlog issues.

Maximum time in hours

3

How to get help

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

  • :brain: Prep work
  • πŸ• Priority Mandatory
  • πŸ‚ Size Medium
  • πŸ“… Databases
  • πŸ“… Week 3
[TECH ED] E-Commerce πŸ”— Clone

https://github.com/CodeYourFuture/Module-Databases/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.

Maximum time in hours

6

How to get help

Bring these to class and work on them in study time together.

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.
gitGraph commit id: "e-commerce" branch e-commerce commit id: "List all socks" commit id: "List products cost >100" commit id: "5 most expensive products"

How to review

Bring your schemas to class and we’ll talk about them.

  • 🎯 Topic Communication
  • 🎯 Topic Structuring Data
  • πŸ• Priority Mandatory
  • πŸ¦‘ Size Large
  • πŸ“… Databases
  • πŸ“… Week 3
[TECH ED] Codewars πŸ”— Clone

https://www.codewars.com/users/CodeYourFuture/authored_collections

Why are we doing this?

Every week you need to complete at least three kata. Spend at least 20 minutes, three times a week, on your kata workout. To apply for the Launch you need a 5kyu. How will you achieve this?

You may be asked to pair programme at any time and re-do your logged solutions on your Codewars account, so make sure you understand your solutions and can explain them.

Maximum time in hours

1

How to get help

Collaborate with your peers in the #cyf-codewars channel.

How to submit

Your Codewars progress is tracked automatically.

  • 🎯 Topic Problem-Solving
  • 🎯 Topic Programming Fundamentals
  • πŸ• Priority Mandatory
  • πŸ‚ Size Medium
  • πŸ‡ Size Small
  • πŸ“… Databases
  • πŸ“… Week 3
[TECH ED] Full Stack Product πŸ”— Clone

https://github.com/CodeYourFuture/Full-Stack-Project-Assessment

Why are we doing this?

Here is the fabled Full Stack Assessment. This project will help you prepare for Final Projects. Check out the readme and then look at the project views below to see the issues your team will need to work on.

Check out the user stories for this project Check out the all the required issues for week 3

Maximum time in hours

6

How to get help

Share your blockers in your class channel. Use the opportunity to refine your skill in Asking Questions like a developer.

Anything else?

Final Projects Entry and Exit Criteria

  • 🎯 Topic Code Review
  • 🎯 Topic Delivery
  • 🎯 Topic Iteration
  • πŸ• Priority Mandatory
  • πŸ‹ Size X-Large
  • πŸ”‘ Priority Key
  • πŸ“… Databases
  • πŸ“… Week 3