The aim of studying and bibliography

The main aim of study: The main aim of education on the module is the presentation of selected issues in the field of programming database applications that have practical application in their design and creation.

The general information about the module: Creating simple and more complex projects of applications that retrieve data from various databases.

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	Jason Price	Oracle Database 12c i SQL	Helion.	2015
3	H. Schildt	Java Kompendium Programisty zgodne z JDK 7	Helion, wyd. VIII.	2012

Basic requirements in category knowledge/skills/social competences

Formal requirements: The student should complete the basic course of databases and basics of programming. 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 relational databases, algorithms, SQL language and basics of programming.

Basic requirements in category skills: He can design relational databases and not only, and creates simple programs such as C ++ / Java and uses SQL.

Basic requirements in category social competences: Works in a group, communicativeness.

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 server-side application architecture. In addition, it discusses the basic structures and functions used to create basic blocks of database application programs in selected programming languages.	lecture, laboratory, project	pass, observation of performance	K_W05+ K_W06+++ K_W07++ K_W08++ K_U09+ K_U12+ K_U23+ K_K01+ K_K03+	P6S_KK P6S_KO P6S_KR P6S_UK P6S_UW P6S_WG
02	Designs and creates data storage structures for functions, stored procedures and packages based on various data types (including object and XML).	lecture, laboratory, project	pass, observation of performance	K_W05+ K_W06+++ K_W07+++ K_W08+++ K_U09++ K_U12+ K_U23+ K_K01+ K_K03+	P6S_KK P6S_KO P6S_KR P6S_UK P6S_UW P6S_WG
03	Creates and implements on selected databases functions, stored procedures and packages using conditional logic, data structures and exception handling.	lecture, laboratory, project	pass, observation of performance	K_W05++ K_W06+++ K_W07+++ K_W08+++ K_U09++ K_U12+ K_U23+ K_K01+ K_K03+	P6S_KK P6S_KO P6S_KR P6S_UK P6S_UW P6S_WG
04	Designs, implements and manages a database application consisting of a logical (process) and presentation layer based on selected programming languages and their functions.	lecture, laboratory, project	pass, observation of performance	K_W05++ K_W06+++ K_W07+++	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
5	TK01	Organizational classes. Determining the form of credit and the scope of the material. Familiarizing with the work regulations in the laboratory.	W01, L01
5	TK02	Procedural programming language PL / SQL: variables and types, conditional logic, loops, functions, procedures and packages, sequences, cursors. Data management in PL / SQL: triggers, data concurrency, locks, conflicts and their causes, detection and troubleshooting, deadlocks.	W01, W02, L01, L02, P01	MEK01 MEK02 MEK03
5	TK03	Creating object types in SQL and PL / SQL: creating object types, obtaining information about object types, using objects in PL / SQL, records, collections, type inheritance, reference cursors, Bulk Collect.	W03, L03, P02	MEK01 MEK02 MEK03
5	TK04	Exception handling in PL / SQL: exception capture, predefined errors in the Oracle server, interception of Oracle predefined errors, effects of propagating exceptions in nested blocks, personalization of PL / SQL exceptions messages.	W04, L04, P3	MEK03
5	TK05	XML and Oracle database: XML characteristics, XML generation from relational data, work in PL / SQL from XML, XML support in the database, XSQL Pages Publishing Framework.	W05, L05, P4	MEK02
5	TK06	Hypertext and PL / SQL Server Pages: server side scripts, module mod_plsql in Oracle, PL / SQL packages Web Toolkit, creating hypertext procedures in PL / SQL generating dynamic HTML code, PL / SQL Server Pages in Oracle, steps for creating PSP scripts , reports and forms in the PSP.	W06, L06, P05	MEK03 MEK04
5	TK07	Working with Oracle SQL in JSP: Java / JSP environment, JDBC drivers: OCI and Thin, connecting with the database, issuing SQL statements and retrieving rows from the database, inserting and modifying data, controlling transactions, data visualization (forms, reports).	W07, L07, P06, P07	MEK02 MEK04

The student's effort

The type of classes	The work before classes	The participation in classes	The work after classes
Lecture (sem. 5)	The preparation for a test: 5.00 hours/sem.	contact hours: 15.00 hours/sem.
Laboratory (sem. 5)		contact hours: 15.00 hours/sem.
Project/Seminar (sem. 5)		contact hours: 15.00 hours/sem..
Advice (sem. 5)		The participation in Advice: 2.00 hours/sem.
Credit (sem. 5)	The preparation for a Credit: 6.00 hours/sem.	The written credit: 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	The lecture ends with a written exam. The condition for admission to the exam is to obtain a positive final grade from the laboratory and a positive evaluation of the implementation of an independent project.
Laboratory	Presence is obligatory in all laboratory classes - medical exemptions are allowed with the need to make up for classes.
Project/Seminar	The aim of the project classes will be an independent (also team-based) implementation of an IT project, the effect of which is to be documented, a database application based on client-server architecture.
The final grade	The final grade is issued as the weighted average of 1/3 of the laboratory grade, 1/3 of the project grade and 1/3 of the lecture 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