Related Posts
Fishes, need your honest advise - I have 40 days left with Notice period and no job in hand due only 4-5 months of relevant experience and total yoe- 3.10 years. Is there any chance I will get the job in next 40 days due to immediate joiner? Or give me referral please
Skills: ReactJs
Tata Consultancy Accenture Infosys ZS Associates
Any openings for SAP ABAP ,YOE -2 ??
Hello fishes
Being Scrum Master what are the requirements from Capgemini or Clients to put me to Onsite role? (Either it may be Certifications, Qualifications, External factors or any challenges anybody faced surprisingly)
Please help me here to understand, as there's discussions going on and I don't want to let go this opportunity!Capgemini
More Posts
Please help me with In-hand salary :
What inspired you to join this industry?
Countdown... beginning now
Additional Posts in Data & Analytics Consultants
New to Fishbowl?
unlock all discussions on Fishbowl.
Nested queries, window functions.
Try to get involved in SQL coding within the context of your work. Taking these dumb online quizzes kind of encourage short-term, rote memorization. As an interviewer, it becomes immediately apparent that somebody hasn't used this professionally.
Honestly, if you're looking to grow within this industry, you need to look beyond that interview and realize that SQL is a core skill that you need to develop. Nobody is really interested in data scientists that can't obtain data correctly and efficiently. Having to support a >$130k/year employee with additional team members to query data is a losing proposition as well.
Honestly, the algorithmic coding is extremely easy nowadays with so many point-and-click frameworks, code samples and forums, and the general availability of libraries. SQL is probably going to occupy half your time.
Aggregate functions. Focus on them and know them. That is the key divider I have found in SQL. Those that can do and understand aggregate functions and those that can’t. After learning those, you can learn anything by looking it up (CTEs, loops, etc.)
Bowl Leader
Practice practice practice. Then practice more. The concepts are basic once you list them all out and think through them, but getting relations and syntax you never use quickly and right is basically muscle memory. People don't naturally think in self-joins.