DOTS - Database Online Teaching SQL

Snapshot

Courses available:

Academic award	SCOTCAT award	Academic status	Course length
Certificate	N/A	CPD	5 weeks

Start date(s):

April

Academic School:

School of Computing

How to apply:

Application forms can be downloaded from the DOTS course webpage on the School of Computing website.

Fees for 2008-09: £100

Module Content and Structure

DOTS is a five-week, online module teaching the SQL component of the Advanced Higher Information Systems syllabus. Specifically, the module covers Data Manipulation Language (DML), Data Query Language (DQL), Aggregate, Sorting and Grouping Functions and Joins.

The topics are divided into five units, each of which lasts for a week. Topics are taught using a combination of self-presenting powerpoints, quizzes, tutorials and example programs. Each topic concludes with a piece of assessed work.

Up to five hours a week should be set aside in order to complete the module. This may vary depending on your prior experience or methods of working. Within this time, at least three hours should be spent working online.

School of Computing

The School of Computing provides a distinctive, balanced and enjoyable learning environment, matched to the future needs of both society and the computing field. Our degree portfolio includes undergraduate degrees in Applied Computing, Interactive Media Design and E-Commerce Computing, plus postgraduate Masters degrees in Computing with a range of specialisations, Intelligent Computational Systems, and Information Technology and International Business. For both face-to-face and distance learning courses, we work hard to create online learning communities of students.

The multi-disciplinary School has an international reputation in computer support for older and disabled people, healthcare computing, space systems and interaction design. All these areas of research have been developed through strong, long-term relationships with other leading academic institutions worldwide, and in collaboration with professional and industrial partners. The School is also active in commercialising its research, with several recent spin out companies fostering an entrepreneurial atmosphere.

Assessment

There are three items of assessed coursework spread through the module.

Student Support

The module is supported by a tutor who is available via email and discussion board, and who runs regular web conferences.

Entry Requirements

Students are expected to have a basic knowledge of databases, including tables, rows, columns, primary keys, foreign keys, relationships, etc

Equipment

Participants need regular access to a computer on which they can install software, access to the Internet, and the University of Dundee VLE - Blackboard. The necessary software will be supplied. As yet, there is no support for MACs.