(MySQL / SQLite)

• Database

  • (def)
  • Relational vs Non-relational DB
  • DB vs DBMS

• SQL

  • (def)

• SQLite

  • (def)

• MySQL

  • (def)

• DDL statements

  • (def)
  • CREATE DATABASE
  • CREATE TABLE
  • CREATE VIEW
  • CREATE INDEX
  • CREATE PROCEDURE
  • CREATE TRIGGER
  • USE
  • DROP DATABASE
  • DROP DATABASE
  • ALTER DATABASE
  • ALTER TABLE

• DML statements

  • (def)
  • SELECT (: WHERE / ORDER BY / GROUP BY / functions / LIMIT )
  • INSERT
  • UPDATE
  • DELETE
  • Clauses used with DML statements:
    • JOIN

• DQL statements

  • (def)
  • SHOW

• Other Statements

  • SET

• Constraints

  • (def)
  • UNIQUE
  • NOT NULL
  • CHECK
  • DEFAULT
  • PRIMARY KEY
  • FOREIGN KEY

• Logical Operators

  • AND
  • OR
  • NOT
  • BETWEEN
  • IN