I'm going to have a SQL test for an interview. What are some key functions/things I should know even if you consider this to be very very basic knowledge? Anything helps since I don't know much but going to try learning/practicing as much as I can before the interview

like
Posting as :
works at
You are currently posting as works at

If you can watch an Intro to SQL video and practice making even simple queries, I would recommend doing that ASAP. YouTube has many videos on this topic. freecodecamp.org has a SQL cheat sheet article to get started, and searching for "sql cheat sheet" comes up with lots of sites. For making and trying out queries, I recommend SQLBolt.com or SQLZoo.com. You can also complete SQL challenges on HackerRank. Good luck!

like

Make sure you understand the differences between the types of joins. I used DataCamp and found the exercises helpful to go through daily.

like

Related Posts

Can anyone please share their experience of Data scientist/ ML interview at Microsoft. I have mine coming up. I highly appreciate any help on the areas covered, level of coding test etc. TIA Microsoft 6 yrs exp

like

Really want to work at Google as a PM. Experience in Tech Strategy consulting and product management for a cloud infrastructure company. What else do I need to be a good fit and get this role? I'm good with clients, presentations, organizing, planning, keeping roadmaps on time and on target and managing people. I'm not super duper technically but as an ex- developer I can understand what needs to be done. My insecurities are keeping me from applying.

likehelpfulfunny

Had an interview for SM role at ACN 3 weeks back but haven’t heard back. This was skills round interview after HR round. Am I still in the game or it’s a no? Don’t want to followup with HR just yet.

What are some common technical interview questions that come up most often in PM interviews?

like

Help! Final interview with Spectrum and I’ll be meeting with my potential peers, other HR generalist and the VP of ops. I’ve never been in a peer interview like this. What should I expect? What sort of questions should I ask? Also, I was told they’re only seriously considering one other candidate so how do I really stand out & seal the deal???

like
like

So Google reached out to me for the
role of a cloud data engineer. Could
anyone shed light on the interview
process?
Any added insights/tips would be
appreciated!

I have landed a graduate offer at KPMG for Tech risk, which is IT audit, my background is Cyber Security, with technical skills from penetration testing, vulnerability scanning, reporting and remediation to the otherside of the fence incident response, SIEM, threat hunting, reverse engineering
In my interviews i conducted with partners and managers i expressed my interest in techincal cyber roles showing competence and even my home lab environments, i was told there might not be budget for me?

like

I have a one hour phone interview with Accenture Federal Services. Any tips on what to expect? I’ve never had a phone interview that long.

like

Anybody here interview with TikTok? Do they usually ghost after a final round or send a rejection email?

like

Been with Deloitte for about a year as a consultant and currently interviewing for a Business Integrity role at Meta. From what I understand, the business integrity role is an internal consulting role for them. I’d like to not have billable hours anymore and more of a WLB but not sure if there any key differences between the two besides that. There is a pay increase but not really concerned about that. Any thoughts on this transition if I am offered?

like

What sorts of SQL questions are typically asked in interview questions for senior data analysis jobs? Like is knowing SQL from freecodecamp enough or should I look into taking a course online?

I’ve unfortunately not gotten the chance to use SQL in my current position so I don’t feel like I have enough experience in it, but have experience in everything else (Python, tableau, storytelling, etc)

Hi,
I have a question.
Is everyone getting selected in JPMC , everyone who is appearing for interviews ?
I am seeing a lot of posts over here 😄

like

Hey folks how interview and onboarding process happen in HCL Technologies i have a notice period of 90 days and cleared all the rounds had my salary discussion what next ?

After salary discussion how much time usually HCL Technologies take to release offer i am asking because i am waiting for the offer letter so that I can resign.

like

I have a CSM interview coming up. Please share some advice to clear it.

Feeling really frustrated and don’t know what to do. Interviewed early March, informed that I moved onto second rounds after ~2 weeks. Was told there would final rounds in late April but they never took place and haven’t scheduled it still.

I move states in July to start my job at D but I really want this MBB role. There’s roommates in my current and possible future state dependent on me to find out where I’m working as well. At this point I also feel very demotivated to study/prep.

like

I interviewed for a mid market role selling into pub sec and they came back with an offer for a different team as an Enterprise Software AE. So, I never really got to talk to the person that I'll be reporting to and ask questions.

What questions would you ask the hiring manager to assess the opportunity?

like

It’s funny - I’ve been rejected so many times in my short career. But when it happens, I still feel a small sting. Just got dinged from an interesting role - how do you deal with the aftermath?

