Course code 07 67 5020 17
ECTS credits 6
Course title in the language of instruction
Database Programming
Course title in Polish Database Programming
Course title in English
Database Programming
Language of instruction English
Course level first-cycle programme
Course coordinator dr inż. Agnieszka Wosiak
Course instructors
Delivery methods and course duration
Lecture Tutorials Laboratory Project Seminar Other Total of teaching hours during semester
Contact hours 30 30 0 60
E-learning No No No No No No
Assessment criteria (weightage) 0.00 0.00 0.00
Course objective
  1. Acquiring the knowledge concerning database programming extensions to SQL.
  2. Gaining the ability to design a database structure and write programming units for data managing and processing.
Learning outcomes
  1. A student who completed the course can characterize database programming languages.
  2. A student who completed the course can describe the structure of database subprograms.
  3. A student who completed the course can apply appropriate database programming units to implement business logic on a database server.
  4. A student who completed the course can perform code analysis of database subprograms in the context of a particular business problem.
Assessment methods
Written exam (learning outcomes 1. and 2.)
Discussion (learning outcomes 1., 2., 3., and 4.)
Laboratory tasks (learning outcomes 3. and 4.)
Written report (learning outcomes 3. and 4)

 
Prerequisites
Fundamentals of databases
Course content with delivery methods
LECTURE
1. Physical and logical Oracle Database architecture. PL/SQL development environments.
2. Introduction to PL/SQL. Declaring PL/SQL variables.
3. Writing executable statements and control structures.
4. Using explicit cursors.
5. Handling exceptions.
6. Using dynamic SQL.
7. Creating stored procedures and functions.
8. Creating triggers.
9. Creating packages.
10. Design considerations for PL/SQL code.

LABORATORY 
Students, working in groups, design the structure and implement a database solution for a specified business scenario or organization.
Basic reference materials
  1. Steven Feuerstein: Oracle PL/SQL Programming, 6th Edition, O'Reilly, 2014.
  2. Benjamin Rosenzweig, Elena Rakhimov: Oracle PL/SQL by Example, 5th Edition, Prentice Hall, 2015.
  3. Michael McLaughlin: Oracle Database 11g PL/SQL Programming Workbook, McGraw-Hill Education, 2010.
  4. Michael McLaughlin, John Harper: Oracle Database 12c PL/SQL Advanced Programming Techniques, McGraw-Hill Education, 2014.
Other reference materials
  1. Steven Feuerstein: Oracle PL/SQL Best Practices: Write the Best PL/SQL Code of Your Life, 2nd Edition, O'Reilly, 2007.
  2. Michael Rosenblum, Paul Dorsey: Oracle PL/SQL Performance Tuning Tips & Techniques, McGraw-Hill Education, 2014.
  3. Arup Nanda, Brendan Tierney, Heli Helskyaho, Alex Nuijten, Martin Widlake: Real World SQL and PL/SQL: Advice from the Experts, McGraw-Hill Education, 2016.
Average student workload outside classroom
91
Comments
Last update 2017-05-30 09:13:54