Administration of the database server - spec: Database Technologies
Informacje ogólne
Kod przedmiotu: | CII5SE11CI-Z17 |
Kod Erasmus / ISCED: | (brak danych) / (brak danych) |
Nazwa przedmiotu: | Administration of the database server - spec: Database Technologies |
Jednostka: | Akademia Finansów i Biznesu Vistula |
Grupy: | |
Punkty ECTS i inne: |
5.00
|
Język prowadzenia: | angielski |
Skrócony opis: |
(tylko po angielsku) MS SQL Server is a relational database management system (RDBMS) developed by Microsoft. This product is built for the basic function of storing retrieving data as required by other applications. It can be run either on the same computer or on another across a network. |
Pełny opis: |
(tylko po angielsku) Learn how to install Microsoft SQ Server Prepare Microsoft Windows Server environment for MS SQL Database installation Learn how to install Microsoft MS SQL Database from scratch Installation decisions before building the RDBMS Learn how to use Microsoft SQL Server Configuration Manager Learn how to use Microsoft SQL Server Management Studio Configure SQL Server in a secure way Learn hardening Microsoft SQL Server Surface Area Configuration & Reduction Policy Based Management with Microsoft SQL Server Using Powershell to configure SQL Server |
Literatura: |
(tylko po angielsku) 1. Pro SQL server 2012 administration Ken Simmons and Sylvester Carstarphen, Apress 2. Microsoft-sql-server-2012-step-by-step-pre-press, Patrick LeBlanc. 3. Tutorials Point (www.tutorialspoint.com) 4. SQL Server 2012 Tutorials: Writing Transact-SQL Statements SQL Server 2012 Books Online, 2012 by Microsoft Corporation 5. Microsoft SQL Server Installation Guide, 2010 – 2013 Robert Schudy, Warren Mansur and Jack Polnar, Boston University |
Efekty uczenia się: |
(tylko po angielsku) Student will use UI navigation, Wizards usage, writing code in the Transact-SQL language, code debugging or syntactic issue resolution, Troubleshooting, accomplishing specific focused tasks by using code. Students will experience the importance of excelent database design and development. Students will understand query logical processing phases and it's impact on query performance Students will write efficient queries and use advanced T-SQL techniques to solve challanging programming tasks. |
Metody i kryteria oceniania: |
(tylko po angielsku) Tests |
Zajęcia w cyklu "Semestr zimowy 2017/2018" (zakończony)
Okres: | 2017-10-01 - 2018-02-15 |
zobacz plan zajęć |
Typ zajęć: |
Ćwiczenia, 30 godzin
Konwersatorium, 15 godzin
|
|
Koordynatorzy: | Mirosław Lisiecki | |
Prowadzący grup: | Mirosław Lisiecki | |
Lista studentów: | (nie masz dostępu) | |
Zaliczenie: |
Przedmiot -
Egzamin/zaliczenie na ocenę/zal w skali zal-std2
Ćwiczenia - Egzamin/zaliczenie na ocenę/zal w skali zal-std2 Konwersatorium - Egzamin/zaliczenie na ocenę/zal w skali zal-std2 |
|
Skrócony opis: |
(tylko po angielsku) MS SQL Server is a relational database management system (RDBMS) developed by Microsoft. This product is built for the basic function of storing retrieving data as required by other applications. It can be run either on the same computer or on another across a network. |
|
Pełny opis: |
(tylko po angielsku) Learn how to install Microsoft SQ Server Prepare Microsoft Windows Server environment for MS SQL Database installation Learn how to install Microsoft MS SQL Database from scratch Installation decisions before building the RDBMS Learn how to use Microsoft SQL Server Configuration Manager Learn how to use Microsoft SQL Server Management Studio Configure SQL Server in a secure way Learn hardening Microsoft SQL Server Surface Area Configuration & Reduction Policy Based Management with Microsoft SQL Server Using Powershell to configure SQL Server |
|
Literatura: |
(tylko po angielsku) 1. Pro SQL server 2012 administration Ken Simmons and Sylvester Carstarphen, Apress 2. Microsoft-sql-server-2012-step-by-step-pre-press, Patrick LeBlanc. 3. Tutorials Point (www.tutorialspoint.com) 4. SQL Server 2012 Tutorials: Writing Transact-SQL Statements SQL Server 2012 Books Online, 2012 by Microsoft Corporation 5. Microsoft SQL Server Installation Guide, 2010 – 2013 Robert Schudy, Warren Mansur and Jack Polnar, Boston University |
|
Uwagi: |
(tylko po angielsku) CI-I5SE/1 |
Właścicielem praw autorskich jest Akademia Finansów i Biznesu Vistula.