Related Posts
Can anyone at Amex share my resume in their team to directly start the rounds of interview? I have tried for referrals through linkedIn and did not recieve any call from the HR.
29th Apr is my last working day in my current organization.
Tech stack: SQL, Tableau, Python, Excel, Powerpoint with more than 4 years of experience. Currently have an offer of 23 LPA fixed. Fixed anything above this or equal to would work. American Express American Express India Campus American Express Global Business Travel
#cgi is looking to hire experienced #seleniumautomation engineers
Experience: 2+ years
Location: #hyderabad/#bangalore
Notice period: 0 to 60 days
If you think your profile matches the above requirement, then please feel free to share your resumes with me at
saikiran.palugula@cgi.com
Kindly mention your <Experience>, <Notice period> and <Position name> in the email subject
More Posts
Additional Posts in Data & Analytics Consultants
Are there RPA use cases in data work?
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.