IF DBS 01 Work with relational databases for beginners
IF DBS 02 Design your relational database for beginners
IF DBS 03 Database design using MySQL
IF DBS 04 Business Intelligence and Data Warehousing: Development & UI/UX Design
IF DBS 01
Work with relational databases for beginners
Workshop
Matej Bel University, Banská Bystrica, Slovakia
Mo 14.8. 11.00-12.30 und 14.00-16.30 Uhr
Di 15.8. 09.00-12.30 und 14.00-16.30 Uhr
Mi 16.8. 09.00-10.30 Uhr
Target group: open
Prerequisites: none
Sprache/Language: Die Unterrichtssprache wird Englisch sein. / The teaching language will be English.
Requirements: email exchange before, presentation and exercises during, for credit point assignments after the summer university
Participants: 12
Credit Points (ECTS): with assignment 1
Modul acceptance in Uni Bremen: (General Studies VAK) META-2017/IF.2017.DBS.01
(Digital Media VAK) 03-B-UN-2/IF.2017.DBS.01 (Freie Wahl); auf Antrag wählbar für Master
(Informatik VAK) (keine Anerkennung)
(Produktionstechnik) anerkannt im Modul General Studies
(Wirtschaftsinformatik) (keine Anerkennung)
This course will give the participants an introduction to work with relational databases from a user’s point of view.
We will work on basic examples and exercises with a few samples of databases. We will use SQL and work with databases in a free Oracle environment. Besides this we will compare it to working in Access. By the end of this course the participants will understand the basic work with relational databases better and will be able to use databases in a more effective way.
Jana Jacková works at the Department of Computer Science, Faculty of Natural Sciences at the Matej Bel University in Banská Bystrica, Slovakia. Her educational activities and research focus are on teaching programming, database and information systems, didactics of informatics/computer science, teacher training in informatics, ICT in education and participation in computing education research.
IF DBS 02
Design your relational database for beginners
Workshop
Matej Bel University, Banská Bystrica, Slovakia
Do 17.8. 09.00-12.30 und 14.00-16.30 Uhr
Fr 18.8. 09.00-12.30 und 14.00-16.30 Uhr
Target Group: open
Prerequisites: none
Sprache/Language: Die Unterrichtssprache wird Englisch sein. / The teaching language will be English.
Requirements: email exchange before, preparation of a presentation before the summer university, presentation and exercises during the summer university
Participants: 12
Credit Points (ECTS): with assignment 1
Modul acceptance in Uni Bremen: (General Studies VAK) META-2017/IF.2017.DBS.02
(Digital Media VAK) 03-B-UN-2/IF.2017.DBS.02 (Freie Wahl); auf Antrag wählbar für Master
(Informatik VAK) (keine Anerkennung)
(Produktionstechnik) anerkannt im Modul General Studies
(Wirtschaftsinformatik) (keine Anerkennung)
Basic concepts of a relational database design will be taught (Entity-Relationship(ER)-Model, Normal forms) alongside with examples of databases. Participants will learn to design their own databases that are suitable for data according to their own interests. They will design an ER-Model for their own database in the 3rd normal form. According to this model they will create their own database in Access and/or Oracle environment (free version).
Jana Jacková works at the Department of Computer Science, Faculty of Natural Sciences at the Matej Bel University in Banská Bystrica, Slovakia. Her educational activities and research focus are on teaching programming, database and information systems, didactics of informatics/computer science, teacher training in informatics, ICT in education and participation in computing education research.
IF DBS 03
Database design using MySQL
Workshop
Arab Academy for Science and Technology, Alexandria, Egypt
Mo 7.8. 11.00-12.30 und 14.00-16.30 Uhr
Di 8.8. 09.00-12.30 und 14.00-16.30 Uhr
Mi 9.8. 09.00-10.30 Uhr
Target group: open
Prerequisites: Interested in software engineering and previous experience with coding in general.
Sprache/Language: Die Unterrichtssprache wird Englisch sein. / The teaching language will be English.
Requirements: email exchange before, presentation and exercises during, for credit point assignments after the summer university
Participants: 12
Credit Points (ECTS): with assignment 1
Modul acceptance in Uni Bremen: (General Studies VAK) META-2017/IF.2017.DBS.03
(Digital Media VAK) 03-B-UN-2/IF.2017.DBS.03 (Freie Wahl); auf Antrag wählbar für Master
(Informatik VAK) (keine Anerkennung)
(Produktionstechnik) anerkannt im Modul General Studies
(Wirtschaftsinformatik) (keine Anerkennung)
Database design is one of the most important aspects of web programming. Successful implementation of any system with Data Storage will always need proper database design. MySQL is considered the most popular Open Source Relational SQL database management system. Besides this MySQL is one of the best relational data base management systems (RDBMS) being used for developing web-based software applications.
Through a hands-on approach, this course will help participants implement databases using MySQL, starting with basic introduction to Entity-Relationship (ER)-Models, creating tables and querying data from MySQL database to data manipulation. Real-life examples will be presented.
Injy Sarhan is a Teacher Assistant at the Arab Academy for Science and Technology, Alexandria, Egypt. She obtained her Master's degree in Natural Language Processing in November 2016. Her course work has covered a wide range of topics including Database, Operating Systems and Networks. Her technical expertise includes programming languages such as C, Bash Scripting, Python and SQL.
IF DBS 04
Business Intelligence and Data Warehousing: Development & UI/UX Design
Course
Istanbul, Turkey
Istanbul, Turkey
Do 24.8. 09.00-12.30 und 14.00-16.30 Uhr
Fr 25.8. 09.00-12.30 und 14.00-16.30 Uhr
Target group: students and practitioners from computer science or related fields, interested in business intelligence and data warehouse topics
Prerequisites: knowledge about database area and UI design is nice to have (e.g. E-R diagrams, SWL) but inot compulsory.
Sprache/Language: Die Unterrichtssprache wird Englisch sein. / The teaching language will be English.
Requirements: email exchange before, exercises during, and for credit point assignments after the summer university
Participants: 12
Credit Points (ECTS): with assignment 1
Modul acceptance in Uni Bremen: (General Studies VAK) META-2017/IF.2017.DBS.04
(Digital Media VAK) 03-B-UN-1/IF.2017.DBS.04 (General Studies); auf Antrag wählbar für Master
(Informatik VAK) 03-BU-1/IF.2017.DBS.04 (General Studies); auf Antrag wählbar für Master
(Produktionstechnik) anerkannt im Modul General Studies
(Wirtschaftsinformatik) (keine Anerkennung)
This workshop will give answers to those questions: What is data warehouse (DWH) and business intelligence (BI)? How can you transform the huge data to information? How to use DWH/BI tools for developer side and end user side? What is UX Design? Why User Experience is important and does it really necessary during BI development? How can you increase your abilities of applications' usability?
Our workshop will have both academic and practical material. Participants will learn and practise QlikSense, a very high-end and popular BI tool, with both a developer and end-user part using coding algorithms and UI/UX design methods. During the workshop participants will practice a demo for a sales department in a worldwide clothing brand.
Gokcen Burcu Erturk is currently working as an application specialist focusing on data warehousing, business intelligence, data mining, big data and analytics at a private corporate company, KocSystem, in Turkey. She is also enthusiastic about Google technologies and a member of Google Developers Group in Ankara.
Eylem Yılmaz is a senior quality assurance specialist with extensive test and user focused skills. She currently works for Asseco SEE which provides and sells ICT solutions over their own e-commerce Secure Payment Platform. She has a B.Sc. in Computer Science from Kocaeli University and a M.Sc. in Industrial Product Design from Istanbul Technical University.
|