I am giving interview for data analyst roles and the level of SQL which is being asked is like above anything and I am making a fool out of myself in front of interviewers. General W3schools or resources are not serving the purpose. Can somebody help me how can I prepare well ..

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

2 YouTube channels: kudvenkat and tech brother amir
1 platform for practicing: data.world

like

Brush up basic concepts. Practice questions based on complex nested queries and window functions. You can also try leetcode medium and hard level problems.

like

Conceptualize a problem you want to solve in domain of your interest.
Browse through the datasets uploaded by others and add them to your workspace. You can add datasets of your own as well.

Use the SQL.editor in the workspace to work with multiple datasets, like you will in real world.

Hope this helps :)

like

Not the most conventional approach
But just how I'm trying to do these days:
Find a good book on SQL (eBook maybe)
Get through the concepts in same order
Understand concepts of window functions, CTEs, Aliasing, these are like the norm these days
Then, jump to leetcode SQL
It can be harsh to a beginner but once you tackle the big waves, everything else will seem supereasy
All The Best

like

Related Posts

Hey everyone, I have my first interview coming for Project Management role at Meta. Any tips or recommendations? Does anyone know the layout of the interview?

likehelpful

Hi Fishes anyone recently got interviewed for Dynamics 365 team in India ? What is the interview process like ?

Hi Sharks,

Has any of you attended interview with ServiceNow company? I am shortlisted for second round, want to know what to expect in 2nd round and what to prepare.

like
like

Hii fishes, i am starting to interview at jpm, can anyone guide me on the process and what should be my salary expectations be for Software Engineer python, yoe 1.5+ at mumbai

like

Looking to pivot into managerial. Can someone take a look at my resume? Tips would be appreciated as well!

likehelpful

Hello,

I just completed an initial phone interview with HR from 
HSBC

It's for the Corporate Banking Manager - ISB - Commercial Banking associate position. What are the next steps of the interview? Is there any behavior or technical assessments? What are the possible salary ranges? Thank you HSBC HSBC

Recently i got offer from bosch ,meanwhile benz is also called for 4th round of interview,what should i do if i received offer from benz ?can i withdraw from bosch within a month and join benz?

Anyone prepping over holidays? MBB interview here

like

Amazons excessive interviews are an awful candidate experience. Why do they think this will help them win top talent in this competitive environment? Especially with their public cultural issues…? Lots of great paying companies without having to take a day off from work to interview! It’s overkill

like

I just started with a company as an HR Generalist. Within the 3 weeks of being there, my boss’s boss left, and today I found out my boss gave notice. HR is not valued at the company and it’s disheartening to know I was hired into a mess. I am now actively looking but how do I explain to other employers why I am actively looking and what do I put on my resume? I have never had to deal with this before.

like

Slalom 🐠: I interviewed with a team in SF in January and was dinged. I now have another interview with a different team in the SF office. Do I bring up my previous discussions? How, when? Cont.

like

Hey Guys, I have applied to Accenture through their Accenture India portal and it's still showing pending review and my interview hasn't been scheduled yet. as I checked found out that pending review means the Application has been passed from HR to the operations team what should I do now as it's been more than 4 weeks and I haven't received any response from them and there is no way to contact them.i am getting a little frustrated about this

like

My interview status is showing Candidature is on hold after the Accenture final round. When can I expect the result?

Thanks in advance.

like

Hi guys, After CAF completion by last week, yesterday I received a call from the HR for the second round of evaluation. So, I attended it yesterday and performed well by answering 90-95% of the questions. Even the interviewer gave good comments on my performance. But suddenly today I received an email that my candidature isn't suitable for the role and they're keeping my profile in the database. Does this mean they'll call me if there are openings with some other project?

Hi everyone

Being a self motivating person still feeling dejected it little demotivating.

Trying from all resources including Naukri ,LinkedIn,instahyre and many more ways includeind sending mail to the recruiters.
But not getting any desired role or company . Makes me feel disheartened,feels like will have to wait a very long to get something desired.

Total ex : 6.3 yr
Skill: functional,manual,API testing .
Notice period:30 days

Your generous suggestion n comment will help .

like

I interviewed at KPMG on 11/14 and got a verbal offer the next day but since then waiting to hear from them. Been following up continuously but the partners are not replying it seems. In the meanwhile i have an offer from BT offering 90k for 4 yrs of experience which seems to be fair. I am just unsure whether to accept the offer as I was waiting for kpmg reply as I want B4 on my resume which apparently is a big deal. Is BT also good on resume for future employers ??

likehelpful

Hi what questions do they ask for data analyst role? I have a test for the role with two questions. Thanks

like

Hello Guys,

SAP SD 4 YOE, INFY
CCTC -7.34
EY IN offered - 13.61(2lakh VP)

I have accepted EY IN Offer.
Now I am getting calls from EY GDS for interviews.

I am not sure if u should attend the interview or not at GDS.
When I shared this scenario with my EY IN HR, she said please don't attend it may create conflict and you may also get blacklisted.

EY GDS HR is like, you can attend the interview, there's no problem at all. We don't have such a policy. Please suggest what decision I should make.

Guys suggest how should I try for product based companies I mean don't find any details in naukri how should I apply kindly suggest?

Java developer
6yoe

like

More Posts

