Module Title:   SQL: Programming and Administration

Module Credit:   20

Module Code:   CM-0311L

Academic Year:   2015/6

Teaching Period:   Semester 1

Module Occurrence:   A

Module Level:   FHEQ Level 5

Module Type:   Linked 10+10

Provider:   Computer Science

Related Department/Subject Area:   SCIM (Dept of Computer Science)

Principal Co-ordinator:   Dr Mumtaz Kamala

Additional Tutor(s):   Dr David Forbes

Prerequisite(s):   None

Corequisite(s):   None

Aims:
To provide an understanding of the concepts and principles of structured query language (SQL) based databases. To develop the skills of database programming and administration using client/server databases e.g. Oracle, SQL Server, MySQL, or PostgreSQL.

Learning Teaching & Assessment Strategy:
This module is based around a series of laboratory based practical sessions during which the topics encountered during the lectures and seminar sessions are explored. The remainder is made up of preparation of coursework, private study and directed reading. Programming experience with a modern language is expected.

Lectures:   12.00          Directed Study:   152.00           
Seminars/Tutorials:   0.00          Other:   0.00           
Laboratory/Practical:   36.00          Formal Exams:   0.00          Total:   200.00

On successful completion of this module you will be able to...

demonstrate an enhanced understanding of SQL; analyse and evaluate information at an abstract level with regard to SQL.

On successful completion of this module you will be able to...

develop a well-structured database using a collection of tables for information storage; generate a database solution from a given target specification; administer a SQL based database.

On successful completion of this module you will be able to...

demonstrate advanced problem solving ability in the analysis and evaluation of information from a range of sources. The ability to consult and optimise databases.

  Examination - practical/laboratory 2.00 100%
 
  Demonstration of practical SQL under controlled conditions in two part sessions
  Examination - practical/laboratory 2.00 100%
 
  Supplementary assessment - individual practical assignment under controlled conditions of a similar nature to original

Outline Syllabus:
Introduction to Information Systems. Architecture of relational databases. Basics of database specification, design, entity/relationship diagrams and normalization. Database administration including installation, creation, testing, security and maintenance. Structured query language (SQL); basic queries, aggregations, joins, indexes, updating and deleting. Advanced features; user defined functions, views, transactions and triggers. Database issues including an introduction to distributed databases, data warehouses and data mining.

Version No:  4