IV138V Databaseadministration for SQL-servers 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: MS SQL Server 2005, relational database design, database structure, DDL, DML, T-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 a MS SQL Server 2005 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 MS SQL Server 2005 database works
• Describe the concepts table, column, primary key, foreign key, constraint, data type and view
• Describe what a MS SQL Server 2005 database is composed of
• Use SQL DDL commands to create and edit a MS SQL Server 2005 database
• Use SQL DML commands to on a basic level select, update and delete data in a MS SQL Server 2005 database
• Use T-SQL commands to on a basic level create procedures, functions and triggers in a MS SQL Server 2005 database
• Use logins, users, roles and privileges to manage security in a MS SQL Server 2005 database
• Use existing tools in MS SQL Server 2005 to import data
• Use existing tools in MS SQL Server 2005 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 a MS SQL Server 2005 database works
• Give a thorough description of what a MS SQL Server 2005 database is composed of
• Give a thorough description of how which logins, users, roles and privileges that are available in MS SQL Server 2005 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

N/A: MCTS Self-Paced Training Kit (Exam 70-431): Microsoft SQL Server 2005 - Implementation and Maintenance, Pagina/Microsoft Press, 2006, 073562271X  

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

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