Cooperative studies for upper secondary education

Pori

Tampere

Database Basics

If you want to cancel your participation before the start of your studies or if you have to interrupt your studies, please contact the Student Affairs Office.

<a href="https://www.tuni.fi/en/about-us/tampere-university-student-affairs-office">Tampere University Student Affairs Office</a>

Basic studies

Faculty of Information Technology and Communication Sciences

Data Processing and Information Technology

Discuss your study plans with your school&#180;s study counsellor and find out in advance the suitability of the studies and the possibility of accreditation in your degree. Before sign up, make sure that your study counsellor gives you approval for applying for studies.Sign up for studies usually ends at least 2 weeks before the start of the studies.<a href="https://tuni.fi/tau-cooperative-studies-for-upper-secondary-education-enrolment">See more detailed registration instructions</a>.

English

Hervanta Campus

City Centre Campus

University-level studies are free of charge for students of partner upper secondary schools that have signed a cooperation agreement. The student's own school pays for the studies to the Tampere University according to the agreement. The terms of payment are described in more detail in the cooperation agreement.<a href="https://tuni.fi/tau-cooperative-studies-for-upper-secondary-education-payment-terms">Read more about the fees</a>.

Sign up

Course topics include establishing a database, updating data and posing queries in SQL language, database modelling and design. In addition, history and development trends of databases and principles of database management systems are covered briefly.

<h2>Voluntary</h2><h3>Group 1: Hervanta</h3>27.08.2025 14:00 - 16:00, TAU P&#228;&#228;rakennus PA103 opetustila (40) 03.09.2025 14:00 - 16:00, TAU P&#228;&#228;rakennus PA103 opetustila (40) 10.09.2025 14:00 - 16:00, TAU P&#228;&#228;rakennus PA103 opetustila (40) 17.09.2025 14:00 - 16:00, TAU P&#228;&#228;rakennus PA103 opetustila (40) 24.09.2025 14:00 - 16:00, TAU P&#228;&#228;rakennus PA103 opetustila (40) 01.10.2025 14:00 - 16:00, TAU P&#228;&#228;rakennus PA103 opetustila (40) 08.10.2025 14:00 - 16:00, TAU P&#228;&#228;rakennus PA103 opetustila (40) <h3>Group 2: Verkossa - Online</h3>27.08.2025 16:00 - 18:00 03.09.2025 16:00 - 18:00 10.09.2025 16:00 - 18:00 17.09.2025 16:00 - 18:00 24.09.2025 16:00 - 18:00 01.10.2025 16:00 - 18:00 08.10.2025 16:00 - 18:00 <h3>Group 3: Hervanta</h3>28.08.2025 14:00 - 16:00, TAU Rakennustalo RO105 opetustila (40) 04.09.2025 14:00 - 16:00, TAU Rakennustalo RO105 opetustila (40) 11.09.2025 14:00 - 16:00, TAU Rakennustalo RO105 opetustila (40) 18.09.2025 14:00 - 16:00, TAU Rakennustalo RO105 opetustila (40) 25.09.2025 14:00 - 16:00, TAU Rakennustalo RO105 opetustila (40) 02.10.2025 14:00 - 16:00, TAU Rakennustalo RO105 opetustila (40) 09.10.2025 14:00 - 16:00, TAU Rakennustalo RO105 opetustila (40) <h3>Group 4: Verkko-opetus - Online teaching</h3>29.08.2025 08:00 - 10:00 05.09.2025 08:00 - 10:00 12.09.2025 08:00 - 10:00 19.09.2025 08:00 - 10:00 26.09.2025 08:00 - 10:00 03.10.2025 08:00 - 10:00 10.10.2025 08:00 - 10:00 <h3>Lecture Group 1: Kyselytunti</h3>26.08.2025 14:00 - 16:00 02.09.2025 14:00 - 16:00 09.09.2025 14:00 - 16:00 16.09.2025 14:00 - 16:00 23.09.2025 14:00 - 16:00 30.09.2025 14:00 - 16:00 07.10.2025 14:00 - 16:00 <h3>Lecture Group 2: Q&amp;A Session</h3>27.08.2025 10:00 - 12:00 03.09.2025 10:00 - 12:00 10.09.2025 10:00 - 12:00 17.09.2025 10:00 - 12:00 24.09.2025 10:00 - 12:00 01.10.2025 10:00 - 12:00 08.10.2025 10:00 - 12:00 <h3>Other Event: </h3>04.10.2025 13:00 - 16:00, TAU Pori 336 harjoitussali (70)

After completing the course a student <ul><li>knows the basic concepts and structures of SQL databases (relational databases)</li><li>is able to establish a database and update and retrieve the data in a database using SQL language</li><li>knows the basic concepts and principles of &nbsp;ER modeling</li><li>is able to model data using ER diagrams</li><li>is able to &nbsp;convert ER diagrams into SQL database schemas </li><li>knows history and development trends of databases</li><li>knows principles of database management systems in a general level </li></ul>

Finnish

Available in the learning environments

The course is completed by submitting exercises and course work to the learning environment of the course, as well as taking the exam in an Exam classroom.The lecture part includes educational videos and remotely organized Q&amp;amp;A sessions. Participation in Q&amp;amp;A sessions is optional.In exercise groups, you get support to do exercises. Participation in them is optional. Exercise groups are organized both remotely and on campuses.The study material, Q&amp;amp;A sessions, and exercise groups are available in Finnish and English. The databases used in the exercises are in English.

Database Basics

Target group

Extent

Course dates

Application period

Fees

Campus

City

Faculty

Language of instruction

Code

Study fields

Study level

Database Basics, 5 cr

Contact information

How to register

Payment terms

Cancellation terms

Your last viewed study options

Database Basics

Give feedback on our website!