Logo ČVUT
CZECH TECHNICAL UNIVERSITY IN PRAGUE
STUDY PLANS
2024/2025

Web and Database Server Administration

Login to KOS for course enrollment Display time-table
Code Completion Credits Range Language
BIE-AWD.21 Z,ZK 5 2P+2C English
Course guarantor:
Michal Valenta
Lecturer:
Lukáš Bařinka, Michal Valenta
Tutor:
Lukáš Bařinka, Michal Valenta
Supervisor:
Department of Software Engineering
Synopsis:

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.

Requirements:

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

Syllabus of lectures:

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.

Syllabus of tutorials:

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.

Study Objective:
Study materials:

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.

Note:
Further information:
https://courses.fit.cvut.cz/BI-AWD
Time-table for winter semester 2024/2025:
06:00–08:0008:00–10:0010:00–12:0012:00–14:0014:00–16:0016:00–18:0018:00–20:0020:00–22:0022:00–24:00
Mon
roomT9:347
Valenta M.
Bařinka L.

12:45–14:15
(lecture parallel1)
Dejvice
Tue
Wed
Thu
Fri
Time-table for summer semester 2024/2025:
Time-table is not available yet
The course is a part of the following study plans:
Data valid to 2024-11-30
For updated information see http://bilakniha.cvut.cz/en/predmet6672406.html