| Course Unit Code | 460-2038/03 |
|---|
| Number of ECTS Credits Allocated | 4 ECTS credits |
|---|
| Type of Course Unit * | Optional |
|---|
| Level of Course Unit * | First Cycle |
|---|
| Year of Study * | Third Year |
|---|
| Semester when the Course Unit is delivered | Summer Semester |
|---|
| Mode of Delivery | Face-to-face |
|---|
| Language of Instruction | Czech |
|---|
| Prerequisites and Co-Requisites | |
|---|
| Prerequisities | Course Unit Code | Course Unit Title |
|---|
| 460-2013 | Database and Information Systems |
| 460-2035 | Introduction to Database Systems |
| 460-2036 | Database Systems |
| Name of Lecturer(s) | Personal ID | Name |
|---|
| BAC027 | doc. Ing. Radim Bača, Ph.D. |
| Summary |
|---|
The main topic of this course is the administration of the most widespread database system (Oracle, MS SQL Server a MySQL). The course is focused on general aspects of these products and also on their specified features.
|
| Learning Outcomes of the Course Unit |
|---|
The student who pass this course will be able to work with the three most widespread database systems (Oracle, MS SQL Server, MySQL) and efectively utilize their features. The database system start, configuration and common administration is explained and tried practicaly on an accessible hardware. Students will be able to tune the performance of databases running on a database system and detect possible problems.
- Oracle, MS SQL Server and MySQL intorduction.
- Database enviroment and hardware.
- Initialization and configuration of one instance of an database system.
- Parameters of the database.
- User acess rights and identity management.
- Database maintanance: back-up, recovery, index rebuild.
|
| Course Contents |
|---|
Syllabus of lectures.
1. SQL Server - databáze creation, filegroups, data files, parameters set-up, user creation, role assignment, user rights, back-up recovery.
2. SQL Server - services, resource governor, database audit, automatic database maintenace, logs, log shiping.
3. Oracle - tablespaces, data files, database restart, database parameters, memory set-up, recovery and back-up, users, rights and roles.
4. Oracle - services, alert log, trace logs, resource governor, database audit, automatic maintenance, table creation, treshold value set-up.
5. MySQL - data files, users and access rights, recovery and back-up, database parameters.
6. Summary and general talk abou DBA and different platforms (RAID, NUMA, Clusters).
7. SQL Server - physical database design (clustered, unclustered index, materialized views), physical database design.
8. Oracle - physical database design in Oracle.
9. Oracle - automatic physical database design, Database replay. |
| Recommended or Required Reading |
|---|
| Required Reading: |
|---|
| DBMS documentation to Oracle, SQL Server and MySQL. |
M. Krátký, R. Bača: Databázové systémy. http://db.cs.vsb.cz/edu/dbsys.pdf. leden, 2009.
Dokumentace k SŘBD Oracle, SQL Server a MySQL. |
| Recommended Reading: |
|---|
D.K.Burleson. Physical database design using Oracle, Auerbach, ISBN 0-8493-1817-3
S.Lightstone, T.Teorey, T.Nadeau. Physical database design, Morgan Kaufmann, ISBN-10: 0-12-369389-6 |
D.K.Burleson. Physical database design using Oracle, Auerbach, ISBN 0-8493-1817-3
S.Lightstone, T.Teorey, T.Nadeau. Physical database design, Morgan Kaufmann, ISBN-10: 0-12-369389-6 |
| Planned learning activities and teaching methods |
|---|
| Lectures, Tutorials |
| Assesment methods and criteria |
|---|
| Task Title | Task Type | Maximum Number of Points
(Act. for Subtasks) | Minimum Number of Points for Task Passing |
|---|
| Graded credit | Graded credit | 100 (100) | 51 |
| První bodovaný úkol Sql Server | Laboratory work | 25 | 0 |
| Druhý bodovaný úkol Sql Server | Laboratory work | 25 | 0 |
| Bodovaný úkol PostgreSql | Laboratory work | 25 | 0 |
| Zprovoznění vybraného DBMS | Project | 25 | 0 |