Database Systems Administration
General data
Course ID: | 1100-AB0LII |
Erasmus code / ISCED: | (unknown) / (unknown) |
Course title: | Database Systems Administration |
Name in Polish: | Administrowanie systemami bazodanowymi |
Organizational unit: | Faculty of Mathematics and Computer Science |
Course groups: | |
ECTS credit allocation (and other scores): |
0 OR
6.00
(depends on study program)
|
Language: | Polish |
(in Polish) Forma zaliczenia: | (in Polish) egzamin |
(in Polish) Forma studiów: | (in Polish) stacjonarne |
Prerequisits: | Good knowledge of relational databases, SQL languages, Windows server |
Short description: |
The course addresses issues related to the administration of database management systems. It focuses on installing and configuring database server, working with databases and their objects, performing backup and recovery. It also covers authenticating and authorizing, audidting and monitoring database server environment, using the Agent services. High availability mechanisms are also discussed. The database server used in this course is MS SQL Server. |
Learning outcomes: |
On completion of this subject, student: E1) understands the importance of databases and their applications E2) knows main database servers E3) installs and configures a database server E4) can work with databases (creates databases, modifies them and manages data files) E5) manages primary database objects (tables, indices, views) E6) understands available recovery models E7) develops a strategy for backups and performs different types of backups E8) can restore the database after malfunction E9) understands the issues releted to authentication and authorization E10) creates users and roles, grants priviliges to them E11) knows the main mechanisms of security and audit E12) uses the main tools to administer and monitor the database E13) can work individually and in small groups on the given issue E14) can organize the learning process E15) understands the need for continuous training E16) complies with the legal and ethical in his actions |
Classes in period "Winter Semester 2024/2025" (future)
Time span: | 2024-10-01 - 2025-02-16 |
Navigate to timetable
MO TU W TH FR |
Type of class: |
Information technology laboratory, 28 hours
Lecture, 28 hours
|
|
Coordinators: | (unknown) | |
Group instructors: | (unknown) | |
Students list: | (inaccessible to you) | |
Examination: |
Course -
(in Polish) Ocena zgodna z regulaminem studiów
Information technology laboratory - (in Polish) Ocena zgodna z regulaminem studiów Lecture - (in Polish) Ocena zgodna z regulaminem studiów |
Classes in period "Winter Semester 2023/2024" (past)
Time span: | 2023-10-01 - 2024-02-25 |
Navigate to timetable
MO TU W
LI
W TH FR |
Type of class: |
Information technology laboratory, 28 hours
Lecture, 28 hours
|
|
Coordinators: | Michał Bleja | |
Group instructors: | Michał Bleja | |
Course homepage: | http://imul.math.uni.lodz.pl/~bleja/asb | |
Students list: | (inaccessible to you) | |
Examination: |
Course -
(in Polish) Ocena zgodna z regulaminem studiów
Information technology laboratory - (in Polish) Ocena zgodna z regulaminem studiów Lecture - (in Polish) Ocena zgodna z regulaminem studiów |
|
(in Polish) Czy kurs na PZK?: | (in Polish) T |
|
Teaching Method: | Case study Seminar The project method The exercise method |
|
Method and Criteria of Assessment: | The laboratory grade is the grade for the final laboratory exam. There are four absences during the exercises allowed. The lecture grade is the grade for the final lecture written exam. The final grade of this course is the weighted average of the final written exam grade (52%) and the final laboratory grade (48%). |
|
(in Polish) Metody weryfikacji i oceny stopnia osiągnięcia założonych efektów uczenia się: | The lab exam verifies the following education effects: E4- E9, E11, E12, E13, E14-E19. The lecture exam verifies the following education effects: E1-E7, E10-E13,E15. Estimated time of own work (in university hours): - preparation for classes (current work): 40 - project preparation: 20 The student verifies the effects of his / her own work with the teacher |
|
Course Content: | 1) Overview of main relational database management systems 2) Architecture of MS SQL Server (Database Engine, SSIS, SSRS, SSAS) 3) Version history and editions of MS SQL Server 4) Installing components of SQL Server 5) Configuring and managing MS SQL Server instances (Configuration Manager, Management Studio) 6) Working with databases (creating and altering databases, database options and properties, managing database files and group files) 7) Managing database objects (tables, views, indices, statistics, functions, procedures, triggers) 8) Basic administration of the Active Directory Services 9) Implementing authentication and authorization (managing logins and server roles, managing users and database roles) 10) Recovery models and database backups 11) Restoring of SQL Server databases in different scenarios (point of failure recovery, point in time recovery, restore a database to a marked transaction). 12) Database migration and copy methods to another servers 13) Working with SQL Server Agent (jobs, alerts) 14) Creating and altering maintenance plans by using Maintenance Plan Wizard. 15) Implementing high availability a) replication (snapshot, transactional, peer-to-peer transactional, merge) b) log shipping c) database mirroring d) Windows Server Failover Clustering e) AlwaysOn Availability groups 16) Transactions, isolation levels, locks 17) Detecting and eliminating deadlocks 18) Monitoring SQL Server by using: a) Performance Monitor b) Activity Monitor c) system views d) log files 19) Registering activity by using SQL Server Profiler |
|
Bibliography: |
1) Slides available to students 2) Microsoft SQL Server Books Online |
Classes in period "Winter Semester 2022/2023" (past)
Time span: | 2022-10-01 - 2023-02-19 |
Navigate to timetable
MO W
LI
TU LI
W TH W
LI
FR |
Type of class: |
Information technology laboratory, 28 hours
Lecture, 28 hours
|
|
Coordinators: | Michał Bleja | |
Group instructors: | Michał Bleja | |
Course homepage: | http://imul.math.uni.lodz.pl/~bleja/asb | |
Students list: | (inaccessible to you) | |
Examination: |
Course -
(in Polish) Ocena zgodna z regulaminem studiów
Information technology laboratory - (in Polish) Ocena zgodna z regulaminem studiów Lecture - (in Polish) Ocena zgodna z regulaminem studiów |
|
Teaching Method: | Case study Seminar The project method The exercise method |
|
Method and Criteria of Assessment: | The laboratory grade is the grade for the final laboratory exam. There are four absences during the exercises allowed. The lecture grade is the grade for the final lecture written exam. The final grade of this course is the weighted average of the final written exam grade (52%) and the final laboratory grade (48%). |
|
(in Polish) Metody weryfikacji i oceny stopnia osiągnięcia założonych efektów uczenia się: | The lab exam verifies the following education effects: E4- E9, E11, E12, E13, E14-E19. The lecture exam verifies the following education effects: E1-E7, E10-E13,E15. Estimated time of own work (in university hours): - preparation for classes (current work): 40 - project preparation: 20 The student verifies the effects of his / her own work with the teacher |
|
Course Content: | 1) Overview of main relational database management systems 2) Architecture of MS SQL Server (Database Engine, SSIS, SSRS, SSAS) 3) Version history and editions of MS SQL Server 4) Installing components of SQL Server 5) Configuring and managing MS SQL Server instances (Configuration Manager, Management Studio) 6) Working with databases (creating and altering databases, database options and properties, managing database files and group files) 7) Managing database objects (tables, views, indices, statistics, functions, procedures, triggers) 8) Basic administration of the Active Directory Services 9) Implementing authentication and authorization (managing logins and server roles, managing users and database roles) 10) Recovery models and database backups 11) Restoring of SQL Server databases in different scenarios (point of failure recovery, point in time recovery, restore a database to a marked transaction). 12) Database migration and copy methods to another servers 13) Working with SQL Server Agent (jobs, alerts) 14) Creating and altering maintenance plans by using Maintenance Plan Wizard. 15) Implementing high availability a) replication (snapshot, transactional, peer-to-peer transactional, merge) b) log shipping c) database mirroring d) Windows Server Failover Clustering e) AlwaysOn Availability groups 16) Transactions, isolation levels, locks 17) Detecting and eliminating deadlocks 18) Monitoring SQL Server by using: a) Performance Monitor b) Activity Monitor c) system views d) log files 19) Registering activity by using SQL Server Profiler |
|
Bibliography: |
1) Slides available to students 2) Microsoft SQL Server Books Online |
Classes in period "Winter Semester 2021/2022" (past)
Time span: | 2021-10-01 - 2022-01-23 |
Navigate to timetable
MO LI
W
LI
TU W
LI
LI
W TH FR |
Type of class: |
Information technology laboratory, 28 hours
Lecture, 28 hours
|
|
Coordinators: | Michał Bleja | |
Group instructors: | Michał Bleja | |
Course homepage: | http://math.uni.lodz.pl/~bleja/asb | |
Students list: | (inaccessible to you) | |
Examination: |
Course -
(in Polish) Ocena zgodna z regulaminem studiów
Information technology laboratory - (in Polish) Ocena zgodna z regulaminem studiów Lecture - (in Polish) Ocena zgodna z regulaminem studiów |
|
(in Polish) Czy ECTS?: | (in Polish) T |
|
Teaching Method: | Case study Seminar The project method The exercise method |
|
Method and Criteria of Assessment: | The laboratory grade is the grade for the final laboratory exam. There are four absences during the exercises allowed. The lecture grade is the grade for the final lecture written exam. The final grade of this course is the weighted average of the final written exam grade (50%) and the final laboratory grade (50%). |
|
(in Polish) Metody weryfikacji i oceny stopnia osiągnięcia założonych efektów uczenia się: | The lab exam verifies the following education effects: E4- E9, E11, E12, E13, E14-E19. The lecture exam verifies the following education effects: E1-E7, E10-E13,E15. Estimated time of own work (in university hours): - preparation for classes (current work): 40 - project preparation: 20 The student verifies the effects of his / her own work with the teacher |
|
Course Content: | 1) Overview of main relational database management systems 2) Architecture of MS SQL Server (Database Engine, SSIS, SSRS, SSAS) 3) Version history and editions of MS SQL Server 4) Installing components of SQL Server 5) Configuring and managing MS SQL Server instances (Configuration Manager, Management Studio) 6) Working with databases (creating and altering databases, database options and properties, managing database files and group files) 7) Managing database objects (tables, views, indices, statistics, functions, procedures, triggers) 8) Basic administration of the Active Directory Services 9) Implementing authentication and authorization (managing logins and server roles, managing users and database roles) 10) Recovery models and database backups 11) Restoring of SQL Server databases in different scenarios (point of failure recovery, point in time recovery, restore a databse to a marked transaction). 12) Database migration and copy methods to another servers 13) Working with SQL Server Agent (jobs, alerts) 14) Creating and altering maintenance plans by using Maintenance Plan Wizard. 15) Implementing high availability a) replication (snapshot, transactional, peer-to-peer transactional, merge) b) log shipping c) database mirroring d) Windows Server Failover Clustering e) AlwaysOn Availability groups 16) Transactions, isolation levels, locks 17) Detecting and eliminating deadlocks 18) Monitoring SQL Server by using: a) Performance Monitor b) Activity Monitor c) system views d) log files 19) Registering activity by using SQL Server Profiler |
|
Bibliography: |
1) Slides available to students 2) Microsoft SQL Server Books Online |
Classes in period "Winter Semester 2020/2021" (past)
Time span: | 2020-10-01 - 2021-02-07 |
Navigate to timetable
MO TU W TH LI
FR LI
W
LI
LI
|
Type of class: |
Information technology laboratory, 28 hours
Lecture, 28 hours
|
|
Coordinators: | Michał Bleja | |
Group instructors: | Michał Bleja | |
Course homepage: | http://math.uni.lodz.pl/~bleja/asb | |
Students list: | (inaccessible to you) | |
Examination: |
Course -
(in Polish) Ocena zgodna z regulaminem studiów
Information technology laboratory - (in Polish) Ocena zgodna z regulaminem studiów Lecture - (in Polish) Ocena zgodna z regulaminem studiów |
|
Teaching Method: | Case study Seminar The project method The exercise method |
|
Method and Criteria of Assessment: | The laboratory grade is the grade for the final laboratory exam. The laboratory exam checka the following education effects: E4- E9, E11, E12, E13, E14-E19. The lecture grade is the grade for the final lecture written exam. The lecture exam checks the following education effects: E1-E7, E10-E13,E15. The final grade of this course is the weighted average of the final written exam grade (50%) and the final laboratory grade (50%). |
|
Course Content: | 1) Overview of main relational database management systems 2) Architecture of MS SQL Server (Database Engine, SSIS, SSRS, SSAS) 3) Version history and editions of MS SQL Server 4) Installing components of SQL Server 5) Configuring and managing MS SQL Server instances (Configuration Manager, Management Studio) 6) Working with databases (creating and altering databases, database options and properties, managing database files and group files) 7) Managing database objects (tables, views, indices, statistics, functions, procedures, triggers) 8) Basic administration of the Active Directory Services 9) Implementing authentication and authorization (managing logins and server roles, managing users and database roles) 10) Recovery models and database backups 11) Restoring of SQL Server databases in different scenarios (point of failure recovery, point in time recovery, restore a databse to a marked transaction). 12) Database migration and copy methods to another servers 13) Working with SQL Server Agent (jobs, alerts) 14) Creating and altering maintenance plans by using Maintenance Plan Wizard. 15) Implementing high availability a) replication (snapshot, transactional, peer-to-peer transactional, merge) b) log shipping c) database mirroring d) Windows Server Failover Clustering e) AlwaysOn Availability groups 16) Transactions, isolation levels, locks 17) Detecting and eliminating deadlocks 18) Monitoring SQL Server by using: a) Performance Monitor b) Activity Monitor c) system views d) log files 19) Registering activity by using SQL Server Profiler |
|
Bibliography: |
1) Slides available to students 2) Microsoft SQL Server Books Online |
Classes in period "Winter Semester 2019/2020" (past)
Time span: | 2019-10-01 - 2020-02-23 |
Navigate to timetable
MO W
LI
LI
TU LI
W LI
TH FR |
Type of class: |
Information technology laboratory, 28 hours
Lecture, 28 hours
|
|
Coordinators: | Michał Bleja | |
Group instructors: | Michał Bleja | |
Course homepage: | http://math.uni.lodz.pl/~bleja/asb | |
Students list: | (inaccessible to you) | |
Examination: |
Course -
(in Polish) Ocena zgodna z regulaminem studiów
Information technology laboratory - (in Polish) Ocena zgodna z regulaminem studiów Lecture - (in Polish) Ocena zgodna z regulaminem studiów |
|
Teaching Method: | Case study Seminar The project method The exercise method |
|
Method and Criteria of Assessment: | The laboratory grade is the grade for the final laboratory exam. The laboratory exam checka the following education effects: E4- E9, E11, E12, E13, E14-E19. The lecture grade is the grade for the final lecture written exam. The lecture exam checks the following education effects: E1-E7, E10-E13,E15. The final grade of this course is the weighted average of the final written exam grade (50%) and the final laboratory grade (50%). |
|
Course Content: | 1) Overview of main relational database management systems 2) Architecture of MS SQL Server (Database Engine, SSIS, SSRS, SSAS) 3) Version history and editions of MS SQL Server 4) Installing components of SQL Server 5) Configuring and managing MS SQL Server instances (Configuration Manager, Management Studio) 6) Working with databases (creating and altering databases, database options and properties, managing database files and group files) 7) Managing database objects (tables, views, indices, statistics, functions, procedures, triggers) 8) Basic administration of the Active Directory Services 9) Implementing authentication and authorization (managing logins and server roles, managing users and database roles) 10) Recovery models and database backups 11) Restoring of SQL Server databases in different scenarios (point of failure recovery, point in time recovery, restore a databse to a marked transaction). 12) Database migration and copy methods to another servers 13) Working with SQL Server Agent (jobs, alerts) 14) Creating and altering maintenance plans by using Maintenance Plan Wizard. 15) Implementing high availability a) replication (snapshot, transactional, peer-to-peer transactional, merge) b) log shipping c) database mirroring d) Windows Server Failover Clustering e) AlwaysOn Availability groups 16) Transactions, isolation levels, locks 17) Detecting and eliminating deadlocks 18) Monitoring SQL Server by using: a) Performance Monitor b) Activity Monitor c) system views d) log files 19) Registering activity by using SQL Server Profiler |
|
Bibliography: |
1) Slides available to students 2) Microsoft SQL Server Books Online |
Classes in period "Winter Semester 2018/2019" (past)
Time span: | 2018-10-01 - 2019-02-10 |
Navigate to timetable
MO TU LI
W LI
TH W
LI
FR |
Type of class: |
Information technology laboratory, 28 hours
Lecture, 28 hours
|
|
Coordinators: | Michał Bleja | |
Group instructors: | Michał Bleja | |
Course homepage: | http://math.uni.lodz.pl/~bleja/asb | |
Students list: | (inaccessible to you) | |
Examination: |
Course -
(in Polish) Ocena zgodna z regulaminem studiów
Information technology laboratory - (in Polish) Ocena zgodna z regulaminem studiów Lecture - (in Polish) Ocena zgodna z regulaminem studiów |
|
Teaching Method: | Case study Seminar The project method The exercise method |
|
Method and Criteria of Assessment: | The laboratory grade is the grade for the final laboratory exam. The laboratory exam checka the following education effects: E4- E9, E11, E12, E13, E14-E19. The lecture grade is the grade for the final lecture oral exam. The lecture exam checks the following education effects: E1-E7, E10-E13,E15. The final grade of this course is the weighted average of the final oral exam grade (50%) and the final laboratory grade (50%). |
|
Course Content: | 1) Overview of main relational database management systems 2) Architecture of MS SQL Server (Database Engine, SSIS, SSRS, SSAS) 3) Version history and editions of MS SQL Server 4) Installing components of SQL Server 5) Configuring and managing MS SQL Server instances (Configuration Manager, Management Studio) 6) Working with databases (creating and altering databases, database options and properties, managing database files and group files) 7) Managing database objects (tables, views, indices, statistics, functions, procedures, triggers) 8) Basic administration of the Active Directory Services 9) Implementing authentication and authorization (managing logins and server roles, managing users and database roles) 10) Recovery models and database backups 11) Restoring of SQL Server databases in different scenarios (point of failure recovery, point in time recovery, restore a databse to a marked transaction). 12) Database migration and copy methods to another servers 13) Working with SQL Server Agent (jobs, alerts) 14) Creating and altering maintenance plans by using Maintenance Plan Wizard. 15) Implementing high availability a) replication (snapshot, transactional, peer-to-peer transactional, merge) b) log shipping c) database mirroring d) Windows Server Failover Clustering e) AlwaysOn Availability groups 16) Transactions, isolation levels, locks 17) Detecting and eliminating deadlocks 18) Monitoring SQL Server by using: a) Performance Monitor b) Activity Monitor c) system views d) log files 19) Registering activity by using SQL Server Profiler |
|
Bibliography: |
1) Slides available to students 2) Microsoft SQL Server Books Online |
Classes in period "Winter Semester 2017/2018" (past)
Time span: | 2017-10-01 - 2018-02-09 |
Navigate to timetable
MO LI
TU LI
W W
LI
TH FR |
Type of class: |
Information technology laboratory, 28 hours
Lecture, 28 hours
|
|
Coordinators: | Michał Bleja | |
Group instructors: | Michał Bleja | |
Course homepage: | http://math.uni.lodz.pl/~bleja/asb | |
Students list: | (inaccessible to you) | |
Examination: |
Course -
(in Polish) Ocena zgodna z regulaminem studiów
Information technology laboratory - (in Polish) Ocena zgodna z regulaminem studiów Lecture - (in Polish) Ocena zgodna z regulaminem studiów |
|
Teaching Method: | Case study Seminar The project method The exercise method |
|
Method and Criteria of Assessment: | The laboratory grade is the grade for the final laboratory exam. The laboratory exam checka the following education effects: E4- E9, E11, E12, E13, E14-E19. The lecture grade is the grade for the final lecture oral exam. The lecture exam checks the following education effects: E1-E7, E10-E13,E15. The final grade of this course is the weighted average of the final oral exam grade (50%) and the final laboratory grade (50%). |
|
Course Content: | 1) Overview of main relational database management systems 2) Architecture of MS SQL Server (Database Engine, SSIS, SSRS, SSAS) 3) Version history and editions of MS SQL Server 4) Installing components of SQL Server 5) Configuring and managing MS SQL Server instances (Configuration Manager, Management Studio) 6) Working with databases (creating and altering databases, database options and properties, managing database files and group files) 7) Managing database objects (tables, views, indices, statistics, functions, procedures, triggers) 8) Basic administration of the Active Directory Services 9) Implementing authentication and authorization (managing logins and server roles, managing users and database roles) 10) Recovery models and database backups 11) Restoring of SQL Server databases in different scenarios (point of failure recovery, point in time recovery, restore a databse to a marked transaction). 12) Database migration and copy methods to another servers 13) Working with SQL Server Agent (jobs, alerts) 14) Creating and altering maintenance plans by using Maintenance Plan Wizard. 15) Implementing high availability a) replication (snapshot, transactional, peer-to-peer transactional, merge) b) log shipping c) database mirroring d) Windows Server Failover Clustering e) AlwaysOn Availability groups 16) Transactions, isolation levels, locks 17) Detecting and eliminating deadlocks 18) Monitoring SQL Server by using: a) Performance Monitor b) Activity Monitor c) system views d) log files 19) Registering activity by using SQL Server Profiler |
|
Bibliography: |
1) Slides available to students 2) Microsoft SQL Server Books Online |
Copyright by UNIVERSITY OF LODZ.