Course code 07 67 5020 17
Number of ECTS points 6
Course title in the language of instruction 
Database Programming
Course title in Polish Database Programming (Programowanie baz danych)
Course title in English 
Database Programming
Language of instruction English
Type of classes
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.45 0.55 0.00
Unit running the course Instytut Informatyki
Course coordinator dr inż. Agnieszka Wosiak
Course instructors dr hab. inż. Przemysław Ignaciuk, dr hab. inż. Agnieszka Wosiak
Prerequisites 
Fundamentals of databases
Course 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.
Programme learning outcomes
    Programme content
    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)
    Grading policies
    Course content 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 
    		
            
    
            
    
                Updated on 
                2021-05-11 11:26:52
            
    
            
    
                Archival course yes/no
                no