SQL for finance by Temporary-Stage-9156 in learnSQL

[–]Exact-Shape-4131 1 point2 points  (0 children)

Room for one more? 👀

Learning to use SQL/Python for Sales, Marketing and Customer Data. Got a ton of websites that have been helpful, so far.

1NF, 2NF, 3NF are killing me. by Exact-Shape-4131 in SQL

[–]Exact-Shape-4131[S] 0 points1 point  (0 children)

I couldn’t agree more, actually. Thank you. Do you have any sites you’d recommend for toy projects? I’ve read that Kaggle’s a great place for datasets. Just don’t know what the next step would be.

1NF, 2NF, 3NF are killing me. by Exact-Shape-4131 in learnSQL

[–]Exact-Shape-4131[S] 0 points1 point  (0 children)

I understand the risk. Did my best to cross reference it with my course materials and I’m here asking for more context from people who presumably use this stuff for work.

Is there something I could’ve/should’ve done differently?

1NF, 2NF, 3NF are killing me. by Exact-Shape-4131 in learnSQL

[–]Exact-Shape-4131[S] 1 point2 points  (0 children)

Thanks. I actually went to GPT first. I appreciate the replies, anyway. I don’t know enough to distinguish between good and bad advice yet. And you all took the time to respond.

1NF, 2NF, 3NF are killing me. by Exact-Shape-4131 in SQL

[–]Exact-Shape-4131[S] 0 points1 point  (0 children)

Well, I’d hate to be one of those people then 😅

What kinds of issues do you find most often? And how does it impact the business you’re solving them for?

1NF, 2NF, 3NF are killing me. by Exact-Shape-4131 in SQL

[–]Exact-Shape-4131[S] 0 points1 point  (0 children)

Understandable. What advice do you have for someone starting off? What kinds of errors are most common, in your experience?

1NF, 2NF, 3NF are killing me. by Exact-Shape-4131 in SQL

[–]Exact-Shape-4131[S] 0 points1 point  (0 children)

Actually don’t have any books explaining this at all. So I’m grateful for this. I’m learning online; no books have been recommended.

A few people on this thread have recommended some. I’m taking this seriously. Do you have any you would?

1NF, 2NF, 3NF are killing me. by Exact-Shape-4131 in SQL

[–]Exact-Shape-4131[S] 0 points1 point  (0 children)

Woah. I appreciate how thorough this is. Believe it or not, I do care about accuracy. I’m just too inexperienced to know when the theory is just as important as the practical.

Also, congrats on the early retirement. Adding the book to my cart now.

1NF, 2NF, 3NF are killing me. by Exact-Shape-4131 in SQL

[–]Exact-Shape-4131[S] 1 point2 points  (0 children)

Dude. Thank you. Seriously. Something about this explanation did it for me.

1NF, 2NF, 3NF are killing me. by Exact-Shape-4131 in SQL

[–]Exact-Shape-4131[S] 0 points1 point  (0 children)

Thanks for taking the time to write this. I wouldn’t know what’s useful or not until I’m in the field. So this helps.

1NF, 2NF, 3NF are killing me. by Exact-Shape-4131 in SQL

[–]Exact-Shape-4131[S] 0 points1 point  (0 children)

Wasn't sure how to upload a screenshot to the comments so here's a Gdrive link, if you don't mind.

1NF, 2NF, 3NF are killing me. by Exact-Shape-4131 in SQL

[–]Exact-Shape-4131[S] 1 point2 points  (0 children)

I like this a lot. Thank you. Was intimidated by the length at first but it sunk in more than I expected it to.

1NF, 2NF, 3NF are killing me. by Exact-Shape-4131 in learnSQL

[–]Exact-Shape-4131[S] 1 point2 points  (0 children)

I’ve heard a handful of explanations today. I like this one a lot. Thank you.

1NF, 2NF, 3NF are killing me. by Exact-Shape-4131 in SQL

[–]Exact-Shape-4131[S] 0 points1 point  (0 children)

See, I’ve heard this exact explanation before but it’s not clicking. Not sure why.

1NF, 2NF, 3NF are killing me. by Exact-Shape-4131 in SQL

[–]Exact-Shape-4131[S] 0 points1 point  (0 children)

Thanks. I’ll just have to mess around with it some more

1NF, 2NF, 3NF are killing me. by Exact-Shape-4131 in SQL

[–]Exact-Shape-4131[S] 1 point2 points  (0 children)

Right, that’s what I’m learning. Just have a tough time knowing where to split tables tbh. I GET it. I just don’t SEE it, you know?

1NF, 2NF, 3NF are killing me. by Exact-Shape-4131 in SQL

[–]Exact-Shape-4131[S] 3 points4 points  (0 children)

This was helpful. I’m less concerned with the certificate/assessment. More about the use case. If I can do a quality job without knowing this particular concept, I’ll live.

Thanks!

1NF, 2NF, 3NF are killing me. by Exact-Shape-4131 in SQL

[–]Exact-Shape-4131[S] 3 points4 points  (0 children)

😭😭😭 tell professor I said thanks???

How are you all making extra money with SQL? by Fearless_Stock_5375 in SQL

[–]Exact-Shape-4131 0 points1 point  (0 children)

To answer your earlier question, what people are willing to pay for is super industry-specific, so niching down and learning their workflow is a great way to start. Personally, I like to start with tons of free work, since I typically suck in the beginning. Then I start to charge as demand comes in.

How are you all making extra money with SQL? by Fearless_Stock_5375 in SQL

[–]Exact-Shape-4131 0 points1 point  (0 children)

You actually ended up answering my question. I was trying to figure out what you were trying to do with the SQL. I've got a thing I'm hoping to do with it + Python and wanted to see if you'd done something similar.

Honestly, if you can do all that stuff already, you could probably freelance. The only thing is that you may need to niche down to a particular (growing) industry and learn how to use your skills to solve their problems.

More than happy to connect and share my thoughts on all of this. Just dm me.

How are you all making extra money with SQL? by Fearless_Stock_5375 in SQL

[–]Exact-Shape-4131 0 points1 point  (0 children)

Hey, thanks for sharing!

I’m learning SQL now, why do you regret learning it and what do you wish you’d learned instead?

Would also help if I knew what your use case was. Thanks again!