Hi Fishes,

Can somebody please recommend a good resource to learn SQL from the basics to the advanced topics like window functions, advanced joins, etc ?

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

It's a pretty simple language so go for any of the basic sites - W3school, tutorialpoint etc. and try some hands on questions from hackerrank or any other thstat lets to do some mock practice as a good start. You would get plenty of opportunities on your project anyways. As long as you are logical, it should be a matter some couple of months to get exposed to the most of problems you would have to solve for the clients. In yhe long run, its just the same concept of bunching modules and building your business requirements through SQL.

like

Thanks for the reply ZS1

Or from in-house learning platforms too! 😅

like

Related Posts

Those of you who have left consulting for Program/Project Management at tech companies (not Product), what do you think of the switch? Have heard anecdotally that work can be uninteresting and career progression suspect, but seems like a very chill, high paying exit. Does this differ greatly if it is technical PM? Would love to hear thoughts.

like

I have an offer from Capgemini Invent (senior con) and Infosys Consulting (business consulting). Offer almost same.

I am Looking for good learning opportunities.

Any one working in IT M&A /PMI vertical of Capgemini invent please give me your reviews about the work and the quality of projects.

Anyone working in Infosys Consulting SURE COE, please provide your reviews about type of projects. Are all projects in delivery or anything in advisory side as well?

Non tech/ management consulting

like

I’m a former educator that has transitioned to working for a SaaS company. I have been hired under one role but have been managing projects in design UX/UI, content management (auditing and process development), and governance (currently working on a bot project). I certified as a scrum master but I’m having a hard time finding a Scrum position. In transparency I have been in the field about 2 years. Any and all suggestions are welcome and encouraged.

like

Trying to transition from accounting to functional consulting for ERP. Any good process to make this move? Any particular requirements ?

like

Unfortunately the US CPE course that i pursued was same as the course that i did last year and hence i didnot get credits and became NON-compliant as of june 2021. Can anyone please advise on what to do to become compliant?

like

What’s a good out from RA? Thinking about moving away from audit/accounting

like

I have been having a few emails exchanges with a recruiter and he said that based on my experience, I could start as a Level 6. What is this? Is this truly a SM role? Is this a consulting role?

Have you all done any certifications related to QA? Is ISTQB foundation + advanced Test Automation Engineer certifications worth the money? Together they’ll cost around 13K

like

How did you get into tech recruiting, and are you happy with it?

likehelpful

Hi Guys,

Switching companies...is better to go for lead ba role or for scrum master?

CTC is the same... looking for insights on growth career wise ,work pressure and learning.

YOE:4.5 as BA

like

I am looking to change my career from agency to product marketing or management. Are there any tips or anyone I can talk to consider making this transition? Thanks!

like

Hi Everyone! I'm looking to transition from healthcare consulting to pharma / biotech preferably in BD / corporate strategy roles, especially in LA area. Would appreciate if you can share your experience if you have made the amas transition (roles? Work type?). Looking to get a sense of what type of work exists out there.

For context, I've a PhD in Life sciences and 1.5 YOE in healthcare consulting at a boutique consulting firm

like

Marketing leaders at startups: at what point did you make your first dedicated product marketing hire? What lessons did you learn? Did you do it too early? Too late? Didn’t hire senior enough?

like

Can anyone provide advice or guidance on where to start to get into a career in project management?

like

I have an interview for a role in Quality, specifically ER. I have no ER experience but have med surg, oncology, home care, and OR so I was just planning on talking about how all my previous RN roles have involved process improvements. Any other helpful suggestions?

like

If I got a manager for employment claims’ position is it hard to pivot to an associate counsel role etc? What do you think the main difference between the two are? Is it a good position for a stepping stone to in house counsel?

like

Ust vs Nagarro vs Cognizant, which one is better for 10years experience Nagarro IBM Cognizant

like

Does having a masters in graphic design, fine arts or advertising benefit you and help you move along in your career? Or does knowing the right people and type of company help you move along?

like

Taking FAR soon! Currently reviewing the book and wanted to see if y’all had any advice on what modules/sections to cover more then others? Been hearing Gov/NFP is a big one. Anyone care to share what the exam was like for them and what it mainly covered?

like

Was having a chat with a recruiter who does a lot of work for me so out curiosity I am interested to hear what do consultants look for when they are moving into the industry.
- What are some of the key elements you look for vs deal breakers?
- What types of firms and industry are of interest?

like

More Posts

Coding in college vs. coding with consultants

Post Photo
likefunny

You can be not nice or not smart. Pick one.

Post Photo
likefunny

What’s going on with the stock market today?

like

Wednesday 3/14 FYI Island Visit thread

Comment in the below format if you want visitors or are looking to visit an island.

like

Just got divorced after being separated for a year. Any suggestions for places to go and meet new folks?

like

Do you tell your boss you’re going through a breakup? I’m phoning it in and obviously going to be camera off for awhile.

