TI2007 Databases and CMS at Elementary School

Faculty of Education
Spring 2021
Extent and Intensity
0/2/0. 2 credit(s). Type of Completion: z (credit).
Teacher(s)
doc. Ing. Jiří Strach, CSc. (seminar tutor)
Guaranteed by
doc. Ing. Jiří Strach, CSc.
Department of Technical Education and Information Science – Faculty of Education
Contact Person: doc. Ing. Jiří Strach, CSc.
Supplier department: Department of Technical Education and Information Science – Faculty of Education
Timetable of Seminar Groups
TI2007/01: Thu 9:00–10:50 učebna 25, J. Strach
Course Enrolment Limitations
The course is also offered to the students of the fields other than those the course is directly associated with.
fields of study / plans the course is directly associated with
Course objectives
The subject deals with database systems and editorial systems. Shows the creation of active web pages using Visual Studio, the Access database system and the Oracle SQL server.
Learning outcomes
At the end of this course the student will be able to: a) describe and use individual technologies to create active websites; a) Visual Studio creation; b) designing databases and working with Access database systems and Oracle SQL Server; a) manipulate data through databases from the web; b) create independently active websites;
Syllabus
  • 1. Database Access Systems, SQL (Database Theory, DBS Creation, Database Model Design, Custom Database Creation) 2. Work with the Oracle Database Server 3. Access database design test 4. Overview of site creation options (HTML, CSS, content management systems) 5. Dynamic www pages (VBScript, ASPNET MVC2 principle and usage) 6. Visual Basic and Visual Developer - Fundamentals of Programming (Visual Basic Syntax and Basic Commands - Practical Demos) 7. Visual Basic - other usage options, introduction to SQL databases (form processing, database on the web, PHP utilization in cooperation with database) 8. Other site creation options (separate project work) 9. Other site creation options (stand-alone project work) 10. Use of services on the Internet (domain registration, www space, search engines, statistics, ...) 11. Independent work (project work with the possibility of consultation) 12. Submission and approval of the project
Literature
    required literature
  • http://boss.ped.muni.cz/databaze.pdf
  • KROENKE M., AUER J. Databáze. Computer Press,Brno,2015.496s. 978-80-2514-352-0
    recommended literature
  • FUKS, J., BARCHFELD, A.Visual Basic Velká kniha řešení. Computer Press,Praha,2010,780s.ISBN: 978-80-251-2212-9
Teaching methods
nterpretation. exercises, self-study
Assessment methods
development of the project
Language of instruction
Czech
Further comments (probably available only in Czech)
Study Materials
The course is taught annually.
Information on the extent and intensity of the course: 8 h. konz./sem. (komb. stud.).
Teacher's information
http://boss.ped.muni.cz/databaze.pdf
The course is also listed under the following terms Spring 2018, Spring 2019, Spring 2020, Spring 2022, Spring 2023, Spring 2024, Spring 2025.
  • Enrolment Statistics (Spring 2021, recent)
  • Permalink: https://is.muni.cz/course/ped/spring2021/TI2007