This lab will firstly introduce you to the learning environment provided by Oracle Academy. It will show you how to setup an Oracle Academy account and login to ilearning to access the module materials.

This lab will put into practice the entity relationship diagraming you have seen in the lectures.

This lab will put into practice the advanced entity relationship diagraming you have seen in the lectures.

This lab will put into practice relationship transferability, types of relationships and how to deal with many to many relationships you have learned in the lectures.

This lab will put into practice the identification of unique identifiers and the process of normalisation.

This lab will put into practice the table mapping process.

This lab will put into practice the CREATE TABLE statement and the INSERT INTO statement.

This lab will put into practice the CREATE TABLE statement for creating constraints.

This lab will put into practice the SELECT statement using operators, comparisons, aliases and ORDER BY