# Learn SQL

[Chapter 4: Introduction to DBMS: Designing and Implementing Databases from Scratch for Absolute Beginners](https://www.amazon.com/Introduction-DBMS-Designing-Implementing-Databases/dp/9355510268)

## POSTGRESQL FUNDAMENTALS

[Load PostgreSQL Sample Database](https://www.postgresqltutorial.com/postgresql-getting-started/load-postgresql-sample-database/)

1. [SELECT](https://www.postgresqltutorial.com/postgresql-tutorial/postgresql-select/)
2. [Column Alias](https://www.postgresqltutorial.com/postgresql-tutorial/postgresql-column-alias/)
3. [ORDER BY](https://www.postgresqltutorial.com/postgresql-tutorial/postgresql-order-by/)
4. [SELECT DISTINCT](https://www.postgresqltutorial.com/postgresql-tutorial/postgresql-select-distinct/)
5. [WHERE](https://www.postgresqltutorial.com/postgresql-tutorial/postgresql-where/)
6. [LIMIT](https://www.postgresqltutorial.com/postgresql-tutorial/postgresql-limit/)
7. [FETCH](https://www.postgresqltutorial.com/postgresql-tutorial/postgresql-fetch/)
8. [IN](https://www.postgresqltutorial.com/postgresql-tutorial/postgresql-in/)
9. [BETWEEN](https://www.postgresqltutorial.com/postgresql-tutorial/postgresql-between/)
10. [LIKE](https://www.postgresqltutorial.com/postgresql-tutorial/postgresql-like/)
11. [IS NULL](https://www.postgresqltutorial.com/postgresql-tutorial/postgresql-is-null/)
12. [Table Aliases](https://www.postgresqltutorial.com/postgresql-tutorial/postgresql-alias/)
13. [Joins](https://www.postgresqltutorial.com/postgresql-tutorial/postgresql-joins/)
14. [INNER JOIN](https://www.postgresqltutorial.com/postgresql-tutorial/postgresql-inner-join/)
15. [LEFT JOIN](https://www.postgresqltutorial.com/postgresql-tutorial/postgresql-left-join/)
16. [RIGHT JOIN](https://www.postgresqltutorial.com/postgresql-tutorial/postgresql-right-join/)
17. [SELF-JOIN](https://www.postgresqltutorial.com/postgresql-tutorial/postgresql-self-join/)
18. [FULL OUTER JOIN](https://www.postgresqltutorial.com/postgresql-tutorial/postgresql-full-outer-join/)
19. [Cross Join](https://www.postgresqltutorial.com/postgresql-tutorial/postgresql-cross-join/)
20. [Natural Join](https://www.postgresqltutorial.com/postgresql-tutorial/postgresql-natural-join/)
21. GROUP BY
22. UNION
23. INTERSECT
24. HAVING
25. GROUPING SETS
26. CUBE
27. ROLLUP
28. Subquery
29. ANY
30. ALL
31. EXISTS
32. INSERT
33. INSERT Multiple Rows
34. UPDATE
35. UPDATE Join
36. DELETE
37. DELETE Join
38. Upsert

## Additional Learning Resources:

[Watch SQL For Beginners Tutorial](https://www.youtube.com/watch?v=5hzZtqCNQKk)

[Database Management Systems and SQL – Tutorial for Beginners](https://www.freecodecamp.org/news/dbms-and-sql-basics/)
