Transcript ppt
http://www.inf.uniri.hr Educational levels in teaching databases Patrizia Poščić, [email protected] Danijela Subotić, [email protected] The presentation is about: • Educational levels through several database courses which are being held in the Department of Informatics’ undergraduate (bachelor) and graduate (master) programs • Courses: – Introduction to Databases – Databases – Selected Topics in Databases 2 Introduction to Databases • The course is held on the second year of undergraduate program (3rd semester) • The course consists of theoretical lectures and practical exercises on the computer • 2+2, 5 ECTS • 53 students enroled in 2011/2012 3 Introduction to Databases • In the lectures students can learn: – basic definitions and concepts of databases, – entity-relationship model, relational model and relational algebra, – dependencies in relational database – normalization – other types of databases 4 Introduction to Databases • In the exercises students can learn basics of SQL programming language (in Oracle) • During the semester through practical assignments students learn how to: – create database, create and alter tables in the database, insert-update-delete data, create and work with indexes, constraints, roles and views 5 Introduction to Databases • Also students learn how to run queries against one or multiple tables: – conditions, logical operators, grouping and sorting the results, aggregate, arithmetic and string functions, transactions, – joins, – SQL*Plus. 6 Databases • The course is held on the second year of undergraduate program (4th semester) • The course consists of theoretical lectures and practical exercises on the computer • 2+2, 5 ECTS • 43 students enroled in 2011/2012 • The main objective of the course is to train students to work independently with relational databases 7 Databases • In this course students can use all the knowledge about databases (specifically, modeling and database design) which they acquired last semester • In the lectures students can learn: – more about database security and innovations in the area of databases – also, students work in pairs or small groups (up to 4 students) on a essay with preferred topic 8 Databases • In the exercises students can learn: – how to build standalone database and business application based on the relational and entity-relationship data model in a Clarion programming tool – at the end of the semester, students are required to develop their own application based on a relational database 9 Databases Example of entityrelationship model 10 Databases Example of business application created during practical exercises 11 Selected Topics in Databases • The course is held on the first year of graduate programs Business informatics (mandatory) and Information and communication systems (elective) • The course consists of theoretical lectures and practical exercises on the computer • 2+2, 6 ECTS • 15 students enroled in 2011/2012 • The course is new and still in development 12 Selected Topics in Databases • In the lectures students can: – become familiar with the concept of business intelligence and ERP systems, – learn the basics of dimensional modeling and data warehousing – learn the basic concepts of OLAP systems (Online Analytical processing) and ETL processes – learn the basic concepts of data mining 13 Selected Topics in Databases • In the exercises students can learn how to: – upgrade and expand previously acquired knowledge of SQL programming language, with complex SQL*Plus report generating and PL/SQL procedural extension language – work with several OLAP tools (Microstrategy and Palo for now) in order to generate reports for business decisionmaking 14 Selected Topics in Databases • In the future: – we plan to acquire Oracle Warehouse builder • students can also learn how to build their own data warehouse (from existing relational database) • Students can generate business reports in selected OLAP tool which is connected with their own data warehouse 15 Selected Topics in Databases Dimensional model – star schema 16 Some numbers … 2011/2012 IDB DB STDB Number of students 53 43 15 Successfully passed 61,5% 89,5% 65% 3,1 4,3 3,6 Average grade 17 Conclusion • Our goal is to present students with a compact set of knowledge in the field of databases • Upgrade and development of knowledge through the educational process • This knowledge gives them great flexibility and makes them more competitive on the market 18 Thank You for your attention!