Microsoft SQL Server DeveloperLaajuus (6 ECTS)

Objective

After the course, the student has the ability to develop, maintain and troubleshoot databases with an SQL Server.

Content

Implementing Tables and Views (14 percent)
Implementing Programming Objects (16 percent)
Working with Query Fundamentals (21 percent)
Applying Additional Query Techniques (15 percent)
Working with Additional SQL Server Components (11 percent)
Working with XML Data (12 percent)
Gathering Performance Information (11 percent)

Assessment criteria, satisfactory (1)

Implementing Tables and Views
- the student knows how to create and alter tables, views and indexes;
- the student knows how to configure and modify constraints;
- the student knows how to implement data types and partitioning solutions;

Implementing Programming Objects
- the student knows how to create and alter stored procedures;
- the student knows how to create and alter DML triggers;
- the student is able to create and deploy CLR-based objects;

Working with Query Fundamentals
- the student knows the basics about queries and is able to perform basic queries with an SQL Server;

Applying Additional Query Techniques
- the student is able to perform advanced query techniques with an SQL Server;

Working with Additional SQL Server Components
- the student is able to implement Server Broker solutions and track changes;

Working with XML Data
- the student is able to query and manage XML data;

Gathering Performance Information
- the student is able to capture execution plans and collect system performance data and assess it;

Assessment criteria, good (3)

Implementing Tables and Views
- the student knows how to create and alter tables, views and indexes;
- the student knows how to configure and modify constraints;
- the student knows how to implement data types and partitioning solutions;
- the student shows independent solutions.

Implementing Programming Objects
- the student knows how to create and alter stored procedures;
- the student knows how to create and alter DML triggers;
- the student is able to create and deploy CLR-based objects;
- the student shows independent solutions.

Working with Query Fundamentals
- the student knows the basics about queries and is able to perform basic queries with an SQL Server;
- the student shows independent solutions.

Applying Additional Query Techniques
- the student is able to perform advanced query techniques with an SQL Server;
- the student shows independent solutions.

Working with Additional SQL Server Components
- the student is able to implement Server Broker solutions and track changes;
- the student shows independent solutions.

Working with XML Data
- the student is able to query and manage XML data;
- the student shows independent solutions.

Gathering Performance Information
- the student is able to capture execution plans and collect system performance data and assess it;
- the student shows independent solutions.

Assessment criteria, excellent (5)

Implementing Tables and Views
- the student knows how to create and alter tables, views and indexes;
- the student knows how to configure and modify constraints;
- the student knows how to implement data types and partitioning solutions;
- the student shows independent solutions and critical evaluation.

Implementing Programming Objects
- the student knows how to create and alter stored procedures;
- the student knows how to create and alter DML triggers;
- the student is able to create and deploy CLR-based objects;
- the student shows independent solutions and critical evaluation.

Working with Query Fundamentals
- the student knows the basics about queries and is able to perform basic queries with an SQL Server;
- the student shows independent solutions and critical evaluation.

Applying Additional Query Techniques
- the student is able to perform advanced query techniques with an SQL Server;
- the student shows independent solutions and critical evaluation.

Working with Additional SQL Server Components
- the student is able to implement Server Broker solutions and track changes;
- the student shows independent solutions and critical evaluation.

Working with XML Data
- the student is able to query and manage XML data;
- the student shows independent solutions and critical evaluation.

Gathering Performance Information
- the student is able to capture execution plans and collect system performance data and assess it;
- the student shows independent solutions and critical evaluation.