Tuesday
8:30 - 10:00 S.1-110
classroom lecture and
practice |
Thursday
10:15 - 11:45 S.2-520
computer lab lecture and
practice |
| 02.19 |
2.2.
Intro, 2.4. Relational
Algebra |
02.21 |
L1:
Select list, L2: Where condition |
| 02.26 |
Exerc/Rel.Alg, HW, 6.1-6.2.Select |
02.28 |
L5:
From list, L7: Set
operations |
| 03.05 |
6.1-6.2.
Select, 6.3. Subqueries
|
02.07 |
L3: Functions
(Char, Date, Conv.) |
| 03.12 |
5.1-5.2.
Ext.Rel.Alg, 6.4.
Grouping |
03.14 |
L4: Aggregation,
group by, having
|
| 03.19 |
Exerc/SQL, HW, 6.5. Modifications |
03.21 |
L6:
Subqueries, L: Correlated
subq.
|
| 03.26 |
Exerc/DML, 7.1-7.4.Const, 7.5.Trig. |
03.28 |
Spring Holiday, no classes, weeks
|
| 04.02 |
Spring Holiday, no classes,
see weeks
|
04.04 |
MIDTERM
TEST
(practice) |
| 04.09 |
9.3-9.4. SQL/PSM,
Oracle: PL/SQL |
04.11 |
L8: DML, L9: DDL,
L10: Views |
| 04.16 |
5.3-5.4.
Logical
Query Lang: Datalog |
04.18 |
plsql, DocCh4:
control statments |
| 04.23 |
Exercises/Datalog, 10.2
Recursion |
04.25 |
plsql, DocCh6:
ref.types, cursors |
| 04.30 |
3.1-3.2. FD's,
3.3-3.5.
Rel.Design |
05.02 |
plsql, DocCh8: subprg., Recursion |
| 05.07 |
3.3-3.5.
Rel.Design, 3.6. MVD's |
05.09 |
Neumann
Day in ELTE, see weeks
|
| 05.14 |
4.1-4.6. E/R
Model, 4.7-4.8. UML |
05.16 |
FINAL
TEST (practice) |
| Examination season: May 21 - July 5, 2013 |
05.23 |
RE-WRITING
TEST
(practice) |
| Tue... |
FINAL
EXAM (lecture)
|
Thu... |
|
main 