🏷️ backlog

Module-Databases πŸ”—

[PD] Prepare answers to interview questions using STAR - part 2 πŸ”— Clone

Coursework content

Use the provided spreadsheet to come up with answers to all these commonly asked interview questions in line with the STAR framework. The examples can be taken from previous work, study, or volunteering experience.

Estimated time in hours

2

What is the purpose of this assignment?

This assignment will improve your competency-based interview skills.

How to submit

Share the link to your copy of the spreadsheet on the ticket on your board.

  • 🏝️ Priority Stretch
  • πŸ‚ Size Medium
  • πŸ‡ Size Small
  • πŸ“… Databases
  • πŸ“… Week 1
[PD] Definition of Done πŸ”— Clone

Coursework content

The criteria in a Definition of “Done” will vary depending on the backlog item a development team delivers. Search the web for examples of Definitions of “Done” relevant to the kind of software development you would like to do.

Write three phrases to include in a Definition of “Done” for each of these backlog items:

  • Software development user story
  • Website change without coding, eg content on a page
  • An A/B experiment to test a hypothesis for improving a feature
  • Project report and proposal presentation to report on recent progress and request further funding
  • Technical analysis of a problematic scenario before deciding how to solve it

Estimated time in hours

1

What is the purpose of this assignment?

  • Write a definition of done for several kinds of backlog items.
  • Make sure your text is grammatically correct. You should not have more than 3 mistakes.

How to submit

  • Create a Google Doc. Share for public visibility and comment.
  • Paste the link into this GitHub issue.

Anything else?

  • πŸ• Priority Mandatory
  • πŸ‡ Size Small
  • πŸ“… Databases
  • πŸ“… Week 1
[TECH ED] Play the Bandit πŸ”— Clone

https://overthewire.org/wargames/bandit/

Why are we doing this?

Basic Linux skills are essential for roles in Cloud, DevOps, Cyber, and SRE. Junior Cloud and DevOps roles are growing in the industry. It’s a good idea to practice Linux skills to make yourself more employable and feel more comfortable operating computers.

Your goal is to get to Level 20 by the end of the Databases module. You can do this by completing one level a week from JS2 onwards. You can do one level a week!

You should be at level 16 or higher this week.

Maximum time in hours

.5

How to get help

Work through the puzzles together in #cyf-over-the-wire

Don’t share solutions in this channel, or you steal from others the opportunity of learning.

How to submit

There is no submission step. However, to apply for some roles and some courses (like CYF+ ) you must demonstrate these skills, so it would be a good idea to learn them.

Anything else?

Here’s an AI prompt you can use to get the best, most helpful learning experience:

Please act as a friendly, warm, straightforward technical mentor. You are an experienced Site Reliability Engineer who uses the terminal regularly and understands all shell commands in bash. You can explain clearly, using English mostly at CEFR B2 level, how to execute shell commands and how to navigate Linux file systems. We will be playing The Bandit, Over the Wire, shell game together. I don’t want you to give me all the answers. I want you to walk me towards the answer, helping me to find out and learn Linux commands, explaining clearly what is happening as we go. Please answer my questions carefully and do not offer code solutions, just explain in English the approach I should take and then review the commands I suggest to you. Say okee dokee if you understand.

And remember: every time an LLM offers code you don’t recognise, you must ask “Is this valid?” and “is this safe?” before you continue. AI is confidently wrong, a lot.

  • 🎯 Topic Problem-Solving
  • 🎯 Topic Programming Fundamentals
  • πŸ• Priority Mandatory
  • πŸ¦” Size Tiny
  • πŸ“… Databases
  • πŸ“… Week 1
πŸ§‘πŸΎβ€βš–οΈ Check module success criteria πŸ”— Clone

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

Why are we doing this?

πŸ”‘ The most important thing is that you are secure in your understanding.

At the end of the course, we will expect you to build novel applications using your understanding. If you cannot build things, we cannot put you forward for jobs. It is in your personal interest to make sure you have properly understood this module.

To progress to the next module you need to meet the success criteria for this module. How will you as a cohort meet the module success criteria? Discuss it in your class channel and make a plan together.

πŸ§‘πŸΏβ€πŸŽ€ good strategies

  • asking volunteers to review your code
  • helping each other with coursework blockers
  • arranging midweek study sessions
  • using Saturday time to review code and cohort tracker

πŸ™…πŸΏ bad strategies

  • opening empty PRs
  • copying and pasting
  • breaking the Trainee Agreement
  • mistaking the measure for the target

Maximum time in hours

.5

How to get help

Discuss with your cohort. Support each other.

How to submit

In week 4 of your module you will need a representative to report to the organisation. Here’s your template, fill in your details and delete as appropriate:

πŸ“ˆ Cohort Progress Report from @cohort-name to @programme-team

  • criterion
  • criterion
  • criterion
  • criterion

βœ… We are progressing to the next module.
β›” We are taking a consolidation week to meet our targets.

  • 🎯 Topic Code Review
  • 🎯 Topic Communication
  • 🎯 Topic Delivery
  • 🎯 Topic Requirements
  • 🎯 Topic Teamwork
  • 🎯 Topic Testing
  • 🎯 Topic Time Management
  • πŸ• Priority Mandatory
  • πŸ¦” Size Tiny
  • πŸ“… Databases
  • πŸ“… Week 4
  • πŸ“… Week 1
[PD] Prepare answers to interview questions using STAR πŸ”— Clone

Coursework content

Use the provided spreadsheet to come up with answers to at least SIX commonly asked interview questions in line with the STAR framework. The examples can be taken from previous work, study, or volunteering experience.

There is an additional, stretch coursework to answer all questions.

Estimated time in hours

1.5

What is the purpose of this assignment?

This assignment will improve your competency-based interview skills.

How to submit

Share the link to your copy of the spreadsheet on the ticket on your board.

  • πŸ‚ Size Medium
  • πŸ”‘ Priority Key
  • πŸ“… Databases
  • πŸ“… Week 1
[TECH ED] Check the prep πŸ”— Clone

https://curriculum.codeyourfuture.io/databases/sprints/1/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. The prep work here will introduce you to the new concepts for the week.

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 1
[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.

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
  • 🎯 Topic Testing
  • πŸ• Priority Mandatory
  • πŸ‚ Size Medium
  • πŸ‡ Size Small
  • πŸ“… Databases
  • πŸ“… Week 1
[TECH ED] PG Exercises πŸ”— Clone

https://pgexercises.com/questions/basic/

Why are we doing this?

Complete the first six of these ‘Simple’ SQL Queries.

https://pgexercises.com/questions/basic/

If you have time you can look at some of the others, but they may require extra research to complete.

Maximum time in hours

3

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

No submission step

  • 🎯 Topic Programming Fundamentals
  • 🎯 Topic Structuring Data
  • 🏝️ Priority Stretch
  • πŸ‚ Size Medium
  • πŸ“… Databases
  • πŸ“… Week 1
[TECH ED] Full Stack Product πŸ”— Clone

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 all the required issues for week 1

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.

How to setup

Go to Database product prep with info on how to get setup for this project.

Anything else?

Final Projects Entry and Exit Criteria

  • 🎯 Topic Functional Programming
  • 🎯 Topic Iteration
  • 🎯 Topic Requirements
  • 🎯 Topic Structuring Data
  • 🎯 Topic Testing
  • πŸ• Priority Mandatory
  • πŸ”‘ Priority Key
  • πŸ¦‘ Size Large
  • πŸ“… Databases
  • πŸ“… Week 1