|
|
|
||
Last update: Kubová Petra Ing. (02.01.2018)
|
|
||
Last update: Kubová Petra Ing. (02.01.2018)
Students will be able to: design and implement small databases and work with them effectively using the SQL language in a wide range of situations. understand theoretical foundations for subsequent courses, such as Database systems administration or specialized database-oriented courses (SQL, Database systems 2) in the second cycle degree programme. |
|
||
Last update: Svozil Daniel prof. Mgr. Ph.D. (26.03.2019)
R: Steven Feuerstein: Oracle PL/SQL Best Practices, O'Reily, 2007 R: Simmon Riggs, Hannu Krossng: PostgreSQL 9 Administration CookBook, Packt Publishing Ltd. 2010 A: Zoltan Boszormenyi, Hans-Jurgen Schonig: PostgreSQL Replication. Packt Publishing Ltd. 2013 |
|
||
Last update: Kubová Petra Ing. (02.01.2018)
https://edux.fit.cvut.cz/courses/BI-DBS (login necessary) |
|
||
Last update: Svozil Daniel prof. Mgr. Ph.D. (26.03.2019)
1. Bulk data processing concepts. DBMS architecture. Functions of individual components. 2. Data abstraction. Conceptual, database and physical level data model. 3. Conceptual data model. Basic constructs, integrity constraints. 4. Overview of database models - network, hierarchical, relational and object-relational model. 5. Relational data model. Relation, attributes, domains, relational database schema, DDL SQL. 6. Expressing integrity constraints through functional dependencies. Normal forms of relations. 7. Database query languages. Relational algebra, SQL. 8. [2] SQL: DDL, DCL, DML. 9. Relational schema design. Normalization using decomposition. Decomposition quality criteria. 10. Relational database schema design using a direct transformation from a conceptual schema. 11. Transactions, error recovery, concurrency control, data security and integrity. 12. Physical data model, tables as heaps, Rowid direct access, B* tree type index, bitmap index, indexed cluster, hashed cluster. 13. NoSQL databases and modern trends in database technologies |
|
||
Last update: Kubová Petra Ing. (02.01.2018)
Common user-level knowledge of Unix/Linux and MS Windows operating systems, ability to describe a solution to a problem algorithmically, and elementary knowledge of algebra and logic are expected. Active knowledge of a specific programming language is not required. |
|
||
Last update: Svozil Daniel prof. Mgr. Ph.D. (07.02.2018)
Pro zı́skánı́ zápočtu je potřeba dostatek bodů ze semestrálního testu a ze semestrální práce. Zkouška se skládá z povinné pı́semné části a z volitelné ústnı́ části. |
Teaching methods | ||||
Activity | Credits | Hours | ||
Účast na přednáškách | 1 | 28 | ||
Příprava na přednášky, semináře, laboratoře, exkurzi nebo praxi | 1 | 28 | ||
Práce na individuálním projektu | 1.5 | 42 | ||
Příprava na zkoušku a její absolvování | 1 | 28 | ||
Účast na seminářích | 1.5 | 42 | ||
6 / 6 | 168 / 168 |