The aim of studying and bibliography

The main aim of study: The main aim of the module's education is the presentation of selected issues in the field of building modern database systems that have practical application in their administration and operation.

The general information about the module: Preparation for administration of various types of RDBMS.

Teaching materials: http://v.prz.edu.pl/pawel.dymora

Bibliography required to complete the module

Bibliography used during lectures

1	M. McLaughlin	Oracle Database 12c. Programowanie w języku PL/SQL	Helion.	2015
2	A. Silberschatz, H. F. Korth, S. Sudarshan	Database System Concepts	McGraw-Hill Higher Education.	2011
3	Bob Bryla, Kevin Loney	Oracle Database 11g, Podręcznik administratora baz danych	Helion.	2010
4	H. Garcia-Molina, J.D. Ullman, J. Widom	Systemy baz danych	WNT.	2006
5	T Cannolly, C. Begg	Systemy baz danych	Read Me.	2004
6	L Banachowski	Relacyjne Bazy danych – wykł. i ćwiczenia	PJWSTK.	1998
7	Jason Price	Oracle Database 12c i SQL	Helion.	2015

Basic requirements in category knowledge/skills/social competences

Formal requirements: The student should complete the basic database course.The student satisfies the formal requirements set out in the study regulations.

Basic requirements in category knowledge: The student should know the basic issues in the field of set theory, set algebra, relational databases, ICT and computer skills.

Basic requirements in category skills: The student is able to design complex databases.

Basic requirements in category social competences: Group work.

Module outcomes

MEK	The student who completed the module	Types of classes / teaching methods leading to achieving a given outcome of teaching	Methods of verifying every mentioned outcome of teaching	Relationships with KEK	Relationships with PRK
01	Explains the basic elements of the database system architecture at the physical and logical level and their interrelationships. In addition, it explains the basic processes of the database system.	lecture, laboratory, project	pass, observation of performance	K_W05+ K_W06++ K_W07++ K_W10+ K_U13+ K_U14++ K_U15+ K_U18++ K_U23+ K_K01+ K_K03+	P6S_KK P6S_KO P6S_KR P6S_UK P6S_UW P6S_WG
02	Designs a database system at the physical and logical level.	lecture, laboratory, project	pass, observation of performance	K_W05+ K_W06+++ K_W07++ K_W10+ K_U13+ K_U14+++ K_U15+ K_U18+++ K_U23+ K_K01+ K_K03+	P6S_KK P6S_KO P6S_KR P6S_UK P6S_UW P6S_WG
03	Manages and optimizes the database system at the physical and logical level.	lecture, laboratory, project	pass, observation of performance	K_W05+ K_W06++ K_W07++ K_W10+ K_U13+ K_U14+++ K_U15++ K_U18+++ K_U23+ K_K01+ K_K03++	P6S_KK P6S_KO P6S_KR P6S_UK P6S_UW P6S_WG
04	Designs and manages the security of the database system in relation to data, system and users.	lecture, laboratory, project	pass, observation of performance	K_W05+ K_W06++ K_W07++ K_W10+ K_U13++ K_U14++ K_U15+++ K_U18+ K_U23+ K_K01+ K_K03++	P6S_KK P6S_KO P6S_KR P6S_UK P6S_UW P6S_WG

Attention: Depending on the epidemic situation, verification of the achieved learning outcomes specified in the study program, in particular credits and examinations at the end of specific classes, can be implemented remotely (real-time meetings).

The syllabus of the module

Sem.	TK	The content	realized in	MEK
4	TK01	Organizational classes. Determining the form of credit and the scope of the material. Familiarizing with the work regulations in the laboratory.	W01, L01
4	TK02	Database system architecture on the example of Oracle database: database server structure, database connection, memory structure, database buffers, shared area, primary and secondary processes, logical and physical data structure, table spaces, segments,	W01, W02, L02	MEK01 MEK02 MEK03
4	TK03	Environment preparation and database creation in Oracle: Oracle database administrator tasks, administrative tools, database installation, system requirements, environment variables, Oracle Universal Installer, database planning, Listner configuration, Database Configuration Assistant (DBCA), password management, configuration	W03, L03, L04, P1, P2	MEK02 MEK03
4	TK04	Data storage structure management: storage structure (data warehouse - storage), blocks, extents, segments, space tables and data files, space management in tablespaces (Tablespace), modification, deletion, management and viewing of table space, database enlargement, Oracle Managed Files (OMF), Automatic Storage Management (ASM).	W04, W05, L05, L06, P3, P4	MEK01 MEK02 MEK03
4	TK05	User security management: database user account, predefined accounts: sys and system, creating, deleting, blocking and managing user accounts, resetting password, authenticating users, the principle of least privileges and its use, protection of privileged accounts, privileges: system, object, roles , broadcasting, receiving and managing privileges at the user and role level, creating and managing roles, implementing security features for passwords, assigning quotas to users.	W05, L06, P5	MEK02 MEK04
4	TK06	Schema management: Schema allocation, specification of data types in tablesech, creation, deletion and modification of tables, data integrity, integrity constraints, indexes and their types (B-tree, bitmap), views, sequences, synonyms, temporary tables.	W06, L07, L08, P6	MEK01 MEK02 MEK03
4	TK07	Backup and recovery concept: damage categories, checkpoint process (CKPT), LogWriter and Redo Log files, MTTR assistant, multiplication of control files, archiving process and Archive Log file, archivelog mode, data transfer, data import and export methods.	W07, L09, L10, P7	MEK01 MEK04

The student's effort

The type of classes	The work before classes	The participation in classes	The work after classes
Lecture (sem. 4)	The preparation for a test: 50.00 hours/sem.	contact hours: 15.00 hours/sem.
Laboratory (sem. 4)		contact hours: 20.00 hours/sem.
Project/Seminar (sem. 4)		contact hours: 15.00 hours/sem..
Advice (sem. 4)		The participation in Advice: 2.00 hours/sem.
Exam (sem. 4)	The preparation for an Exam: 10.00 hours/sem.	The written exam: 2.00 hours/sem.

The way of giving the component module grades and the final grade

The type of classes	The way of giving the final grade
Lecture	Oral exam.
Laboratory	Obtaining a positive grade from each topic of the subject.
Project/Seminar	Based on the documentation of the implemented project theme.
The final grade

Sample problems

Required during the exam/when receiving the credit
(-)

Realized during classes/laboratories/projects
(-)

Others
(-)

Can a student use any teaching aids during the exam/when receiving the credit : no

The contents of the module are associated with the research profile: no