Basic database design and development
Relational Database Design
Relational Database design - ER diagrams to include deriving entities, attributes, relationships and cardinality,Primary Keys, Foreign Keys. Mapping ERDs to a relational schema, data normalisation, relational integrity, keys, indexes; database transactions, ACID properties
SQL
Schema definition: Create, Drop, Alter tables, Data manipulation in SQL: Insert, update and Delete tables and rows.SQL queries: basic queries, grouping, ordering, Built in SQL functions, joins, subqueries.
Database Objects
An introduction to basic database objects to include: sequences, views, indexes, stored procedures, functions and triggers.
Cloud Based Instances & NOSQL
An introduction to the concept of NOSQL and exposure to cloud based database instances.
| Module Content & Assessment | |
|---|---|
| Assessment Breakdown | % |
| Other Assessment(s) | 50 |
| Formal Examination | 50 |