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 Web and Database Server Administration Extent of teaching: 13KP+4KC Instructor: Completion: Z,ZK Department: 18102 Credits: 4 Semester: L Annotation:
Student in the branch "BI-IT Information technology" who lack the compulsory BIK-AWD course, ask the office of study affairs for enrolling an equivalent course BIK-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.
Lecture syllabus:
1. Database engine architecture from the installation, configuration, and backup point of view. Concepts of Oracle, PostgreSQL and MySQL database engines. 2. Specifics of Oracle configuration, administration and backup. Specifics of PostgreSQL configuration, administration and backup. 3. Specifics of MySQL configuration, administration and backup. Common maintenance and backup in individual DB engines. 4. Techniques for detecting and debugging problematic SQL queries. Apache web server - features, architecture, installation. 5. Apache server configuration and testing. Apache server modules. 6. Authentication and authorization, security, monitoring access to the server, analysis tools. Backing up and restoring data, web server integrity. 7. Integration of MySQL and PHP into a web server, phpMyAdmin. Proxy server, URL rewriting, optimization, load balancing. Seminar syllabus:
1. Project assignment. Project assignment consultations. 2. Project consultations. Project presentation. Literature:
1. Mullins, C. S. ''Database Administration: The Complete Guide to Practices and Procedures''. Addison-Wesley Professional, 2002. ISBN 0201741296. 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/
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 (Valenta/Barinka).The course is also part of the following Study plans:
Study Plan Study Branch/Specialization Role Recommended semester BIK-BIT.2015 Computer Security and Information technology V 6 BIK-BIT.2020 Computer Security and Information technology V 6 BIK-SPOL.2015 Unspecified Branch/Specialisation of Study VO 6 BIK-WSI-SI.2015 Web and Software Engineering V 6
Page updated 28. 4. 2024, semester: Z/2020-1, Z/2021-2, L/2020-1, Z/2024-5, Z/2022-3, Z,L/2023-4, L/2019-20, L/2022-3, Z/2019-20, L/2021-2, Send comments to the content presented here to Administrator of study plans Design and implementation: J. Novák, I. Halaška