Learning Objectives

Learning Objectives

Learning Objectives

1. I can explain the concept of a database
2. I can explain the concept of a relational database
3. I can understand the concept of a table in a database
4. I can understand the concept of a record in a database
5. I can understand the concept of a field in a database
6. I can understand the concept of a primary key in a database
7. I can understand the concept of a foreign key in a database
8. I can understand that the use of a relational database facilitates the elimination of data inconsistency and data redundancy.

Learning Objectives

1. I can use SQL to retrieve data from a relational database, using the commands: SELECT FROM, WHERE, ORDER BY, ASC / DESC
2. I can use SQL to insert data into a relational database using the commands. INSERT INTO, VALUES
3. I can use SQL to update data in a relational database using the commands. UPDATE, SET, WHERE
4. I can use SQL to delete data in a relational database using the commands. DELETE FROM, WHERE

Learning Objectives