🏷️ backlog

Module-Databases πŸ”—  

[PD] Apply to join Launch Module πŸ”— Clone

[PD] Apply to join Launch Module πŸ”—

Coursework content

Launch Module is coming up! You need to make sure you are prepared to apply.

Check the Entry Criteria and:

  1. Make sure you have achieved the criteria
  2. Review the job description on that document
  3. Tailor your CV and cover letter to this job description.
  4. Sign-up using the form.

Estimated time in hours

1

What is the purpose of this assignment?

This assignment asks you to double-check that you are ready to apply to the Launch Module.

How to submit

Your Leaders will talk you through the process and invite you to interview shortly.

  • πŸ‡ Size Small
  • πŸ”‘ Priority Key
  • πŸ“… Databases
  • πŸ“… Week 2
  • πŸ”‘ Priority Key
  • πŸ“… Week 2
  • πŸ“… Databases
  • πŸ‡ Size Small
[PD] Do an interview using AI πŸ”— Clone

[PD] Do an interview using AI πŸ”—

Coursework content

Use an AI to help you prepare for a potential job interview for the position you identified in the previous coursework.

Possible prompts for the AI might be:

  • Given my CV and the following Job Description, play the role of an interviewer in a job interview for this position.
  • Given my CV and this Job Description, what concerns might the employer have about how good an applicant I am?

Estimated time in hours

0.5

What is the purpose of this assignment?

Prepare for a possible job interview. Use AI to help you determine how well your CV matches an employer’s job description. Remember not to post personal information on any AI.

How to submit

Copy and paste the discussion with the AI on a doc and share it here. Make sure it can be commented on by anyone.

  • 🏝️ Priority Stretch
  • πŸ‡ Size Small
  • πŸ“… Databases
  • πŸ“… Week 2
  • πŸ“… Week 2
  • πŸ“… Databases
  • πŸ‡ Size Small
  • 🏝️ Priority Stretch
[PD] Following up after an interview πŸ”— Clone

[PD] Following up after an interview πŸ”—

Coursework content

Suppose you’ve applied for a job with a great CV and cover letter, landed the interview, and now have completed the interview, thinking it went well. At the end of the interview, you asked and were told what the next steps are. Now what?

The situation is now largely out of your control. It is better to turn your energy to more productive activities like building your portfolio, networking or searching and applying for other opportunities.

However, there are a few times when it is beneficial to email the hiring manager:

  • A brief Thank You note
  • A follow-up check if the promised next steps are very overdue,
  • Alerting them of changes to your circumstances (such as another job offer)
  • Asking for feedback in the event you don’t get an offer

Read this Harvard Review Article to see when and how you might follow up in these circumstances.

Estimated time in hours

1

What is the purpose of this assignment?

Understand when and how to follow up after an interview

How to submit

Write a short paragraph for each of the following scenarios:

  • A brief Thank You note
  • A follow-up check if the promised next steps are very overdue,
  • Alerting them of changes to your circumstances (such as another job offer)
  • Asking for feedback in the event you don’t get an offer

Share the doc on this issue, ensuring it is available for comments. Don’t forget to review it so you don’t have any grammar or spelling mistakes.

  • 🏝️ Priority Stretch
  • πŸ‡ Size Small
  • πŸ“… Databases
  • πŸ“… Week 2
  • πŸ“… Week 2
  • πŸ“… Databases
  • πŸ‡ Size Small
  • 🏝️ Priority Stretch
[PD] Positive thinking πŸ”— Clone

[PD] Positive thinking πŸ”—

Coursework content

Think about up to 5 negative thoughts you have/used to have about your skills and experience. Give them a positive spin, and write them down.

Estimated time in hours

0.5

What is the purpose of this assignment?

This assignment will help you to practice thinking in positive terms.

How to submit

Share the link to your coursework on ticket on your board.

  • πŸ• Priority Mandatory
  • πŸ‡ Size Small
  • πŸ“… Databases
  • πŸ“… Week 2
  • πŸ“… Week 2
  • πŸ“… Databases
  • πŸ‡ Size Small
  • πŸ• Priority Mandatory
[PD] Review your Development Plan πŸ”— Clone

[PD] Review your Development Plan πŸ”—

Coursework content

