MariaDB

• Bismillah
• Environment Setup
• DB Bismillah
  • Database
  • Table
  • Query
• Insert
• Select
• Where
  • AND, OR, NOT
  • NULL, NOT NULL
  • LIKE
  • IN, NOT IN
  • BETWEEN
  • Operators
• Aggregation
  • COUNT
  • AVG
  • SUM
  • MAX, MIN
• ORDER BY
• LIMIT
• Aliases
• GROUP BY
• HAVING
• Update
• Delete
• Insert Select
• Comments
• Table
  • Create
  • Drop
  • Alter
  • Constraints
  • Null & Not Null
  • Unique
  • Primary Key
  • Foreign Key
  • Default value
  • Index
  • Auto Increment
  • Check
  • Data Types
• Joining
  • Joins
  • Inner Join
  • Self Join
  • Left Join
  • Right Join
  • Cross Join
  • Union
• Subquery