SQL-basics course assigments for Tampere University SQL course.
"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.
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"