Logo ČVUT
Loading...
CZECH TECHNICAL UNIVERSITY IN PRAGUE
STUDY PLANS
2011/2012
Faculties | School elective courses | Katalog předmětů ECTS | Česká verze
Welcome page > Faculty of Electrical Engineering > Department of Computer Science and Engineering > SQL

SQL

Login to KOS for course enrollment Display time-table
Code Completion Credits Range Language
X36SQL Z,ZK 4 2+2c Czech
The course is a substitute for:
The language SQL (36SQL)
Lecturer:
Jaroslav Pokorný (gar.)
Tutor:
Jaroslav Pokorný (gar.), Ivan Halaška
Supervisor:
Department of Computer Science and Engineering
Synopsis:

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.

Requirements:

https://service.felk.cvut.cz/courses/X36SQL

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.

Syllabus of lectures:

1.Introduction, relational database model, basic constructs of SQL, basics of DDL language: data types, integrity constraints, CREATE TABLE statements,

2. indexing in SQL, statement SELECT, simple queries, arithmetic, aggregation functions

3. multi-level aggregation, value expressions, predicates in SQL, quantification in SQL, set operations,

4. 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.

5. Static and dynamic SQL, cursors, exception states and their processing, JDBC.

6. Stored procedures, triggers.

7. 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.

8. OR model and SQL: typing system in SQL:1999 and SQL:2003, subtypes, subtables, reference and dereference. Implementation of OR model in commercial DBMSs.

9. Another features of SQL:1999 and SQL:2003. Recursion in SQL.

10. SQL/MM: Full-Text.

11. SQL/MM Spatial.

12. Temporal extensions of SQL.

13. OLAP in relational databases, CUBE operator.

14. SQL and XML.

Syllabus of tutorials:

1. Organization rules, objectives, the class room environment

2. Getting started with thin and fat SQL clients, SQL queries

3. The first milestone of the semestral project

4. An anonymous program in the language of modules

5. Use of cursors, records and collections

6. The written test, in the second part the discussion about the test

7. The second milestone of the semestral project

8. Exceptions handling, stored procedures, the implementation of the semestral project

9. Stored functions, the implementation of the semestral project

10. Database triggers, the implementation of the semestral project

11. Stored packages, the implementation of the semestral project

12. Written test, in the second part the discussion about the test

13. The implementation of the semestral project

14. The evaluation of the semestral project

Study Objective:
Study materials:

1. Pokorný J.: Dotazovací jazyky. Science, Veletiny, 1994

2. Hoffman, J.: Introduction to Structured Query Language

http://www.highcroft.com/highcroft/sql_intro.pdf

3. Abbey M., Corey M., Abramson I.: Základy práce s databází Oracle 9i.

SoftPress 2002

4. ISO, Information Technology - Database Language SQL2. ISO/IEC 9075:1992

5. Oracle10g SQL Reference.

http://oraserv.felk.cvut.cz:7777/10gdoc/server.102/b14200/toc.htm

6. Oracle10g PL/SQL Reference.

http://oraserv.felk.cvut.cz:7777/10gdoc/appdev.102/b14261/toc.htm

Note:
Time-table for winter semester 2011/2012:
Time-table is not available yet
Time-table for summer semester 2011/2012:
06:00–08:0008:00–10:0010:00–12:0012:00–14:0014:00–16:0016:00–18:0018:00–20:0020:00–22:0022:00–24:00
Mon
Tue
roomKN:E-301
Pokorný J.
16:15–17:45
(lecture parallel1)
Karlovo nám.
Šrámkova posluchárna K9roomKN:E-310
Halaška I.
18:00–19:30
(lecture parallel1
parallel nr.101)
Karlovo nám.
Lab K310 Linux
Fri
Thu
Fri
The course is a part of the following study plans:
Generated on 2012-7-9
Copyright © Jiří Kosek, 2010–2012 | Copyright © ČVUT, 2010–2012 | Hosted by Výpočetní a informační centrum ČVUT | Send your questions and comments to HelpDesk ČVUT nebo na spravcekos@cvut.cz
For updated information see http://bilakniha.cvut.cz/en/predmet11451204.html