For an interview a basic qualification was to know very basic R and SQL. What is a basic thing I can learn to be familiar enough? Just had to be something very simple.

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

Question is not very clear? Do you want to know how to get basic knowledge of SQL/R or other skills that are easy to pick up?

like

Gotcha, I highly recommend courses on Udemy (or perhaps other places). Usually at B4 you can get free access to those courses through corporate account.

For SQL, I did a course: the SQL bootcamp - from hero to zero. Great tutorial and hands-on. You can stick to the basic modules and not bother about the more complex ones. In total it takes 20hrs but with 5 you can get by.

For R - do some research, not sure which ones are good.

All of the resources you’ve been provided on this thread are great starting points. However, since this is for a job interview I’d suggest going on to HackerRank and attempting some of the basic/easy SQL problems. Depending on the company you’re interviewing with, if there is a SQL test, it might be in a format similar to this. Good luck

like

For SQL you should know how to make, delete and join tables at the most basic level. As well as query a table using WHERE clauses. Look at W3 School to learn these points

For R, you should know how to assign variables, generate data frames, and perform basic manipulation of the data frame to perform calculations (think sum, concatenation, updating, etc. )

W3 schools for SQL

W3 Schools lol

Sound like more of a data literacy point.

Types of joins and data formats should be enough. Specific syntax can be googled when needed.

Related Posts

BCG🐠 how long is the cool off period for a fresh application if I didn't get to the interview stage?

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

How far in advance of when you want to leave should you start talking to recruiters?

like

I was asked in pwc sdc interview to come to bangalore location once i get selected. Can i still request for wfh?

How much time does Infosys takes to share the offer letter and proceed with documentation and stuff. I have cleared 2 rounds of interview and still waiting for HR to contact me.

like

Hello all,

I have an Interview with Atlassian for a pre sales solutions engineer role in Canada that requires 5-8 YOE . What's the salary range I should be aiming for ?

like

Does anyone have any tips on how to reach out to a recruiter? Is it weird to just email someone I found online with my resume?

like

Guys, I interviewed at amex gurgaon 10days ago and was told by VP that I will hear from HR very soon. But when I checked on HR yesterday, she said interviews are still in progress and it will take a week more to finalize.
I want to know do they take this long to close a position? This opening was posted on 30th Sep.. It's already been 1.5 months. This is when they said the position was urgent!! 🙄

like

Looking for a casing buddy! Fairly new to casing and come from a science background not business. 2nd round BCG interview coming up. :)

like

Got update from UST like cleared 1st round. Is there any other round or HR round is L2 ?.

like

How long after interviewing for a lateral position would you expect to hear back?

like

Hi do you interview from time to time just to check what’s your market worth?

like

I have first round next week for full stack developer profile. It is going to be a coding round. What kind of questions can I expect? DSA and algorithm only?

like

I have been in production for 10 years but all of it has been done through my own production company (which was basically just me)

Should I just list the relevant projects instead of saying I have 10 years experience as a Senior Producer or Executive producer on my resume?

like

Hello Fishes.. I had applied for a position and had completed the cultural assessment. Received an automated mail that said “we will be in touch soon”. It’s been more than 20 days and haven’t received any communication. Should I expect any reply now? What’s the usual procedure like?

Hi guys, I am a systems engg in TCS with 3 years exp. Technologies known: C, C++, Java, COBOL, Oracle DB, SQL, Unix/Linux, Shell scripting.
I had applied for Infosys in the company portal long back, but haven't got any replies yet. I am looking for the Developer/ Production support roles.
And I am in my notice period, lwd is 27th sept.
Also, have an offer from L&T with doj 29th Sept.
If any one can help me out with a interview referral, it would be great.
Thank you

How much of the buyside recruiting process is dependent on your school? Like if you went to a non targ but were top bucket, will you still lose out on interviews to Ivy League grads?

like

Wrapped up 3rd interview (including initial HR call) on earlier this week Director… when do you think I could get a offer?

like

Had an interview where they asked about salary. They asked what salary I was expecting and said that they pay 6 figure salary and I responded that I’d be happy with 6 figure salary. Would that mean they won’t offer me more than 100k?

like

I have 2 years of sales experience but am looking to make a career change into HR? Any tips of how to standout on my resume or any general advice? Thanks!

like

More Posts

Our agency received two Cannes Lions this year. Neither piece of work received even a merit at Hatch. Someone hates us.

likefunny

Has anyone successfully pursued a relationship with someone they met at work? An MD I am really attracted to has been chasing me, but I am nervous about what the repercussions could be if it doesn't work out. Still, it's tempting

likehelpful

How long does it take for Deloitte Fed to followup after an interview?

Trying not to drive myself nuts waiting for the followup!

likehelpful

