Ugh I am going to give up and take a SQL class. It seems every in-house role I’m interested in requires it. Where is the best place to take it for a beginner??

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

First find out WHAT they use it for and then learn that. Most times you are just pulling data and that’s quite simple to learn. If you take a SQL course you might end up learning a more academic view of SQL’s role in database management and that’s the purview of a data engineer.

likehelpful

This is so helpful!

like

I had to do the same thing recently. I went to Udemy and took the SQL boot camp!

likeuplifting

Datacamp

likeuplifting

Khan Academy was where I started. Great for free learning. Once I realized that I wanted to take the next step with SQL and data analytics I moved on to taking the full Google Data Analytics certificate course on Coursera

like

try out sqlzoo.net for the basics. its free and the little chapters/exercises are really helpful. from there if you want to do more, try youtube tutorials or a datacamo

likesmart

Coursera

like

I think that Datacamp's program is the best around. Here's a pro tip I heard: try a free course, let it linger after not proceeding onto the paid portion, and DataCamp will send you an email with a % off coupon. Otherwise, there is usually a sale around the holidays.

like

Just go to w3schools.org and do their free online sessions. Learn select, joins, sub query, case, etc… and it’ll be all you need for 90% of positions.

like

Learn sub query and CTE. Find out the difference and why some might prefer CTEs

like

I’ve found it most helpful to start from a problem you’re trying to solve or question you’re trying to answer and then seeing how to get there using a given tool (SQL in this case).

Anything else becomes too abstract to be helpful and I lose any new knowledge due to lack of use.

like

Coursera or Udemy are both great. Agree with the first couple of comments, but sometimes you just want the cert.

like

Try a junior college, they might have it online and with the syllabus you can go through the course at your pace. If you are an in state resident it might be far cheaper (maybe even more credible? don’t quote me, do your due diligence) than other online offerings.

like

Danny ma’s serious sql course.

For most interviews, you’ll need to know the basics (basics ends at the difference between WHERE and HAVING), CASE WHEN, and PARTITION BY.

like

Kind of shocked this is an acquiescent relenting... This is a fairly easy skill to learn the basics on that is valuable enough on a resume to be able to speak to for any analytics professional.

Why were you holding out for so long?

Related Posts

I've been waiting tables for the past 20 years. It's a decent job that has gotten me through some difficult times, but I am getting old and tired. What career path would be most advisable for me at age 40?

like

Hi. I got selected as a consultant in Global business services role (SA&MA) in DI. Can someone throw some light on this practice as what it does? Will the clients be India based or overseas?

like

Hi Fishes,
Have potential opportunity at HSBC EDPI.
Just wanted to know how much can I ask for GCB5 AVP Business Analyst role?
YOE - 6 Years
CCTC - 20 LPA
Also how long does it take to move from AVP to VP and how are the yearly hikes?

like

I am a recent grad(Finance), and my MBA school is not a named institute like Stanford. I would want to work for a consulting co. who is heavily involved in Finance. Can you help me create a roadmap from where should I start? What are top finance business consulting companies and how to get there? My undergrad was in science.

like

Hi Fishes,
Could you please shed some light on Manager(M3) role in L&T insurance domain.
Appreciate your review

like
like

I am an associate at an AM200 firm and was (IMO) very clear prior to accepting this role that I value work-life balance and wanted to try to keep work at night on the weekends to a minimal, but since February, it seems like it’s always something that requires my time as needed disregarding “business hours” or my personal schedule. Thoughts on whether to bring this up or continue to be a team player until I burn out and pay off my student loans?

likefunny

Hi,
Any thoughts on
Plural Strategy ? Types of projects, wlb, exit opportunities, culture?
A recruiter reached out. Looking to do my due diligence before getting started with the process. TIA.

like

Hi fishes, My LWD is near by. Kindly suggest me what's the process of smooth exit from Mphasis
I haven't received any communication from HR or management yet.

