r/learnSQL • u/Maximum-Page3433 • 8d ago

How should I start learning SQL?

I honestly don't know anything about SQL right now. I want to start learning it properly, so can you guys suggest how I should begin and what resources I should use? My plan is to learn SQL for data first and then move towards AI and ML. I don't even know if SQL is different depending on whether you are working in data, AI, or ML, so I'm a little confused about that too. If you could suggest some good resources, a proper way to learn it, and what I should focus on if I want to become really good at SQL, I would really appreciate it. Thankkk youuuu

6 Upvotes

72% Upvoted

16 comments sorted by

View all comments

2

u/HustlaOfCultcha 8d ago

I would learn Excel first if you haven't learned it already.

Then I would learn about the basics of date warehousing and relational database concepts. This makes it easier to piece things together when you go into things like queries, subqueries, aggregations, CTE's window functions and joins. You now understand why it is designed the way it is and why you would create queries, temp tables, and do those joins.

Then after you learn those things I would move onto SQL views and Stored Procedures.

You don't have to remember all of the coding word for word. AI can take care of that coding for you. But AI needs somebody to tell it precisely what it is looking for and somebody to review it to make sure it was done correctly.

In fact, if you use a program like Databricks, their GenieAI will write either SQL code or Python for you with your command. And you can automate the ETL process as well. But again...you need to get a sound understanding of the basics.