course in Czech language
full-time study course, currently teaching
Number of teaching periods (lectures + seminars): 2+2c
Termination: Credit, examination
time table at FEE
Successful graduation of the course requires knowledge and skills, that students have acquired in course Database systems and Database systems II (relational model, object-relational model, database optimiser). Since these courses cover the SQL language in a short overview and haphazardly, a thorough treatment of most features of the SQL language is given here, particularly according to the standards SQL:1999 and SQL:2003. As a background of these standards, the object-relational data model is discussed in detail. An attention is devoted to recursion in SQL as well as to selected parts of the SQL/MM standard. The last part o lectures is devoted to temporal extensions of SQL, to possibilities of SQL for OLAP, and to partial integration of SQL and the XML language.
- Introduction, relational database model, basic constructs of SQL, basics of DDL language: data types, integrity constraints, CREATE TABLE statements,
- indexing in SQL, statement SELECT, simple queries, arithmetic, aggregation functions
- multi-level aggregation, value expressions, predicates in SQL, quantification in SQL, set operations,
- null value, joins, DML language (statements INSERT, DELETE, UPDATE), integrity constraints, referential integrity. Views. Statements for granting and revoking privileges for user access to databases. SQL standardization.
- Static and dynamic SQL, cursors, exception states and their processing, JDBC.
- Stored procedures, triggers.
- Object-relational (OR) model and SQL: the notion of a universal server, ad hoc extensibility, type, user defined types, row types constructors, references, and collections.
- OR model and SQL: typing system in SQL:1999 and SQL:2003, subtypes, subtables, reference and dereference. Implementation of OR model in commercial DBMSs.
- Another features of SQL:1999 and SQL:2003. Recursion in SQL.
- SQL/MM: Full-Text.
- SQL/MM Spatial.
- Temporal extensions of SQL.
- OLAP in relational databases, CUBE operator.
- SQL and XML.
- Organization rules, objectives, the class room environment
- Getting started with thin and fat SQL clients, SQL queries
- The first milestone of the semestral project
- An anonymous program in the language of modules
- Use of cursors, records and collections
- The written test, in the second part the discussion about the test
- The second milestone of the semestral project
- Exceptions handling, stored procedures, the implementation of the semestral project
- Stored functions, the implementation of the semestral project
- Database triggers, the implementation of the semestral project
- Stored packages, the implementation of the semestral project
- Written test, in the second part the discussion about the test
- The implementation of the semestral project
- The evaluation of the semestral project
- Pokorný J.: Dotazovací jazyky. Science, Veletiny, 1994
- Hoffman, J.: Introduction to Structured Query Language
- Abbey M., Corey M., Abramson I.: Základy práce s databází Oracle 9i.
- oftPress 2002
- ISO, Information Technology - Database Language SQL2. ISO/IEC 9075:1992
- Oracle10g SQL Reference.
- Oracle10g PL/SQL Reference.
Assessment requirements are stated on the subject's Web page above. Students must get an assessment before an exam. An exam is in a written form and it consists of a number of short problems.