4 ms·

I always wanted do invest my 20 hrs into SQL. I've already put 10 with a data analyst course so i know what a sqlite , select and joins are. I've created a not

I always wanted do invest my 20 hrs into SQL. I've already put 10 with a data analyst course so i know what a sqlite , select and joins are. I've created a not trivial query once. Is this OK for learn some more ?

rntksi 7y ago
Sure thing. I think learning SQL is never wasted time. Try looking into SQL functions & TRIGGERs, LATERAL JOINs, ROLLUP & CUBE. If you have even more time, check out the different things an SQL server can do when you DROP a row that contains references, how you define CONSTRAINTs, and some particular features that only some subset of SQL dialects have, such as LISTEN/NOTIFY for PostgreSQL.
- UweSchmidt 7y ago
  And, for anyone looking to pick up the basics: These ancient websites got me up to speed ages ago: www.sqlcourse.com www.sqlcourse2.com
- pathseeker 7y ago
  >Try looking into SQL functions & TRIGGERs, LATERAL JOINs, ROLLUP & CUBE. If you're a developer, I would look into CONSTRAINTS way before getting to anything like this. Learning how to model your constraints correctly in the database (preventing duplicates, etc) is one of the most important bits of schema design because it will save you tons of code and likely a bunch of race conditions.
- freeqaz 7y ago
  Knowledge is power and knowing more deeply about what your database is capable of is very helpful. It's worth knowing every tool in your tool chest! That said, be careful with going too overboard with one specific tool (SQL). You may find yourself using a hammer for everything, when another tool may be more appropriate. More specifically, it's easy to abuse advanced SQL constructs to create a mess for yourself. Too much business logic in the database is something I've seen become a nightmare for other programmers looking at software later. :) This post[0] goes a bit into more detail about explaining where you should keep your "business logic" when choosing to put it in code or into SQL. 0: https://softwareengineering.stackexchange.com/questions/194446/how-much-business-logic-should-the-database-implement https://softwareengineering.stackexchange.com/questions/1944...
csomar 7y ago
Yes, I think it's very useful. There are lots of things that SQL can do that are being done by code right now because the developers don't know any better.
kevindong 7y ago
The game itself has a walkthrough [0] of all the SQL features you need to solve the murder mystery. From skimming through it, it seems to be pretty good and succinct. [0]: https://mystery.knightlab.com/walkthrough.htmlhttps://mystery.knightlab.com/walkthrough.html https://mystery.knightlab.com/walkthrough.htmlhttps://myster...
esaym 7y ago
https://theartofpostgresql.com/ https://theartofpostgresql.com/
- hultner 7y ago
  Added to my buy/reading list. Looks like it could be a good mix of simpler queries and more advanced concepts.
sn9 7y ago
Stanford's Intro to DBs course is probably the best introduction to SQL available online. https://lagunita.stanford.edu/courses/DB/2014/SelfPaced/about https://lagunita.stanford.edu/courses/DB/2014/SelfPaced/abou...

rntksi 7y ago

Sure thing. I think learning SQL is never wasted time. Try looking into SQL functions & TRIGGERs, LATERAL JOINs, ROLLUP & CUBE. If you have even more time, check out the different things an SQL server can do when you DROP a row that contains references, how you define CONSTRAINTs, and some particular features that only some subset of SQL dialects have, such as LISTEN/NOTIFY for PostgreSQL.

UweSchmidt 7y ago
And, for anyone looking to pick up the basics: These ancient websites got me up to speed ages ago: www.sqlcourse.com www.sqlcourse2.com
pathseeker 7y ago
>Try looking into SQL functions & TRIGGERs, LATERAL JOINs, ROLLUP & CUBE. If you're a developer, I would look into CONSTRAINTS way before getting to anything like this. Learning how to model your constraints correctly in the database (preventing duplicates, etc) is one of the most important bits of schema design because it will save you tons of code and likely a bunch of race conditions.
freeqaz 7y ago
Knowledge is power and knowing more deeply about what your database is capable of is very helpful. It's worth knowing every tool in your tool chest! That said, be careful with going too overboard with one specific tool (SQL). You may find yourself using a hammer for everything, when another tool may be more appropriate. More specifically, it's easy to abuse advanced SQL constructs to create a mess for yourself. Too much business logic in the database is something I've seen become a nightmare for other programmers looking at software later. :) This post[0] goes a bit into more detail about explaining where you should keep your "business logic" when choosing to put it in code or into SQL. 0: https://softwareengineering.stackexchange.com/questions/194446/how-much-business-logic-should-the-database-implement https://softwareengineering.stackexchange.com/questions/1944...

csomar 7y ago

Yes, I think it's very useful. There are lots of things that SQL can do that are being done by code right now because the developers don't know any better.

kevindong 7y ago

The game itself has a walkthrough [0] of all the SQL features you need to solve the murder mystery. From skimming through it, it seems to be pretty good and succinct. [0]: https://mystery.knightlab.com/walkthrough.htmlhttps://mystery.knightlab.com/walkthrough.html https://mystery.knightlab.com/walkthrough.htmlhttps://myster...

esaym 7y ago

https://theartofpostgresql.com/ https://theartofpostgresql.com/

hultner 7y ago
Added to my buy/reading list. Looks like it could be a good mix of simpler queries and more advanced concepts.

sn9 7y ago

Stanford's Intro to DBs course is probably the best introduction to SQL available online. https://lagunita.stanford.edu/courses/DB/2014/SelfPaced/about https://lagunita.stanford.edu/courses/DB/2014/SelfPaced/abou...