# Most recents (24)

#Day5 for Reporting "Crack SQL interview in 50Qs" is hear. Let's rumble

Find the links to the questions here
1. leetcode.com/problems/the-n…
2. leetcode.com/problems/prima…

#SQL #DATAANALYSIS #Interviews #lowcode
Let's break them down:
1. Intuition
The query aims to retrieve information about managers in the Employees table, including their IDs, names, the number of employees reporting to them, and the average age of their reports.
The solution involves using a self join. Since we were told that a manager is also an employee, we will join the table to itself, where the employee_id field is equal reports_to field. On this premise, we aggregate the number of employees who report directly to the manager,
Let's break down each question
1. Logic: Show the classes, where the number of student is more than 5. The word "At least" tells us something, we have to include 5 as part of our filtering condition, hence >=5
2. This looks pretty straight forward. For each user, we want to....
..return the number followers, hence the need to use the Group BY clause. This clause allows us to aggregate data against the unique categorical/qualitative values in a field.
3. The given SQL query finds the maximum value (num) from the "mynumbers" table that appears only once.
Let's break down each code
1. The ending part to the question is where the major conditional logic lies. We were told to return the needed columns, and price for the first year of every product sold. Since we do not have distinct column showing min years for each product,
We have to create that with a subquery in the Where clause. We are concerned about the first year of every product sold, so we aggregate the min years for each product. After doing that, we tell SQL to return the prices of products, the year, and qty when the product was first..
A friend rang me after applying for 40+ jobs in 2 months with 0 contacts and 0 interviews

I got him 4 recruiter contacts, 3 interviews and 1 officer in 2 weeks

Here's what we tweaked:

He initially told me he was job hunting and would prefer to apply online

After reading his profile, I tried to discourage him, but he insisted on online applications.

I agreed but on a condition
I told him:

"If you don't get a job in 60 days, we will do it my way"

He agreed.

Deal.
I recently helped 3 professionals prepare for job interviews.

They landed their dream jobs at:
- JP Morgan, UK
- Australian Government Health Department
- International Research Institute, UK

They couldn't thank me enough.

Here's how I prepared them:

[steal my template]
1. There are 3 key stages in a job interview - entry, process and exit.

The entry and exit are the most important.
#1. The Entry

You need to put your best foot forward for the entry by ACING your first question.

It's crucial
Mar 1:
1/ #RussianVolunteerCorps actions in #Bryansk

“We are #Russians, and we are not #Russians”: what is known about the “#RussianVolunteerCorps

@CrimeanWind, of #Telegram, background report on #Russian ..continued

2/
#UkraineRussiaWar #Partisans
t.me/Crimeanwind/24…
Mar 1:
3/ #RussianVolunteerCorps in #Bryansk

..representatives adhere to right-wing views & #Claim to have traveled the entire #FrontLine.

🔸Details.
#Russian #Volunteer #Corps founder, #DenisKapustin (#Nikitin)..continued

4/
#UkraineRussiaWar #Ukraine
t.me/Crimeanwind/24…
I've been on both sides of an Interview table and have experience over 50+ interviews.

#100DaysOfCode #Interviews

You will be intentionally given a vague question with vague inputs.

You are expected to ask clarifying question and have clear understanding of requirements before jumping into solution.

Don't assume anything !!
2. Improve Solution Overtime

You're not expected to come up with optimised solution in one go. First come up with brute force and then eventually try to optimize it.

Interviewers usually give some hint about optimised solution. Don't expect it for obvious ones.
Delighted to hold my book, now out with @CUP_PoliSci! Making Bureaucracy Work examines how public agencies deliver primary #education in India.