When you read and analyse Job Descriptions, you will inevitably find some core or extra requirements you don’t meet perfectly. These missing requirements are good triggers for you to consider adding to your Development Plan.

  • Are there some technologies employers keep asking about that you want to learn?
  • Are there some skills or experiences that they are looking for that you could plan to develop?
  • Might there be opportunities for future projects or portfolio work to incorporate the learning and use of these technologies or skills?

Review your analysis of the Job Descriptions and make changes to the short or long-term goals in your Development Plan accordingly.

Estimated time in hours

0.5

What is the purpose of this assignment?

See missing requirements as learning opportunities.

How to submit

Share your updated Development Plan with your PD Coach or a trusted colleague and ask for their feedback on your changes.

  • 🏝️ Priority Stretch
  • πŸ‡ Size Small
  • πŸ“… Databases
  • πŸ“… Week 2
  • πŸ“… Week 2
  • πŸ“… Databases
  • πŸ‡ Size Small
  • 🏝️ Priority Stretch
[TECH ED] Big Spender πŸ”— Clone

[TECH ED] Big Spender πŸ”—

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

Maximum time in hours

5

How to get help

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

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.
gitGraph commit id: "start" branch feature/big-spender commit id: "transaction range" commit id: "handle variations" commit id: "expense area" commit id: "list of names" commit id: "etc" checkout main merge feature/big-spender

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

How to review

Swap with a colleague and review each other’s answers.

  • 🎯 Topic Communication
  • 🎯 Topic Requirements
  • 🎯 Topic Structuring Data
  • πŸ• Priority Mandatory
  • πŸ”‘ Priority Key
  • πŸ¦‘ Size Large
  • πŸ“… Databases
  • πŸ“… Week 2
  • πŸ¦‘ Size Large
  • πŸ”‘ Priority Key
  • πŸ“… Week 2
  • πŸ“… Databases
  • πŸ• Priority Mandatory
  • 🎯 Topic Structuring Data
  • 🎯 Topic Requirements
  • 🎯 Topic Communication
[TECH ED] Check the prep πŸ”— Clone

[TECH ED] Check the prep πŸ”—

https://curriculum.codeyourfuture.io/databases/sprints/2/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 2
  • πŸ“… Week 2
  • πŸ“… Databases
  • πŸ‚ Size Medium
  • πŸ• Priority Mandatory
  • :brain: Prep work
[TECH ED] Codewars πŸ”— Clone

[TECH ED] Codewars πŸ”—

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? If you are already at 5kyu, you will soon need to reach 4kyu, so don’t slack off.

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 Small
  • πŸ“… Databases
  • πŸ“… Week 2
  • πŸ“… Week 2
  • πŸ“… Databases
  • πŸ‡ Size Small
  • πŸ• Priority Mandatory
  • 🎯 Topic Programming Fundamentals
  • 🎯 Topic Problem-Solving
[TECH ED] Full Stack Product πŸ”— Clone

[TECH ED] Full Stack Product πŸ”—

https://curriculum.codeyourfuture.io/databases/product/

Why are we doing this?

Here is the fabled Full Stack Assessment. This project will help you prepare for Final Projects. Check out the prep for this project 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 Delivery
  • 🎯 Topic Iteration
  • 🎯 Topic Requirements
  • πŸ• Priority Mandatory
  • πŸ‹ Size X-Large
  • πŸ“… Databases
  • πŸ“… Week 2
  • πŸ“… Week 2
  • πŸ“… Databases
  • πŸ‹ Size X-Large
  • πŸ• Priority Mandatory
  • 🎯 Topic Requirements
  • 🎯 Topic Iteration
  • 🎯 Topic Delivery
[TECH ED] SQL Bolt πŸ”— Clone

[TECH ED] SQL Bolt πŸ”—

https://sqlbolt.com/

Why are we doing this?

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

Maximum time in hours

0

  • 🎯 Topic Programming Fundamentals
  • 🎯 Topic Time Management
  • 🏝️ Priority Stretch
  • πŸ“… Databases
  • πŸ“… Week 2
  • πŸ“… Week 2
  • πŸ“… Databases
  • 🏝️ Priority Stretch
  • 🎯 Topic Time Management
  • 🎯 Topic Programming Fundamentals