best way to learn sql for an interview in 2 days? 😅 (already am past beginner level!)

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

If you’re truly past beginner level then focus on joins. Inner/outer and differences and example queries. Joins are by far the most notoriously asked questions in SQL interviews.

likesmart

Hackerrank has some good challenges

I was asked to write a SQL query on a white board for my interview, be prepared!

What type of SQL knowledge are they expecting? For beyond basic querying, you should look into DW stuff like facts and dimension modeling, SCD types. Kimball Group is a good source for anything DW related.

Related Posts

I have an experience of 8.3Yrs, current ctc 14lpa and i have an offer of 21.5lpa from tcs. My profile is python, django, docker and kubernetes. My technical rounds have been cleared in Capgemini. How much compensation should I ask for in my HR round?

Hi Fishes,
Tomorrow is my coding/ DSA round with Google for the role of Cloud Engineer - AI, I am practicing the google interview questions from leetcode, if you can share any prior experiences and problems that you have encountered will be very useful. Much appreciated, thanks

like

Have an interview with a growth stage startup, what should I wear for a virtual interview ?

like

Have an EY-P interview coming up... what are my "why Parthenon?" answers?

Anyone here with experience as a Product Manager? I’ve close to decade of consumer lending experience including Sales/Advisory, Supervisor and Underwriting. I have have been looking to pivot into a more impactful role this year. I am due for an interview for a Product Manager next week. The company ticks all my boxes but the job description a bit vague. I will be grateful if anybody willing to share what the day role looks like and what I need to look out for in an interview. Thanks. Cheers.

Any recommendations on resources to study for Android system design interviews?

Happy Wednesday everyone. I'm so excited, I have a recruiter call scheduled with @Meta for Administrative Partner position. I've been in my current employer role for 19 years and I'm nervous as heck. I haven't had to do an interview in so long. Can someone please tell me what to expect with the recruiter call? I'm assuming it will be mostly about the role, my skills and background? Do they ask salary expectations? I have no idea what to say for the salary question. Feedback appreciated. Thanks

likeuplifting

I'm curious to know how many (and which) tech companies have resumed physical onsite interviews in their offices?

like

I need some advice my friends. I interviewed last year for M1 at a big four but ended up coming in as S3 with the expectation to be promoted to M1 within 6-12 months per the interview. Now they are saying target promotion is now end of 2022 (would make it 18 months). Are they just dragging me along since we are short seniors? I’ve now been in public for 6 years now. I was in the “met expectations” group for performance. Is it time for me to go into private? Will my raise be anything exciting?

like

Any recommendations for recruiters? NY RR second year. I prefer to stay in NY.

like

Hi All,

I have given an interview for BI Customer Analyst for 3 years experience @NielsenIQ. How much salary should I expect?

How to follow up with HR if the offer letter hasn't rolled out yet?I asked once but HR said "Will Call" and its been more than 10 days?Is it advisable to follow up again?

like

Hey 🐠 cleared first technical round in Tech Mahindra today got call for second round but didn’t declare technical or Hr..
Pls help if any one have idea how many rounds will be there…
YOE- 9.8
Tech stack - Apigee api gateway

like

Hi fishes. I am a fresher and have been recruited as an associate consultant into tech consulting via campus interview. I join in a few months and my package is 7lpa fixed plus 80k variable. I plan to stick with EY for at least 2-3 years barring exceptional circumstances. How can I expect my salary to progress over this duration? Thanks!

like

Hi Folks, I have submitted the documents in last week 8 days ago for Test automation position. But still I didn't hear for further steps of HR round. I called HR, she said my docs are under review, they will get back to me. My question is what time it takes to release the offer for Persistent. Also anyone knows how is Accleriote BU at persistent, would be helpful for me. Thanks

How long should I have to wait before applying for a transfer to abroad job in USA in the same company? Currently on a contract role as risk investigator L3 in Amazon

like

Hi fishes,
I was selected for a l3 role via IJP in the 1st week of may and the hiring manager informed me via email that i had been selected for the role and requested confirmation to proceed with offer letter generation. I didn't hear anything from HM after that. When can I expect to receive an internal offer letter? Should I contact HM to know about the status ? Please provide some insights. TIA :)

like

I am currently 100% remote and went through training and onboarding 100% remote. I am now looking for a new job and I have found remote work is really competitive. Any tips for how/where to apply? I am applying for content and copy writing roles all around the US as long as the are remote.

like

How do I professionally decline a second interview? I know for sure I don’t want to work at the firm.

like

I'm considering applying for all the Contact Tracing jobs I keep seeing. Any clue what the pay is?

like

More Posts

like

Where do you like to go in person clothes shopping? Which stores? (I.e., ponce, Atlantic station, Lenox, etc.)

like

How much would orange theory cost if you went 2-3x each week?

like
like

What are the non-tech roles one can try in Amazon prime video team?

like

Could anyone help me with a Google referral for the Austin office?

like

Pwc India vs Deloitte India

Please let me know your experiences if you are working with either of them.

Culture, wlb, yearly hike, learning curve anything that comes to your mind.