Have anybody come across cognizant retention? Will they release offer after Head approval and HR processing? And how long that the process take? Please share your exp if any and how much salry they matched with your offer?

like

Pwc India : 9.2 Lpa fixed
Cognizant : 9.55 fixed
E&Y India : 11 Lpa fixed .

Where should I join ? Please suggest. PwC Cognizant EY SAP

SAP ABAP

like

RIP Jeff Immelt. Not sad to see this guy go.

like

Will production even be fun when we go back??

like

My company covers in depth results each week, including meetings set/attended, wins, revenue, retention etc. I feel as if evaluating in such depth is detrimental to the psyche, as you never get to “ride the high.” In addition, some weeks are simply slower than others, and it’s not always representative of what the results at the end of the period or quarter will be. Is this not a big deal, and I’m I placing too much importance on it? Or is it beneficial to review results less frequently?

like

Why do we pay tax at all if the Fed can just print $$$$ from thin air?

🤔

like

Any PwC manufacturing folks here (Reliability/Maintenance or Prod Development). Looking for referral and also some advise on level (Mgr v Sr Mgr).

like

I’d to get a job in a small architecture firm or work for a developer to help build up my network. For the past 6 years I’ve taught high school architecture and engineering and done real estate on the side. I have an industrial design degree and tremendous construction and real estate sales knowledge. I also started architecture school but stupidly switched to industrial design. I don’t want to go back to school for architecture. Ultimately, I want to own my own company developing real estate.

like

Hi! I've worked as PM/Sr BA/PO in the past, have 5 yoe. Then was called for military active orders for one year, and now trying to get back into the civilian world. I'm looking for product management jobs in Irvine, CA or remote!

I have a product manager interview with PwC next week and was wondering if anyone had any tips? I heard the interviews at Consulting firms are a bit different. Any advice would be greatly appreciated! Thank you!

like

Has anyone recently done visa stamping in India (Mumbai center) through Dropbox? My appointment is in 3 weeks and I heard of one occurrence in Mumbai where the candidate was delayed by 2 weeks (still waiting for his papers).

like

Hi, just got an offer for an L5 and could use some help negotiating. I’m located in LA.

Base: $180k
Equity: $164k
Bonus: $36k

Thoughts on whether base is fair? How much can I request as a sign on bonus?

Thanks so much 😊

like

Any book recommendations for philosophy, psychology, and business? Or any book you read last year changed your values? Going to fly international, gonna read it on flight. 😍

like

Any Insurance Broker Account Managers in Oklahoma (Health/Life/ Employee Benefits)? Would you be willing to share your salary information and any information about your work load/the amount of groups you manage and their size as well as your years of experience? I’m trying to determine if mine is comparable to what others receive. Thanks for any insight!

like

Lwd is 6th of Jan in IBM. Can we return our laptop via courier ?

like

Does the electric cord of liberty spark in your heart?

funny

Additional Posts in Consulting

Is it easy or at least possible to move from federal consulting to commercial?

like

Murray Christmas - From EY

Post Photo
likefunny

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

Any recommendations on reliable home office printers?

like

Bain & Company Which are the best consulting firms and practices for Climate Change & Sustainability, especially in the Canadian geography? Also, please suggest the best Canadian city for consulting jobs.

McKinsey & Company | Boston Consulting Group | Bain & Company | Kearney | LEK | EY | Oliver Wyman | PwC | Deloitte

#ClimateChange #Sustainability #Water #ESG

like

What are the best consulting firms for pricing (consumer goods focused)?

like

Consulting to buy side (public investments, hedge funds, mutual funds, etc outside of PE) - anyone heard of people doing this?

like

Anyone have any recs for self help books? Looking for more relatable topics to myself I guess?

like

Any book recommendations for philosophy, psychology, and business? Or any book you read last year changed your values? Going to fly international, gonna read it on flight. 😍

like

Which top consulting firms, if any, will pay for your MBA?

like

What are some great behavioral or conversational skills you noticed in good communicators / team leads?

like

Anyone at Capital One willing to chat and refer me? Dallas office!

like

Poll: What dress code do you follow at your home office?

At what point do firms legitimately start considering shutting down? Almost impractical to expect staff to continue without impact

like

What’s the difference between Op Model work & Org design work?
And between Op Model work & cost cutting work?
Starting to understand these terms, but want to understand them in relation to each other

like

Top consulting firms in the aviation / urban air mobility space?

like

Best place to work in Newark airport for long period of time if you can’t afford a lounge pass?

like

Looking for some material for a crash course in IT strategy consulting - books article etc. any recommendations would be appreciated

like

If I had a traditional IRA before being employed in a 401k eligible role, can / must I roll that IRA into the 401k or can I leave the accounts separate without deleterious tax consequences?

like

Best books on leadership and self development?

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