Johdatus SQL-palvelimeenLaajuus (3 op)

Osaamistavoitteet

The goal of this course is for the student to be familiar with Microsoft SQL Server as one of the most powerful relational database management systems. After passing this course, the student will be able to select a proper SQL Server regarding the technologies are being used in their projects, and will be able to work with Microsoft SQL Management Studio to manage a database, and to design a whole database with efficient tables and data types. And finally the student will be able to use most of the on-demand and practical features and abilities of SQL.

Sisältö

Descriptions and comparison of SQL servers - Introduction to Microsoft SQL Server - 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 - Stored Procedures - Functions - Indexes - Views - Triggers - Backup and restore - Users and roles - Reports - SQL performance tips - SQL security tips.

Arviointikriteerit, tyydyttävä (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.
- The student is familiar with the environment of MS SQL Server Management Studio.
- The student is able to write simple queries on the tables.

Arviointikriteerit, hyvä (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.

Arviointikriteerit, kiitettävä (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.

Arviointikriteeri, hyväksytty/hylätty

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