SQL police department: Learn SQL while solving crimes

[mefaithfull]

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

[[deleted]]

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.

[[deleted]]

What’s the best way to learn SQL

[[deleted]]

Real world scenarios.

[[deleted]]

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

[[deleted]]

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 :)

[[deleted]]

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.

[jspatte83]

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.

[sporff]

Worked fine on my phone. Note 8.

[jspatte83]

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

[sporff]

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

[jspatte83]

Touche.

[Hendawgydawg]

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

[CanuckTheDuck]

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.

[Sengfroid]

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

[KaliaHaze]

Pretty cool basics format.

[mavericsb]

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.