SQL Application

Lecturer:

Jaromír Kukal (gar.)

Tutor:

Jaromír Kukal (gar.)

Supervisor:

Department of Software Engineering in Economy

Synopsis:

Practical realization of database system according to general principles of database analysis.

Requirements:

Passing of 18DATS

Syllabus of lectures:

Syllabus of tutorials:

1 Databse platforms, interface, script, DDL, DML.

2 Creation of table and index in DDL.

3 Update, projection and restriction in DML.

4 Sorting, aggregation and second restriction in DML.

5 NULL value in table, expression and restriction.

6 Set of values and nested querry.

7 View as virtual table and its creation in DDL.

8 Realization of integrity constrains in DDL.

9 Joining of data sources and hierarchical views.

10 Querry optimization and fast set operations.

11 Creation of procedures in DDL, branching and loop.

12 Table returning procedure and exceptions.

13 Events in database system and triggers.

14 Layer of views and procedures between data and client.

Study Objective:

Knowledge:

Exercise DDL SQL, DML SQL and PL/SQL on various examples. General rules of DB system realization and independency on platform of DB server are the main aims.

Abilities:

Orientation in given subject and ability to solve real tasks in SQL and PL/SQL.

Study materials:

Key references:

Groff J.R., Weinberg P.N.: SQL - The Complete Reference, Mc Graw Hill, 2002.

Recommended references:

Kriegel A., Trukhonov B.M.: SQL Bible, John Wiley and Sons, 2008.

Note:

Time-table for winter semester 2011/2012:

Time-table is not available yet

Time-table for summer semester 2011/2012:

Time-table is not available yet

The course is a part of the following study plans: