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

Fish on visa - do you put ‘Candidate requires sponsorship’ on your resume ? I feel it is a time waste to get interview calls and anticipation only to find out they don’t sponsor on the call.

like

Had a final round on Monday. How long should I wait to hear back?

likehelpful

Has anyone struggled with hire right before ? How impacting is this for the process?

like

Had a first round interview scheduled for a large CPG brand. My interviewer never called me, and I emailed following up to confirm the call. It’s been over a day and no response. What is going on with recruiters? I tried giving them the benefit of the doubt, but not even an email back saying “something came up” or “we’ve moved on” ? I’ve been ghosted after every final interview during my recent job search, but never had I been ghosted before even having the first call??

likehelpful

When I was a device driver developer with 2 years relevant experience I had got calls from Nvidia and Qualcomm. Unfortunately I wasn't able to crack the interviews back then.

For next 5 years I worked mostly on application development and broadening my exposure. I am not getting even a single call from such companies now.

Is it a good idea to rebrand myself as a device driver developer so that I can get calls again?

like
like

Just found out, I'll be interviewing for a role at BCG next month. Does anyone want to practice casing together?

like

GCA Questions Help

Hi everyone!
I've had 2 rounds of interviews at Google (UK) for a non-tech role in Platforms & Ecosystems (L4/L5). Recruiter told me that I've been selected for the final rounds (GCA + Leadership Interview). From his feedback, one thing they wanted me to improve on was the GCA Questions. Would anyone have any tips on how to prepare for these? I've checked some of Jeff Sipe videos online but would appreciate any support! I find GCA quite stressful...
Thx
Thanks in advance!

like

Hi, can you tell me how many rounds takes place in for automation testing round. I have got a link for an online test and what is the difficulty level should we expect from this test v

like

I have an offer accepted from Elevance 125k (Anthem) and w a good team and seems that WLB would be ok. Also, Amazon hiring manager wants to interview me for a job. Is just a hiring manager int. so obvi nothing guaranteed. Salary if offered will be more than 150k. My question is should I accept the interview and see where it goes? Is it really worth it to proceed with a company like Amazon for 25k+. I live in CA so $ is imp but I do have a toddler so WLB is also imp. Both role are Sr. MGR.

like

I have a consulting/PE interview on Friday, please recommend consulting books or sites to read. Need to speak consulting language

like
like

Hello fishes have an interview scheduled for power programmer for Microsoft Azure .net technology. In the mail it has been mentioned the interview would have coding, so will that be technology based coding questions or DSA programs ?

like

Hi, am interested in applying to Putnam UK via positions shown on Linkedin. Anyone willing to chat or perhaps provide a referral? Thanks in advance!

like

Hi everyone,

I have received an online assessment from Accenture for selenium Automation Testing.
Any one has any idea what sort of questions are asked. It will be really helpful.

Thanks in advance

like

Has anyone gone through the deloitte cyber risk interview process recently? How many interviews did you have and how was the process?? Salary?

like

What is the current market worth of a security architect (cloud and application security) with 9.7 years of experience?

Skillset: Application and cloud security architecture, threat modelling, SSDLC, secure design reviews, SAST (code review), DAST/pentesting, DevSecOps, cloud native security (microservices, containers, Kubernetes), etc.

I have interviews lined up with Honeywell, Deloitte, KPMG, Tata Play, GE, etc. Just want to test the waters before I answer the salary expectation question.

like

Is all the development work in Thoughtworks done in pairs.Is code pairing just for interviews or its followed in all the projects too?

like

What is the salary range of employees working in Salesforce and having 8 years of experience ?
Got interviewed for MTS position

like

Any idea what a Hirevue assessment for a talent position at EY would consist of?

like

More Posts

Currently job hunting with sponsorship to Canada, AU or anywhere. I am a Software Engineer based in the Philippines with 17 years of industry experience. I'm currently leading a team in a fintech company. I'm technology agnostic and have worked with different platform from smalltalk to react, I can work both front and back end. Please PM me if you have any opening and can accomodate me. thanks!

like