What is my argument? How might it advance our thinking on #bureaucracy, #implementation & the politics of inclusive #development? 🧵1/
My book investigates variation in the delivery of primary schooling across rural India. Comparative scholarship has shed light on differences in social policies and public spending. I focus on policy implementation, a critical but understudied arena of education politics. 2/
Why implementation? Most countries have laws for universal primary schooling (#SDGs Goal 4). E.g. India has expanded education programs and spending. But implementation is a huge challenge. Meeting this challenge is critical for millions of households who rely on govt schools. 3/
Hola dev,

Si estás preparándote para entrevistas técnicas dónde hay una etapa de código o “whiteboard” te recomiendo que uses el plan de estudios LeetCode75 (@LeetCode), aquí te explico en que consiste. #algorithms #Interviews

👇🏻
En LeetCode75 vas a encontrar una lista completa y simplificada de contenido seleccionado para mejorar tus habilidades técnicas 🤓💪🏻

Tiene 2 niveles de las 75 mejores preguntas para que te prepares y no pierdas tiempo en generar tu propio plan de estudios, fue creada >>
considerando la experiencia de otros Ing. de Software y sus procesos.

El objetivo es que pongas tus esfuerzos 🧠📝 únicamente en tu preparación y no distraerte al crear tu lista entre tantos algoritmos de la plataforma y así desde el primer día puedes empezar a estudiar. >>
[1/14] Недавно посвятил много времени подготовке к собесам в западные компании. За это время перелопатил большое количество самых разных материалов. В этом треде хочу поделиться наиболее классными ресурсами, которые точно вам помогут. Погнали =>
#interviews #mobile #Backend
[2/14] Общее техническое. Если вы чувствуете просадку с network, не до конца знаете/понимаете TCP/IP и тд, то очень рекомендую вот этот курс - .
[3/14] Плаваете в теме сертификатов, не понимаете, а как же именно HTTPS обеспечивает защиту и тд, то вам сюда - cryptobook.nakov.com.
I did 20+ intern/trainee interviews yesterday and this is what I learnt.

1. Attitude and communication skills have drastically improved over the years.
2. Candidates are asking right Qs about companies and are critical about opportunities to try multiple tech stacks. 1/5
3. Still not enough focus on basics. Struggles when simple OOP questions come in forms of use cases.
4. Are willing to learn. Yes to this always!
5. Not a single candidate queried about wages. 2/5
6. Expectations of USD pegged salary benefits haven't yet penetrated this batch of freshers.
7. Need more girls in tech! 3/5
Daily Bookmarks to GAVNet 12/12/2021 greeneracresvaluenetwork.wordpress.com/2021/12/12/dai…
Fans Pour Funding—and Faith—Into a Hit Drama About Jesus

wsj.com/articles/fans-…

#entertainment, #movies, #TheChosen, #ChristianThemes
Reductionism vs. emergence: Are you “nothing but” your atoms?

bigthink.com/thinking/reduc…

#emergence, #reductionism, #science, #philosophy
En complément du superbe #Thread de @_Cryptique, voici le mien avec de nombreux comptes francophone #crypto à suivre.

J'ai réalisé ça sur le thème un peu #humoristique mais ces comptes restent néanmoins des personnes sérieuses.

J'espère que vous trouverez le format sympa !
@Arke56374430

Peintre #digital et sculpteur de l'ère du numérique personne ne sait s’il est réellement humain ou si c’est une IA avancée.

Un #artiste accompli autour de nombreux #NFTs, il partage également son expertise autour de l’art numérique de demain.
@AucoinDubloc

A commencer le défi #From0To10K pour finalement s’orienter vers l’éducation ainsi que la démocratisation de la #crypto et du #Bitcoin

Du simple terme crypto à la présentation de nouveaux projets, c’est une véritable mine d’information dans un but éducatif
Daily Bookmarks to GAVNet 11/23/2021 greeneracresvaluenetwork.wordpress.com/2021/11/23/dai…
Scientists may have found the longest dinosaur in the world. It's called the Supersaurus

usatoday.com/story/news/nat…

#archaeology #dinosaurs #supersaurus #discovery
The Complex Alternative: Complexity Scientists on the COVID-19 Pandemic

sfipress.org/books/the-comp…

#BookReview #COVID19 #ComplexityScience #interviews
Networking tips that built my self-efficacy (thanks @midhatf3) a self-reflection and follow-along 🧵

apparently, MORE than 80% of jobs are found by networking?!! And networking is more than just starting a connection - it is also about maintaining it. I'll just leave some silence to absorb this statistic (looking at you #phdchat) and next up is identifying who's who
Networks and people are continuums... but identifying one or more roles a person in your network serves can *srsly* help you make a bettr elevator pitch.

Let's brainstorm & try to categorize our networks. Lets identify the category that needs more ppl. Lets build ntwrks robustly
Daily Bookmarks to GAVNet 12/25/2020 greeneracresvaluenetwork.wordpress.com/2020/12/25/dai…
The New Business of AI (and How It’s Different From Traditional Software)

a16z.com/2020/02/16/the…

Google tightens grip on research reports with 'sensitive topics' review system: Report

#PeerReview #ResearchReports #google #truth #transparency #trust
A 🧵on #hiring especially for early stage #founders

Sell 👁️👁️
Sell the vision you have, if you can't sell your vision yourself, chances of hitting a home run is negligible, hiring talent/ selling to customers/ raising money is insanely difficult without this trait
Reach out📢
Reach out to the best people in your network, get them to work with you, convince them if you think they're a great fit.

Real eg. : Had to visit & meet parents of a potential content writer, as she had extraordinary skills, but her parents were against working.
Think of Candidates as #Customers, you've to sell them the vision 🔭 + Provide an #experience.

Experience here means - proper communication {Well written JD, what exactly are they expected to do, hours, skills reqd}, tell them how would they progress? how much can they make?
High stakes means people are on the lookout for anything bad.

And honestly, if you get vetoed by one interviewer, you probably didn't vibe with them. That may or may not be "your fault" but you CAN work on being positive and high-energy.

Let me do a quick thread on #interviews.
I've done hundreds of interviews, both as interviewer and interviewee, and most people grossly misunderstand how #interviews work.

First off, an interview is human interaction.
This seems obvious but the point is, it's not a neutral infodump. It's a vibe check.

What that means is a little more complicated, because people are complicated.

If you are awesome and they can pick up on it, great! Unless they're insecure, in which case it goes against you.
Do #qualitative interviews cause #distress when used for sensitive topics and/or in sensitive populations?
A thread (& case study with #cancer #survivors).
1/5
2/5 #Qualitative research is ideally suited to gain rich insights into human experience, including those with medical conditions and at-risk groups.

But, one #barrier to conducting #qualitative interviews is concern (often from physicians or IRB/ethics) of causing #distress
3/5 Yet, data on distress around #qualitative #interviews with medical pops is lacking.

In our new #PsychoOncologypaper, #AYA #cancersurvivors completed a validated distress screening tool before, after & 1 week after an interview on #fearofrecurrence

onlinelibrary.wiley.com/doi/epdf/10.10…
Depuis 3 ans maintenant, j’accumule des stats sur les invités et chroniqueurs dans les médias. Aujourd’hui, c’est l’heure du bilan du 1er août 2019 au 31 juillet 2020, sur plus de cent émissions, chroniques, tribunes, interviews, etc.
@acrimed_info @arretsurimages #politique
Si j’ai le temps, il y aura par la suite des zooms sur l’année de certaines émissions ou interviews phares, comme C dans l’air, certaines matinales ou autres. Je peux aussi répondre aux demandes spécifiques.
Côté chiffres, pr cette année 2019-2020, mes décomptes ont permis de recenser plus de 23500 interventions, dont plus de 20000 sont « étiquetables » politiquement, dans plus de 120 rdv différents. Cela concerne 1993 personnes, évidemment la majorité n’a qu’une seule intervention.
After 6yrs of a roller coaster ride #PhD and 1yr of #jobsearch, #immigration woes, and a #pandemic, I am humbled and happy to officially accept a Postdoctoral Scientist position @abbvie. I owe this to my wife and savior @priyankaitkar9, #parents, #inlaws, and all #familymembers!
Shoutout to kind and supportive people in my life who guided me and kept me sane and positive so I could aggressively go after my dreams @UMassChemEng @IITGuwahati.
I am also #grateful to all the people who offered me #interviews and #postdoc positions. You helped me gain confidence in my abilities and it was emotionally difficult to decline your offers! 🙏🏽
9 ways to get more #interviews today!!! 🙋‍♀️🥳

It’s a numbers game and here’s how YOU can easily create more opportunities for YOU...

1) Make your #resume super searchable

2) Will your resume pass the 3-second
recruiter test - it’s all about the top half

1/3
3) Tailor resume for job you’re applying for

5) Apply for 3 jobs on job boards

6) Apply directly to 3 companies you want to work for

7)Speak to 3 recruiters who recruit for your niche/industry

2/3
8)Contact 3 old bosses, colleagues, friends, clients you used to work with and let them know what work you are looking for and how they can help you

9)Network with 3 potential hiring managers in companies you want to work for

💜YOU GOT THIS💜

3/3
A thread: How I prepared for a #tech role in #FAANG
1. Technical preparation of #python and #SQL
2. Behavioral and cultural screen with @Latesha_Byrd
3. Deep dive on department domain and current tools and techniques
Technical preparation included practicing @LeetCode and @CodeSignalCom for #SQL and #python. I started to time myself and also spoke out loud what I was doing and why to get familiar with #whiteboarding etiquette. I also had my friends mock interview me.
I also utilized @TeamBatcode for more #python practice with primitive #datastructures and #Algorithms. It was consistent practice while talking out loud. I probably worked through about 50-60 problems.