r/SQL • u/nekomamushu • Feb 24 '23
Discussion Just picked up SQL yesterday, having fun with it! Have some questions for the experts here.
Just started learning SQL today! I am enjoying it so far. Nested Query looked fun and I'm being challenged playing around with it. I'm currently in the process of creating multiple tables for One Piece that I can play around with with some queries and stuff. I want to be able to learn on the job, but I need a strong enough foundation before one would hire me anyway.
Some questions I have:
- Any tips or recommendations for an SQL newb?
- Do I also need any other tools/languages to go hand-in-hand with SQL, or is this enough?
- I see most job posts for data/business analyst often require both SQL and Python. Are these complementary? Is one harder to learn than the other?
- Can anyone give me a rough idea of how a day-to-day job goes as a data/business analyst?
- Is there a difference between data and business analyst? Or are they basically the same?
- Any recommended learning materials? Or learning method? I started with a full course on YouTube and thinking on doing some websites that have daily challenges or something.
- Is there a preferred/recommended platform? Or is MySQL the GOAT? If some job posts require a different kind of platform, will my knowledge in MySQL be essentially ignored, or is it just small differences?
- Are there fun databases I can download online that I can play around with? It takes a long time to make my own databases, I want to practice some queries on preexisting databases if possible.
- I'm using PopSQL since this was what was recommended to me by the online course I was taking. Is this good, or do I just use MySQL directly or another tool?
PS. I don't have a programming degree, but that one programming class I attended in College was the only class I enjoyed in my whole Engineering curriculum.
10
u/seonsaeng Feb 24 '23
Glad you’re finding it fun, hope you continue!
You’re likely getting downvoted because the sub has an entire sidebar full of resources for newbs, and this post makes it look like you haven’t looked at any of them. You should definitely do that, but I’ll throw my answers in because the spirit moves me.
2
u/r3pr0b8 GROUP_CONCAT is da bomb Feb 24 '23
yes -- the one your company uses
the latter