Looking for a paid search manager to join our media team! Headquarters located out of Baltimore, MD but the position has the flexibility to be completely remote. Looking for 3-5 years experience.

अरे? दिवाली पार्टी में शराब परोसी जाएगी या नहीं? इस बारे में कोई विचार? 🙊

likefunny

Looking for SC and Managers to join the Financial Crime team at FTI, DM if interested.

likehelpful

Yoe 5
Capgemini is offering 23fixed. Is there still bandwidth?

like

Can someone please take a look at my resume

Post Photo
like

Holy cow. Have you seen the new Seamless logo? Talk about killing an iconic brand. (Sorry for the screenshot.)

Post Photo
likefunny

Hi All,

This is Prasanna Kumar from India. I hope you are doing well :)
Myself and my wife are working in Infosys. She has got a project in Canada. She has raised a dependent Visa for me also in Canada.
If we go there, she will have a work assignment. But I won't have any work assignments in Canada.
My Canada Visa is already in progress. I am looking out for opportunities for Windchill in Canada.
If you can be able to help me with this, It would be a great help for us
Thanks

like

Would be very helpful if folks in this group can share details about any recent openings at their VC firms.

I am currently in consulting (ZS Associates) from the last 2years and I am looking for opportunities at an analyst/associate level at a VC firm.

like

Hey fishes hows GE Healthcare in terms of payscale? 8.2 YOE , Reporting analytics skill business analyst. Have an offer of 25fixed from other org.

I have two offers- should I go with a sr product manager with Lowes or senior manager, product owner at vf (owns northface,timberland brands). Any suggestions compensation is the same

like

Can grad students get $20k forgiven if they got Pell in undergrad but outstaning loans are only for grad school?

like

Hi Fishes, Has anyone attended MAKE MY TRIP interview on the QA Automation side recently ? what kind of questions are being asked, any idea would be a great help

like

For the noobs - remember if a stock goes up quick, it can go down quick. Good day to buy more!

likefunny

Thoughts on career changing and joining a headhunting/executive recruitment firm? I feel like it won't be super hard for me to start building a book of business with my current network. Anyone with experience?

like

I'll be joining soon . looking for relocation allowance details as I need to move pune. When and how to check the status ?
Should I wait till ko joining as it will be virtual ?

like

Anyone know what they pay for acd and cd at martin?

likehelpful

Hi,
I will be moving to Bangalore next Week. Ive shortlisted some PG's in Koramanagala nearby to my office , any suggestions would be appreciated . Open to PG's or Studio apartment/1BHK flats.

like

Could anyone kindly tell me about the Investment Management and Private Equity Audit Group at Deloitte? 1. Work Life Balance (Is it worst than the ordinary Big 4 WLB?) 2. Is it an entirely different audit from commercial/retail audits (think account balances etc.) 3. Difficult to learn how to audit clients in this industry without prior experience in the industry?(been doing commercial audits for 3 years) 4. Are there relatively good exit opportunities for this audit group? Deloitte PwC EY

like

I have 5 years of experience in 3D design & operations. I accepted the offer of 10L from Accenture to come on notice period (90 days). Now John Deere is offering 11.5L based upon Accenture office. Having global economic slowdown in consideration shall I take this offer? Accenture John Deere

like

Additional Posts in Women in Technology

We made it to 100! High five!

like

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

like

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

like

Has anyone here pivoted into tech and regretted it?

like

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

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

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

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

If you know SQL and/or Python and R but didn't learn this from school or on the job, what method and resources did you use to learn these? Thank you in advance!!

like

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

like

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

like

Whether you are actively looking or need some introspection, I recommend completing a ManualOf.Me about yourself, how you like to work, and what you value. You may even surprise yourself.

helpful

Hi there! Is it worth getting a masters in tech or to go back to get a B.S. I know I would have to take a couple classes if I were to pursue the masters.

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
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the
Fishbowl app

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Scan your QR code to download
Fishbowl app on your mobile

Download app

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy

Already have an account? Log in

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use(New) and Privacy Policy(New)
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

General

Legal