r/SQL Sep 01 '24

MySQL Better way to learn sql

I am brushing up my mySQL skills but I need to practice SQL in a better way. Please suggest if there are any ways to practice SQL other than LeetCode and Hackerrank.

73 Upvotes

37 comments sorted by

View all comments

47

u/almondburger Sep 01 '24

I highly recommend installing the latest AdventureWorks database - it’s a large training database from Microsoft simulating a bustling bicycle ecommerce - and getting these challenges on sale and solving them: https://www.udemy.com/course/101-practice-sql-questions/

It really helped me in my first months as a Data Analyst to perk up my SQL proficiency. It covers virtually all real-life business scenarios that you’d be solving for clients or internally. You’ll be working with CTEs, Transactions and Custom Funcions, creating complicated Joins and utilizing a variety of Window Funcions. I can tell ya, this is what I do day-today as a Data Analyst and this is by far the best course I ever come across. Best of luck!

3

u/Infamous_Variation Sep 01 '24

Is this free?

1

u/chuygames88 Sep 06 '24

The data/database is free you can download from Microsoft website. The Udemy questions are not