---
title: "Belajar SQL dengan PostgreSQL"
url: https://mathdium.com/posts/belajar-sql-dengan-postgresql
category: "SQL"
author: "Ibnu Toriq"
published: 2022-02-25
description: "Topik ini akan berisi materi belajar SQL dengan PostgreSQL, berikut listnya: Apa itu PostgreSQL"
---

# Belajar SQL dengan PostgreSQL

Topik ini akan berisi materi belajar SQL dengan PostgreSQL, berikut listnya:

1. [Apa itu PostgreSQL](/posts/apa-itu-postgresql)
2. Instal
   1. [Instal PostgreSQL di macOS](/posts/instal-postgresql-di-macos)
   2. Instal PostgreSQL di Windows (WSL)
   3. Instal PostgreSQL di Linux (Ubuntu)
3. Cara Konek ke Server Database PostgreSQL
4. Pengenalan Sampel Database PostgreSQL
5. Load PostgreSQL Sampel Database
6. Dasar-dasar PostgreSQL
   1. SELECT
   2. Column Aliases
   3. ORDER BY
   4. SELECT DISTINCT
   5. WHERE
   6. LIMIT
   7. FETCH
   8. IN
   9. BETWEEN
   10. LIKE
   11. IS NULL
   12. Table Aliases
   13. Joins
   14. INNER JOIN
   15. LEFT JOIN
   16. RIGHT JOIN
   17. SELF JOIN
   18. FULL OUTER JOIN
   19. CROSS JOIN
   20. NATURAL JOIN
   21. GROUP BY
   22. UNION
   23. INTERSECT
   24. EXCEPT
   25. HAVING
   26. GROUPING SETS
   27. CUBE
   28. ROLLUP
   29. Subquery
   30. ANY
   31. ALL
   32. EXISTS
   33. INSERT
   34. INSERT Multiple Rows
   35. UPDATE
   36. UPDATE Join
   37. DELETE
   38. DELETE Join
   39. Upsert
7. Mengelola Table
   1. Tipe-tipe data di PostgreSQL
   2. Create Table
   3. Select Into
   4. Create Table As
   5. SERIAL
   6. Sequences
   7. Identity Column
   8. Alter Table
   9. Rename Table
   10. Add Column
   11. Drop Column
   12. Mengubah tipe data kolom
   13. Rename Column
   14. Drop Table
   15. Temporary Table
   16. Truncate Table
8. Database Constraints
   1. Primary Key
   2. Foreign Key
   3. CHECK Constraint
   4. UNIQUE Constraint
   5. NOT NULL Constraint
9. Tipe-tipe data di PostgreSQL
   1. Boolean
   2. CHAR, VARCHAR, and TEXT
   3. NUMERIC
   4. Integer
   5. SERIAL
   6. DATE
   7. TIMESTAMP
   8. Interval
   9. TIME
   10. UUID
   11. JSON
   12. HSTORE
   13. Array
   14. User-defined Data Types
10. Conditional Expressions & Operators
   1. CASE
   2. COALESCE
   3. NULLIF
   4. CAST