like

Anyone looking for a sales role? Fully remote at a media and research company. Base+ Commission.

like

Hello everyone! This is my first time posting since joining this platform. I’m interested in connecting with someone who is open to HR mentoring. I’ve been in HR now for about six years and have never had a mentor. I’ve been relying mostly on SHRM and other people in the company for feedback. Even if it’s for feedback, I would really appreciate it. Thank you!

like

I’m curious - let’s say you have a role to fill but they are targeting only female candidates to balance out the team. What recruiting strategies can i implement to meet those needs?

like

Hi Fishers,

I have appeared for the HCL Devops position and after clearing the 1st round they have sent the mail for the Client Interview.
Can anyone please suggest how it would be !!

like

Lowe's Lowes Lowe's hi guys, I am in final round of interview with lowe's india for senior analyst role. Can anyone help with the offer range I can negotiate for?
Current CTC: 11.5 LPA
YOE: 3 years in analytics and total 5.5 years in IT.

like

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

Anyone know of any mid level mgmt careers that 20 years of retail Asset Protection/Investigations/Safety Management skills and experience would transfer well into?

likehelpful

Hey all,
So I’m currently interviewing for another position, to be a business development specialist at a relatively large tech company in PA. I have about a years worth of experience. Indeed estimates the salary to be between 60k-80k, I was wondering what I should expect?

Hi Fishes, Can someone please refer me for lead Analyst position in Wells Fargo, Bengaluru location. I have 8+ years of experience with SAS and SQL as primary skills and need to relocate to Bengaluru. Thanks in advance.

like

Would you leave a job at a startup who is still running on investment funds after almost 5-6 years of founding even though work environment is great?

More Posts

How is Atos for Oracle Cloud Financials? Do they have enough projects?
How much ctc can I ask for with 8.3 yrs of experience?

What is the average salary for an account manager in employee benefits at brokers firm? And what about a senior account manager salary? I have 7 years of experience in the health insurance industry. I want to see if I’m on track or if it would be out of line to ask for a raise.

like

Anyone willing to give a referral for IBM and Deloitte canada, I am a new grad and looking to start my career in consulting

like

I have received offer from accenture but still I am not accept it as my current company's increment letter is due. Is they consider my increment letter and send me the revised offer letter if I accept it now???? Please help me.

like

Hey there!

I got offers from Accenture with 6 LPA + Variable pay and from PWC with 7 LPA + Variable pay (Screenshot below). I would like to join acccenture but the amount seems very less. I have 2.3 years of experience. Should I negotiate with accenture? Please give me some expert opinion.

Post Photo
like
likeuplifting

Hi,

My PF memberId starts with PYKRP, is it same for everyone?

like

Is 80k cash + 20k company share a good deal for a junior dev role in the bay area?🙏

like

Hi fishes LTI or Wipro or Harman connected services Please suggest which company is better join. salary offered is almost same. With respect to wlb and job security which is good?

like

Hello All,

I have got an offer from one company with a 32L + 15% variable. Now I got two other offers with 36L. Should I go for it?

like

My mind every time I meet new clients

Post Photo
likefunny

Back to your regularly scheduled programming

Post Photo
likefunny

Female 🐠 - how bad is dating in nyc in your late 20s - early 30s? I’m going through a break up and obviously not going to look for anything serious right away but just curious on what to expect

like

Is it worthwhile to get an MBA as a tech-leaning consultant (data scientist)?

like

Hi all. I accepted an offer for a PDM position with Deloitte few days back. However now I have an offer from a very big gaming company for a similar role and want to decline D's offer. Just want to know if any of you have faced this situation and what are the repercussions of doing so? Any suggestions?

helpful

What will be the procedure after accepting offer letter in CGI? Is it virtual onboarding and when will we receive link? I see to report office on joining day in offer.. CGI

