< TYPO3 Explained

Relational database and SQL basics

Doctrine

Show in app

Description

Concept of a relational database and performing basic operations on it.

Goals

I know

  • what a relational database is
  • what a constraint is
  • what a relationship is and what the different types of relationships are
  • what a database cascade is
  • what SQL is
  • that SQL is declarative and not imperative

I can

  • create databases with SQL
  • create tables with SQL
  • write and execute SELECT, INSERT, UPDATE and DELETE statements
  • make use of LEFT JOIN, RIGHT JOIN and INNER JOIN clauses
  • make use GROUP and HAVING clauses
  • make use of the ORDER BY clause
  • make use the LIMIT clause
  • create and make use of INDEXES

Maintainer

Grégoire Paris Doctrine