Database Developer - SOF013AS3AE - Opinto-opas

Database Developer, 5 cr - SOF013AS3AE

Upcoming implementations

Database Developer SOF013AS3AE-3002 13.01.2025-16.05.2025 5 op (ITE5PASOF1, ...) +-
Teaching methods and instruction

Contact classes and weekly coursework.

Teams group for questions and instruction. Weekly email consultation on exercises.

*** IMPORTANT ***
The prerequisite is that you have passed the course Data Management and Databases (SOF001AS2AE-3001) or another equivalent 5 cr course, or you can demonstrate equivalent skills and knowledge prior commencing the course.

Learning material and recommended literature

The course material is available in Moodle.

Campus

Pasila Campus

Exam dates and re-exam possibilities

Mid-term exam and final exam.
The exam dates are available in Moodle.
There are two re-exams in autumn 2025.

Teaching language

English

Internationality

The course is in English. Usually, there are participants from different nationalities.

Timing

13.01.2025 - 16.05.2025

Learning assignments

There are weekly lab exercises and written assignments, and and an individual case assignment. These are available in Moodle. Note: The mandatory lab tasks require you to use the SQL Server Developer edition. The software does not run on Mac OS.

Enrollment

02.01.2025 - 10.01.2025

Content scheduling

Weekly contact classes.

*** IMPORTANT ***
You will be required to confirm your course participation by completing a given set of exercises before the second course week's class
Groups
- ITE5PASOF1
- CONTACT
- ITB5PASOF1
- IT5PASOF1
Teachers

Kari Silpiö

Seats

15 - 40

Further information

Mid-term exam and Final exam.
The coursework might raise/lower the course grade by one.

*** IMPORTANT ***

* The required minimum amount of coursework should be completed before the final exam.

* Haaga-Helia's policy: When the implementation type of the course is contact, online or blended it is required that the student is present during those teaching hours that are marked in the study schedule. If you are absent more than 25%, your grade will be lowered by one. If you are absent more than 50%, the course is failed.

Degree Programme

TRATI Tradenomi tietojenkäsittely

R&D proportion

0.00 cr

Virtual proportion

0.00 cr

Evaluation scale

H-5

Current implementations

No ongoing implementations yet.

Past implementations

Database Developer SOF013AS3AE-3003 19.08.2024-13.12.2024 5 op (ITE5PASOF1, ...) +-
Teaching methods and instruction

Contact classes and weekly coursework.

Teams group for questions and instruction. Weekly email consultation on exercises.

*** IMPORTANT ***
The prerequisite is that you have passed the course Data Management and Databases (SOF001AS2AE-3001) or another equivalent 5 cr course, or you can demonstrate equivalent skills and knowledge prior commencing the course.

Learning material and recommended literature

The course material is available in Moodle.

Campus

Pasila Campus

Exam dates and re-exam possibilities

Mid-term exam and final exam.
The exam dates are available in Moodle.
There are two re-exams in spring 2025.

Teaching language

English

Internationality

The course is in English. Usually, there are participants from different nationalities.

Timing

19.08.2024 - 13.12.2024

Learning assignments

There are weekly lab exercises and written assignments, and and an individual case assignment. These are available in Moodle.

Enrollment

03.06.2024 - 16.08.2024

Content scheduling

Weekly contact classes.

*** IMPORTANT ***
You will be required to confirm your course participation by completing a given set of exercises before the second course week's class
Groups
- ITE5PASOF1
- CONTACT
- ITB5PASOF1
- IT5PASOF1
Teachers

Kari Silpiö

Seats

15 - 40

Further information

Mid-term exam and Final exam.
The coursework might raise/lower the course grade by one.

*** IMPORTANT ***

* The required minimum amount of coursework should be completed before the final exam.

* Haaga-Helia's policy: When the implementation type of the course is contact, online or blended it is required that the student is present during those teaching hours that are marked in the study schedule. If you are absent more than 25%, your grade will be lowered by one. If you are absent more than 50%, the course is failed.

Degree Programme

TRATI Tradenomi tietojenkäsittely

R&D proportion

0.00 cr

Virtual proportion

0.00 cr

Evaluation scale

H-5
Database Developer SOF013AS3AE-3001 15.01.2024-17.05.2024 5 op (CONTACT, ...) +-
Teaching methods and instruction

Contact classes and weekly coursework.

