Hey folks, looking to get more exp. with complex SQL queries like aggregations, ranking, etc. Currently use it daily for simple table queries, joins, etc., but nothing beyond that. Any recommendations for sites other than Leetcode and Hacker Rank?

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

StrataScratch is a good platform too

like

It's Great 👍

like

Is it for learning or practicing purposes? For learning, there’re lot of courses in the internal platforms. For practicing, HackerRank is the most useful for SQL. Leetcode is hard to sort SQL questions

like

+1 for stratascratch

like

+1 to your +1 stratascratch definitely helped me study to land at Meta

like

Which project at Deloitte writes SQL? I am new

like

@D2 Yup, and rank, dense rank, having, etc.

You're looking for window function tutorials there's a million out there, a few great ones on YouTube with downloadable data and follow along code

like

Serious SQL by Danny ma is very good. One time fee for a lifetime of materials. He gets deep

like

Related Posts

How do we get others to join Fishbowl? There are currently only 15 of us from the company and we have about 2000 employees now.

like

Any referal for UK - Data warehousing or Data Management space or Data Modeling?
YOE - 11+

like

Hi guys,

I've completed my online assessment for
Accenture . How long will it take for the team to call me for further process? Accenture

like

How do you properly vet a law firm? I feel the associates I speak with talk up the firm and aren’t always candid.

like

Anyone know of any Cannabis clubs/groups in Houston? DM me please

During a 90 minute model test are you typically expected to build out the full pro forma B/S?

like

Can someone suggest me which one is better.
Senior Associate in Cognizant or Senior software Engineer in TSYS.

Both are providing almost same CTC.

like

Does anybody know anything about international secondment opportunities from KPMG India?

like

Accepted an offer for an internship from a company but the second company I was interview with offered me a job a week later. How do I politely decline the first job even though I’ve already signed the offer?

like

Can you leave as an A2 to an audit client that you’re not on the team

like

Approval chances for the CSR, given credit score of 760, income between 75-85, and small student loan <5000? Only had 1 card in the past but never missed a payment. Avg length of credit history is 2yr

like

My boss asked me to take care of some of the details of a project for her—the stuff that isn't really my area of expertise. And now I feel like a shirker because I haven't been able to finish them yet.

like

Hi folks. Going to join Thoughtworks as a senior consultant soon.

Want to ask so they give any goodies to new joinee? Or even to existing employees? If yes, what do they give? Excited to know these little details.

Yoe : 8
Ctc: 29

Hi!

I recently did a job interview and I made it clear to the HR my expectation salary is 60k a year, non negotiable.
Today I got the job offer and they are offering me 54k. My current company is making me 50k with tons of benefits which is why I am asking for 60k.

Should I accept the offer or renegotiate?

like

Hi all,
I just moved here so this might be a dumb question so please don’t judge. Why does my laundry smell like pee and how can I fix it? I used a common washer and dryer in my building. Is it because of that? Is it mold? Is it the water? I air dry my workout leggings and they all smell really weird and I don’t know what to do 😔

like

I am working as a technology analyst and have 5.5 yrs of experience. Currently I am working for application support with java Spring MVC as a technology. I am eager to switch for a better prospect. Please do advice. Any referral in this regard can be of great help. Thanks in advance!!

like

After accepting EY offer do I need to send the screenshot for last working day mail and resignation mail to HR.

like

I am currently in Retail Project Management (coming up on 2 years) right now and am looking to make a shift into real estate finance. My degree is in finance, and I am really looking to pair that degree with my passion for real estate investment. Any suggestions on how to make the transition? I am just concerned on how to sell my current experience to a finance-specific role. Any thoughts and comments are greatly appreciated!

like

Additional Posts in Data & Analytics Consultants

from God import pandemic
From China import coronavirus, mortality_rate

covid_19 = pandemic.coronavirus.set_mortality(mortality = 1.)

like

What is a data lake in basic terms?

like

What’s so good about the Georgia Tech OMSC and OMSA? Is it just the cost? Seems to be recommended by most of reddit

likehelpful

When industries refer to business intelligence engineers, are they looking at a senior level or entry level? Some of these job descriptions seem rather outlandish in terms of years of experience required like 5+

like

What’s the best/simplest way to understand Sets vs Groups in tableau?

like

Business practice: "can you guys build a model that overlays where Coronavirus is going to break out with client sites"

likefunny

Docket + R - I have an container running a rocker image and I’m trying to launch a bash terminal and the RStudio server (/init) at the same time. Is this possible? I tried adding CMD [“/init”] too.

like

today I choose violence

Post Photo
funnylikesmartuplifting

Hey, was wondering if anyone would be able to give me a referral for McKinsey?

like

I need to do a timeline with lots of information over a long period of time. I wanted to that in Tableau, but partner will not pay license and data is sensitive so I cannot use Tableau public.
Do you have suggestions?
The requirements are the following:
- No online input data upload (so local editing)
- The produced output file must be local and easily exportable and readable
-timeline must be interactive (filter/click/zoom in/out/view detals etc.)
- free

Any kind of help is really appreciated

like

Big 4 Data Scientists, how did you exit to big tech firms? I’ve been unlucky with online applications and even referrals. I think it might be my resume or how I present myself. Can any free birds please give guidance?

like

Anyone have recommendations on the best app/site to learn Python? 🐍
I’m a complete beginner.

like

What are the top sales & marketing metrics that tech companies track? I have an interview for a Data architect role and the data aspect is my strength but need to brush up on the business insight part

like

What is the best way to handle group financial consolidation in a multinational company?

like

Hello, Anyone here from Deloitte Omnia AI who could refer me for an open opportunity.

like

1) Hypothetically if you were looking to sabotage a colleague, can you code an excel document to throw off their numbers or calculations, (if you send them that document and they download it for use)?

like

What tech companies are best for Data Analysts? Looking for $120k base + equity that’s gonna be worth a lot + other great benefits + possible remote.

funny

Is 128k a fair base salary for Consultant in Deloitte Analytics & Cognitive. MS CS and about 3 yrs experience. In one of the fastest growing but midtier tech cities in the US.

like

Noob question - I want to consolidate the dates into a single dates column. Would numpy or pandas help me reorganize this dataset effectively or should I do it within excel?

Post Photo
like

My manager continues to ask me to help other teams and do work on other billable projects. I’m sick of it .. and I’m going to explicitly say that no I can’t do it because my hours are taken by the existing project we are doing. Is this appropriate?

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