TIc024 Database systems

Faculty of Education
Autumn 2023
Extent and Intensity
0/0/0. 2 credit(s). Type of Completion: z (credit).
Teacher(s)
doc. Ing. Jiří Strach, CSc. (lecturer)
Ing. Martin Dosedla, Ph.D. (seminar tutor)
Ing. Zdeněk Hodis, Ph.D. (seminar tutor)
Mgr. Martin Kučera (seminar tutor)
Mgr. Karel Picka, Ph.D. (seminar tutor)
Guaranteed by
doc. Ing. Jiří Strach, CSc.
Department of Technical Education and Information Science – Faculty of Education
Contact Person: Kateřina Brabcová
Supplier department: Department of Technical Education and Information Science – Faculty of Education
Prerequisites
Basic skills of working with Microsoft Office
Course Enrolment Limitations
The course is only offered to the students of the study fields the course is directly associated with.
fields of study / plans the course is directly associated with
Course objectives
At the end of the course the student will be able to: Create databases and work with a database system; manipulate data through databases from the web; create a stand-alone active Web page to connect to Access and the SQL Server;
Learning outcomes
The student will have general knowledge of database systems. They will be able to use their knowledge to create a database file system in Visual Basic. He will be able to create a system project in Access. It will be able to create a Front End as a Windows application. It will be able to create a Front End in a Web browser. He will be able to work with the SQL Server
Syllabus
  • Database systems - Access, SQL 1st database of databases, creation of DBS, design of database model, creation of proprietary database) 2, Working with the   Database Server Sql Server 3. Dynamic www pages (ASPNET principle and usage) 4. Visual Basic and Visual Devloper - Basics of Programming (Basic Visual Basic Syntax and Basic Commands - Practical Demos) 5.Visual Basic - Other usage options, introduction to SQL databases (forms processing, database on the web, use in cooperation with the   database) 6. Other site creation options (Independent project work) 7. Use of services on the Internet (domain registration, www space, search engines, statistics, ...) 8. Separate work (work on the project with the possibility of consultation N
Literature
    recommended literature
  • Fuxs,J, Barchfeld,a.Visual Basic Velká kniha řešení. Computer Press,Praha,2010,780s.ISBN: 978-80-251-2212-9
    not specified
  • http://boss.ped.muni.cz/databaze.pdf
  • http://boss.ped.muni.cz/vyuka/material/puvodni/91.pdf
Teaching methods
theoretical training, individual work on pc
Assessment methods
Continuous testing, elaboration of project from database area according to current assignments.
Language of instruction
Czech
Further comments (probably available only in Czech)
The course is taught each semester.
The course is taught: in blocks.
Information on the extent and intensity of the course: 12 hodin + 14 hodin e-learningu.
Teacher's information
http://boss.ped.muni.cz/databaze.pdf
The course is also listed under the following terms Autumn 2018, Spring 2019, Autumn 2019, Spring 2020, autumn 2020, Spring 2021, Autumn 2021, Spring 2022, Autumn 2022, Spring 2023, Spring 2024, Autumn 2024, Spring 2025.
  • Enrolment Statistics (Autumn 2023, recent)
  • Permalink: https://is.muni.cz/course/ped/autumn2023/TIc024