Teams group for questions and instruction. Weekly email consultation on exercises.

*** IMPORTANT ***
The prerequisite is that you have passed the course Data Management and Databases (SOF001AS2AE-3001) or another equivalent 5 cr course, or you can demonstrate equivalent skills and knowledge prior commencing the course.

Learning material and recommended literature

The course material is available in Moodle.

Campus

Pasila Campus

Exam dates and re-exam possibilities

Mid-term exam and final exam.
The exam dates are available in Moodle.
There are two re-exams in next semester.

Teaching language

English

Internationality

The course is in English. Usually, there are participants from different nationalities.

Timing

15.01.2024 - 17.05.2024

Learning assignments

There are weekly lab exercises and written assignments, and and an individual case assignment. These are available in Moodle.

Enrollment

02.01.2024 - 12.01.2024

Content scheduling

Weekly contact classes.

*** IMPORTANT ***
You will be required to confirm your course participation by completing a given set of exercises before the second course week's class
Groups
- CONTACT
- ITB5PASOF1
- IT5PASOF1
- EXCH
Alternative learning methods

If your starting-level is strong enough, then you can complete some parts of the the course independently. That is, if you can keep up with the course / coursework on your own, then you are not required to join the contact classes. The exams at the campus is mandatory.

Teachers

Kari Silpiö

Seats

15 - 40

Further information

Mid-term exam and Final exam.
The coursework might raise/lower the course grade by one.

Degree Programme

TRATI Tradenomi tietojenkäsittely

R&D proportion

0.00 cr

Virtual proportion

0.00 cr

Evaluation scale

H-5

Upon successful completion of this course, the student should be able to
* explain the basic concepts and terminology related to physical database design and implementation
* use the basic database administration tools to create and manage a database in the target environment
* apply declarative and procedural integrity enforcement in the database implementation
* explain basic database performance problems and ways to improve database performance
* explain the basic concurrency mechanisms and concurrency conflicts
* use SQL transactions efficiently to ensure database performance and consistency
* explain transaction logging and database recovery
* perform database backup and restore operations.

The course focuses on physical database design and implementation in the relational database environment. The main themes on the course are database integrity, database performance, database security, and database recoverability. The course includes hands-on work on the following:
* data integrity enforcement
* database performance, database indexes
* concurrency control and transaction management in the multi-user environment
* transaction logging and database recovery, backup and restore
* database security.

a. Contact lessons, course assignments, independent studies, and written examinations OR
b. Self-study, course assignments, and written examinations.

If you already have achieved the required learning objectives of this course, then you can show your competence with a portfolio and a demonstration exam. Please contact the teacher of the course if you need any advice on this matter. Recognition of prior learning should be applied for prior commencing the course.
See also: Further information regarding the recognition of prior learning

Course pages

Connolly, T. & Begg, C. Database Systems. A Practical Approach to Design, Implementation, and Management. 3rd edition or later. Addison-Wesley.

For additional reading:
Dewson, R. Beginning SQL Server for Developers: From Novice to Professional. New York: Springer-Verlag New York Inc.

This course focuses on the physical level of the database architecture. You will get hands-on skills in database administration needed in the database developer role. The weekly hands-on exercises in the SQL Server environment will give you practical experience and help you to learn the course content in motivating way.

This course is a part of the Software Development study profile.

The course prerequisite is that you have passed the course Data Management and Databases (SOF001AS2AE) or an equivalent course.

The student
* shows passable activity in class and individual studying
* has passable understanding of the concepts and terminology discussed in the course
* has passable understanding of the basic ways to improve database performance
* has passable understanding of the main problems in concurrent database access
* often needs some assistance in solving basic problems
* has some difficulties in using the course materials to support own learning.

The student
* shows good activity in class and individual studying
* has good understanding of the concepts and terminology discussed in the course
* has good understanding of the basic ways to improve database performance
* has good understanding of the main problems in concurrent database access
* sometimes needs assistance in solving basic problems
* can use the course materials in an effective way to support own learning
* can find some more information from other sources.

The student
* shows excellent activity in class and individual studying
* has excellent understanding of the concepts and terminology discussed in the course
* has excellent understanding of the basic ways to improve database performance
* has excellent understanding of the main problems in concurrent database access
* can solve problems independently
* can fluently use the course materials and other sources to support own learning
* can independently find more information from other sources
* can independently learn more details of course topics.