IV135V Administration of Relational Databases, Introduction 7.5 credits

The course is composed of a number of lectures, projects and exams.

The three lectures bring up the contents which is included in the course: Oracle Database 10g, relational database design, database structure, DDL, DML, PL/SQL, users, roles, privileges, import and backup.

The two projects bring up practical tasks within the contents of the course.

The three exams bring up theoretical tasks within the contents of the course split up into three parts.

The overall aim of the course is to provide an understanding of how an Oracle 10g database works, of what it’s composed and how it is administrated.

To pass, the student shall be able to do the following after a completed course:

• Describe how a relational database works.
• Describe the concepts table, column, primary key, foreign key, constraint, data type and view.
• Describe what an Oracle 10g database is composed of.
• Use SQL DDL commands to create and edit an Oracle 10g database.
• Use SQL DML commands to on a basic level select, update and delete data in an Oracle 10g database.
• Use PL/SQL commands to on a basic level create procedures, functions and triggers in an Oracle 10g database.
• Use users, roles and privileges to manage security in an Oracle 10g database.
• Use existing tools in Oracle 10g to import data.
• Use existing tools in Oracle 10g to backup databases.

For a higher grade, the student shall be able to do the following after a completed course:

• Give a thorough description of how an Oracle 10g database works.
• Give a thorough description of what an Oracle 10g database is composed of.
• Give a thorough description of how which users, roles and privileges that are available in Oracle 10g to ensure security.

Completed upper secondary school including documented proficiency in Swedish and English.

Access to a qualified PC with Windows 2000 or newer, CPU min 500MHz (1GHz is recommended), 512 MB of RAM, internet access, CD-rom reader, 1 GB of free HD space for software needed in the course. Database software can be download from the Internet.

Preliminary

Chip Dawes: OCA Oracle 10g Administration I Study Guide, Sybex, 0782143679

Michael Abbey, Ian Abramson, Michael J Corey: Oracle Database 10g A Beginners Guide, Oracle press, 0072230789  

The course material consists of a course book (given at course start) and software from Oracle.

If the course is discontinued, students may request to be examined during the following two academic years.

• PRO1 - Project, 1.5 credits, grading scale: P, F
• PRO2 - Project, 1.5 credits, grading scale: P, F
• TEN1 - Examination, 1.5 credits, grading scale: P, F
• TEN2 - Examination, 1.5 credits, grading scale: A, B, C, D, E, FX, F
• TEN3 - Examination, 1.5 credits, grading scale: A, B, C, D, E, FX, F

Based on recommendation from KTH’s coordinator for disabilities, the examiner will decide how to adapt an examination for students with documented disability.

The examiner may apply another examination format when re-examining individual students.

Passed exam 1 (TEN1;1,5p) – grade P-F.

Passed exam 2 (TEN2;1,5p) – grade A-F.

Passed exam 3 (TEN3;1,5p) – grade A-F.

Passed project 1 (PRO1;1,5p) – grade P-F.

Passed project 2 (PRO2;1,5p) – grade P-F.

The final grade is given when TEN1, PRO1 and PRO2 are Passed (grade P) and when TEN2 and TEN3 have the lowest grade of E.

• All members of a group are responsible for the group's work.
• In any assessment, every student shall honestly disclose any help received and sources used.
• In an oral assessment, every student shall be able to present and answer questions about the entire assignment and solution.

ostlin@kth.se