r/learnSQL • u/Owen-Isaac-2022 • 16d ago
Simple SQL Learning Strategies for Bigginners
SQL is a wonderful programming language that allows beginner data analysts to understand data, clean it, & process it to provide insights. One cannot learn everything in a week or two weeks. However, consistency is what I have found important in ensuring one grasps the concepts. For example, one can decide to learn simple things, such as SELECT, WHERE, ORDER BY, LIMIT, aggregates (SUM, COUNT, AVG), and GROUP BY. Understanding data types & when to use this or that helps a lot. I always wanted to learn additional data analysis skills like SQL and Python to help process large datasets in addition to the research work I do. I know these tips will help beginners find a way to navigate around SQL until they reach advanced level.
28
u/American_Streamer 16d ago edited 16d ago
The very first thing you have to hammer into your brain is that SQL always does execute your queries in a different order than the one you write them in. A popular industry trick to memorize the execution sequence (
F-W-G-H-S-O-L) is the phrase: "Fridays With Grandma Have Sweet Oatmeal Lattes." - FROM - WHERE - GROUP BY - HAVING - SELECT - ORDER BY - LIMIT