Logo ČVUT
CZECH TECHNICAL UNIVERSITY IN PRAGUE
STUDY PLANS
2023/2024
UPOZORNĚNÍ: Jsou dostupné studijní plány pro následující akademický rok.

SQL Applications

Login to KOS for course enrollment Display time-table
Code Completion Credits Range Language
18SQL Z 2 0+2 Czech
Garant předmětu:
Jaromír Kukal
Lecturer:
Jaromír Kukal, Dana Majerová
Tutor:
Jaromír Kukal, Dana Majerová
Supervisor:
Department of Software Engineering
Synopsis:

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

Requirements:

Passing of 18DATS

Syllabus of lectures:

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

2. Creation of table and index in DDL.

3. Data updating, projection and restriction in DML.

4. Sorting, aggregation and the second restriction in DML.

5. The NULL value in table, expression and during restriction.

6. Set of values and nested query.

7. View as virtual table and its creation in DDL.

8. Realization of integrity constrains in DDL.

9. Joins of data sources and hierarchical views.

10. Optimization of query and fast operations over data sets.

11. Creation of procedures in DDL, branching and loop.

12. Procedure which returns a table and exceptions.

13. Events in database environment and triggers.

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:

[1] Stephens, R., Plew, R., Jones, A. D. Sams Teach Yourself: SQL in 24 Hours. 6th edition. Sams Publishing, 2015.

[2] Rockoff , L. The Language of SQL. 2nd edition. Addison-Wesley Professional, 2016.

Recommended references:

[3] Molinaro, A. SQL Cookbook: Query Solutions and Techniques for Database Developers. Sebastopol (CA, USA):

O’Reilly, 2005.

Note:
Time-table for winter semester 2023/2024:
Time-table is not available yet
Time-table for summer semester 2023/2024:
Time-table is not available yet
The course is a part of the following study plans:
Data valid to 2024-03-27
Aktualizace výše uvedených informací naleznete na adrese https://bilakniha.cvut.cz/en/predmet24906005.html