SQL-Inhalte

Einen guten Überblick für Einsteiger finden sie hier.

Inhalte

CREATE Table Statement

• Constraints
  • not null
  • default
  • unique
  • primary key
• Data Types
  • varchar(n) [oder nvarchar()]
  • int
  • decimal(p,s)
  • date
  • time
  • datetime
  • ENUM()

Primary Keys and Binary Trees

INSERT Statement

NULL value

UPDATE Statement and DELETE Statement

SELECT Statement

• SELECT- FROM - WHERE - GROUP BY - ORDER BY - LIMIT
• alias
• Aggregate functions (max, min, sum,avg, count)
• SELECT DISTINCT
• JOIN (inner join, left join, right join)

CREATE VIEW Statement

SQL-Functions

• YEAR(), MONTH(), DAY()
• DATEDIFF()
• CURRENT_TIMESTAMP()