Database Basics

Learn to establish databases and make queries in SQL language, and model data with ER diagrams. Gain essential skills in SQL and database design.

31.3.2025 - 31.12.2025

5 cr

Registration period closed

Face-to-faceOnline

Basic studies

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.

Additional information

Verkko-opetus

How will you study

Additional information and registration

Price and registration period

Check on the university's website

Go to the institution's website(Opens in a new tab)

Additional information:

Dates

31.3.2025 - 31.12.2025

Fields

Information and communication technologies

Scope

5 cr

7 components

Code

DATA.DB.100

What you will learn

After completing the course a student

knows the basic concepts and structures of SQL databases (relational databases)
is able to establish a database and update and retrieve the data in a database using SQL language
knows the basic concepts and principles of ER modeling
is able to model data using ER diagrams
is able to convert ER diagrams into SQL database schemas
knows history and development trends of databases
knows principles of database management systems in a general level

Organiser

Tampereen yliopisto

Contact details

avoin.tau@tuni.fi

Belongs to themes:

Change management and analytics