|
Lecturer(s)
|
-
Borkovcová Monika, Ing. Ph.D.
|
|
Course content
|
Relational databases, database server, tables. Tools for work with Oracle database. SQL language, DDL, DML. Datatypes. Statement Select - basic syntax, projection, restriction. Statements Insert, Update, Delete. NULL values, operators, conditions. Inner and outer joins of tables. Group aggregations, aliases, sorting. Subqueries, set operators. SQL functions. Database design, relations, E-R diagrams. Normal Forms, normalisations. Table creation, constrains, primary keys, foreign keys. Views, sequences. Indexes. Data Dictionary.
|
|
Learning activities and teaching methods
|
|
Monologic (reading, lecture, briefing), Dialogic (discussion, interview, brainstorming), Demonstration, Projection, Skills training
|
|
Learning outcomes
|
The aim of the subject is to learn the basis of SQL language in practical use.
Master of the elementary work with SQL language in Oracle database system.
|
|
Prerequisites
|
unspecified
|
|
Assessment methods and criteria
|
Written examination, Home assignment evaluation, Creative work analysis, Didactic test, Discussion
To obtain the credit, students must attend a required number of lessons and fulfil specified requirements (hand over the functional solutions of lessons assignments, completing tests during term). The exam consists of two parts, practice test and theoretical exam. The practice test means to realize functional solutions of given tasks in Oracle database system and the oral discussion about the designed solution.
|
|
Recommended literature
|
-
Groff, J.R., Weinberg, P.N. SQL - kompletní průvodce. Praha: Computer Press, 2005.
-
Lacko, L. Oracle, správa, programování a použití databázového systému. Praha: Computer Press, 2007.
-
Opel, A. Databáze bez předchozích znalostí. Praha: Computer Press, 2006.
-
Stephens, K.R., Plew, R.R. Naučte se SQL za 21 dní. Praha: Computer Press, 2004.
-
Šimůnek, M.:. SQL, kompletní kapesní průvodce.
|