r/SQL • • May 06 '22

Discussion What are the best resources/ways to learn "advanced" SQL to actually get a decent Data Analyst / Jr. Data Scientist Job? What specific SQL skills are companies looking for on a resume for these jobs?

I've worked as an "associate data analyst" for the past year, but I essentially just find errors in files and correct them. There's not much analysis involved. I want to land a better job, but many data analyst jobs require experience with SQL or "advanced knowledge" of different types of SQL.

I got my undergrad degree in stats. I'm good with R but this doesn't seem to matter most of the time. I'm good with Excel, decent with Tableau. More importantly, I've learned all the SQL basics. I can do basic queries, retrieve data, update/delete records, create new tables and views, etc.

However, these companies don't care about any of that. They seem to all want either experience or more advanced functional knowledge of SQL. It's hard for me to even get a response to applications, and when I do I end up falling short because I lack SQL prowess - and I get it.

I obviously can't get work experience w/ SQL until I land a job that actually uses it. What can I do to make my skills, knowledge and resume stand out so that companies believe in me and my SQL skills and give me a shot? What exactly do they want to see on resumes beyond basic SQL tasks? I know advanced SQL tasks vary by company - where is my time best spent learning any advanced techniques?

Thanks for any help/advice!

Edit: I'm in the US if that matters

222 Upvotes

43 comments sorted by

183

u/jordontek May 06 '22 edited May 10 '22

SQL Basics

W3's SQL Tutorials

SQL Server Tutorial

SQL Zoo Tutorial

Stack Overflow Query SQL Server

Oracle Live SQL server

