SQL/S2 - JD + Questions for employers

[kfklein15]

Class Prep (1 hour)

1. Find 1 job application and understand it: what type of company is it, what type of job, which skills you match directly, and indirectly which ones you don't.
2. Think about questions you would ask
3. Think about what are the needs and pain points of the company and this company (understand:headcount, for example

Class Exercises (1 hour)

1. Discuss what you identified on your JD and give feedback on each other's work.
2. What kind of questions would you ask this employer before the interview or during the interview? What should you not ask?
3. Discuss needs and pain points of employers and how we can use this to start conversations/ask questions?
4. Follow-up after the interview

Coursework (180 minutes)

1. In your group, each of you must find 1 job applications and understand them: what type of company is it, what type of job, which skills you match directly, and indirectly (transferrable skills), which ones you don't. Discuss what you identified and give feedback on each other's work. (1 h)
2. Proctive using chat GPT with this JD you identfiied
3. Pre-FP work"
4. Review your Development Plan

Reference Materials https://syllabus.codeyourfuture.io/db/week-2/lesson#pd-learning-to-sell-yourself

Link to Google Doc

ASK BARNEY FOR GUIDANCE

[LaraHuzjan]

Esther requested this topic :) can't seem to assign her for some reason

[LaraHuzjan]

@Barny-6 job description content

[LaraHuzjan]

@Barny-6 this topic is very much focused on Employability, could you give us some pointers so that it's more clear what kind of content is expected.

[Barny-6]

For the Job Description content, we need something that talks about:

• Where to find job descriptions and the various strengths of each
• How to identify if the job description is a suitable level for you
• How to identify if the job description is a suitable technical fit for you
• How to evaluate the strengths and weaknesses of a job description

This involves knowing:

• What is expected of different job titles (i.e. FE Vs FS Vs PM etc.)
• How to identify the core requirements vs extra requirements on a JD
• How to spot red Flags

I feel confident that I know a lot of this but I don't have any resources per see. I will look for some and am happy to review any that are found.

[Barny-6]

Some classic points that come up when I run the session:

• Women tend to apply only when they hit a significantly higher proportion of skills listed in a JD than men. From experience I believe this same phenomenon applies throughout our community.
• Many don't seem to understand quite how much they will be expected to learn on the job and believe that they need to know everything before applying
• Many don't seem to understand the role of a junior and how they fit into the wider team

[kfklein15]

Have reviewed and looks good. Will load now.

[kfklein15]

Prep PR Day PR Coursework

• https://github.com/CodeYourFuture/Module-Databases/issues/146
• https://github.com/CodeYourFuture/Module-Databases/issues/147
• https://github.com/CodeYourFuture/Module-Databases/issues/148
• https://github.com/CodeYourFuture/Module-Databases/issues/149

[LaraHuzjan]

CW #146 has been archived due to the timing being overrun. It can still be used elsewhere.

[kfklein15]

@LaraHuzjan , did you try to approve the PRs yourself?

[LaraHuzjan]

New Prep PR