SQL Beginner Guide
Learn SQL the simple way ■
This guide covers the most important SQL concepts every beginner should know:
■ SELECT & WHERE
■ ORDER BY & GROUP BY
■ HAVING Clause
■ INNER JOIN & LEFT JOIN
■ NULL Behavior
■ COUNT(), AVG(), SUM()
■ LIMIT & CASE
■ Beginner SQL Tricks
Created by @[Link]
1. SELECT Statement
Definition: The SELECT statement is used to retrieve data from a database table.
Why It Matters: It is the most commonly used SQL command because every query starts with
fetching data.
SELECT name, salary FROM employees;
Quick Tip: Use SELECT * only for learning. In real projects, select only required columns.
2. WHERE Clause
Definition: WHERE filters rows based on a condition.
Why It Matters: Useful when you only want specific data instead of the whole table.
SELECT * FROM employees WHERE salary > 50000;
Quick Tip: WHERE works before GROUP BY in query execution.
3. ORDER BY
Definition: ORDER BY sorts data in ascending or descending order.
Why It Matters: Useful for rankings, reports, leaderboards, and displaying organized data.
SELECT * FROM employees ORDER BY salary DESC;
Quick Tip: ASC is default. DESC sorts highest to lowest.
4. GROUP BY
Definition: GROUP BY combines rows with the same values into groups.
Why It Matters: Mostly used with aggregate functions like COUNT(), AVG(), SUM().
SELECT department, COUNT(*) FROM employees GROUP BY department;
Quick Tip: Every non-aggregated column must appear in GROUP BY.
5. HAVING Clause
Definition: HAVING filters grouped data after GROUP BY.
Why It Matters: WHERE cannot filter aggregate results, but HAVING can.
SELECT department, COUNT(*) FROM employees GROUP BY department HAVING COUNT(*) > 5;
Quick Tip: Think of HAVING as WHERE for grouped results.
6. INNER JOIN
Definition: Returns only matching rows from both tables.
Why It Matters: Used to combine related information from multiple tables.
SELECT [Link], [Link] FROM customers INNER JOIN orders ON [Link] = o
Quick Tip: INNER JOIN ignores unmatched rows.
7. LEFT JOIN
Definition: Returns all rows from the left table and matched rows from the right table.
Why It Matters: Helpful when you want complete data even if matches do not exist.
SELECT [Link], [Link] FROM customers LEFT JOIN orders ON [Link] = or
Quick Tip: Unmatched rows return NULL values.
8. NULL Values
Definition: NULL represents missing or unknown data.
Why It Matters: Understanding NULL is very important because it behaves differently from normal
values.
SELECT 10 + NULL;
Quick Tip: Any operation with NULL usually returns NULL.
9. COUNT(), AVG(), SUM()
Definition: Aggregate functions perform calculations on multiple rows.
Why It Matters: Used heavily in reports and analytics.
SELECT COUNT(*), AVG(salary), SUM(salary) FROM employees;
Quick Tip: COUNT(*) counts rows including NULL rows.
10. LIMIT
Definition: LIMIT restricts the number of rows returned.
Why It Matters: Useful for previews, pagination, and testing queries.
SELECT * FROM employees LIMIT 5;
Quick Tip: LIMIT is commonly used with ORDER BY.
Congratulations ■
You now know the SQL basics that most beginners struggle with.
The best way to improve in SQL is:
✔ Practice daily
✔ Solve small queries
✔ Build mini projects
✔ Learn how databases actually work
Keep learning consistently ■
Follow @[Link]
For more SQL, Python & Java content.