The new forums will be named Coin Return (based on the most recent vote)! You can check on the status and timeline of the transition to the new forums here.
The Guiding Principles and New Rules document is now in effect.
Learning SQL
TheBlackWind
Registered User regular
Registered User regular
So, I have it in my mind that I'd like to learn to work with SQL. My initial instinct was just to grab a book and practice, but there are a lot of books!
I'm curious if anyone has any recommendations for books or alternate methods to learn. Something self-paced is ideal, but if someone has a better idea than a book, I'd be open to it.
Thanks!
I'm curious if anyone has any recommendations for books or alternate methods to learn. Something self-paced is ideal, but if someone has a better idea than a book, I'd be open to it.
Thanks!
PAD ID - 328,762,218
0
Posts
is a site I found from someone on here. I give it to my employees to help them understand it and it's reasonably complete from a basics perspective. Beyond basics it's highly dependent on database how you structure things.
B.net: Kusanku
Also, I got a lot of classes (some free) at Udemy.com they often have bundled deals.
I'd say maybe find a dataset (in Access format or something) and maybe an accompanying study/tutorial, and go off the questions they ask you.
Because it's super easy to write a query for something like "Find me all the salesman from the state of NY", but it doesn't really get you any closer to being good at SQL.
BF3 Battlelog | Twitter | World of Warships | World of Tanks | Wishlist
I write reports out of medical software. All I knew of SQL going in was some half remembered stuff from a databases class I took 10 years earlier and really really basic selects with maybe one join.
Trying to figure out how to find and compile information that other people wanted definitely helped me with the"questions" problem.
Things that would be helpful to practice:
- Different join types
- inner
- outer
- exclusion
- linear joins
- etc.
- aggregating information
- things like using sub-selects or correlated sub-queries to find a value in one table that's between a related value on another table (eg. a table with some sort of activity log where you want to find the most recent activity occurring between timestamps on another table)
- case statements
- in-line tables
This isn't an exhaustive list, and it's only from the perspective of using existing data, not creating or updating, but if you can do these things, you've got a good start.Are you looking to get into the analytical side or the IT admin side?
Definitely lean more towards analytic with my prior work, though I'm sure if I wanted to pursue certification there's a lot of overlap.
If that's the case and you're looking for things to learn, here's what I'd recommend (if you don't have expertise already):
BI Tools - MicroStrategy, Tableau etc. - a bunch have free personal editions now you can use to train yourself
Python - it's becoming a go-to piece of big data coding as some people move away from R with MicroSofts purchase of Revolution.
Big data tools like Spark/Hadoop etc.
yeah, basically these exact things
sql zoo was the tutorial recommended to me that helped get me my current job
now at my job i use tableau a good bit (and there is tableau public which you can use for free to learn)
learn some python, using pandas (data frameworks and such) is helpful
and right now i am learning spark for big data stuff (used to use pig but we moved to spark)
Yeah, some people at my work were going through that together... I should have joined them
Yeah, I started it, but had to drop working it halfway through due to work/real life stuff.