Deloitte India PwC India

like

Hi Guys.. I have an interview scheduled with JP Morgan Chase. May I know what would be the max limit salary which I could ask for 7.3 YOE, Java Full Stack Engineer.

like

Hi! I’m currently CoS to the CEO for a PE backed healthcare company. I currently make $140K + $25K bonus. I was CoS for 1.5 year at a nonprofit before joining this company, and have been at my current company for 1.5 years for a total of 3 years of CoS experience. I’m up for a raise this month, and curious what some of you are making for ballpark? I’m also on a COO path at my current company and was wondering if anyone else is also on that trajectory and if you have any tips? Thanks!

like

After how many days the Date of exit gets updated in the UAN portal after the LWD in TCS.
I have received my final payment after 10 days of my last working day.
Because after Date of exit is updated only we can start the PF transfer process right?

like
like

Hi. I’m relatively new to recruiting and my role is primarily in supporting recruiters. I’ve noticed that even when I include a specific request or call to action, that my emails receive a response less than 50% of the time. Is this lack of responsiveness indicative of company culture or more about the culture of recruiting, since they receive so many emails? Thoughts? I’ve not experienced this rate of responsiveness in any organization I’ve worked for. I am beginning to take it personally.

like

Hello Wiproite,
What should be the good offer from Wipro as compensation and band for a 14 yr IT experience with niche skillset?

Anybody joined wipro recently??
I have my onboarding this Monday on 1st August. How much time did it take for you to get the laptop??

And what type of joining kit you got ??

like

Hi All,

Can you like my post so that I can use the this platform?

Thanks in advance!!

like

CW salary at FB/Meta within the Creative X group? I keep seeing posts for copywriter positions that require 6 years of experience so I’m assuming even though they call it copywriter it’s more in line with senior / ACD agency salary.

like

Any Strategy& SM available to DM? Have an offer and would like to get some thoughts on the base, sign-on and bonus - negotiable? Also, bonus cycles and timelines etc?

like

Hello Fishes ,

Need an Industry average salary for Credit Analyst in Mumbai in Rating agencies

like

If someone recently got promoted in FIS Global let's say from P2 to P3, what approximate percent of salary increase you got?
Or i should rather ask what how much salary can we expect if Pay band increases here at FIS Global ?
Any inputs are appreciated 👍
Thanks.

like

Yay or nay on Deloitte Healthcare Ops? Anyone with feedback or experience to share? Thanks

like

Additional Posts in Consulting

Let's have a productive conversation about the Google employee who was just fired for his controversial diversity memo

like

Best consulting firms to target for Supply Chain & Operations Strategy apart from MBB after graduating from MIT SCM

like

Finally getting a chance to put together a home office space. Looking for tips, photos, ideas. I have two monitors and a laptop so my do a three screen set-up. Debating about getting a standing desk or putting money in a super comfy leather chair. Open to hearing what you have done!

like

Best consulting firms without the massive ego?

like

Y'all. My Uber driver's license plate is different from what it said it then app. AND we're currently pulled over on the side of the road at the ATM so he can get cash for the toll

like

What are some publications, books, podcasts, online classes etc that can help me prepare for my first year in consulting? Have 5 years of experience in finance and making the jump to consulting.

like

I'm almost at the point of an offer, and also just started a 6 month long engagement since my utilization was taking a hit. How do you fish recommend dealing with the situation once the offer comes?

like

Any book recommendations about human psychology / thought processes?

like

When can we do-away with the dumb liquid rules at the airport?! Just watched TSA dump over half my travel-sized liquid possessions...🖕🏼

like

Is MBB all it’s cracked up to be? Is it worthwhile or better just enjoying the ride to partner in big 4?

likehelpful

Anyone from capital one answer this question for me? Someone just tried to put in a referral for me and said I was already referred to a prior job, but I've never received a referral and if I did, I never received and email.

I even logged into my workday account and I don't even have an application.

like

Joining EY soon. Should I be worried about layoffs happening supposedly in June/July?

like

McKinsey & Company McKinsey & Company when does your PTO year reset? January, July, or a different month?

like

Is it recommended to get two full years of consulting experience before looking for a move elsewhere...for more comp (say to another Big 4, industry, attempt at MBB or FAANG)? Already have 8 yoe in the DoD space outside of consulting. And about 16 months of consulting exp

like

Here's a question I wish I never had to ask. Is it better to use the code for bereavement leave or just burn pto I'm going to lose anyway? Does it make a difference from a utilization standpoint?

like

I finally have an extra room to set up a home office. I’m looking at motorized standing desk, but there are so many options out there that it is overwhelming. What’s your recommendation for an L-shaped desk?

like

Watching Home Alone I see that I was taught a while ago not to fly AA..

like

I f&#%ing love thanksgiving week! Football, UEFA Champions, drinks, food, family, friends, etc

like

Looking for non- fiction book recommendations. I just read Shoe Dog and loved it.

like

Advisory manager training attendees...can't stop thinking about the oversharing dude! Laughed so hard I cried. Sad I didn't start recording him. Anyone think he was still drunk or something?

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