SubjectsSubjects(version: 876)
Course, academic year 2020/2021
  
Administration of web and database server - N500016
Title: Administrace webového a databázového serveru
Guaranteed by: CTU in Prague, Faculty of Information Technology (500)
Actual: from 2017
Semester: summer
Points: summer s.:5
E-Credits: summer s.:5
Examination process: summer s.:
Hours per week, examination: summer s.:2/2 C+Ex [hours/week]
Capacity: unknown / unknown (unknown)
Min. number of students: unlimited
Language: Czech
Teaching methods: full-time
Level:  
For type:  
Guarantor: Valenta Michal Ing. Ph.D.
Interchangeability : N500017
Z//Is interchangeable with: N500017
Annotation -
Last update: Svozil Daniel doc. Mgr. Ph.D. (14.12.2016)
Students are introduced to the administration of database and web servers and services. Students will be able to install, configure, maintain, test and backup complex systems of database and web services. To provide a balanced overview, students will be introduced to three different database engines: Oracle as a representative of a large commercial system; PostgreSQL as a representative of a complex and advanced open-source, community-developed software; MySQL as the most common database engine to use with the Apache web server.
Aim of the course -
Last update: Svozil Daniel doc. Mgr. Ph.D. (14.12.2016)

Students will be able to:

administer database and web servers and services

administer Oracle, PostgreSQL and MySQL database engines

configure Apache web server

Literature -
Last update: Svozil Daniel doc. Mgr. Ph.D. (14.12.2016)

Kabir, M. J. Apache Server 2: kompletní příručka administrátora. Brno: Computer Press, 2004. ISBN 80-251-0319-6.

Mullins, C. S. ''Database Administration: The Complete Guide to Practices and Procedures''. Addison-Wesley Professional, 2002. ISBN 0201741296.

Learning resources -
Last update: Svozil Daniel doc. Mgr. Ph.D. (14.12.2016)

https://edux.fit.cvut.cz/courses/BI-AWD/

(login necessary)

Syllabus -
Last update: Svozil Daniel doc. Mgr. Ph.D. (14.12.2016)

1. Techniques for detecting and debugging problematic SQL queries.

2. Database engine architecture from the installation, configuration, and backup point of view.

3. Principles of Oracle, PostgreSQL and MySQL database engines.

4. Specifics of Oracle configuration, administration and backup.

5. Specifics of PostgreSQL configuration, administration and backup.

6. Specifics of MySQL configuration, administration and backup.

7. Common maintenance and backup in individual DB engines.

8. Apache web server features, architecture, installation.

9. Apache server configuration and testing. Apache server modules.

10. Authentication and authorization, security, monitoring access to the server, analysis tools.

11. Backing up and restoring data, web server integrity.

12. Integration of MySQL and PHP into a web server, phpMyAdmin.

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

Registration requirements -
Last update: Svozil Daniel doc. Mgr. Ph.D. (14.12.2016)

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

Teaching methods
Activity Credits Hours
Účast na přednáškách 1 28
Práce na individuálním projektu 1,5 42
Příprava na zkoušku a její absolvování 1,1 30
Účast na seminářích 1 28
5 / 5 128 / 140
 
VŠCHT Praha