Related Posts
Hi Sharks,
I just wanna know a small information one of my friend got selected for Microland ltd as Associate business lead Finance,
Can anyone give me insights on the role and company
I was checking these details online i have mixed reviews can anyone comment ?
Mains doubts on these 3 topics
- work life balnce
Working culture
Financial growth
More Posts
Average London Producer Salary?
How much Salary IC3 gets in Oracle (SMTS)?
Arey kidhr gaya mumbai ka spirit 🤣
Additional Posts in Consulting Exit Opportunities
New to Fishbowl?
unlock all discussions on Fishbowl.



Drop prd.fact_customer
D3 I'm self taught SQL on the job and now I "own" the database, but I have no real context of my actual skill level to her than I'm still learning something new everyday.
When you say hard in reference to windowing and ranked partitions is that just because that would be hard going in cold in an interview situation, or because that really is high level stuff. I write window and rank queries about ever few days when solving a new problem.
I Don't mean that as a brag, my schema understanding is for crap because I just haven't seemed to need to use it. But I did completely rewrite our ETL from scratch to eliminate tons of technical debt too and horrible performance choices ... My predecessor didn't now the meaning of sargable. 😫
I'm mostly just wondering if my SQL skills are more marketable than I thought
Omg. Selecting records of data from a table
Practice your sub selecting. How many distinct users were logged in between 10am-11am on any given monday in Q1? If you can grapple this, you're good.
The harder sql interview questions will probably be using window functions and ranking partition etc
DROP TABLE. Always use this command.
Appreciate the sarcasm though 😶
You will be given a rdbms structure and will be asked to write a query to answer quick business questions. Example.. how to find all new customers in the month of Jan through email email referral? You will have to write the query and provide additional insights about the scenario.
Yeah I think ey1 has got the general idea. Something like, given a few tables and a specific customer id, create a query to find all of that customer's orders within a time frame or other restriction. I don't think you should be asking for use cases, that'll box you into a specific way of thinking. Just try to approach it from how to generally use SQL if that makes any sense. Good luck
I joined a mid size tech startup and took SQL knowledge for granted. When i was on projects at D, all the data was given to me in csv, but at a tech company you literally ave to pull all your data through sql and grab different kinds of data from different schemas.
I know the queries, but looking for actual use cases since interviewer told me they’re mostly logic based. Thinking it’s more like joining tables
Customer 360 view...personalization and behavioral analytics. Marketing segmentation and user profiling
Guessing: go get your data