Which SQL language to learn for interviews? I learned postgresql for a while but realized that most of the interviews don't provide the option to use postgresql. Also, there don't seem to be many res-

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

Just learn standard SQL and you should be okay. Also, for what kind of job are you applying?

like

Whenever I think of SQL, I think of ANSI SQL plus platform specific syntax and constructs. Ultimately, I think of it as a declarative language — give me what I ask, don’t care how you do it.

However, T-SQL (Microsoft) and PL/SQL (Oracle) are more procedural languages (e.g., how to do it) that enhance the capabilities of a specific platform. For example, PostgreSQL allows for various procedural languages that can be used (e.g., PL/Python, PL/Tcl, PL/Perl)

You can know SQL but not necessarily the procedural language associated with a particular database platform.

Ansi sql

like

resources to learn and practice (pgexercises doesn't have advanced stuff).

Try HackerRank for practice. You can probably do Postgres or MySQL unless you want to specifically do something with Microsoft

Do you use SQL at Bcg?

Sql is always sql.

Adding to what d1 is saying, ansi sql is a (series of) standard(s) not an actual dialect of sql.

You still need to pick an implementation to learn. And most sql implementations do contain commonly used statements that are either not specified in the ansi standards or not (fully) compliant. Other times they may comply with certain versions of ansi in parts and other versions of ansi in other parts.

Coming back to the original question I think postgresql is a great dialect to learn. Oracle and t-sql are also good.

Related Posts

What’s the longest interview process you’ve been through?

like

Hello All

Can we list out important areas of SAP SD wrt frequent usage and interview perspective??

Mine will be...
1.Special business processes - third party sales, consignments, STOs
2.Configuration of Enterprise structure, Sales Documents.
3. Customer master and material master creation and triggering to 3rd party systems.

Please add...

like

Hello everyone,
Anyone here who have gone through the tech interview round with Mindtree on or around 19th November 2022 ?

like

Hi Guys,

I have completed my tech interview rounds with UBS and have received email for fitment round.

Can anyone share what happens in this fitment round on interview?
HRs have asked to submit documents even before this fitment round; which seems unusual. Is this normal for UBS and this is how they progress?

Thank you.

like

Hi, I am Data Analyst and I have an interview with TD for a Business Intelligence role that mainly revolves around creating Tableau dashboards. Do you have any tips or ideas for the interview?
TD

like

Normal to not hear from recruiter or hiring manager for weeks / month+ after conclusion on all interviews?

like

anyone who had h1b stamping in Toronto recently? how many bus days from the interview do they return the passports?

like

Would it be necessary to serve one month notice period in probation in FIS?
I mean , I wanted to serve complete one month of notice so that I could give interviews more and negotiate but there is no dependency on me so can they release me early or they will go with complete one month. ?

FIS - disappointed me in terms of tech , process, tools . will never join again.

like

Hi All,

I have 4 years of experience as a Salesforce developer.
Can anyone suggest good product based company for Salesforce developer.
I have extensive development experience on apex,Aura,integration. After after spending 3 years in service based companies, learning is very low pace now. So wanted to switch to a product based company.
Attend one interview in sirionlabs and got offered but not sure how it is.

like

Anyone from @Tide UK? I’m interviewing for a role and I’d need some help with the prep.

like

I am applying to more positions through staffing agencies as one way to get a writing job. When they tell me the hourly rate and I suggest a few dollars higher per hour, they'll say, "Just so you know, the competition is priced lower than you."

Is this to scare me into submission to charge less so that they can profit more? Or is an employer really not going to pick me because I am priced 1-$2 more per hour than someone else? Wdyt?

like

hr mailed me personally that i cleared the second round and called me,told about salary expectation.but didnt receive any official mail.should i get any official mail? how long it will take to get the offer letter?

like

Can anyone confirm that you can’t have two background investigations happening for clearance concurrently? I applied for an internship 3.5 years ago that required TS/SCI and is actively processing. My

Hi, what questions would you suggest someone ask an in-house or boutique firm entertainment attorney during an informational interview??

like

Anyone have any insights into working at Amazon Music specifically? Looking for cultural insights on the marketing side of the house. Actively interviewing but these reports I’m seeing about Amazon’s work/life culture are slightly alarming….

like

May I know, how many rounds of interview Deloitte has for the role of Data science consultant?

like

EY is applying for my greencard and I’m currently in the recruitment stage where the job is was posted for 30 days already. Whats the chance that someone applies and have to wait additional 6 months?

How to understand the healthcare industry in a few days? I am currently applying for a consultant role to help clean up a client’s books for the past 3 years. I have accounting clean up experience in the for profit industry and auditing experience for nonprofit but not including healthcare.

More Posts

Itna sannata q hai bhai?

funnylike

Anyone interested in below skills,DM for referral

Post Photo

Well ladies.. I went from getting dumped about a month ago for having ‘too much in common’ to literally so many men after me that I can’t juggle them. So wanted to give y’all hope. It can happen.

likeupliftingfunny

What would you do if the president asked you to be on the Coronavirus task force? Contd.

Post Photo
likefunny

What’s a median salary for a Senior Copywriter with international awards in Paris?

Firm with the Best work life balance and culture in M&A consulting?

like

Any guys in Chicago free during the week to grab drinks? Early 30s male here looking to make new friends. Typically like dive bars and hang out LP, Old Town, Wicker, Logan Square, West Loop, River N.

like

Hi Fishes got an offer can someone tell me what monthly in-hand salary can i expect.

Post Photo
helpful

Going in-house was the best decision I have ever made. Never going back to a law firm 😅😅

like

Industry-wide layoffs tomorrow or nah?

like

Hi fishes
I got offer from PWC for 14LPA. My CCTC is 9.6LPA. I am expecting more they said max we can give 14LPA. And I asked for JB HR said if I join soon then they can give JB. In my organization NP is 90 days.
My question is should i push for more salary? I am expecting alteast 16-18 LPA
My YOE is 10

Thanks

like

What is the average salary of a Senior 1?

like

anybody working in Saxo Bank Gurgaon ?
If yes hows the work culture and work life balance as a BA ?

Like

like

Deloitte PPMD - is it okay for specialist leaders to introduce themselves as senior managers (i.e on LinkedIn)?

Interesting post, given recent conversations here…

Post Photo
like

Self contained ASD room. Does anyone not follow school bell schedule? Do you start and end each hour like the Gen Ed kids ( 1st hr. 2nd hr. and so on)? If you don’t follow bells, how does that work for you and do you do anything different?

like

SO captured my big baby being extra sad that I was locked in my office and working late tonight ❤️

Post Photo
like

Additional Posts in Consulting Exit Opportunities

Anyone exit to a sports team? Looking at a business strategy & analytics role. Wondering about base pay, total comp, benefits

like

Hi all - any advice for trying to transition into Strategy from Finance Transformation? Would I stand a better chance by looking at boutique firms? I’m a SA with 4 YOE. Thanks for your help!

like

I get that PE megafunds carry weight on your resume/for mba apps - would experience at lower/MM funds be brushed over?

like

I am a technical program manager and updating my resume. For a tpm what are the typical numbers I can add to show achievements. For e.g successfully delivered 9 programs. any idea what are the typical success indicators for a tpm role

like

Anyone have insight to Deloitte digital group in US... considering a Cloud senior consultant offer from them

like

Would you wear a suit for an interview for a tech company(uber, netflix, snap)? Usually I wouldn't but this is for a finance/corp dev position so not sure if it's any different

like

Ex-consultant now in marketing. Used to be an avid follower here and got great insights on companies when trying to exit consulting so thought I’d try here for advice. Outside of FAANG, what are good large CA-based tech companies that provide good pay, WLB, and culture? DD has great people and WLB, but pay is low and you’re not given the tools and resources to succeed + truly make an impact. Google and Apple are ideal but need backups. Like is Salesforce still good? A company along those lines.

like

Which level in consulting opens the most exit opportunity doors? (C, SC, M, SM, etc)?

like

Anyone here at Lippincott? Thoughts? Advice on interviewing? Looking at the SF office specifically

like

When to put in two weeks notice? I've received and signed my offer letter- best practices to wait for background check to clear?

like

How did you know when you needed to leave consulting?

I never had anxiety before, but am increasingly dreading work in the morning (people are great, just the pressure takes a big toll). Took a month long mental health leave and am still in the exact same boat. Maybe it’s time?

like

How long does it typically take to hear back after a final round?

like

Hi all. I was laid off a few months ago.I have less than one year of experience. Would I be able to get another consulting job with less than 1 year experience or only apply to analyst/consulting job?

like

I have an engineering background, graduated last December, and accepted MBB over FAANG (product design & manufacturing engineering offers) . This bowl’s focus on exiting consulting into FAANG (cont)

like

EY fish, if I’m about to start interviewing for a role, but see another role I’m equally qualified for, could I still apply? Interviewing for FSO but see a role that I think is just PI.

like

How should I answer the question “what are your professional goals?” I don’t even put that much thought into why I’m a consultant. It was just the path of least resistance and it feels like a good enough fit. Do you guys have professional goals?

like

Is LinkedIn absolutely necessary in finding a job?

like

Has anyone paid back their sign on bonus when quitting? Did they allow you to pay it back in a repayment plan?

like

Any advice on transitioning from big4 strategy/ops trans to MBB strategy without an MBA?

Does anyone have any perspectives to share on RELEX Solutions? I have been contacted for the Senior Manager role (London based)

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

Send download link to your phone

OR

Scan your QR code to download
Fishbowl app on your mobile

By continuing you agree to Terms of Use and Privacy Policy.

Messaging rates may apply

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