|
Vyučující
|
-
Borkovcová Monika, Ing. Ph.D.
|
|
Obsah předmětu
|
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. All study materials are part of the e-learning course. The subject is taught only in the form of e-learning.
|
|
Studijní aktivity a metody výuky
|
|
Monologická (výklad, přednáška, instruktáž), Dialogická (diskuze, rozhovor, brainstorming), Demonstrace, Projekce, Nácvik dovedností
|
|
Výstupy z učení
|
The aim of the subject is to learn the basis of SQL language in practical use. The subject is only for ERASMUS students.
Master of the elementary work with SQL language in Oracle database system.
|
|
Předpoklady
|
The course is intended for students who have no experience with relational databases and SQL language.
|
|
Hodnoticí metody a kritéria
|
Písemná zkouška, Posouzení zadané práce, Rozbor díla tvůrčího charakteru, Didaktický test, Rozhovor
To obtain the assessment and examination, the student must complete the requirements: 1) Pass all tests. 2) For tests, only the result of the first attempt is counted. 3) You will then be graded on the following scale: 100-90% - Grade "A" 89-80% - Grade "B" 79-70% - Grade "C" 69-60% - Grade "D" 59-50% - Grade "E"
|
|
Doporučená literatura
|
-
Oracle Academy. Lectures and Presentations.
|