I’m interviewing for financial analyst roles at tech companies. I’ve used MySQL before and know some basic queries/statements such as create, select, join, where, like, etc. Any recommendations for SQL interview resources tailored for beginners or people that don’t have coding background?

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

W3 schools. It’s for beginners and has sample questions, is comprehensive and better yet it’s free. Pic below it literally covers almost everything and is quite detailed

Post Photo
like

I think this was covered in another thread but check out https://sqlzoo.net

like

Would recommend also knowing the case statement.

like

These have been helpful in conjunction with w3schools

"SQL Police department, learn SQL while fighting crime"
https://news.ycombinator.com/item?id=23066776

"medium hard SQL interview questions"
https://news.ycombinator.com/item?id=23053981

like

Related Posts

I’m in big law and on the cusp of making the jump to in-house. It sounds like the company I just interviewed with is getting ready to make me an offer. It’s definitely going to be a pay cut coming from big law but I do get some nice equity in the company. Is the jump worth it? I’m so burnt out by big law and this seems like an awesome opportunity to help shape a newish company. Any tips on how to figure out if this is the right move for me?

like

Should I complain to a firm's HR if the interviewers laughed at my answer during an interview? Maybe it sounded scripted but it was still heartfelt and genuine: my immigration story and how that made me appreciate the rule of law. I said it soo many times during OCI's that maybe it eventually sounded robotic, but for the interviewers to laugh and one to say sarcastically "nice elevator pitch", I thought was rude. Thoughts?

like

How long does it take between a second interview and a job offer? What the norm?

I’m a jr SWE and have successfully landed an interview with Google. It’s time for the coding and interview rounds. I’m a wreck. What was the best way to prep for this portion of the interview?

like

Have a consulting interview this week I’m prepping for. Doesn’t necessarily have to be related to the case portion, but what are the best questions candidates have asked you during an interview?

like

Hi Guyz,

I went through the entire recruitment process and got selected for IBM ISL. Now I am being told by the HR that they are unable to release offer as there is a hiring freeze.

Can any one please tell me if its correct or just an excuse not to give me offer. If its true, when will this freeze be removed?

like

Hi folks, i am looking for a job change i have 2.6 yoe in data engineering with tech stack - hive, hadoop, pyspark, sql, python , aws. These days i am not getting much calls. I worked for x company for 2 yrs and switched to y company in feb 2022. But recently i faced a situation. I cleared all rounds and send my docs to sunlife financial but now when i am trying to connect with them they are saying your candidature is on hold. I alao resigned from my current company. What should i do?

like

When doing interviews in industry. What questions have you asked at the end of an interview that turned out poorly or you wish you didn't ask.

like

Does LTI gives offer for 2 months notice period?
I had completed my hr round, and hr told she will be ok for 2 months notice period,I had received an Email that I had cleared all the stages but still doesn't hear back from them

like

Hi fishes, I interviewed for a company called software AG, I want to know how is the company and is the work culture good? PS Interviewed for the data analyst position

like

Hi All.

I have total of 3.4 YoE and also M.Tech.
My current CTC is 8lpa which is low as per standards.
How much can I ask for, if i attend and clear technical interview and during HR round when the discussion comes up.

Now a days BTech freshers from good college get more than 15lpa...

like

Any tips for a candidate who is currently in working in a bank in IT operations and interviewing for a tech company for a role they don't have technical experience at all? Moving from a BA position to another BA role but tech is completely different...

like

Hi,
I am a Master's student at Northeastern University looking for Data Analyst co-ops and internships.
I would love to get feedback on my resume or any other advice I can get for my internship search. Would love to connect and talk more.
Thank you :)

Post Photo
like

What are equivalent roles in Google for AWS Solutions Architect, TAM, etc. Why everyone is applying to AWS and not to Google? Does anyone know how GCP interview is like?

like

I've a question on what sections to put on a regular resume. I see some people are using consulting style resume for outside companies as well. Do you think it's a good idea to devide work experience by projets? Or is it better to have "projects highlights" separate from work experience.. something like: intro>functional expertise> project highlights>work experience>education?

like

Information required before your Amazon interview. Amazon

What is this mail ? And the position was not mentioned in the form, and I have applied to 3 different roles.

like

How long does it typically take to get a verbal offer from ZS Associates (Strategy Insights and Planning) after the final interview?

like

For those who didn’t make the switch from IB, how much time did it take to prep to a point where you felt ready to interview for PE associate roles?

like
like

Hi everyone, Could someone help me with interview process for sse IN4 (Java, microservices), how many rounds of interview will be there ! I have given 2 tech interviews. How long will it take for them to respond ! I feel that i did well in the interview..
Any insights on this would be helpful to me and much appreciated !

