Subjects

Your browser does not support JavaScript, or its support is disabled. Some features may not be available.

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
Additional information:	http://www.ms.mff.cuni.cz/~kopecky/vyuka/dbapl/

Guarantor:	RNDr. Michal Kopecký, Ph.D.
Teacher(s):	RNDr. Michal Kopecký, Ph.D.
Class:	Informatika Bc. Informatika Mgr. - volitelný
Classification:	Informatics > Database Systems
Pre-requisite :	NDBI025

Opinion survey results Examination dates Noticeboard

Annotation -

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

Last update: Kopecký Ladislav, Ing. (23.04.2007)

Course completion requirements -

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)

Last update: Kopecký Michal, RNDr., Ph.D. (02.10.2017)

Literature - Czech

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

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

Syllabus -

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

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