This module is an introductory module for students with little or no knowledge of websites. It aims to introduce students to the principles of HTML, CSS, PHP and effective design, providing opportunity for practical work, which will involve analysing and improving a current web site.
The module focuses on the relational databases. It introduces database software, design, creation, management and programming. It starts with conceptual entity-relationship design, followed by logical database design and physical database creation.
Students will learn:
· to design and implement a relational database via a number of interfaces such as the bash terminal, phpMyAdmin and mySQL Workbench.
· to implement the principles of ‘CRUD’ (Create Retrieve, Update, Delete) via Structured Query Language (SQL).
· the concept of normalisation, what ‘normal forms’ are, and how this reduces or eliminates redundancy and duplication.
· to write stored procedures, transactions and triggers and how to access databases via various third party application and programs.
User permissions will be covered as will some performance tuning via query monitoring and optimisation.