Opetussuunnitelmat
DIN23SP
Not applicable
0-5
English
Studies in English, Information Technology, Programming, Databases, Web development
Not applicable
R&D Studies: 0.00 cr
Virtual Studies: 0.00 cr
Contact Teaching: 5 cr
Pekka Alaluukas
Avoin AMK, Tutkinto-opiskelijat
Evaluation Criteria
0-5
Assessment Methods and Criteria
Not applicable
Planned Learning Activities and Teaching Methods
Lectures will be on Zoom and they will be recorded. The exercises are held on campus. There is no obligation to attend the exercises. The exercises can also be done at home.
Weekly exams and the final exam will be in Moodle.
Location and time
Not applicable
Learning environments
Not applicable
Recommended or Required Reading
Not applicable
Further Information
Not applicable
Completion Alternatives
Not applicable
Teacher(s)
Pekka Alaluukas
Work Placement and Working Life Connections
Not applicable
Exam Schedule
Not applicable
International Connections
Not applicable
Student's Time Use and Workload
Not applicable
Learning Progress
Not applicable
Evaluation criteria accepted
1-2: I know the basic concepts of relational databases. I know the design principles of relational databases and I am able to design databases that meet the requirements of relational databases in accordance with them. I know the basics of the SQL language and can write SQL queries. I understand how an interface application that utilizes a database works and I can analyze how an existing interface application works.
3-4: I can plan and implement well-functioning relational databases. I can manage relational databases using the SQL language. I can create backups of databases and transfer a database from one environment to another, such as a local database to a cloud service. I can write complex SQL programs. I can write interface applications that utilize relational data using sources.
5: I can plan and implement well-functioning relational databases. I can justify the choices I made in the implementation of the database. I cope with all tasks related to database management using the SQL language. I can write complex SQL programs and manage the use of procedures.
I can write interface applications that use relational data without using sources.
Evaluation criteria failed
Not applicable