Web and Database Server Administration

Lecturer:

Lukáš Bařinka (gar.), Tomáš Kadlec (gar.), Michal Valenta (gar.)

Tutor:

Lukáš Bařinka (gar.), Tomáš Kadlec (gar.), Michal Valenta (gar.), Jan Chrastina, Petr Jendele

Supervisor:

Department of Software Engineering

Synopsis:

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.

Requirements:

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

Syllabus of lectures:

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

2. Concepts of Oracle, PostgreSQL and MySQL database engines.

3. Specifics of Oracle configuration, administration and backup.

4. Specifics of PostgreSQL configuration, administration and backup.

5. Specifics of MySQL configuration, administration and backup.

6. Common maintenance and backup in individual DB engines.

7. Techniques for detecting and debugging problematic SQL queries.

8. Apache web server - features, architecture, installation.

9. Apache server configuration and testing.

10. Apache server modules.

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

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

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

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

Syllabus of tutorials:

1. Project assignment.

2. Project assignment consultations.

3. Project consultations.

4. Project presentation.

Study Objective:

This is the concluding course that deals with the administration of a complex system. 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).

Study materials:

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

Note:

Time-table for winter semester 2011/2012:

Time-table is not available yet

Time-table for summer semester 2011/2012:

	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:348 Kadlec T. Jendele P. 11:00–12:30 (lecture parallel1 parallel nr.101) Dejvice NBFIT BOU ucebnaroomT9:348 Jendele P. Kadlec T. 12:45–14:15 (lecture parallel1 parallel nr.102) Dejvice NBFIT BOU ucebna
Tue
Fri	roomT9:348 Jendele P. Kadlec T. 11:00–12:30 (lecture parallel1 parallel nr.103) Dejvice NBFIT BOU ucebnaroomT9:107 Valenta M. Bařinka L. 16:15–17:45 (lecture parallel1) Dejvice Posluchárna
Thu
Fri

The course is a part of the following study plans:

• Information Systems and Management, Version for Students who Enrolled in 2009 and 2010, in Czech (VO)
• Information Technology, Version for Students who Enrolled in 2009 and 2010, Presented in Czech (compulsory course of the specialization)
• Informatics, Version for Students who Enrolled in 2009 and 2010, Presented in Czech (VO)
• Informatics (Bachelor)- Version for those who Enrolled in 2011 and 2012 (in Czech) (VO)
• Information Systems and Management - Version for those who Enrolled in 2011 and 2012 (in Czech) (VO)
• Information Technology- Version for those who Enrolled in 2011 and 2012 (in Czech) (compulsory course of the specialization)