UF0D132 SQL Database

Faculty of Philosophy and Science in Opava
Winter 2021
Extent and Intensity
2/1/0. 4 credit(s). Type of Completion: zk (examination).
Teacher(s)
Ing. Jaroslav Zeman (lecturer)
Ing. Jaroslav Zeman (seminar tutor)
RNDr. Jan Novotný, Ph.D. (lecturer)
Guaranteed by
RNDr. Jan Novotný, Ph.D.
Centrum interdisciplinárních studií – Faculty of Philosophy and Science in Opava
Prerequisites
No prerequisite.
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 course is devoted to the basics of relational databases and nonprocedural a standardized language SQL. The students are acquainted with the administration of SQL Server, creating a relational database as the basis of the information system.
Learning outcomes
After completing the course, the student will be able to: - describe database models especially the concept of relational database - orient and work with the language SQL - design and build a relational database
Syllabus
  • Database Systems:
    - Description of the systems, features, object-oriented database model.
    - Relational database.
    - Description, basic concepts, the mathematical apparatus, search engine algorithms.
    Database design:
    - The procedures for creating relational database, conceptual schema ER-diagrams, types of attributes, relational connection, database normalization.
    SQL syntax:
    - Predicates, logical connectives, handling DB, sessions, entities, projection, selection, data aggregation, transaction management, access rights management.
    Use SQL in othres programming languages: PERL, PHP.
Literature
    required literature
  • Arie D. Jones, Ron Plew, Ryan K. Stephens. Naučte se SQL za 28 dní. Computer Press. info
    recommended literature
  • O'Reilly. PHP a MYSQL. Computer Press. ISBN 80-7226-760-4. info
Teaching methods
Interactive lecture
Lecture supplemented with a discussion
Assessment methods
Grade
Credit
Language of instruction
Czech
Further comments (probably available only in Czech)
The course can also be completed outside the examination period.
Teacher's information
To obtain the credit, students must hand in a semester project. The semester project will consist of a database created by students on a topic obtained after a consultation with the lecturer, by the midway through the teaching period. The database must be a functional unit that is error free and that will store data on the given topic.
The exam consists of a consultation about the semester project. The evaluation of the project will focus on its overall completion, namely: the reliability of the development of the database, student's personal contribution to the work on the theme, possibilities of further development of the database and also students' understanding of the issues and the acquired knowledge during the course.
The course is also listed under the following terms Winter 1993, Winter 1994, Winter 1995, Winter 1996, Winter 1997, Winter 1998, Winter 1999, Winter 2000, Winter 2001, Winter 2002, Winter 2003, Winter 2004, Winter 2005, Winter 2006, Winter 2007, Winter 2008, Winter 2009, Winter 2010, Winter 2011, Winter 2012, Winter 2013, Winter 2014, Winter 2015, Winter 2016, Winter 2017, Winter 2018, Winter 2019, Winter 2020, Winter 2022.
  • Enrolment Statistics (Winter 2021, recent)
  • Permalink: https://is.slu.cz/course/fpf/winter2021/UF0D132