Development of Database Applications - NDBI026
Title: Vývoj databázových aplikací
Guaranteed by: Department of Software Engineering (32-KSI)
Faculty: Faculty of Mathematics and Physics
Actual: from 2022
Semester: summer
E-Credits: 4
Hours per week, examination: summer s.:1/2, MC [HT]
Capacity: unlimited
Min. number of students: unlimited
4EU+: no
Virtual mobility / capacity: no
State of the course: taught
Language: Czech, English
Teaching methods: full-time
Teaching methods: full-time
Additional information: http://www.ms.mff.cuni.cz/~kopecky/vyuka/dbapl/
Guarantor: RNDr. Michal Kopecký, Ph.D.
Class: Informatika Bc.
Informatika Mgr. - volitelný
Classification: Informatics > Database Systems
Pre-requisite : NDBI025
Opinion survey results   Examination dates   SS schedule   Noticeboard   
Annotation -
Last update: Ing. Ladislav Kopecký (23.04.2007)
SQL language for Oracle and MS SQL databases vs. ANSI SQL - Tables, views - Procedural extensions, PL/SQL language, Transact-SQL - Object/relational extensions - abstract data types, objects, arrays, nested tables - Query optimization Relational and object/relational schema design. Design of server-side running database applications. Access rights management. Transaction control, database locks
Course completion requirements -
Last update: RNDr. Michal Kopecký, Ph.D. (02.10.2017)

A condition for the passing the course is delivering of a database application according to the negotiated assignment

(database layer of the application plus application logic embedded in the database using its procedural extensions)

Literature - Czech
Last update: RNDr. Michal Kopecký, Ph.D. (15.05.2020)

Manuály k databázovému systému Oracle / MS SQL

  • SQL reference guide

Loney K., Theriault M.: Mistrovství v Oracle Database 11g; Albatros Media

Lacko L.: Oracle - správa, programování a použití databázového systému; Computer Press

Syllabus -
Last update: RNDr. Michal Kopecký, Ph.D. (28.05.2019)

SQL language for Oracle and MS SQL databases vs. ANSI SQL

  • Tables and views
  • Procedural extensions
  • PL/SQL language in Oracle - triggers, procedures, functions and packages
  • Transact-SQL in MS SQL - triggers, procedures and functions
  • Object-relational extensions - objects, arrays, nested relations
  • SQL query optimization

Design of relational and object-relational schemas

Design of server-side database applications

Restiction of access rights to application components

Transaction control, database locks