Introduction to SQL Server (5 ECTS)

Location and time

Up to Student her-/himself.

Materials

Online.

Employer connections

N/A

Exam schedules

Can be find on study environment.

International connections

N/A

Completion alternatives

N/A

Evaluation methods and criteria

Assignments 40%
Quiz 20%
Project 40%

Student workload

Lectures = 30h
Labs = 30h
Assignments = 20h
Self-study = 23h
Quiz = 2h
Project = 5h
Total = 110 hours

Content scheduling

Up to Student her-/himself.

Teaching methods

- Tutorial Videos
- Assignments
- Quiz
- Project
- Self-study

Further information

N/A

Evaluation scale

Hyväksytty/Hylätty

Assessment criteria, satisfactory (1)

- The student understands why we need databases in some projects.
- The student is familiar with the most popular SQL servers.
- The student can properly select the most efficient SQL server based on the technologies he/she is using in a project.
- The student is able to properly select the suitable edition of MS SQL server based on his/her project needs and is able to install it on his/her local computer/server.

Descriptions and comparison of SQL servers - Introduction to Microsoft SQL Server – MS SQL Server Services - MS SQL Server editions - Installing an instance of MS SQL Server - Introduction to MS SQL Management Studio - Creating a database - Creating and working with tables inside a database - Selecting proper data types - Understanding primary key, and foreign key - SELECT statement - INSERT statement - UPDATE statement - DELETE Statement – SQL Clauses, keywords, and operators - Stored Procedures - Functions - Indexes - Views - Triggers - Backup and restore - Users and roles - Reports - SQL performance tips - SQL security tips.
Further information
Evaluation criteria - satisfactory (1-2)
- The student understands why we need databases in some projects.
- The student is familiar with the most popular SQL servers.
- The student can properly select the most efficient SQL server based on the technologies he/she is using in a project.
- The student is able to properly select the suitable edition of MS SQL server based on his/her project needs and is able to install it on his/her local computer/server.
- The student is familiar with the environment of MS SQL Server Management Studio.
- The student is able to write simple queries on the tables.

Assessment criteria, good (3)

- The student is able to create a suitable diagram for his/her database.
- The student is able to understand and select efficient data types based on his/her needs
- The student understands the concepts of primary keys and foreign keys and may apply them for his/her tables.
- The student is able to write more complex queries on the tables.
- The student understands the concept of practical features of SQL Server.

Assessment criteria, excellent (5)

- The student is able to write sophisticated queries on the tables.
- The student is able to use stored procedures.
- The student is able to use indexes.
- The student is able to use triggers
- The student understands the concept of users and roles.
- The student is able to get reports from his/her database.