SQL is Structured Query Language. It lets you communicate with relational databases: getting data out, putting data in, changing data, removing data. And much more.
Do I really need to learn SQL to be a data analyst? permalink
I don't make the following statement lightly: SQL is a superpower for data analysts. If you have any intention of making a successful career in data, your first action should be to learn the basics of SQL.
It will stand by you for the rest of your career in a way that many other tech skills will not. In the words of the famous footwear brand with the swoosh: Just Do It.
Where do I begin learning SQL? permalink
Start with the basics.
SQL is one of those deceptive masters in that it's pretty easy to learn enough to get you up and running but it can take a lifetime to fully conquer it's advanced intricacies. Don't let that discourage you though, getting started and hooked is the easy part.
I'm going to build up a list of the best online SQL courses, training, resources and tutorials. I'll keep adding to it over time so feel free to drop me a note (alan AT simpleanalytical DOT com) if your favourite resource is missing.
Best Free Beginner SQL Tutorials. permalink
SQL Crash Course (Disclaimer: I wrote the tutorials on this one. 30+ bite-sized SQL lessons to get you up and running. Interactive quiz questions and the lot...)
W3 Schools SQL
SQL Fun Time
Select Star SQL
Best Paid SQL Online Courses. permalink
The Complete SQL Bootcamp
The Ultimate MySQL Bootcamp
SQL For Data Analysis - Weekender Crash Course For Beginners
Master SQL For Data Science
SQL - MySQL for Data Analytics and Business Intelligence
SQL For Data Science
Databases and SQL for Data Science
Modern Big Data Analysis with SQL
Foundations for Big Data Analysis with SQL
SQL Essential Training - from Linkedin Learning (formerly Lynda.com)
Learn SQL - from Codecademy.
Mastery With SQL - from Neil Sainsbury.
Best Online SQL Resources and Articles. permalink
Helen Anderson writes about SQL and databases on her own blog and on Dev.to. (She also did a Q&A with me here about her career and data journey so far.)
Randy Au is a regular contributor to Towards Data Science and font of all knowledge on small team data science skills including SQL. (Randy also did a Q&A with me here last year.)
Katie Kodes is a top class Salesforce and Python developer who also shares some excellent resources on SQL. Check out Katie's Q&A here for more background on her data career and skills.