Database Programming
| Rakennetyyppi: | Opintojakso |
|---|---|
| Koodi: | IT00BT01 |
| OPS: | IT 2025 |
| Taso: | Insinööri (AMK) |
| Laajuus: | 5 op |
| Vastuuopettaja: | Dams, Johan |
| Opetuskieli: | Englanti |
Osaamistavoitteet
After completing the course, you will be able to design and implement a database scheme and use a database both through the management system (DBMS) as well as through a programming language. You will learn key concepts and syntax of SQL, NoSQL and XML databases, know what normalization and data integrity is, what constraints are and how to use them. With SQL, you will be able to use main SQL commands (SELECT, INSERT, UPDATE, DELETE), joins and sub-queries, aggregations and groupings, and create views. Through a programming language and API (e.g., JDBC or other) you will learn how to effectively use a database from within an application and how to perform optimization and query performance tuning as well as security considerations to take into account. You will also know what ORM is, which tools are available, and how they are used.
Sisältö
Database schema’s, SQL, NoSQL, XML, DBMS, database manipulation from within applications.