|
Lecturer(s)
|
-
Borkovcová Monika, Ing. Ph.D.
-
Handlíř David, Ing.
-
Navrátil Martin, Ing.
|
|
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
KST/IPALP and KST/IZAPR
|
|
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
|
-
Conolly, Thomas. Mistrovství - databáze : profesionální průvodce tvorbou efektivních databází. Brno: Computer Press, 2009. ISBN 978-80-251-2328-7.
-
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.
-
Lacko, Luboslav. 1001 tipů a triků pro SQL. Brno: Computer Press, 2011. ISBN 978-80-251-3010-0.
-
Molinaro, Anthony. SQL : kuchařka programátora. Brno: Computer Press, 2009. ISBN 978-80-251-2617-2.
-
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.
-
Stephens, Ryan K. Naučte se SQL za 28 dní : [stačí hodina denně]. Brno: Computer Press, 2010. ISBN 978-80-251-2700-1.
-
Šimůnek, M.:. SQL, kompletní kapesní průvodce.
|