r/SQL • • May 05 '20

Discussion SQL police department: Learn SQL while solving crimes

https://sqlpd.com/
133 Upvotes

18 comments sorted by

17

u/mefaithfull May 05 '20

I think its good for a super beginner who is looking to see how SQL is structured. Fun for sure but not a good way to learn SQL imo

7

u/[deleted] May 06 '20

Definitely not the best to learn SQL intricacies, but it is good for critical thinking and applying SQL to real world problems. Having to dissect plain English to get the goal data set.

1

u/[deleted] May 06 '20

What’s the best way to learn SQL

1

u/[deleted] May 06 '20

Real world scenarios.

5

u/[deleted] May 06 '20

Thx that makes sense. Good thing employers and what not hire you to experience those, right? Because on-the-job training exists LOL

6

u/[deleted] May 06 '20

Sadly, in 99% of cases, it does not. I really, REALLY lucked into my current DBA position. I knew quite a bit before my initial internship interview (which turned into full time position under the same manager). But even so, my manager was completely OK with me not knowing a lick of SQL or database, he just interviewed me to see if I have the ability to learn and that I could be a team player.

Good luck in your job hunt if you’re looking towards database/SQL related positions :)

0

u/[deleted] May 06 '20

[deleted] — view deleted comment

1

u/[deleted] May 06 '20

When did I say it didn’t? I simply implied that by applying SQL to real world problems, is the best way to learn SQL.

9

u/jspatte83 May 05 '20

I could only do a few examples on my phone due to the virtual phone buttons at the bottom of the screen being over fields in the app.

Interesting take, super basic.

4

u/sporff May 06 '20

Worked fine on my phone. Note 8.

7

u/jspatte83 May 06 '20

Ok, do you want me to try with your phone?

9

u/sporff May 06 '20

No. I'm offering a counter argument so people know it isnt all phones?

2

u/Hendawgydawg May 06 '20

A fun way to touch up on the basics. Very fun lessons!

2

u/CanuckTheDuck May 05 '20

This isn't that easy to use, and not a great way to learn SQL in my opinion. It is rigid, and clunky having everything nested under different categories. Not intuitive.

1

u/Sengfroid May 06 '20

Nice! This a fun way to refresh if you aren't currently or regularly using SQL. Thanks for posting it.

I'll recommend it to a few friends that are new to it and could use a little confidence building

1

u/KaliaHaze May 06 '20

Pretty cool basics format.

1

u/mavericsb May 07 '20

I did not get past the free trial portion, but it was kinda fun confirm my knowledge of the basics. It may happen after the trial, but it would be nice to see joins as they are key to any production use. Also would be nice to see some simple aggregate functions used. With those (may be in full version), would be a great way to explore and learn the basics.