Relational database and SQL basics

Doctrine

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