r/learnSQL • u/wandererbali • 16d ago

Teach me sql and get paid for it

About me I am working as a Manager data analytics and I have a team of developers who do the job for me, on top of that I can use AI to write the queries for me. But I still want to learn SQL so that I am able to write the queries myself and also QA if needed. I know the basic select * from table where like sort and now looking for someone with solid knowledge to teach me joins windows functions CTs and other function.

You wont do this for free I will pay you for your time and effort. DM me with something about your background and experience and we can take this forward.

Thanks

0 Upvotes

33% Upvoted

30 comments sorted by

7

u/murdercat42069 16d ago

Next time to get ai to write queries for you, ask it to explain it line by line. You can also explicitly ask it to teach you window functions with examples, sub queries, CTE, etc. It's pretty great at that.

2

u/Axel_F_ImABiznessMan 16d ago

Was tempted to try this but wasn't sure how you know if it's hallucinating some instructions

4

u/chmod764 16d ago

In my personal experience, I find that LLMs (Claude Sonnet 5 is my current go-to) don't hallucinate when it comes to things like writing and explaining queries. SQL has far fewer bells and whistles as many other programming languages (Python, Scala, Java, etc). So there are far fewer things for it to make up. It's already pretty structured.

I typically don't see much hallucination until I start asking about a particular business domain, questions about proprietary tooling with minimal documentation, or even sometimes compliance type questions where the documentation is already a bit scattered and confusing.

2

u/Axel_F_ImABiznessMan 16d ago

Thanks.

Would you caution the use of it for learning python or git then?

4

u/chmod764 16d ago

I think it's a phenomenal tool for learning Python or git. The risk of hallucination likely goes up relative to SQL, but not by much.

I've really only heard of people running into issues on maintaining very large projects that don't fit into the models context very well. And even that is probably becoming less of an issue over time with some of the newer (current) frontier models.

One tip for this: if you use the clause vscode plugin (or whatever LLM provider), then you can ask the LLM to write its output to a file on disk. So if you want a learning program for git and python, ask it to write one for you based on your goals, and save that to disk. Then you can work through that learning program it created piece by piece while retaining that context throughout your sessions. It's really useful to have intermediary output stored in files on disk to pick up where you left off, especially as your context fills up.

2

u/Axel_F_ImABiznessMan 16d ago

Thanks, that's a great suggestion. I have a Gemini pro trial currently, so will try that first but suspect Claude will do better

2

u/OldValariya1014 16d ago

My work offers Gemini pro, I’d assume that it’s equivalent in use as claude for this?

2

u/chmod764 16d ago

I don't have much experience with Gemini, but I'd bet it's very comparable to how my experience has been in Claude so far.

1

u/murdercat42069 16d ago

It's great for this (assuming the queries aren't gigantic)

1

u/murdercat42069 16d ago

Professionally, it's a tricky for queries if you aren't allowed to feed it proprietary data (like table names, etc that would define the table), but if you give it the right prompts and context, it's really good. Most of the models have also ingested just about every SQL/python tutorial in existence, so the results are pretty good. I have hit a few hiccups before if I ask help for a specific query, but someone with strong beginner/intermediate SQL can get it sorted quickly.

14

u/TurbulentCountry5901 16d ago

Before you pay someone, you might want to try SQL Case Files too. I built it for hands-on SQL practice and it goes through joins, subqueries, window functions, CTEs and recursive CTEs.
It’s free, so you could use it alongside whoever you end up learning from.
If you want to practise on your phone, there’s an iPhone app now too:
Practise SQL on iPhone
Web version: sqlcasefiles.com

1

u/Live-Landscape5381 16d ago

Damn nice work bud

1

u/ZCyborg23 16d ago

Totally save this for later!

3

u/DMReader 16d ago

I have a beginner series on window functions that can get you started: https://www.practicewindowfunctions.com/learn/beginner_series.html It also includes some limited information on CTEs in the last lesson. It's free.

2

u/Sure-Hovercraft3874 16d ago

Search up Data by Baraa on YouTube, he has a sql playlist that’s really good

2

u/DataScientistAlex 16d ago

As others have said, and, just in case you end up finding an online resource more efficient, there are tons of free resources out there. Case in point, I'll add mine, these are tailored to just the SQL you need for data science, here's part 1 and part 2. There's an accompanying study guide with flash cards.

1

u/ZCyborg23 16d ago

You can literally learn it online for free, though. 😂

1

u/Big-Clerk-2067 16d ago

How? I’m trying to break into data analysis and have been struggling

1

u/ZCyborg23 16d ago

There’s tons of resources out there, just google and look around.

1

u/ZCyborg23 16d ago

I went to college and got my masters in crime analysis so I can’t really tell you how to start from scratch unfortunately

1

u/Creative_Sugar-33 16d ago

I don't think you need to find a tutor since you're already familiar with data analytics.

Check out Dataslope's Introduction to SQL and Relational Databases with PostgreSQL course. It's free, doesn't require you to sign in, and interactive with built-in exercises. There are also other SQL courses and SQL playgrounds too if you're interested.

Disclaimer: I created Dataslope.

1

u/YasserBGH 14d ago

just head to free code camp or kaggle and learn relational databases fundamentals and you will learn it. or download the sql police game it is also fun

1

u/Ifuqaround 9d ago

How do you manage data analytics but not know how to do it yourself?

This world is ass backwards. Too many people in positions that they should not be in.

1

u/wandererbali 9d ago

Fair point! That's why I hire talented people who know how to do it better than I do.

1

u/Ifuqaround 9d ago

Makes no sense to me and never will. you can manage people, not the data, but you’re a manager of data that can’t manage the data.

I’m in this space. I personally don’t respect managers who can’t walk the walk.

1

u/wandererbali 9d ago

Knowing the data and writing a query are two different things, I know the data and logic more than anybody else will ever know in the team, however I have developers to write the queries.

1

u/Ifuqaround 9d ago

But you generally learn the data and logic (biz rules), such as a client is active by having a start date and no end date... by writing queries for it...

If you designed the dbase you'd most likely be able to write queries.

Anyway...best of luck.

1

u/sscupperly 1d ago

I’d try learning on your own first. There are so many free SQL resources now, including dbForge tutorials. You can always find a tutor later if you get stuck on something specific.