like

More Posts

Hi Fishes,
I'm currently looking for a job change in UX field.
I have 2yrs of relevant experience. If anyone can refer me that would be of great help

Thanks in advance 🙂

like

How is epam anywhere health insurance plan?

like

Hi ,
Can some one please refer me ?
I have experience in automation Testing .
YOE-2.1 LWD-4th October

like

What are the rankings for top consulting firms in the human capital space? (Big 3, big 4, +++)

Hi Fishes--what would be in hand salary in WIPRO for 26LPA..considering 15% variable as well.. Usually how much they pay from variable.

likesmartfunny

Starting at a new firm, What can I do to leave a good first impression?

like

How many days walmart takes to roll out an offer. My hr round happened on Friday 24 June still no updates

like

What should be the salary package for senior research analyst from a Gurgaon based company

like

What is the future earning potential of a Talent Acquisition Manager in London?

If you eventually move into a Head of/Director of Talent, how high can the salaries go?

Currently on £40K + Bonus + Equity

like
like

Is there a special title at your company for a Project Manager that works on product development and not an IT project manager?

An example might include launching a new product from conception through form writing, rating, filing, programming, training, and implementation, or the transfer of products from an acquisitions writing company to ours.

like

How much do partners at big 4 make on average? How bout MBB?

like
like

What will be the inhand salary for 17 lpa in hcl?

like

Need suggestion urgently.
Currently working in TCS Bangalore in BFSI domain.
Yoe - 8.5
CCTC - 12.5
Grade - C3B
HR Ready to give - 17.5 and also got mail confirmation from HR.

Canada Onsite is already approved by country RMG and Immigration HR. Approved by canadian embassy also as got the official mail from tcs Canada with salary offered in Canada is 72K CAD.


Got job offer from HCL Bangalore
CTC offered - 23 LPA
Grade - E3.1

Please advice as not able to decide. TIA

like

What is a good salary range for a Principal UX Designer with 15+ years of experience working in either Finance, Tech or Media industry in NYC?

like

I know it is not fashion related, but do you guys have any recommendations on ergonomic chair to buy for home office? Been dealing with some lower back pain while working/studying from home

like

Are you very serious and wish you were less serious or vice versa?

likehelpful

Is Canada giving out tourist visas these days?

like

Additional Posts in Consulting

OTS is growing rapidly and leadership has asked us SMs to assist with recruiting. One of our needs is for cybersecurity and data privacy consultants interested in M&A e.g. CISSP, CISA, CIPP, CIPM, etc

like

I saw a dream that project let me go! I was so happy in my dream! and woke up to this reality- been on this public sector client for 16 months and 10 more months to go. Arrrggghhh..

like

What are the main reasons why you would recommend going big 4 instead of MBB? Have any of you successfully swayed a candidate to go big 4 instead of MBB?

like

What is PE ops? Is it just trying to optimize firms in a PE firm’s portfolio to lower operating expenses?

like

If you're a ceo of a polling firm, I need you to resign at once. I'm never trusting a poll ever again

likefunny

Are management consultants as useful to society as farmers, doctors and soldiers?

funnylike

I’m currently on pace to be just shy of having enough stays/nights to keep Hilton diamond for next year. Would there be any red flags if I were to stay in one hotel mon/tues and a different one wed?

like

Question from a newbie consultant - What are some good online courses/ books to improve consulting skills?

like

is $500 for a used aeron good or should i keep searching?

like

Got a random email from a supposed Amazon recruiter for a SDE position (which is not at all a fit). The email is amazon.com domain and there are no red flags in the body but it doesn't feel like an Amazon recruiter due to the tacky signature, etc. Has anyone seen this kind of cold-calling from FAANG recruiter?

like

Houston downtown JW vs Westin.. Thoughts?

like

Finally getting a chance to put together a home office space. Looking for tips, photos, ideas. I have two monitors and a laptop so my do a three screen set-up. Debating about getting a standing desk or putting money in a super comfy leather chair. Open to hearing what you have done!

like

I saw a comment on here from someone referencing a book about organisational Psychology and working with different types of personalities, but I can’t find the comment/thread now. Do any of you have recommendations on this topic?

like

Holding all else constant, do you prefer two continuous weeks of bench time or 10 hours less work per week for 8 weeks

like

My Uber driver has a Tesla. Stories of the Uber driver having a nicer life then you. Go!

like

🐠 Vegas meet up on Jan 6th? Comment if you're down!

like

Book recommendations on leadership, career development, etc?

like

Any 🐠 at the Westin Galleria in Dallas want to grab a drink tonight?

like

What are the best consulting firms in Europe to do AI strategy work in public sector? I have Canadian experience and I’m looking to move geographies.

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