Logo ČVUT
ČESKÉ VYSOKÉ UČENÍ TECHNICKÉ V PRAZE
STUDIJNÍ PLÁNY
2019/2020

Web and Database Server Administration

Předmět není vypsán Nerozvrhuje se
Kód Zakončení Kredity Rozsah Jazyk výuky
BIE-AWD Z,ZK 4 17C
Přednášející:
Cvičící:
Předmět zajišťuje:
katedra softwarového inženýrství
Anotace:

Student in the branch „BIE-IT Information technology“ who lack the compulsory BI-AWD course, ask the office of study affairs for enrolling an equivalent course BI-AWD.1, which has a block lectures.

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.

Požadavky:

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

Osnova přednášek:

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.

Osnova cvičení:

1. Project assignment.

2. Project assignment consultations.

3. [9] Project consultations.

4. [2] Project presentation.

Cíle studia:

This is the concluding module dealing with the administration of more complex systems. It provides an overview as well as hands-on experience with database and web server administration. With respect to databases, attention primarily focuses on the MySQL server that represents the most common solution in the context of www applications. PostgreSQL and Oracle are included in order to give the students a clearer overview of complex DB servers (open-source as well as proprietary).

Studijní materiály:

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

Poznámka:

Studenti, kteří opakují studium a mají uznaný předmět AWD, bude tento předmět mít roli volitelný.#

Opozdilý student, kterému chybí AWD, dělá rozdílovou zkoušku.

Další informace:
Pro tento předmět se rozvrh nepřipravuje
Předmět je součástí následujících studijních plánů:
Platnost dat k 15. 10. 2019
Aktualizace výše uvedených informací naleznete na adrese http://bilakniha.cvut.cz/cs/predmet1448006.html