|
Lecturer(s)
|
-
Klečková Jana, doc. Dr. Ing.
-
Jiroušek Petr, Ing.
|
|
Course content
|
1 Oracle database architecture, basic terms, installation 2 - 3 main database administration tasks - startup, shutdown, monitoring, basic parameters settings 4 user administration, user rights and access, security fundamentals 5 - 6 database objects, overview, characteristics 7 data processing 8 Oracle connectivity network architecture 9 - 10 performance tuning 11 - 12 database backup and recovery 13 - another tools for database administration
|
|
Learning activities and teaching methods
|
Interactive lecture, Laboratory work, Lecture with visual aids
- Contact hours
- 40 hours per semester
- Preparation for formative assessments (2-20)
- 20 hours per semester
- Preparation for comprehensive test (10-40)
- 40 hours per semester
|
| prerequisite |
|---|
| Knowledge |
|---|
| knowledge of SQL language |
| knowledge of database terminology |
| basic knowledge of database functioning and principles |
| Skills |
|---|
| use SQL constructs |
| user orientation in the Linux environment |
| learning outcomes |
|---|
| Knowledge |
|---|
| knowledge of basic types of database failures |
| knowledge scorecard database |
| diagnostic knowledge database state |
| Skills |
|---|
| create and administer Oracle database |
| choose optimal backup strategy |
| recover Oracle database in any point-of-time |
| analyze and solve basic types of database failure |
| analyze and solve smaller performance problems |
| Competences |
|---|
| N/A |
| N/A |
| teaching methods |
|---|
| Knowledge |
|---|
| Lecture with visual aids |
| Interactive lecture |
| Laboratory work |
| assessment methods |
|---|
| Practical exam |
| Test |
| knowledge of basic types of database failures |
| Skills |
|---|
| diagnostic knowledge database state |
| Test |
|
Recommended literature
|
-
Bryla, Bob; Loney, Kevin. Mistrovství v Oracle Database 11g. Vyd. 1. Brno : Computer Press, 2009. ISBN 978-80-251-2189-4.
|