Siirry suoraan sisältöön

Introduction to SQL Server (5 op)

Toteutuksen tunnus: TT00CK70-3006

Toteutuksen perustiedot


Ilmoittautumisaika

02.07.2015 - 31.07.2015

Ajoitus

01.01.2020 - 31.12.2020

Opintopistemäärä

5 op

Virtuaaliosuus

5 op

Toteutustapa

Etäopetus

Yksikkö

ICT ja tuotantotalous

Toimipiste

Karaportti 2

Opetuskielet

  • Englanti

Paikat

0 - 100

Koulutus

  • Tieto- ja viestintätekniikan tutkinto-ohjelma

Opettaja

  • Virve Prami

Ryhmät

  • ATX20TV
    Avoin amk - NonStop vuosi 2020

Tavoitteet

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.

Sisältö

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.

Oppimateriaalit

e-learning

Opetusmenetelmät

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

Harjoittelu- ja työelämäyhteistyö

N/A

Kansainvälisyys

N/A

Toteutuksen valinnaiset suoritustavat

N/A

Opiskelijan ajankäyttö ja kuormitus

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

Lisätietoja opiskelijoille

N/A

Arviointiasteikko

Hyväksytty/Hylätty

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.

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.

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.

Arviointimenetelmät ja arvioinnin perusteet

Assignments 40%
Quiz 20%
Project 40%

Esitietovaatimukset

N/A

Lisätiedot

N/A