Introduction to Databases

Introduction

Databases have been one of the success stories of computing. This course introduces the background and nature of databases, it describes when they are an appropriate solution, and it surveys some the products that are available. The core of course concerns the basics of how databases work, how they are used and how they are designed. There is also an Advanced and Modern Databases course, which is the natural successor to this course.

Duration and Construction

The course lasts two days. Each day will start at 09.30 and finish at 16.30. The delivery is via lecture, exercise and discussion.

The days consist of two morning sessions and three, shorter afternoon sessions, with one hour for lunch. Time will be available after 16.30 for extended discussions or related issues.

Intended Audience

The course is for users and potential users of database systems. The course would also be suitable for people developing simple databases.

Aims

• To show how database management systems work
• To show how to use them
• To introduce techniques for the correct design of databases
• To impart an understanding of database strengths and any weaknesses
• To impart an awareness as to the products available

Deliverables

• Lectures
• Facilitation of discussions
• Direction, assistance and feedback on exercises
• Proposed solutions to the exercises
• Copies of lecture slides, plus explanatory text and summaries
• Reference list of books and sources

Numbers

We recommend that there are no more than 12 participants, with the best results usually obtained when there are at least 8 participants. It is possible, by negotiation and mutual agreement, for more than 12 participants to be present.

Contents

• A brief history of data, data structures and database management systems
• Relational databases
• Database design
• Basic database manipulation
• Querying databases
• Database products
• Basic database administration

Site Requirements

• Data projector of at least 1024 x 768 resolution, and suitable screen
• White-board, preferably not doubling up as the OHP's screen; blackboard and chalk are acceptable
• Flip-chart and easel, with additional flip-chart paper
• It is best if the seating is not fixed. Auditorium style seating, for example, makes it difficult to switch from lecture to group work.

Contacting

Please contact John Deacon by telephone on +44 20 7498 3773; by fax on +44 20 7498 3747; by emailing  jdeacon@jdl.co.uk; or by visiting http://www.jdl.co.uk

[ Home page | Courses List ]

Last modified: Thursday, 08-Feb-2007.
Copyright © 2007 John Deacon. All rights reserved.