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

When a recruiter emails you at work, how do you respond? I feel like it’s stupid to use my firm email for that, but it seems like when I forward to my personal email and reply there, I never get a response?

Anyone know what the interview process for the Strategy & Innovations analyst at CVS Health is like? Anything specific I should prepare for?

likehelpful

I recently interviewed for L7 EM at Google and had 4 great interviews and one not so great system design. I submitted external referrals all of which gave great feedback. The recruiter said the next step is team match/interviews and then the HC. Anyone in a similar situation? What was the result? Google

Has anyone recently interviewed with S&P Global and got an offer?

Does anyone have any insight into accounting roles at Amazon, particularly in the Arlington/DC area? An Amazon recruiter reached out about accounting roles, but the posts in this bowl are about Seattle. Trying to decide if the culture/wlb/pay is even worth looking into since it sounds like the interview process is intense. Base pay seemed pretty low in other posts, but they were a year old and for Seattle.
Amazon

like

Had two rounds of interviews for an in house role and really like the company/job. I followed up Friday regarding next steps and was told they are still interviewing and should be wrapping up soon. Advice on how to stay calm? I want the position and need to know if there’s a way to speed up the process.

like

During my job search, I am getting a lot of recruiters asking for me to answer right to represent emails. These particular recruiters follow a same pattern and seem unprofessional. Shall I be aware and not sign these right to represents? Are they a scam? Or is it a cultural thing… can someone advise me, I’m based in the USA

like

Hi all, Can someone help with interview questions with the Information Security Auditor role? Please

likefunny

Can anyone help me with the interview process for SSE at informatica. i.e. Structure of each round.

like

Hey folks, question about applying for a role in Spotify (Sweden).
Does having a referral make a big difference to get your application reviewed?

I'm currently in Canada and planning to move to Sweden soon so applied for a few spots however I don't have even the slightest idea if
a) applying from Ca will actually get my application tossed out the window
b) I've heard there are gazillion ppl applying so if referral gets me on the radar, instead wasting time just find someone to refer me?

like

I’ve applied to a Life Science position at Deloitte. Anyone willing to chat and put in a good word?

like

Need genuine advise. Got a call from Oasis Resource management pvt ltd. They said that they can help in conducting interviews in canada or UK. Total 5 interviews. They will charge 72k for this and 2k for profile investigation. They claim that under work permit, accomodation, travel cost, meal will be borne by employer for whole work visa tenure along with salary as per profile and market standard.
Are they legit ?
Should i proceed with them ?
Any chance of them being fraud ?
I m ca 7+ yoe 32ctc.

like

Yoe 12. Working in middle-east for last 5 years and KL for 2 years. in the process of finalizing interviews with HCL Technologies and Capgemini. What should be the package should I be asking for. Currently drawing 2.3L a month.

like

Hi All,
It’s been a week since I last heard from pwc in regards to my interview. I gave them my availability for next week but I’m on holiday and few of the days won’t be at home. Shall I follow up with recruiter and make them aware that I’m still waiting for something to be scheduled. Really don’t want to keep waiting…

like

Senior Manager Retail at Apple anyone?
Wondering what a SM would do in retail, by exiting from consulting.
Got interview next week.

likehelpful

Can someone tell me , How many days Barclays will take to respond to any job applications.


@Barclays #barclays

like

5+ years of full-time job as developer and still waiting to reverse a LinkedList at work.

Since there is a heavy impetus on solving Tree, LinkedList, and Graph problems for tech interviews, it can naturally make freshers believe that these concepts will be used in day-to-day life at work. In reality, most of these DSA concepts are already implemented in some libraries our code uses and we rarely have to code such Algorithms by hand.

Problem solving skill >>> DSA
What's say?

like

Is there any intel you would ask your recruiter before your loop that they may give you as help or advice?

Hi,
Anyone got a few minutes to chat about A&M in Dubai, specifically around interview process and expectations for salary at the senior associate level? My research is 35-40k base with variable bonus component. Any insights would be appreciated.