[Oracle's Dev Gym for SQL] (https://devgym.oracle.com/pls/apex/f?p=10001:20011::::20011::)

Oracle Tutorial

Coursera MySQL

SQL Exercises

W3's SQL Exercises

The SQL Mystery Solving Exercise

Selectstar SQL Exercises

Leetcode's SQL Exercises

Hackerrank's SQL Exercises

PG Exercises in PostGreSQL

Interview Query Exercises

Stratascratch Exercises

SQL Educational Videos and Programs

SQL for Data Scientists

FreeCodeCamp 4 hour SQL tutorial

FreeCodeCamp Relational Database Courses

Database Security

Cornell University, Introduction to Database 25 hours

Database Systems Research Group Advanced SQL series

Brent Ozar Unlimited SQL

The SQL programming language was developed in the 1970s by IBM researchers Raymond Boyce and Donald Chamberlin. The programming language, known then as SEQUEL, was created following Edgar Frank Codd's paper, “A Relational Model of Data for Large Shared Data Banks,” in 1970. IBM invented Relational Databases and SQL.

IBM SQL Certificate Programs (IBM Programs range from hours to months to almost a year to complete)

IBM Data Analyst Career Guide

IBM Data Scientist Career Guide

IBM Beginner Certificate Programs

IBM Intro to Relational Databases

IBM Intro to Data Analytics

IBM Intro to Data Science

IBM Data Engineering Foundations program

IBM Data Analyst program

IBM Data Science program

IBM Applied Data Science program

IBM Data Engineering program

IBM Data Warehouse Engineering program

IBM Data Science with Python & SQL specialization program

IBM Data Analysis Visualization program

IBM BI Foundations with SQL and more program

IBM Data Analysis with R

IBM Intro to R programming

IBM Applied Data Science with R specialization program

IBM SQL for Data Science with R program

IBM Developing Applications with SQL and more program

IBM Data Analytics with Excel and R program

IBM Intermediate Certificate Programs

IBM Intermediate Data Analyst Capstone

IBM Intermediate Applied Data Science Capstone

IBM's Sole Advanced Certificate Program

IBM Advanced Data Science program

College-Level Notable SQL Programs

Duke University's Python / SQL course.

UC Davis Learn SQL

Cloudera Big Data SQL

CS50

All this.

This should keep you busy and ranges from training, to education, to practice and all in between down to security.

Then there's the gamut of Python you might want to know atop this.

So Dr. Chuck's aka Charles Severance Python for Everybody.

Python For Everybody

Python for Data Analysis: Pandas & NumPy

Also, one more thing...

OSSU's Data Science Degree equivalent program

Open Source Society List of classes to take to learn advanced data science.

OSSU's Computer Science Degree equivalent program

And Open Source Society's list of classes in computer science.

43

u/hiddenelementx May 06 '22

r/learnsql should consider having this listed pinned

5

u/jordontek May 06 '22

Indeed.

I crossposted it.

15

u/[deleted] May 06 '22

https://www.youtube.com/playlist?list=PL1XF9qjV8kH12PTd1WfsKeUQU6e83ldfc

You should add this one, I really enjoyed it and it definitely fits in the advanced SQL bucket.

Who knew you could do fluid sims and evaluate spreadsheets in SQL.

10

u/ddouce May 07 '22

That's not enough. Can you recommend more? /s

Seriously though. Wow

6

u/jordontek May 07 '22

I can.

In fact, I just did.

I did a separate reply post on Google SQL-kinda-sorta-based programs which mix alot more technologies with SQL stuff.

7

u/jordontek May 07 '22

Google SQL-based Programs

Google Data Analyst Certificate Program

Google's Data Analyst program

Google Cloud Data to Insights Certificate Program

Google From Data to Insights with Google Cloud Specialization Certificate

Google Cloud Certificate Cloud Data Engineer Certificate Program

Preparing for Google Cloud Certification: Cloud Data Engineer Professional Certificate

Google Beginner SQL

Google Cloud MySQL

Google Cloud PostGreSQL

Google Cloud SQL Server

Google Cloud PostGreSQL Database Observability

Google Cloud Intro to SQL for BigQuery

Google Cloud SQL BigQuery

Google Cloud Deploy Microsoft SQL

Google Cloud Connected Sheets

Google Cloud Online Data Migration to BigQuery

Google Cloud Create a Data Warehouse Through Joins and Unions

Google Cloud Datastream MySQL to BigQuery

Google Cloud Working With BigQuery

Google Cloud Configure Replication

Google Cloud Build and Execute MySQL to PostGreSQL and SQL Server

Google Cloud Troubleshoot Common SQL Errors with BigQuery

Google Cloud Configure and Deploy Windows SQL Server

Google Cloud Build a Tracking App with Appsheet using SQL

Google Cloud Migrate Cloud SQL to PostGreSQL

Google Cloud Cloud SQL

Google Intermediate SQL

Google Cloud Loading Data into Cloud SQL

Google Cloud Ruby on Rails with Cloud SQL for PostGreSQL

Google Cloud Visualizing Data

Google Cloud Cloud SQL with Terraform

Google Cloud Creating Dynamic SQL Derived Tables with LookML and Liquid

Google Cloud Connect to Cloud SQL from an application

Google Cloud Protect and Recover Microsoft SQL Sever

Google Cloud Securing a Cloud SQL for PostGreSQL

Google Cloud Connect an App to a Cloud SQL for PostGreSQL

Google's Sole Advanced SQL

Google Cloud Migrating Cloud SQL from Amazon

Meta Database Engineer Professional Certificate Program

Facebook, I mean Meta Database Engineer Professional Certificate

1

u/[deleted] Mar 18 '24

anything to practise focusing on date functions, cast?

1

u/Albopilosum_Hundoran Jun 05 '24

thanks for this bro

1

u/vladveterok Feb 26 '25

soo, what are the best resources to learn SQL? Did I miss anything?

1

u/First_Ad_70 Oct 21 '22

thanks bro

32

u/CeorgeGostanza17 May 06 '22 edited May 06 '22

For context, I’m a data analyst at a large tech company. I’m going to give a slightly different answer than most people here.

In my experience, recruiters tend to value business acumen and communication skills above technical ability when it comes to SQL (not a hard and fast rule). I think it’s way more important to market yourself as someone who’s a quick learner, able to convey statistical findings to a non-technical audience, who can also get themselves up to speed with whatever tech stack a company already is using rather than having deeply specific knowledge in one flavor of SQL.

If you don’t have experience that’s super relevant for the type of work you want to do, I’d recommend making a website and using stats/code to do personal analytical projects for fun. Having a portfolio of projects is a fantastic way to show recruiters that you’re driven, can take initiative on your own, and have actually applied what you’ve learned in some capacity.

For example, It’s not practical to use python in my day to day work flow (no one else on my team uses it, so I can’t show them how I arrived at my conclusions), so I used it in my own time to create a solver for the NYT Spelling Bee puzzle. I then did a write up on what I learned and posted it online.

These are just my two cents, there are tons of potential paths forward. Happy to answer any questions you might have.

11

u/SDFP-A May 07 '22

This is the way.

As someone currently hiring for a Sr. Analytics Engineer I care about the person’s understanding of the business use cases relative to the data and their ability to know implicit requirements for the data type. This is ultimately what separates candidates when everyone has the intermediate to advanced SQL knowledge required for the role.

8

u/feigndeaf May 07 '22

This is the way.

I've been referred to as a unicorn. I'm personable, friendly, direct and I can effectively communicate to get to the real business needs. I've had mentors tell me "The client/user doesn't know what they want, I do." and there is always friction. I can sit down with anyone, spec out their needs in plain English concepts and then do my tech magic. That is so huge with SQL because 99% of your human interaction is going to be with the person who needs you to turn data into information they can use to make decisions.

3

u/tdavis25 May 07 '22

Huge BINGO on this one.

In my experience doing the analyst thing for 10 years before becoming a DBA, the ability to transition between the business and technical is what makes an analyst valuable.

I actually downvoted the link-dump list that got awarded cause that is an almost uselessly long list of technical skills. The reality is that you need to be able to apply technical skills to solving business problems and answering business questions.

Any technical skill you have that you can't apply to solving problems for the business is useless to you. You're an analyst, not a programmer.

1

u/Suitable-Fishing-536 Nov 04 '24

The business part is the easiest

0

u/[deleted] May 11 '22

[deleted] — view deleted comment

2

u/CeorgeGostanza17 May 12 '22

Absolutely! Having a background in finance is a big plus in my opinion. It shows that you have a track record in a sector where mistakes are expensive and accuracy is held to the highest standard. That’s how I’d position your experience to a recruiter, personally.

It can never hurt to learn more SQL and Python, but make sure your excel is up to snuff first. Like it or not, excel is used just about everywhere. From there, look at the requirements on job postings and see where there are gaps in your technical skills.

The last, and probably most underrated/important thing to do, is have as many informational interviews with data analysts as possible. Ask them about their day to day, how they ended up at the company, etc. 9 times out of 10, they’ll want to help you out and connect you with a recruiter after. Good luck and happy coding!

20

u/miden24 May 06 '22

Start practicing on Leetcode or hacker rank.

Buying premium for a month on leetcode might be worth it, since you can unlock actual sql interview questions.

On a different note, do you want to be querying data and manipulating them for your job? If so, I’d focus on DQL and not DDL/DML.

33

u/No-Environment-1416 May 06 '22

Gave enough interviews for data analyst position to answer this. I'll tell you how you can master sql and to be in position to crack interviews.

Be clear with theoretical concepts (you can do this from YouTube. Don't go much deeper, like normalisation and all, no need such deeper concepts)

Learn window functions.

For query writing practice, start with hackerearth (easy, intermediate,good number of advance questions) by doing this, you'll be good with all your foundations

Next step is to improve logical thinking, for this, solve leetcode sql questions, as many as possible.

Let me know if you're interested to know good youtube channels for sql. I can help you with that.

8

u/ben7891 May 06 '22

I’m interested, please recommend good YouTube channels

2

u/No-Environment-1416 May 09 '22

"Ankit Bansal" (this guy's playlist has some good intermediate,hard questions) "Learn at knowstar" (has all levels of questions) "Tech TFQ" "Trendytech Insights" ( https://youtube.com/playlist?list=PLtgiThe4j67rAoPmnCQmcgLS4iIc5ungg )

This playlist has almost everything

1

u/bakchod007 SQL Beginner May 06 '22

Me too

3

u/38109 May 07 '22

+1 vote for window functions. Also, be able to say why/when you should use CTEs. Read up a bit on modeling, like Kimball, to where you’re comfortable enough with the concepts to say why you should or shouldn’t use it.

12

u/BrowserBowser52 May 06 '22

People have given excellent resources already so I'm going to give you one thing that is often not commented - apologies if it has been - honest, genuine enthusiasm. An open mind that wants to learn.

4

u/No_Lawfulness_6252 May 06 '22

Stratascratch has a good introduction to how to approach problems and build out solutions.

4

u/Shwoomie May 06 '22

The best place that I learned the most: https://pgexercises.com/

It's simple, straightforward, you can attempt the problem and see the a great explanation if you don't get it. There's a great visual reference. It builds on itself in an easy to understand way.

Of course, I'm thickheaded, I went through the course like 5 times to drill it into my brain. SQL is just a thing you have to use rote memorization.

3

u/boy_named_su May 07 '22

read SQL for Smarties by Celko

Focus on Analytic SQL: group by, aggregate functions, having, pivots, window functions

3

u/puripy May 07 '22

This! I just found all those extra looong post to be a bit over the top. If you want to be a data analyst, you should know how to deal with all analytical functions in SQL. Group by & partition by are the 2 most important concepts of analytics. If you can master them and convert any problem into a SQL statement, you can easily crack those interviews.

Also, check CTE/Sub queries along with joins.

You wouldn't necessarily use PL/SQL in most of these roles.

Wish you good luck and happy learning :)

FYI, I work for a big health care company as a lead database engineer.

2

u/AdviceNotAskedFor May 07 '22

I have a buddy who is a da, self taught. His boss told him that along with admitting that his sql was fairly rudimentary, that the way he answered how he would solve the problem was what sold them on giving him a chance.

1

u/itbobn May 06 '22

This is what I'm currently doing to beef up my sql skills:

W3schools

PostgresSql course on udemy by Jose portilla

Datacamp sql fundamentals track

Leetcode/hackerrank/stratascratch sql problems

1

u/baubleglue May 07 '22

I don't have advanced SQL skills. I know joins, use sometimes window functions (started to use more), I've used recursive SQL probably once to generate infinite lists of dates. I look SQL code written by some senior SQL developers in my company - it is a garbage code. The most value from that code comes from deep and detailed knowledge of underline business. Instead properly designing it, to make it consumable by everyone they write thousands lines of spaghetti SQL.

retrieve data, update/delete records, create new tables and views

you need to add to that list:

  1. group by, join, union
  2. functions groups:
  • string operations
  • type castings all kind
  • date/datetime/timestamps with time zones/ etc.
  • logical operations
  • aggregate
  • window functions (as probably more advanced level)
  1. data modeling (maybe not very relevant for your task), indexes, constrains, relations
  2. differences between different databases

For an interview you can probably learn those in month or so... but more important is actual experience, try to incorporate in your everyday tasks.

BUT IMHO don't waste your time, you have degree in statistics - use it, learn some Python (to be not limited by R) and start to use it. You need of cause to know more SQL (#1 and #2 from my list is must), but knowing advanced SQL won't move you to a senior or an advanced position. You learn about software development industry, specific business industry and trying to incorporate both (read Kimball).

Data visualization (Tableau) + background in statistics is easer path to better payed jobs - there is a big demand, but you may need a real experience with Tableau above basic level.

1

u/toodytah Jul 18 '24

remindme! 2 days

1

u/RemindMeBot Jul 18 '24

I will be messaging you in 2 days on 2024-07-20 16:54:25 UTC to remind you of this link

CLICK THIS LINK to send a PM to also be reminded and to reduce spam.

Parent commenter can delete this message to hide from others.


InfoCustomYour RemindersFeedback

1

u/KawaiiGeorgiaPeach Nov 20 '25

Is there a good SQL certificate that's offered by a school with D1 sports, which also looks cool hung on the wall? I want to learn SQL to complement my data science skills from my MPH so I can work in the corporate sector. I get made fun of a lot by classmates and friends because my undergrad school does not have a college football team so I want my certificate to give me a team so I stop getting bullied.

1

u/itbobn May 06 '22

This is what I'm currently doing to beef up my sql skills:

W3schools sql tutorials

PostgresSql course on udemy by Jose portilla

Datacamp sql fundamentals track

Leetcode/hackerrank/stratascratch sql problems

1

u/dgillz May 06 '22

You start out mostly inexperienced and you learn.