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.

1.4.2025 - 31.12.2025

5 cr

Registration period closed

Face-to-face

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.

Contains

Check the institution’s website for the required studies.

No active implementations at present.

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:

Fields

Information and communication technologies

Scope

5 cr

Code

DATA.DB.100

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