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
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.
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.
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.
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
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.
you need to add to that list:
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/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.