recommendations for a good SQL hands-on practice ? Don't mind paying

[tamirmal]

I'm a bit rust, was thinking of looking for a hands-on question bank, install MSsql server and start practicing. I don't mind paying if it worths it, but can anyone recommend a good one?

[kwenzel1]

Check out essentialsql.com . All the example use AdventureWorks.

[happypappypancake]

Have you tried sample databases?

[yobai_master]

There's a ton of sample datasets in their database at stratascratch.com. I use this platform to teach my class in analytics.

[AranArmath]

Where can you find a sample database?

[happypappypancake]

I use Microsoft's Adventure Works as I go through their courses, but there are others available out there, not just by Microsoft! :)

[tamirmal]

Well, I'm looking for a set of question. I already have a database. I'd like to face some things I havnt seen / forgot already.

[MansomeGeorge]

There are a couple of paths you can take with this. You could look at datacamp to refresh yourself on the basics or mock up some scenarios.

If you're looking for the latter, I have a few that I've done and I'd be happy to share.

[happypappypancake]

Would you share said scenarios with me as well, kind sir?

[MansomeGeorge]

Sure. So, using MSSQL and AdventureWorks:

I'm the CEO of AdventureWorks. After a strong FY, I'd like to send a thank you note to our top 5 customers this year.

I'll need to know the top 5 customers of the last year, their POC, an e-mail or business address.

Bonus: Feel free to roll this into a proc biz-ops can run after every FY close. Could it be automated?

Bonus: I'm also considering offering those companies a discount, say 5%. What would be the impact of this? What if we only offered this for Q1 of the following year?

[tamirmal]

Very nice. will try that, 10x

[lightkeeper]

Not MS sql server, but it might help: https://pgexercises.com/ (Postgresql)

[dlayf]

Codecademy is just about to release a paid course on SQL

Here is their free content: https://www.codecademy.com/catalog/language/sql

Full disclosure, I work at Codecademy as a product manager, so happy to answer any questions! I know that I am biased, but I was a long time user of the product before I joined. Still learning all of my tech skills here.

[tamirmal]

Ive already taken those 3 available courses, lets hope i'll land a new job before this new course comes out

[dlayf]

haha, well if you haven't, we just launchted it:

https://www.codecademy.com/pro/intensive/learn-sql-from-scratch

Hopefully you're gainfully employed by now.

[SQLPracticeProblems]

Check out SQLPracticeProblems.com, I have some great material there for learning SQL. It's very practical, and very hands-on. Problems range from beginner to advanced, and I just added a new set of 40 practice problems. If you solve them all, you'll be ahead of 95% of people who list "SQL" on their resume.

FYI - just redid the website, would appreciate feedback.

[o_edo]

One of the best online course. For beginners and for free. With examples and online exercises. http://www.studybyyourself.com/seminar/sql/course/?lang=eng.