Hey Guys,
Looking for a job in any established e commerce company as a Key account manager. I have 8 years of experience. Location - NCR
Please help. Thank you

like

Hi i got 15.9 CTC and 50k joining in thoughtworks and 19.7 CTC and 50 k kooning includes 3.7 lacs as variable pay in sg. i have 4 yoe..which one to choose. Please suggest.Thoughtworks Societe Generale

like

LTI-Larsen & Toubro Hiring Drive on 1st OCT.
DM your Email id with Jobid to Get registered.

Post Photo

Additional Posts in Data and Analytics in Advertising & Marketing

Needs some ideas for scenario planning optimizations! Currently have a model to predict conversions given media spend, I can adjust spend up and down to create different budget scenarios and send to model to get respective conversions. Thoughts?

like

Accepted job offer starting Jan 11. Should I let my boss know now so there is more time to transition my workload/approve replacement hire? Want to leave on good terms as I may do some freelance work for them.

like

What's a good use for a personal LinkedIn profile's cover photo/banner real estate? Feels like a waste to have abstract art up there, but I've had my profile critiqued and not sleek enough when I had my value prop in text up there

like

I’m looking for a Sr Analyst, Audience Insights at MediaCom. PM me for details!

like

Any helpful resources for pulling together a B2B measurement framework?

like

Are there any AGENCY folks at small/mid-size shops that are using CDP's? If so, how are you staffing the team and how are you integrating the CDP with your DSP's etc?

like

I have below offers in hand with 9years of experience.
1. MassMutual (India) 25LPA +3L joining bonus
2. Synechron Tech 28LPA (only fixed)
3. TCS 28LPA
4. Tech M 30LPA
Can anyone please suggest which one to join.

like

Hii! Question for everyone, how much should a UX Researcher (quantitative) with 5 years experience + PhD should be making? NYC based

like

Adobe Attribution

Does anyone have an experience with Getting view thru attribution working in adobe? And if so, how was it implemented.
Thank you so much in advance for your help.

like

Hello, I am currently looking for entry level data analytics roles in Advertising and Marketing in Chicago or remote. I am currently an apprentice in a program that is data analytics focused through which I have completed certifications in Google Data Analytics and Google Analytics. I am also familiar with programming languages like SQL, Python, and R. I would love to see if you guys have any leads, it would be greatly appreciated. Thank you!

like

Top companies or types of companies for consumer insights/analytics? E.g. in terms of opportunities to learn, general progression, salary, etc

like

Other than providing insights and reporting, how does your analytics team help drive business KPIs, find new ways to look at audiences/businesses situation or have a huge impact on planning?

like

I recently graduated with a masters degree in Data Analytics from University of Texas at San Antonio with a CGPA of 4.0. I am also awarded distinguished graduate student award for great academic standing and leadership skills. I have worked in india for 3 years for Uber and Amazon as Risk Analyst and quality specialist respectively. I am currently in my F1 OPT and have 30 days left before I submit my offer letter to USCIS. I can share my resume and any help is really appreciated. Thank you!

like

On average, have you seen VCR and CTR are inversely correlated? (When you click out on a video player, does that stop the tracking for quartile completions?)

What is a typical salary for a Data Scientist at a management level that’s 1 or 2 levels above entry? Looking for insight both within the tech side and tech consulting if possible.

like

Best resource to learn SQL?

like

Posted in the advertising job board and posting here as well! We have a few open analytics positions across multiple teams for an IPG agency in New York. Can be remote for now. Shoot me a DM if you’re interested!

like

This is a long shot but anyone on here in Brazil? I need to hire a good Data and analytics person in Brazil. Must know sql (but not necessarily super advanced) and R or Python (but again not the most advanced)

like

Will working in this role with these responsibilities as a “Growth and Content Strategy Senior Analyst” help me get into data analysts roles?

Post Photo
like

looking for any resources about creating messaging matrices for brands. links are appreciated!

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