What’s it take to get hired at Salesforce? I currently have 3 YOE, 7x certified and working as an engagement manager for a small consultancy. What can I do to increase my chances of getting an interview and offer? What roles should I consider? Thanks in advance.

like

Hello Fishes,
My brother is a b.com graduate(2020 passed out) and looking for a job.
The problem here is because Finance jobs requires exceptional skills and academics due to which he is not able to get shortlisted for most job interview screening, he is receiving interview calls from great companies but not able to convert them.
If anybody can help even with an Internship position at their firm that would be a great starter to his career.

PS: leave a like so that I can send Dms across✌

like

More Posts

Hello Guys,
We are hiring for SAP HCM, MM, ABAP HR and multiple roles for SAP partner firm in Ahmedabad. Referral bonus 15k once candidate completes 90 days with the firm. Please connect with me on 7990477483.

like

I've been on PTO for 3 weeks in DR... don't know how to get back to the office this week... I just want to stay here forever. FML

likefunnyuplifting

Regardless of what the Fed says, it looks like USD is steadily (rapidly?) inflating. Emergency fund is 80,000 (plus 10,000 reserve for a rental). What to do with it to hedge against inflation?

like

Do partners at top consulting firms have better WLB?
An Associate here contemplating whether all this is worth it.
Thanks!

like

Ah!! Who else watched episode 6?

like

Is synechron safe to join, I have read a lot of hire and fire reviews, they are ready to give me 2.5 LPA hike on my In-hand offer, also there was no client round conducted, I only know the client is Japan based.

How is the WLB, and yearly appraisal?

like

Which is better, business consulting or tech consulting in terms of learning, broad opportunities, growth and money?

like

Need 11 likes. Please support

likefunny

Hi Guys,

I have recently joined Accenture. I need to fill the TE sheet since the last day to fill is 26th August. How do I know the charge code details? Pls help.

PS. I have joined on 19th August.

like

Happy Project Management Day!!

like

The satisfaction I get from answering questions on Fishbowl makes me think I should make my secret dream of being a career coach a reality.

likeuplifting

Anyone else getting tired of how normalized alcohol is becoming ( well it always has been) eclectically during quarentine. Keep on getting snaps of people drinking at 11 am bc they’re bored. Also annoyed at this wine culture of always needing a glass of wine after menial task bc “wine not”

likefunny

Partners, is it okay to send a deliverable without your review?

funnylike

Looking for a cheap (<$5k) car to use as my daily driver (100+ miles/day) so I can keep miles off my main car. Any suggestions on dealerships?

like

Is there any vacancy for the post of full stack developer or senior software engineer in WALMART Chennai ?

Another failed FET and no more embryos from this IVF cycle. How did you keep from getting discouraged and start another round of stim? I feel at my wit’s end.

like

What have you done to successfully manage burnout long-term? I could use some advice or input

like

For those of you who have been formally given the title of “senior paralegal” what are the qualifications for that title at your firm? Does your firm do promotions from paralegal to senior paralegal? At my firm we are all simply just “paralegal” (we all fully handle our own dockets, no assistants) and I would like to help develop a concrete career track for paralegal to senior paralegal.

like

Any idea if it's okay to remind your manager to approve the reimbursement?
Or let them do it in 7-10 days? But it gets so late.

like

Thoughts on the new Beyoncé and Jay-Z campaign for Tiffany? Seems like a decision that is as historic as it is controversial.

Post Photo
likesmart

Additional Posts in Women in Technology

Resource: Are you looking for additional communities and job boards for women in tech? Check out LadiesGetPaid.com, an online community with lots of subgroups available to join based on career, location, and interests.

like

What is the biggest challenge you are currently facing being in tech, right now?

like

What is one small action that you would recommend ladies in tech do once a week to help their career move forward?

Are there any tips you can share for a technical interview preparation? Are there any online resources I could use?

like

What do you feel is your top career blocker now? Or put differently, what’s stopping you from earning more or advancing?

like

Hey ladies! Does anyone have insight into Business Development roles at Flexport? Have a phone screen coming up this week. Curious about interview process and comp. Looking to leave federal consulting after three years. Flexport

like
likehelpful

Anyone here from a non tech/stem background? What's your story and how did you break into tech

like

Hi everyone! I’m currently in corporate strategy looking to pivot into a front end web development role. Is there any front end developers here willing to have a chat?

like

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
That was just a preview…
Sign Up to see all discussions
  • Discover what it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with other professionals in your field