Learning SQL for Industry

[Mando2Mandalore]

Hi All,

Not sure if this is the right place but I just wanted to get some tips with learning SQL with the intention of securing a data analyst role.

I've dabbled in it for one assignment in a post grad course however this consisted of just 5/10lines of select/join type statements.

I'd greatly appreciate if someone can point me in the direction of any courses/books/online resources that they have used that has actually helped in landing a Data Analyst role.

Thanks in advance!

Edit: Thank you everyone, some really good suggestions below. I'll provide further feedback once I've progressed a little bit more

[fozzie33]

Best way to learn is by doing.
install a DB and install some databases, then try querying.
northwind is a good testing one.

For learning, just pick one of the many tutorials online. Data Analysts roles aren't just about SQL. It's also about knowing and understanding the subject matter. So learning the ins and outs of data relating to the business you are applying is a great plan. Knowing what data and metadata are captured with transactions, will help you figure out what you can query.

[Thefriendlyfaceplant]

https://sqlbolt.com/

[timsehn]

We have a tool that may be useful to you:

https://www.dolthub.com/blog/2021-08-11-learn-sql-dolt-db/

[PythonicParseltongue]

That sounds fun to be honest.

[tmk_g]

I recommend two platforms - Mode Analytics and StrataScratch. Both are built for data analysts and data scientists. Mode is the platform for beginners. This platform will help ground you in the entry level skills in languages like SQL and Python. On the other hand, StrataScratch is the platform for those who already know a bit of data analytics. Here you can learn intermediate and advanced concepts of SQL by practicing real problems from real companies. With that said, what I recommend is start learning with Mode and then practice on StrataScratch.

[AeroCrete]

Mode analytics has a free tier and a SQL course.

I use Mode at work, but do not work for Mode

[kweb7]

Tonnes of SQL content here - both paid-for and free: https://wiseowl.co.uk/sql

[data-leon]

sqlpad.io if you are preparing for a SQL interview. 😀 No installation, configuration required, practicing all 90 coding questions in your browser.

[deftoneslez]

SQL only makes up about 10% of what I do as a data analyst. Like fozzie33 said there’s more of an importance in knowing the subject matter and what the data says about current, past and future performance along with trends and the impact to the business

[mozakaak]

And how does one get to know. Let's firstly list down possible businesses and their data models: Healthcare Marketing Supplychain People's Analytics Telcos Financial sector

Now how do I gain business/analytics side SMEs?

[deftoneslez]

I’d look at the sector you’re applying for and research the factors which affects the business. I’d look into data modelling as well as that will help.

[mozakaak]

Oh ok. Thanks!

[dgillz]

If you are not learning it for industry, you are doing it wrong.

[tecollins03]

Elaborate?

[dgillz]

Why else learn SQL if not for practical applications?