Report on the DB1 course
February 24th, 2007 by xavier
That post’s aim is to show the matter we saw during the three-week intensive course of database 1.
That way, the next teacher coming from Madrid or whatsoever may know from where will he have to start.
Technorati Tags: burundi, ngozi, database, tedeco
I taught to the second year of the computer science degree (a four-year degree). It was all the morning during 3 weeks.
The first week we saw the overall topic of databases. When do we need them? What do they provide?
We also saw the ANSI multi layers architectures with plenty of examples to illustrate their inter-independence.
And we briefly talked about the 2 first data architectures (in arborescence and in network).
The second week we saw the relational model. We explained the concept of the tables and we dug into the relational algebra.
By the end of the week we’ve started to translate the algebra to the SQL language.
We eventually finished the SQL language (we saw the INSERT, UPDATE, DELETE queries, plus the SELECT with conditions, jointures, grouping, aggregation functions such as MIN(), MAX(), SUM(), AVG(), ordering, limits and subqueries).
We have just omitted the DATE relative SQL functions.
We also talked about the integrity management (why it’s important? Why it’s far better to apply integrity checks directly in the DBMS and not in the application’s side). We saw the Cascade strategy and the SET NULL one.
Last week, we have practised on SQL queries and we talked about the normal forms.
As you might see, we didn’t had time to talk about the inner advanced features of the DBMS such as indexes and clusters.
As a remainder, here is the correction of the exam the student passed the Thursday of the third week.
.