Database Systems using Oracle
Level 1 (CQFW Level 4), 20 Credits.
Available Dates:
- Dates:
- No upcoming courses.
Register interest in this course...
Let us keep you up to date about when the course will run again.
Course Description
This module aims to provide the students with a basic understanding of relational database system technology in general, and a practical knowledge of ORACLE in particular. It seeks to equip the students with the skills to design and implement a database system.
Who is this course for?
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.
Syllabus
- Introduction to database systems:
- Basic database concepts;
- The ANSI/SPARC three level architecture;
- The relational data model:
- Data representation:
- Data manipultion
- 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
- Concurancy control
- Deadlock and resolutions
Reading suggestions
- Learning SQL, a step-by-Step guide using Oracle, R.Earp and S.Bagui, Addison-Wesley, 2003
- Database Systems: A Practical Approach to Design, Implementation and Management, 3rd edition
T.Connolly, C.Begg and A Strachan, Addison-Wesley, 2002
