This course mainly includes the database architecture comparison to file-based systems, historical data models, conceptual models, integrity constraints and triggers. Functional dependencies and normal forms, relational models, database processing , “Structured Query Language” (SQL), database access from “Applications-Embedded SQL”, “JDBC”, “Cursors”, “Dynamic SQL” and “Stored Procedures” are the main subconsepts. Emerging trends are also in the stream of the course over which “NoSQL databases”, “Internet Databases” and On-Line Analytical Processing (OLAP) are issued. A team project that builds a database application for a real-world scenario is an important scope part of the course.
SQL language, SQL development tools, PowerPivot