SQL queries. Data Manipulation Language

1. Definition
2. SELECT
3. INSERT
4. UPDATE
5. DELETE
6. SELECT from several tables
7. Questions
8. Exercises
9. Exam questions

11.4.2.4 describe the basic SQL queries for working with one table in a database: SELECT, UPDATE, INSERT and DELETE

11.4.2.5 use SQL SELECT for data selection in more tables

Data dictionary

11.4.2.1 explain the purpose of data dictionary 

SQL queries. Data Definition Language.

1. Definition
2. CREATE
3. DROP
4. ALTER
5. Questions
6. Exercises
7. Exam questions

11.4.2.2 compare the data definition language (DDL), and the data manipulation language (DML) 
11.4.2.3 describe the basic SQL queries for working with tables in a database: CREATE, ALTER and DROP
 

Primary key & Composite key

11.4.1.3 explain the difference between primary composite and foreign key

Normalisation database

1. Definition
2. 1NF
3. 2NF
4. 3NF
5. Questions
6. Exercises
7. Exam questions

11.4.1.5 define the connections between tables in database(1-3NF)

Entity Relationship Diagrams

1. Definition
2. Types of relationship
3. Questions
4. Exercises
5. Exam questions

11.4.1.6 define the connections between tables in database

11.4.1.7 create an entity-relationship (ER) model

How to create database and table in phpMyAdmin?

Data types of MySQL database

1. Data types
2. Example
3. Questions
4. Exercises
5. Exam questions

11.4.1.4 define data types when creating a database

Database MySQL in phpMyAdmin

Relational databases 

11.4.1.1 describe relational databases and their purpose

11.4.1.4 define data types when creating a database

11.4.1.2 use the terms attribute, object, index, record, table and tuple to describe databases