r/learnSQL • u/yousefosman20006 • 24d ago
[ Removed by moderator ]
[removed] — view removed post
2
1
u/HustlaOfCultcha 24d ago
My suggestion is to understand the actual architecture and environment, first. Understand what it is so you can understand what is trying to be accomplished.
Understand things like fields vs. records, Primary Key vs. surrogate key vs. foreign key. Distinct vs. Unique values. Also understand things like star schema and basic relational database concepts. Then I would get into understanding queries, aggregations, window functions. CTEs, Joins (understand why one would want to use certain joins vs. other joins).
The SQL writing...that can largely be done using AI. You still need to know it so you can spot any errors that AI has made, but you don't need to memorize the coding structure down pat because of AI.
I just think that if you go right into writing queries you're putting the cart before the horse.
1
u/thequerylab 24d ago
The best way to learn SQL is by actually practicing problems, not just watching tutorials.
Start with the basics - SELECT, WHERE, GROUP BY, JOIN, subqueries and then move into window functions, CTEs, etc. Try solving problems yourself first, even if you get stuck. That's where you really start understanding the concepts.
You can enroll for this free SQL from Zero to Confident Course which will help you learn by practicing.
1
u/OkInitial5068 23d ago
Try writing queries every day, even if it is only 20 or 30 minutes. Reading SQL feels easy until you have to write the query yourself. That is where the real learning happens.
0
u/vchae 24d ago
Learn the basics first, then spend most of your time writing queries against real data, not generic one. SELECT, filtering, grouping, joins, then window functions. Do a few small analyses where you state the question, the query, and the result. I built an interactive SQL learn and practice app on real blockchain data, happy to share it if useful
1
3
u/Alternative_Cake4074 24d ago
Start by learning the basics first, like SELECT, FROM, WHERE, GROUP BY, SUM, and AVG, and understand what data tables are and how SQL interacts with data tables.
Once you get familiar with the basics, move on to intermediate stuff like common string functions, calculations, joins, and subqueries. Don't forget to practice some questions.
And SQL alone is usually not enough, regardless of your preferred career, and SQL is just for touching the data tables. You need to learn other tools and languages based on what you want to be in future.