Skip to main content
Till KTH:s startsida

IV139V Server-Side-programming for SQL-servers 7.5 credits

Administer About course

Information per course offering

Course offerings are missing for current or upcoming semesters.

Course syllabus as PDF

Please note: all information from the Course syllabus is available on this page in an accessible format.

Course syllabus IV139V (Spring 2009–)
Headings with content from the Course syllabus IV139V (Spring 2009–) are denoted with an asterisk ( )

Content and learning outcomes

Course contents

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, SQL DML, SQL DDL, built-in functions, dynamic SQL, flow control, error handling, variables, cursors, procedures, functions and triggers.

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.

Intended learning outcomes

The overall aim of the course is to provide an understanding of how programming with T-SQL can be used to build up application logic in a MS SQL Server 2005 database.

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 a MS SQL Server 2005 database is composed of.
  • Use SQL DDL commands to on a very basic level create and edit a MS SQL Server 2005 database.
  • Use SQL DML commands to select, update and delete data in a MS SQL Server 2005 database.
  • Use built-in functions and dynamic SQL in a MS SQL Server 2005 database.
  • Use T-SQL to build procedures, functions and triggers with variables, cursors, flow control and error management in MS SQL Server 2005.

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

  • Give a thorough description of how SQL DML-commands can be used to manage data in a MS SQL Server 2005 database.
  • Give a thorough description of how built-in functions can be used to simplify and improve T-SQL commands in a MS SQL Server 2005 database.
  • Give a thorough description of how T-SQL can be used to build advanced application logic in a MS SQL Server 2005 database.

Literature and preparations

Specific prerequisites

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

Literature

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

Examination and completion

Grading scale

A, B, C, D, E, FX, F

Examination

  • PRO2 - Project, 1.5 credits, grading scale: P, F
  • PRO1 - Project, 1.5 credits, grading scale: P, F
  • TEN3 - Examination, 1.5 credits, grading scale: A, B, C, D, E, FX, F
  • TEN2 - Examination, 1.5 credits, grading scale: A, B, C, D, E, FX, F
  • TEN1 - Examination, 1.5 credits, grading scale: P, 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.

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

Other requirements for final grade

  • 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 (betyg P) and when TEN2 and TEN3 have the lowest grade of E.

Examiner

No information inserted

Ethical approach

  • 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.

Further information

Course room in Canvas

Registered students find further information about the implementation of the course in the course room in Canvas. A link to the course room can be found under the tab Studies in the Personal menu at the start of the course.

Offered by

ICT/Systems Science (SU)

Main field of study

Technology

Education cycle

First cycle

Supplementary information

ostlin@kth.se