like

Holiday gifts for your study group? Yay or nay? In an Exec program if that helps.

like

I believe improving one’s sales conversion rate is something everyone want to improve but no one wants to admit they would like to work it. Funny how lawyers will spend thousands on seminars to improve trial skills. But this topic is not discussed in our profession. I have read books in sales. But am unable to find any for lawyers. I want convert every lead I can. Does anyone have tips, books, cle’s or studied this topic?

like

Lets discuss hike and bonus %- mine- 20% and 15%

Hi team, thanks for joining lets grow together.

like

Small law firm in Westchester, NY looking to bring on 2 associates (1 litigation 1 transactional). having difficulty finding the right candidates and interested in engaging a recruiter. Just looking for some direction or recommendations. Appreciate any guidance- thank you,

like

What do you guys think about this milanese strap? Waiting for a rubber strap to come in and putting this on in the meantime. I’m having a hard time deciding if this is dressier or not vs the original. (more pics in thread.)

Post Photo
like

My BGV is in progress for JPMC. I got mail to upload experience/relieving letter. I still didn’t get the relieving letter from my previous company. Shall I upload resignation acceptance letter for this?

like

Hi guys

I applied for 2 position at a time in jp Morgan career portal . That's fine ryt?

Or we can't apply for two roles at a time? Any idea guys?

like

Deloitte audit Vs. Grant Thornton Tax. I have an offer from Grant Thornton and From Deloitte as an Intern this summer. Deloitte is the bigger name and pays a bit better but Grant Thronton has way nicer people and known to have a way better cultre and work environment. What should I do? Where should I go?Deloitte Grant Thornton

like

Hello Guys,

I joined
Cognizant recently, the project interview calls which I am getting is not from my base location.
I have the location constraint, should I wait for the right opportunity or raise this concern to ADP team so they can look in to it?

As per ADP policy, one should not have any constraints and take the project as FCFS basis.
Cognizant

like

Sunlight Financial please refer me
I'm having 3.5 experience in angular + .net core

Seeking a sublet / pied-a-terre situation, ideally in manhattan near soho. 1-3 weeks every 1-2 months. I can give more details via DM!

like

Additional Posts in Consulting India

like
like

Any Delhi people here who can provide a guide to do wedding shopping in Chandni Chowk.
I am trying to find a good wedding lehenga below 50k. Preferably a copy of Marwa couture 😝
Any suggestions would be appreciated. 😁

like

Hi, Please help me to choose company asap in terms of work culture between
1)Impetus technologies
2)Concentrix Catalyst
Technologies:- java, spring boot, microservices

like

Any one from Simplify healthcare can I get some insight on the salary I can expect as a certified business analyst 2 YoE - salary negotiation at Simplify Healthcare.
I am going to ask 9.7 to 10.7 is it justified ?
Simplify healthcare

like

What should be our CTC to get 100000rs as monthly take home?

like

Can someone refer me to Volvo or Boeing for SAP profile ??

What are some of the indications that a person is depressed?

For the past few months, I pretty much kept on overthinking all the time, I don't feel like working & not able to focus on my work etc. My productivity is getting hampered.

Trying to complete a personal project before applying for new jobs, that is also not being completed. Just scrolling LinkedIn, searching for the jobs wrt my skill sets & saving them. Being reluctant to update my resume and apply etc.
Please share what do you think

Hi Guys, I've been working as a salesforce developer for 2 years now and thinking of switching to a PMO role. Is there good career growth? Are PMO's in demand? What do they do exactly? Would the experience be helpful to become a program manager in consulting or Tech post MBA?

Hi Fishes,
Anyone from Sopra Steria/EY/Deloitte/KPMG? Please let me know if there are any opportunities or if you can refer me for Power BI/SQL role.

Yoe - 2.3
LWD - May10

Thanks

Guys, how is DHL IT Services? About work life balance, yearly hike and benefits?

like

Is associate PM and junior PM Same level

like
like

What could be the in-hand salary???? It's for Infosys

Post Photo
like

KPMG Hello everyone, Is it possible to get an onsite opportunity with 3 years of experience as a servicenow developer? Tata Consultancy Ddeloitte@kpmg@infosys@capdeloitte@kpmg@infosysCapgemini

like

Hi Folks,
A funny question may be but would you guys have an idea of the usual age till which an employee can continue working in IT?
I'm sure nobody can work till 60, companies mostly ask employees to resign before that.

like

How are you all clearing online coding rounds?

I'm facing quite a lot of difficulty in companies like PayPal, Paytm.
I'm finding it quite difficult. I have started practice on leet code, but it's just too much to go through along with other things in life.
Do people getting 35,40 LPA are also facing such questions in interview?

Java background for senior development positions.

like

Hi fishes,
Have you guys ever been told to take break because you don't have the same business understanding/Knowledge as your lead/team member? 😬

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