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

12/9 check-in: Happy Friday! What are everyone’s workout plans for today?

likeuplifting

Is it common to have renters insurance or do most renters not have it? The questionnaire for a quote is super detailed...

Houlihan Senior HCOL salary?

like

Any thoughts on horizon therapeutics and their pipeline?

like

Hi, Would be great if I can get referral opportunity for ETL testing opportunity.

Experience : 7.9 yrs

like

Why for Account Management there so many interviews?? why 4 or 5 rounds??? It is only sales???

like

Does salesforce have significant presence in India?

like

We recently sleep trained our 7 month son. He went from waking up multiple times during night and taking only 30 minute naps 3 times during day (most cases nursed to sleep or rocked to sleep or took a drive) to sleeping 12 hours at night without interruption and two 2 hour naps and one 45 minutes nap during day. We both love that he is getting enough sleep and well rested on one hand. On the other hand, we are now wondering if he is sleeping way too much.. contd…

like

I have been an associate for 13 years and make $200k. Seems like this is slightly more than what most firms pay. Am curious to hear how much people with a similar number of years’ experience make

How long after bonuses hit should I give my two weeks notice? I have a new job lined up and bonuses will be paid out on Dec. 20th.

like

Does anyone want to help this group flourish? I'll add you as an admin so we can really get this party started.

Post Photo
like

Billable rate jumped 11% once our fiscal year began July 1…. Smells like a raise??

likefunny

Exploring use of Lexpense, Inc, litigation support services company for case valuation, litigation expense forecasting, funding, and vendor payment. Anyone use them?

like

For those of you working in a nursing home facility, what type of COVID protocols are being implemented there?

like

Laid off with 1 YOE. Do I include college Awards / Extracurriculars (have just one line to list each right now) ? How about SAT scores?

like

I’m ready for work! 😻

Post Photo
likeupliftingfunny

What's the retention rate of PIP candidates in Deloitte India?

like

Additional Posts in Data & Analytics Consultants

Is anyone working on a cool real time data analytics project in the health field? I am trying to figure out where to go next.

like

Anyone heard of Fractal Analytics? What kind of work do they do? Good enviorment? Asking for a friend...

BCG Gamma folks,

Are you happy with the work you are doing or getting?
Or are you planning to move?

like

Any data science product managers here? I want to know what a day to day of a product manager in data science looks like. Wondering if that's the path I should consider

like

Anyone with experience with requirements gathering have good templates they would be willing to share?

like

Which are the top consulting firms in UK to have great mentorship, learning and development as an entry level business/data analyst

like
like

As a data scientist with knowledge of Java, Python, and R, what are some interesting languages for me to learn? I keep hearing software people in my circles talk about Go and Haskell. Do you think learning one or both languages could be useful for my career?

like

Have you guys tried turning Wumbo on in Tableau? Really takes that data viz to the next level.

likehelpful

Anyone have experience with DataRobot? Just got a great DS offer from them but seeing some red flags in WLB/culture ...

like

Isn’t Pascal’s triangle just a visual tool for seeing combinations of items in sets?

like

Graduated from undergrad with BA in Accounting 3.7 GPA, I really want to get into FAANG or analytics.

Any suggestions?

I just interned at a mid tier firm and have a Big4 Audit Associate offer.

like

Is learning how to build APIs useful in data analytics?

like

Does Deloitte offer SC role(Applied AI)to someone having ~2 yoe(ML C). Had an onsite recently, went really well. Recruiter told me you are very close to SC but we can offer Consultant level to you.

like

Let's say I'm a former analytics specialist who left the field several yrs ago for a top 10 MBA and strategy consulting at big 4. How would I parlay this into finding *non-tech* AI/ML/DS roles like strategy or product?

I don't want to use R/SAS/etc daily again, but many places either want me to be a DS/engineer which doesn't suit my interest, or require more recent technical management experience, which I don't have.

likehelpful

If I have 12 months of sales data for a product and have 36+ months of sales data for other similar products, how would I go about forecasting sales to incorporate the newer products 12 months of historical sales as well as the sales data from the similar products? Any techniques or methods I should read about? TIA!

like

Georgia Tech Online Masters of analytics. Thoughts?

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