| Detailed description of the subject |
| 1. week |
Clarifying the basics: RDBMS, SQL; sample database |
| 2. week |
The SQL language and most common commands |
| 3. week |
Major DDL (Data definition language) commands |
| 4. week |
DML (Data manipulation language) commands |
| 5. week |
The PostgresSQL operation and number functions |
| 6. week |
The PostgresSQL functions (character and other functions) |
| 7. week |
DML commands 1 Simple and complex queries |
| 8. week |
DML commands 2 Derived data 1 |
| 9. week |
DML commands 3 Derived data 2 |
| 10. week |
DML commands 4 Joining tables, embedded queries |
| 11. week |
Problem solving (joint) 1. |
| 12. week |
Problem solving (joint) 2. |
| 13. week |
Test |
| 14. week |
Discussion, correction |
| 15. week |
Reserved lesson |
| Recommended reading: |
- Halassy Béla: Az adatbázis-tervezés alapjai és titkai, Idg 2000
- Stolnicki Gyula: Sql kézikönyv, Computerbooks 1998
- Kishore Bhamidipati: Sql programozói referenciakönyv, Panem 1999
- George Koch Kevin Loney: Oracle 8, Panem 2000
|