This project forked from codeyourfuture/module-databases
The central repo for the DB module
All the coursework is listed as issues on this repo. You will copy these issues to your Coursework Planner, which is one repo that will hold all your coursework and assignments for the entire course.
If you do not already have your own Coursework Planner, set one up now:
From Module-Databases created by SallyMcGrath: CodeYourFuture#4
https://www.codewars.com/users/CodeYourFuture/authored_collections
Every week you need to complete at least three kata. Spend at least 20 minutes, three times a week, on your kata workout.
1
Collaborate with your peers in the #cyf-codewars channel.
Your Codewars progress is tracked automatically.
From Module-Databases created by kfklein15: CodeYourFuture#148
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.
Review your analysis of the Job Descriptions and make changes to the short or long-term goals in your Development Plan accordingly.
0.5
See missing requirements as learning opportunities.
Share your updated Development Plan with your PD Coach or a trusted colleague and ask for their feedback on your changes.
From Module-Databases created by SallyMcGrath: CodeYourFuture#8
https://www.codewars.com/users/CodeYourFuture/authored_collections
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.
1
Collaborate with your peers in the #cyf-codewars channel.
Your Codewars progress is tracked automatically.
From Module-Databases created by esma-g: CodeYourFuture#25
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.
0.5
This assignment will help you to practice thinking in positive terms.
Share the link to your coursework on ticket on your board.
From Module-Databases created by SallyMcGrath: CodeYourFuture#10
https://github.com/CodeYourFuture/Module-Databases/tree/main/E-Commerce
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.
6
Bring these to class and work on them in study time together.
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"
Bring your schemas to class and we'll talk about them.
From Module-Databases created by SallyMcGrath: CodeYourFuture#142
https://overthewire.org/wargames/bandit/
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.
.5
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.
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.
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.
From Module-Databases created by SallyMcGrath: CodeYourFuture#1
https://curriculum.codeyourfuture.io/databases/product/
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
6
Share your blockers in your class channel. Use the opportunity to refine your skill in Asking Questions like a developer.
Go to Database product prep with info on how to get setup for this project.
From Module-Databases created by kfklein15: CodeYourFuture#147
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:
0.5
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.
Copy and paste the discussion with the AI on a doc and share it here.
Make sure it can be commented on by anyone.
From Module-Databases created by SallyMcGrath: CodeYourFuture#141
https://curriculum.codeyourfuture.io/databases/success/
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.
.5
Discuss with your cohort. Support each other.
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:
✅ We are progressing to the next module.
⛔ We are taking a consolidation week to meet our targets.
From Module-Databases created by esma-g: CodeYourFuture#27
Launch Module is coming up! You need to make sure you are prepared to apply.
Check the Entry Criteria and:
1
This assignment asks you to double-check that you are ready to apply to the Launch Module.
Your Leaders will talk you through the process and invite you to interview shortly.
From Module-Databases created by SallyMcGrath: CodeYourFuture#9
https://www.codewars.com/users/CodeYourFuture/authored_collections
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.
1
Collaborate with your peers in the #cyf-codewars channel.
Your Codewars progress is tracked automatically.
From Module-Databases created by LaraHuzjan: CodeYourFuture#143
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:
1
From Module-Databases created by SallyMcGrath: CodeYourFuture#13
https://curriculum.codeyourfuture.io/databases/sprints/2/prep/
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.
3
Share your blockers in your class channel
https://curriculum.codeyourfuture.io/guides/asking-questions/
From Module-Databases created by kfklein15: CodeYourFuture#149
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:
Read this Harvard Review Article to see when and how you might follow up in these circumstances.
1
Understand when and how to follow up after an interview
Write a short paragraph for each of the following scenarios:
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.
From Module-Databases created by esma-g: CodeYourFuture#26
Prepare a professional statement for your Linkedin profile ("About" section).
1
This assignment will help you to refine your professional statement on Linkedin.
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.
From Module-Databases created by SallyMcGrath: CodeYourFuture#23
You can try out SQL right in your browser with this interactive tutorial. This means you can do it away from your development environment.
0
From Module-Databases created by SallyMcGrath: CodeYourFuture#150
https://github.com/CodeYourFuture/Module-Databases/issues/
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.
👍 = 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.
.05
Click the emoji button on the first post on any coursework assignment.
From Module-Databases created by SallyMcGrath: CodeYourFuture#2
https://pgexercises.com/questions/basic/
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.
3
Share your blockers in your class channel. Use the opportunity to refine your skill in Asking Questions like a developer.
No submission step
From Module-Databases created by SallyMcGrath: CodeYourFuture#14
https://curriculum.codeyourfuture.io/databases/sprints/1/prep/
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.
3
Share your blockers in your class channel
https://curriculum.codeyourfuture.io/guides/asking-questions/
From Module-Databases created by SallyMcGrath: CodeYourFuture#3
https://github.com/CodeYourFuture/Module-Databases/tree/main/Big-Spender
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.
5
Share your blockers in your class channel. Use the opportunity to refine your skill in Asking Questions like a developer.
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.
Swap with a colleague and review each other's answers.
From Module-Databases created by SallyMcGrath: CodeYourFuture#12
https://curriculum.codeyourfuture.io/databases/sprints/3/prep/
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.
3
Share your blockers in your class channel
https://curriculum.codeyourfuture.io/guides/asking-questions/
From Module-Databases created by SallyMcGrath: CodeYourFuture#5
https://github.com/CodeYourFuture/Full-Stack-Project-Assessment
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
6
Share your blockers in your class channel. Use the opportunity to refine your skill in Asking Questions like a developer.
From Module-Databases created by wainwmr: CodeYourFuture#151
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.
2
This assignment will improve your competency-based interview skills.
Share the link to your copy of the spreadsheet on the ticket on your board.
From Module-Databases created by LaraHuzjan: CodeYourFuture#144
3
From Module-Databases created by esma-g: CodeYourFuture#24
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.
1.5
This assignment will improve your competency-based interview skills.
Share the link to your copy of the spreadsheet on the ticket on your board.
From Module-Databases created by SallyMcGrath: CodeYourFuture#6
https://curriculum.codeyourfuture.io/databases/product/
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.
6
Share your blockers in your class channel. Use the opportunity to refine your skill in Asking Questions like a developer.
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
Django
The Web framework for perfectionists with deadlines.
Laravel
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
Microsoft
Open source projects and samples from Microsoft.
Google
Google ❤️ Open Source for everyone.
Alibaba
Alibaba Open Source for everyone
D3
Data-Driven Documents codes.
Tencent
China tencent open source team.