#36 in SQL books
Use arrows to jump to the previous/next product
Reddit mentions of Joe Celko's Thinking in Sets: Auxiliary, Temporal, and Virtual Tables in SQL (The Morgan Kaufmann Series in Data Management Systems)
Sentiment score: 1
Reddit mentions: 1
We found 1 Reddit mentions of Joe Celko's Thinking in Sets: Auxiliary, Temporal, and Virtual Tables in SQL (The Morgan Kaufmann Series in Data Management Systems). Here are the top ones.
or
- 440 Stainless steel with strong, VERY SHARP blade plus 2 THROWING KNIFE
- Perfect weight, not too light but not too heavy, very handy to chop or slash object, like fruit, paper box, etc
- Attach to belt or use strap on shoulder / Flexible way of carrying
Features:
Specs:
| Height | 9.25 Inches |
| Length | 7.4 Inches |
| Number of items | 1 |
| Release date | February 2008 |
| Weight | 1.7196056436 Pounds |
| Width | 0.87 Inches |
Whelp, believe what you want but some studies have shown that by believing [certain group] are better at a given mental task you will, on average, perform worse at it, even if you are part of [certain group].
Anyways - SQL isn't like many other programming languages. It changes very slowly. So an 'outdated' resource is about 95% as good as a 'modern' one. If I was learning from scratch I'd start off by downloading & installing MySQL + MySQL workbench. You'll want to learn and understand relational databases so you should watch this course by Richard Schneeman. It's fantastic and while it is oriented toward Ruby on Rails it's a great introduction.
Once you've got the basic theory under your belt it's time to dive in with a bit of practice. Head over to sqlzoo and run through the exercises. If you get stuck search google / stackoverflow for answers. Don't just copy & paste. Try and understand what you're doing!
Take good notes, it will help you remember things later on.
After you've done all this, and you feel confident that you like the work go to Udemy / Udacity and search for a few courses in things you're interested in. I'd try out the courses in the data scientist track on Udacity. You can view them for free, and if you pay some money you can get a certification (though how much its worth is still up in the air).
Ok - now time to really step it up. Go to codewars and work your way to at least 5kyu in SQL. It's technically Postgres, not MySQL - but the core concepts are the same. Read through "Thinking in Sets". Again - take notes! You want to remember this stuff.
Finally practice building a few databases of your own using workbench. Once you've got that down, practice building them using the command line. Now you're ready for a basic job using SQL :)
good luck!