Course description - BIK-AWD.21

Main page | Study Branches/Specializations | Groups of Courses | All Courses | Roles Instructions

A course is the basic teaching unit, it's design as a medium for a student to acquire comprehensive knowledge and skills indispensable in the given field. A course guarantor is responsible for the factual content of the course.
For each course, there is a department responsible for the course organisation. A person responsible for timetabling for a given department sets a time schedule of teaching and for each class, s/he assigns an instructor and/or an examiner.
Expected time consumption of the course is expressed by a course attribute extent of teaching. For example, extent = 2 +2 indicates two teaching hours of lectures and two teaching hours of seminar (lab) per week.
At the end of each semester, the course instructor has to evaluate the extent to which a student has acquired the expected knowledge and skills. The type of this evaluation is indicated by the attribute completion. So, a course can be completed by just an assessment ('pouze zápočet'), by a graded assessment ('klasifikovaný zápočet'), or by just an examination ('pouze zkouška') or by an assessment and examination ('zápočet a zkouška') .
The difficulty of a given course is evaluated by the amount of ECTS credits.
The course is in session (cf. teaching is going on) during a semester. Each course is offered either in the winter ('zimní') or summer ('letní') semester of an academic year. Exceptionally, a course might be offered in both semesters.
The subject matter of a course is described in various texts.

BIK-AWD.21 Web and Database Server Administration Extent of teaching: 14KP+4KC

Instructor: Bařinka L., Valenta M. Completion: Z,ZK

Department: 18102 Credits: 5 Semester: Z

Annotation:
Students will get acquainted with the administration of database and web servers and services. They will be able to install, configure, operate, test, and backup complex database and web service systems. The principles will be demonstrated on the PostgreSQL relational database engine and Apache will be used as an example of a web server.

Lecture syllabus:

1. Web server - features, architecture, installation.

2. Web server configuration and testing.

3. Web server modules.

4. Authentication and authorization, security, user directories.

5. Monitoring access to a server, analytical tools.

6. Proxy server, URL rewriting, optimization, load balancing.

7. Relational DB architecture.

8. Relational DB configuration.

9. Usual DB management - user accounts, data structures.

10. DB monitoring.

11. DB engine tuning and configuration.

12. DB engine scaling.

13. Non-relational DB engines.

Seminar syllabus:

1. Web server - features, architecture, installation.

2. Web server configuration and testing.

3. Web server modules.

4. Authentication and authorization, security, user directories.

5. Monitoring access to a server, analytical tools.

6. Proxy server, URL rewriting, optimization, load balancing.

7. Relational DB architecture.

8. Relational DB configuration.

9. Usual DB management - user accounts, data structures.

10. DB monitoring.

11. DB engine tuning and configuration.

12. DB engine scaling.

13. Non-relational DB engines.

Literature:

1. Apache Software Foundation : Apache HTTP Server Documantation Version 2.5. 12th Media Services, 2016. ISBN 978-1680921489.

2. Blokdyk B. : Apache Web Server A Complete Guide (2020 Edition). 5starcooks, 2019. ISBN 978- 0655924326.

3. Mullins C. S. : Database Administration: The Complete Guide to DBA Practices and Procedures (2nd Edition). Addison-Wesley Professional, 2012. ISBN 321822943.

Requirements:
Theoretical background and practical skills in database systems and knowledge of basic web technologies.

Informace o předmětu a výukové materiály naleznete na https://courses.fit.cvut.cz/BI-AWD/

The course is also part of the following Study plans:

Study Plan Study Branch/Specialization Role Recommended semester

BIK-PS.21 Computer Networks and Internet 2021 (in Czech) V 5

BIK-PV.21 Computer Systems and Virtualization 2021 (in Czech) PS 5

BIK-IB.21 Information Security 2021 (in Czech) V 5

BIK-SI.21 Software Engineering 2021 (in Czech) V 5

Page updated 19. 4. 2024, semester: L/2020-1, L/2021-2, Z/2023-4, Z/2024-5, Z/2019-20, Z/2022-3, L/2019-20, L/2022-3, Z/2020-1, Z/2021-2, L/2023-4, Send comments to the content presented here to Administrator of study plans Design and implementation: J. Novák, I. Halaška

BIK-AWD.21	Web and Database Server Administration			Extent of teaching:	14KP+4KC
Instructor:	Bařinka L., Valenta M.			Completion:	Z,ZK
Department:	18102	Credits:	5	Semester:	Z

1.		Web server - features, architecture, installation.
2.		Web server configuration and testing.
3.		Web server modules.
4.		Authentication and authorization, security, user directories.
5.		Monitoring access to a server, analytical tools.
6.		Proxy server, URL rewriting, optimization, load balancing.
7.		Relational DB architecture.
8.		Relational DB configuration.
9.		Usual DB management - user accounts, data structures.
10.		DB monitoring.
11.		DB engine tuning and configuration.
12.		DB engine scaling.
13.		Non-relational DB engines.

1.		Apache Software Foundation : Apache HTTP Server Documantation Version 2.5. 12th Media Services, 2016. ISBN 978-1680921489.
2.		Blokdyk B. : Apache Web Server A Complete Guide (2020 Edition). 5starcooks, 2019. ISBN 978- 0655924326.
3.		Mullins C. S. : Database Administration: The Complete Guide to DBA Practices and Procedures (2nd Edition). Addison-Wesley Professional, 2012. ISBN 321822943.