SQL is a must-have skill for any data-related role. Including data scientists, data analysts, data engineers, or even software developers, very often your future employee will verify your ability to process and manage data.
As the #1 language in the industry for data management, SQL skills are probably one of the most important to master before starting an interview process.
The SQL interview can bear other names and may be called Technical Analysis or Data Interview during a FAANG company interview, you might be asked to perform a series of SQL operations to extract data and insights, and answer follow-up questions about their products.
Before your 'real' interview, it will be super useful to do some mock interviews with an experienced mentor to get you ready.
Our mentors have done hundreds or thousands of real interviews, they will try to emulate a real job interview process.
You will have a conversation that resembles a real interview as closely as possible, in the end, you will also have the opportunity to receive feedback from your mentor.
✅ Experience a simulated SQL interview experience and get a sense of how the FAANG company interview process is like.
✅ Get over nervousness after you've done a few mock interview practices.
✅ Valuable feedbacks during and after the mock interview provided by your mentor.
✅ Become confident and get familiar with the interview process.
You will be asked a series of SQL questions customized towards your dream company, please make sure you share the job descriptions with your mentor, so the questions can be customized towards your dream job.
And you will be writing SQL queries in a browser where your mentor will be able to see your coding in real-time.
A link to access the SQL code editor will be provided before or at the beginning of the interview process.
Great chatting with you yesterday. Here are some notes about the next steps. Overall I really enjoyed our skills assessment session and your answers (still room to be improved, but I think you probably will only need one month to get ready).
So let's spend our next session evaluating your Python/Pandas/Machine Learning and Behavioral questions.
Let me know if you have any questions.
Jimmy skills evaluation Part 1 (SQL, Product Sense)
Current level: 4.5/5
Notes: Jimmy already has excellent SQL skills. She understood the difference between ROW_NUMBER and RANK functions and quickly came up with a query solution. However, there is still room to be improved, e.g., using full outer join and code formatting.
Next steps: For November, Jimmy should continue practicing SQL on SQLPad or Leetcode to maintain a good status.
Current level: 4/5
Notes: Jimmy already has some excellent ideas on answering Product Sense questions and has an initial framework to answer those questions.
Next steps: (in priority)
1. We need to strengthen Jimmy's domain knowledge in advertising since companies such as FB, Google, and TikTok's revenue mostly come from advertising.
Different types of ads network (search, social, video ads) and monetization models: e.g., impression-based (CPM: cost per thousand impressions) vs. performance-based (CPC: cost per click).
An excellent place to start is iab.com, as well as Google and FB's earnings report.
2. Read the cracking the PM interview Chapter 10 (learn how to do company research) and Chapter 14 (product questions), 15 (solidify the framework).
3. Jimmy can also start reading or watching more technology news. Some of the great places to start are techcrunch.com, Bloomberg technology, daily newsletters such as hustle. Co to immerse herself with creative product ideas, latest industry trends, and well-versed in latest technologies.
1. Technical: noticed sometimes it's a bit hard to hear clearly from Jimmy, and perhaps it's because the speaker was blocked, or was there a poor internet connection? We should fix this to make sure an interview can hear Jimmy clearly for the actual interviews.
2. Resume: You need to spend some time reviewing and working on your resume improvement. It's already an excellent copy.
3. LinkedIn (optional): we can spend some time improving your LinkedIn profile.
4. Github (optional): not super important, but it could be helpful to have a public Github account with some sample project codebase.
Tell us what programming languages you would prefer to use when you book this session.
50% Salary Increase!
Thank you so much @Leon !
Your advice and coaching are extremely helpful for preparations for the interviews. The timeline and pacing you helped plan worked out very well.
It kept me on the right track. The exercise on coding and data analytics you recommended greatly sharpened my skills to solve the problems during the technical rounds.
The practice to communicate project work to peers is another highlight to help me earn higher score. Again thank you so much for all your advice!
Dream Job Offer from Apple!
Just wanted to share, I accepted an offer from Apple as a Data Engineer and wanted to offer a huge thank you to both of you guys.
Even though I only shared a small time with you both I benefited a lot from your platform and your mock interviews.
Some of the questions you gave during our Data Modeling with you Mike were presented verbatim.
The mock interview helped me do it in the right way
I did a SQL Mock interview on Instamentor to gain a better understanding of how SQL interviews are conducted.
The questions and tips he provided were incredibly helpful in my preparation.
My actual interview went in a similar manner and having done the mock interview helped me do it in the right way.
Shoutout to Leon Wei from instamentor.com.
Please do reach out to him if you're looking for career advice, general consulting, or resume feedback. I found his services extremely valuable.
And while you're at it, please do check out SQLPad if you're looking to refresh your SQL concepts.
Shout out to Leon Wei from instamentor.com, recommending him if you are searching for great advises and mentorship for your #datasciences career.
Dream Data Scientist job offer!
I've tried several sites to practice SQL and sqlpad.io is my favorite because the questions are well-designed to focus on the most important concepts. Some of the other sites are all over the place.
With sqlpad.io, I can focus on questions by skill level or topic, and the number of questions available is a reasonable amount to study for interview prep.
In addition, I got mentoring sessions with Leon and I was impressed at how helpful it was. Leon was calm and knowledgeable, which helped my nerves over my up-coming interview.
He really takes mentoring seriously and it makes a big difference. After practicing my SQL, I got my data science dream job!
Meticulously prepared and very professional
I signed up on Leon's service and was pleasantly surprised when he helped me out personally on the website. In two mock interviews with him from instamentor.com, he was meticulously prepared and very professional.
Throughout the interview he provided fantastic feedback and frameworks on how to be better prepared for both technical and behavioural aspects of an interview.
He is also a very positive and friendly person and I enjoyed all my interactions with him.
Shoutout to Leon Wei from instamentor.com, recommending him if you are searching for great advices and mentorship for you #datascience career.
What made the session successful was the effortlessness in being honest around Leon.
I had my first mentoring call yesterday. The session was to be for 45 mins but lucky for me, Leon did not have a hard stop. We had a detailed discussion around my career history, career transition, stuff I’m good at and enjoy doing/good at but don’t enjoy/not good at and want to improve, not good at and not interested in improving...you get the drift). Read more
Leon listened patiently, highlighted areas I needed to work on, pointed out practical considerations, and made gentle suggestions on handling a couple of situations I had bombed (salary negotiation was one).
We covered a lot of ground and had concrete to-dos at the end of the call, but what made the session successful was the effortlessness in being honest around Leon. A mentor needs to identify what is holding the mentee back in their career, and their advice can only be as good as the inputs we give them. Leon made it easy to be authentic. I’ll keep you all posted on my journey!
I landed the job I wanted at a FAANG company
Joining INSTAMENTOR.COM was very easy, and I quickly found a mentor who is a good match. My mentor was amazing and friendly. He knew all the details and important things that I needed in my job search. I landed the job I wanted at a FAANG company, and we’re still in touch.
Instamentor is understanding and accommodating
Although my first mentor was great, I decided to pursue a different career track mid-way. They quickly found me a different mentor after I contacted them, without extra charge.
This platform and my mentor have made the job search so much easier
This platform and my mentor have made the job search so much easier for me. All the support and insights from my mentor made me feel so much readier for my interview. This made me walk in completely relaxed and natural in the interview room which got me the job!
Instamentor helped me connect with a mentor from my dream company
Instamentor helped me connect with a mentor from my dream company. I learned a lot about the culture of the company, the good and bad about working there. He also help me prepare my job interviews by providing mock interviews and resume feedbacks.
Instamentor hooked me up with a mentor who changed my career
I’m a business analyst and always want to become a data scientist. I’m really glad Instamentor hook me up with a mentor who successfully changed my career path. With my mentor’s guidance, I’m on track learning coding languages that are crucial as a data scientist. The most important thing is that I have gained courage and confidence on my career development.