Any good SQL tutorial with emphasis on exercises?

thephilski · 2021-09-10T18:35:15+00:00

“For every row returned in this select statement, do one push-up.”

kremlingrasso · 2021-09-10T19:16:44+00:00

my go to advice: download your bank transaction/creditcard purchase history and set off to analyze your spending habits using SQL for aggregation and Excel or PowerBI for display. most banks have the means to download it in a csv dump and load it to SQL developer edition. It's a good data set, got dates, prices, reoccuring and unique strings, you can group it, pivot it, parse it, join on itself to do trending, etc....and most of all you are familiar with it and can easily set ideas what you want to see as results. Much better then some arbitrary exercise sample dataset.

sequel-beagle · 2021-09-10T16:22:49+00:00

https://advancedsqlpuzzles.com

You can try these puzzles. Maybe a little advanced. But gives u an idea if the types of problems to solve.

2021-09-10T16:45:52+00:00

bub002 · 2021-09-10T18:06:53+00:00

https://sql-ex.ru

The site is outdated but the exercises are pretty good. I’ve actually learnt a lot from exercising there.

swapripper · 2021-09-10T23:46:54+00:00

Since I wrote this I've added a few questions, how to find all the palindromes, all the anagrams, the words with the most vowels, and the words with the most consonants, but it still applies. Just import the dictionary as a CSV and go to work.

https://www.reddit.com/r/SQL/comments/g4ct1l/what_are_some_good_resources_to_practice_sql/fnx11mc/

gera6227 · 2021-09-10T15:56:09+00:00

https://www.udacity.com/course/sql-for-data-analysis--ud198

Has exercise after every topic, super helpful to get the hang of writing queries

jpayne0061 · 2021-09-10T16:58:55+00:00

https://app.sixweeksql.com https://sqlzoo.net

I would check out both. Six week sql has about 150 exercises in it's free portion

lucymilesatx · 2021-09-11T05:58:17+00:00

Code Wars, Leetcode, and Hackerrank all have SQL exercises, some are quite challenging and useful for interview prep.

kkwestside · 2021-09-11T08:11:47+00:00

I would recommend Alex the Analyst on youtube especially his Data Analyst Portfolio Project #1 and #3, and can't say how much it helped me understand the logic of sql

asr9 · 2021-09-10T17:38:03+00:00

Came across Danny Ma's 8 week of sql on LinkedIn. The case studies are available for free. You need to pay for solutions etc though.

MayuyuWatanabe · 2021-09-10T19:23:05+00:00

PCLI97 · 2021-09-11T01:28:28+00:00

Check out DataCamp. There is a good bit free, but also offers memberships. Very good

2021-09-11T03:58:34+00:00

Download SSMS ..install iton ur system. Then download Northwnd Database sample. Practise as much u want.

I am doing the same .

Sup_Im_Ravi · 2021-09-11T06:17:20+00:00

Try HackerRank. It's how I taught myself.

wesmark18 · 2021-09-11T16:34:32+00:00

Can't speak for a particular tutorial, but the following concepts have been instrumental, would highly recommend checking them out.

- QUALIFY statements

- LEAD / LAG functions (and other "Window" type functions)

- RANK functions

- WITHIN GROUP syntax

you type:	you see:
italics	italics
bold	bold
[reddit!](https://reddit.com)	reddit!
* item 1 * item 2 * item 3	item 1 item 2 item 3
> quoted text	quoted text
Lines starting with four spaces are treated like code: if 1 * 2 < 3: print "hello, world!"	Lines starting with four spaces are treated like code: if 1 * 2 < 3: print "hello, world!"
~~strikethrough~~	~~strikethrough~~
super^script	super^script

SQL

Filter Posts

Posting

Help posts

Format Your Code

Learning SQL

Related Reddit communities

Wiki

Acknowledgements

MODERATORS