Which is the best consultancy or agents for Canada PR ?

like

Accenture strategy folks.. can someone confirm if work from home is about to end?

Have you had a project funded? What did you get? Share!

How to get released from the tcs project?
in the past i have seen My project manager has not given them a release, in the end they have to resign.
I am in a product support project, i want to switch to another domain.
I am preparing for that but here also i work honestly. I got A band in the last 2 years, my lead is on notice period now they are making me lead ,i dont want that ( extra responsibilities with no extra money) but currently I am the only option for them.

like

Thoughts about Eagle Hill Consulting?

At the moment it’s actually both

Post Photo
likefunny

Looking for a reasonably priced sound studio in Manhattan (record, mix, good facility with light sound design).Also - any local agents who rep good v/o talent (union and non)? Double thx. DM if pref.

Anyone else feeling the whiplash of following supreme court drama and then going to work the next day pretending like half your rights aren't up for debate?

like

Ripple XRP - Bloomberg terminal, bank partnerships, Amex, and more - Forbes, Fortune, Business Insider articles - recent jump to $0.74

like

Offered summer internships at AmEx and JP Morgan for compliance and I'm wondering if everything else is equal as it relates to the offer, which one is more prestigious?

like

McKinsey & Company Hi guys,

Please help me with the referral.

Senior/Lead data Engineer

Exp -- 8.5 years
Notice period -- 30 days
Tech stack -- Big data,Hadoop, Spark, Kafka, Azure,Python,Scala,Sql

Please ping your email id .I will share the Cisco" class="linkified" target="_blank" rel="nofollow" >resume.Cisco Target Bosch Intuit Amazon McKinsey & Company Indeed Flipkart JPMorgan Chase Morgan Stanley VMware Intel Corporation Hewlett Packard Enterprise Paypal Salesforce

like

Hello, I’m looking to relocate from Germany and in search of finance and Internal Audit roles in the UK. I have 3+ years experience in Audit/Risk, a masters degree in Finance and ACCA part qualified. Will appreciate any leads on visa sponsored roles. Thank you!

like

Few Senior positions open in Capgemini.
If anyone interested then DM me.

Post Photo
like

Is there any central website organizing acquisition of or donations for PPE?

like

Anyone from Deloitte requested premium i140 filing?

I want to go to Japan and Hong Kong for 2 weeks in September with my husband but don't have time to research places to stay and visit. Any suggestions?

like

Greetings, Ghosted! bowl members. As 2019 concludes, people who posted here: please let us know if you ever heard back from your ghosters.

like

I was trying to figure out what my personality trait was a few days ago. It’s depression, my personality trait aside from work is depression

like

Additional Posts in DataScientists Network

Hi Folks,
EY GDS is hiring for multiple roles spanned across Data Visualization, Data Engineering, Digital, Data Science, QA, RPA, UI. DM me for complete Job Description and Referral for a suitable opening.

Post Photo
likehelpful

Hi Fishes, I have 2 YOE in data science and my current ctc is 11 lpa. How much hike can I expect while switching jobs? Thanks!

like

How much is Ms in uk on machine learning/data science worth in india

like

Hi Fishers, currerntly at tcs 8 exp with 25l salary as a data scientist.. what hike should i expect next.

like

Hi,
I have been working as A business technology analyst for almost 2 years now and wanted to start learning data science.

I am not sure how much time will it take but wanted to ask y'all where I can start and what would be the right way forward without much impact on my ongoing work.

Genuine answers only.
TIA. :D

like

QBurst is hiring data scientists with 3- 6 YOE. Deep Learning, TensorFlow, PyTorch, ScikitLearn, NLP preferred. WLB is awesome, appraisals happen twice a year and permanent wfh option is there.
DM me for referral. Happy to help :)

like

Hi folks,
My exp is around 9 years and working in the telecomm domain for the entire time.
I want to switch to data science or data analyst domain now.
Is it possible?

If possible then what certification would help me?

like

Hi,
Can anyone tell me what kind of questions to expect in the 2nd round of interview with BCG Gamma for Predictive Analytics?

In the 1st round of interview, I was asked ML questions and basic Modelling approach on 2 cases.

like

Hey sharks,
How to get into freshers data science role as a non-tech professional?

like

Does anyone know a good Laptop for $1100 that would have the following specifications: Intel I5 10th Gen, processor, 512GB SSD, 16 GB RAM with Windows pro, with at least a year of warranty?

like

Hi fishes,

What type of questions can be expected in a managerial round for a data scientist role.

like

I'm a Data scientist with 5 years of experience (all experience is in data science). How much CTC can I expect ?

like

How to complete Azure associate data scientist

like

Any books/resources to understand the ML algorithms with the maths behind it?

like
like

Hi @all

There are following open position. Affine

Principal Data scientist - Experience -7-10 year's
Principal Business analytics - 7-10 YOE.
Data Engineer 4-7 YOE

DM if you are interested

like

I am a data scientist with 5yoe, highest qual - masters(data science) , current ctc -18 ,
Planning for a switch in next 3yrs what is the salary i can expect

like

If we take back the resignation at IBM , is there any policy that prevents from resigning for any specific period?

like

Hello fishes. What do you think is the average yoe times salary for Data Scientist roles. I am asking for people with less than 6-7 years experience.

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