Belajar SQL dengan PostgreSQL

Machine Learning SQL
#1

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

  1. Apa itu PostgreSQL
  2. Instal
    1. 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
1 Likes
#2
#3
#4