like

I just started with a company as an HR Generalist. Within the 3 weeks of being there, my boss’s boss left, and today I found out my boss gave notice. HR is not valued at the company and it’s disheartening to know I was hired into a mess. I am now actively looking but how do I explain to other employers why I am actively looking and what do I put on my resume? I have never had to deal with this before.

like

More Posts

Novice question, do CTA day passes expire on the date you purchased them? Or can I buy multiple ones on the same day and use them in the future?

like

Final day at current company tomorrow and I have 100k+ AMEX points I need to use before they disappear forever. How should I redeem them to get the most bang for my buck?

likehelpful

Any international senior creatives who are on O1 visa ? Need some assistance please.

likehelpful

I joined capgemini on aug 19 2021 but no appraisal has happened till now.
HR said that I appraisal will happen in April 2023 ! Is that true..
That is a very very long time .
Please can anyone tell if that could be true.

like

Hi everyone, I’m seeking some advice - my dog (8yrs old) was attacked several months ago by another dog and after she became depressed and anxious. We got her anti depression meds and those seemed to help but how a lot now a lot of signs are pointing to a potential brain tumor. To get an MRI is +1k. My mom doesn’t want to spend money but it just hurts me so much to see the behavior - she walks around in constant circles, looks sad, seizures, hides under the bed. Any advice would be appreciated.

like

For those who had a successful pregnancy with ivf, do you remember when or if you had the symptoms? I am now 10 days post transfer and dont really feel anything except lazy and tired but that could also be from progesterone supplements.

like

my sister died this morning. I posted about her in a past post. Alcohol addiction, liver failure and then it taxed the kidneys too much, she went into cardiac arrest at 9 am and they could not save her. She was 51. Sad day for sure. Feels odd that she is no longer here. I just wish she could have had a better future.

like

Hi sharks,
How is the career growth for a Salesforce developer in the market in near future.

like

Go LTC go!

like

How does LEK rank against consulting firms in the UK?

How is Microsoft's Customer Value Engineering team? How is the work culture, work life balance and growth opportunities?

like

How is Azure Devops team in Microsoft?
How is the work culture and all?
Which are the best software teams in Microsoft for Hyderabad location in terms of learning and career growth?
If anyone know anything please share.

Thanks

likeuplifting

What is the salary range for b2 in Wipro?

Does wipro provides car parking to employees in Gurgaon cyber city office??

like

Will rent in jersey city waterfront apartments (from Paulus hook to Newport) decrease this fall? $3500+ for one bedroom is insane…

like

How to structure the compensation for level 8 ? Should basic be more or allowance should be more for a package of 25lpa fixed.

like

Yesterday i got resignation acceptance mail from hr with lwd mentioned.

My TL called me that need to go office else they will extend your notice period.

Will that possible or else he is scaring me?

likefunny

Hey all,
So I’m currently interviewing for another position, to be a business development specialist at a relatively large tech company in PA. I have about a years worth of experience. Indeed estimates the salary to be between 60k-80k, I was wondering what I should expect?

How many rounds of interviews for Jackson lewis? How long is the whole process from application to getting offer/rejection?

like

I'm a marketer and I'm having a hard time getting my clients to listen to me.

I have been in marketing for 10 years now. I've worked with hundreds of clients and have been able to increase their sales by over $1 million each year.

But every time I go into a meeting with a new client, they ignore everything I say. They just want to talk about their product. They don't seem interested in learning how to market it better.

like

Additional Posts in Women in Technology

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 do you feel is your top career blocker now? Or put differently, what’s stopping you from earning more or advancing?

like

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

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

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

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

like

Is it common for tech teams in the big 4 to hold out of state meetings before major holidays like labor day? I've only heard this applies to PWC so far....?

Thanks!

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

For an interview for a non-tech role at a tech company, what do you typically do/say that helps you stand out against your peers?

like

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

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

We made it to 100! High five!

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