Tampere University of Technology - Department of Information Technology - Institute of Software Systems




OHJ-3306


Introduction to Databases - 3 op





Periodi 5




22.02.2009 Web pages updated for spring 2009 course implementation.






2006-2007
Lectures




Study Guide
Email



MainPage
Requirements
Lectures
Exercises
Exams
Personnel
Material
Links
Results



Printable page


Site map








This lecture schedule is preliminary and suggestive. Schedule will be updated along the course when (if) necessary.
 
Week Lecture Date Lecture Topics
13
Day 24.03. Introducing course personnel
Course structure, performance, schedule,
Practical arrangements (signing in to exercises etc.).
Introducing IDLE, the learning environment used in the exercises.

1. Introduction
The problem to be solved and the solution to the problem.
An overview of the subject, basic concepts, a database, database management system, ...
A look at database management system actions and essential mechanism.
The concept of transaction.

2. Relational databases and their usage.
Relational model, theoretic background of relational databases, integrity of relational databases, the concept of view.
13
Day 26.03. Relational algebra
Relational calculus (Tuple Relational Calculus, TRC) (Domain Relational Calculus, DRC)
14
Day 31.03. Exercises start this week!

3. SQL queries:
SQL query basics, Data retrieval by using SQL
General idea of practical database languages.

14
Day 02.04. More SQL
15
Day 07.04. 4. Briefly about designing a database
Briefly about design methods and process
Functional dependencies and normal forms

15-16
9.4.-15.4. Easter Holiday
16
Day 16.04. 5. SQL: Creating a database and populating by using SQL.
Creating a database and defining integrity demands by using SQL.
The concept of transaction in SQL.
Populating a database by using SQL.
17
Day 21.4. Briefly about the performance of SQL.
Indexes and how to define them by using SQL.
Database security: Views and authorization in SQL.

17
Day 23.4.
6. Briefly about using SQL in programming and programs.
Database architectures, interfaces, application generators,
saved procedures, triggers, ...

18
Day 28.04.
7. Briefly about different kinds of databases, DBMSs data models, ...
OLTP, data warehousing, spatial databases, deductive databases, ...
Network model, hierarchical model, relational model, object models, object relational models, ...
Distributed and centralized databases
19
Day 05.05.
Continued.
Maybe something extra.
Review, summary, something else...

20
15.05. Examination at 9.00-12.00









Päivitetty viimeksi 22.03.2009 20:28 - introdb(at)cs.tut.fi