Opinto-opas

Objective

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 MS SQL Server.
This course is 100% virtual thanks to the comprehensive tutorial videos made for this course, and the students of this course will receive a free voucher to participate in 461 Exam to obtain Microsoft MCSA Certification.
The student will pass this course after submitting required assignments and project.

Content

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.

Materials

e-learning

Teaching methods

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

Employer connections

N/A

International connections

N/A

Completion alternatives

N/A

Student workload

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

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.

Assessment methods and criteria

Assignments 40%
Quiz 20%
Project 40%

Qualifications

N/A

Further information

N/A