Online SQL courses and classes?
October 6, 2021 7:57 PM Subscribe
I am looking to take an online course to learn SQL with business applications. I know a little bit, but I would like a course that goes deeper and has hands on examples with large / semi-realistic datasets (vs. really small illustrative tables). Recommendations?
Paid course is OK. I would prefer a course, with an instructor, a set cadence (week 1 do this, etc.). and graded assignments. I don't need this for actual credits, but I do want someone to be able to correct any mistakes I make because the devil is in the details. :) Ideally the course gets into manipulating large datasets and joining multiple tables, making dashboards with some data pipelines?, and focused on realistic business problems (e.g., most businesses structure their revenue data this way etc. etc.).
If the course covers ways to analyze the outputs in a more sophisticated? easy? way than putting everything into Excel, even better; especially if it helps to automate reporting work, as an example. If the course also covers ways to make your life easier in a SQL-heavy job :), I am ALL for it.
I've done some light SQL, but am far from facile. I am intermediate in Excel analysis skills and once upon a time, did learn to code, so am familiar with basic programming concepts. I would like to be a lot more adept.
Paid course is OK. I would prefer a course, with an instructor, a set cadence (week 1 do this, etc.). and graded assignments. I don't need this for actual credits, but I do want someone to be able to correct any mistakes I make because the devil is in the details. :) Ideally the course gets into manipulating large datasets and joining multiple tables, making dashboards with some data pipelines?, and focused on realistic business problems (e.g., most businesses structure their revenue data this way etc. etc.).
If the course covers ways to analyze the outputs in a more sophisticated? easy? way than putting everything into Excel, even better; especially if it helps to automate reporting work, as an example. If the course also covers ways to make your life easier in a SQL-heavy job :), I am ALL for it.
I've done some light SQL, but am far from facile. I am intermediate in Excel analysis skills and once upon a time, did learn to code, so am familiar with basic programming concepts. I would like to be a lot more adept.
Just this guy, y'know suggested in a related ask metafilter, that you can get a SQL primer here.
He also generously included a Discord chat: link.
posted by cowlick at 5:11 AM on October 7, 2021 [4 favorites]
He also generously included a Discord chat: link.
posted by cowlick at 5:11 AM on October 7, 2021 [4 favorites]
You're in luck, because the PASS Data Community Summit is coming up next month and there are a TON of free sessions that you can take. The session list is here.
posted by mezzanayne at 11:43 AM on October 7, 2021 [2 favorites]
posted by mezzanayne at 11:43 AM on October 7, 2021 [2 favorites]
It's a book to work through rather than a course... but it sounds like at some point soonish in your learning you might really enjoy and get a lot from A Curious Moon.
posted by protorp at 5:01 AM on October 8, 2021 [1 favorite]
posted by protorp at 5:01 AM on October 8, 2021 [1 favorite]
« Older Budding best friendship keeps hitting a weird... | How to celebrate my friend's wedding in Vienna... Newer »
This thread is closed to new comments.
posted by kschang at 8:58 PM on October 6, 2021 [1 favorite]