Microsoft SQL Server Developer (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)

Location and time

Because course is 100% online (Self-Study) course, study place and timetable is up to Student her-/himself.

Materials

Can be find on study environment.

Teaching methods

100% online (Self-Study) course.

Employer connections

N/A

Exam schedules

Can be find on study environment.

International connections

N/A

Completion alternatives

N/A

Student workload

Up to Student her-/himself.

Content scheduling

Up to Student her-/himself.

Evaluation scale

Hyväksytty/Hylätty

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.

Assessment methods and criteria

After competing all labs the student can take the final test.

The final test contains 30 multi-choice questions and its duration is 120 minutes.

The minimum passing score for the test is 700. If not achieved, the student needs to take another test. The retake limit is 3!