|
Lecturer(s)
|
|
|
|
Course content
|
Topics outline (not aligned to the weekly schedules): 1. Oracle Data Dictionary 2. SQL query optimization 3. Hierarchical query in Oracle 4. Embedded SQL 5. PL/SQL 6. Object extensions of SQL 7. Advanced data security in the database
|
|
Learning activities and teaching methods
|
- Contact hours
- 39 hours per semester
- Preparation for an examination (30-60)
- 30 hours per semester
- Undergraduate study programme term essay (20-40)
- 35 hours per semester
|
| prerequisite |
|---|
| Knowledge |
|---|
| know the basics of procedural programming |
| know the basic graphical notation for the design of the entity-relationship model |
| Skills |
|---|
| to design an entity-relationship or relational model of a simple real situation |
| implement a relational model of a simple real situation in a selected DBMS meeting third normal form |
| write simple statements in SQL |
| Competences |
|---|
| N/A |
| N/A |
| N/A |
| N/A |
| learning outcomes |
|---|
| Knowledge |
|---|
| know the basic language constructions of PL/SQL |
| describe and explain the program constructions for the implementation of an active database |
| know the basic principles of data indexing |
| Skills |
|---|
| create and debug stored procedures, functions, and packages in the database system |
| use advanced SQL capabilities when building a database application |
| Competences |
|---|
| N/A |
| N/A |
| N/A |
| teaching methods |
|---|
| Knowledge |
|---|
| Lecture supplemented with a discussion |
| Self-study of literature |
| One-to-One tutorial |
| Discussion |
| Skills |
|---|
| Lecture with visual aids |
| Practicum |
| Task-based study method |
| Skills demonstration |
| One-to-One tutorial |
| Discussion |
| Competences |
|---|
| Interactive lecture |
| assessment methods |
|---|
| Knowledge |
|---|
| Oral exam |
| Continuous assessment |
| Seminar work |
| Individual presentation at a seminar |
| Skills |
|---|
| Skills demonstration during practicum |
| Continuous assessment |
| Seminar work |
| Individual presentation at a seminar |
| Competences |
|---|
| Oral exam |
| Skills demonstration during practicum |
| Continuous assessment |
| Individual presentation at a seminar |
|
Recommended literature
|
-
Connolly, Thomas M.; Begg, Carolyn E. Database Systems: A Practical Approach to Design, Implementation, and Management. Pearson, 2015. ISBN 978-0-13-294326-0.
-
Heller, J. Pro Oracle SQL Development : Best Practices for Writing Advanced Queries. Apress, 2019. ISBN 978-1-4842-4516-3.
-
Lacko, Ľuboslav. Oracle : správa, programování a použití databázového systému. 2., dopl. vyd. Brno : Computer Press, 2007. ISBN 978-80-251-1490-2.
|