Database Systems using Oracle

  • Level 4
  • 20 credits

Select a start date

Start date 22 January 2018
Duration 12 weekly meetings
Days and times Mondays from 18:00 to 21:00 plus 1 Saturday Day School
Tutor Dr Jianhua Shao
Course code COM17A3086A
Fee £450.00
Concessionary fee £405.00 (find out about eligibility and funding options)

This course introduces you to the basics of database systems.

The topics covered are: database system architecture, database design (at conceptual, logical and physical levels), transaction management (recovery, security and concurrency of transactions), and the use of SQL/Oracle for data manipulation (create tables and query tables).

This course is ideal for the student who wants a good general introduction to Oracle databases.

Learning and teaching

This module includes a mix of traditional lectures and laboratory sessions. Each meeting starts with a lecture and finishes with a laboratory session.

Coursework and assessment

To award credits we need to have evidence of the knowledge and skills you have gained or improved. Some of this has to be in a form that can be shown to external examiners so that we can be absolutely sure that standards are met across all courses and subjects. During the course, students will be given assignments to be submitted to the course tutor. At the end of the course, there will be a class test.

The most important element of assessment is that it should enhance your learning. Our methods are designed to increase your confidence and we try very hard to devise ways of assessing you that are enjoyable and suitable for adults with busy lives.

The syllabus will cover:

  • an introduction to database systems
  • basic database concepts
  • the ANSI/SPARC three level architecture
  • the relational data model
  • data representation
  • data manipulation
  • database design
  • conceptual design (UML class models)
  • physical design (data types and constraints and index)
  • database implementation using SQL
  • Oracle DBMS
  • table creation in SQL
  • data manipulation in SQL
  • introduction to PL?SQL
  • database transaction management
  • concurrency control
  • deadlock and resolutions

Reading suggestions

  • R. Earp and S. Bagui, Learning SQL, A Step-by-Step guide using Oracle,  Addison-Wesley, 2003
  • Connolly T, C. Begg, Database Systems: A Practical Approach to Design, Implementation and Management, 3rd edition, Addison-Wesley, 2002

Library and computing facilities

As a student on this course you are entitled to join and use the University’s library and computing facilities. Find out more about using these facilities.

Accessibility

Our aim is access for all. We aim to provide a confidential advice and support service for any student with a long term medical condition, disability or specific learning difficulty. We are able to offer one-to-one advice about disability, pre-enrolment visits, liaison with tutors and co-ordinating lecturers, material in alternative formats, arrangements for accessible courses, assessment arrangements, loan equipment and dyslexia screening.

Location

Queen's Buildings - South Building
5 The Parade
Cardiff
CF24 3AA