|
|
|
||
Last update: T_KSI (13.05.2003)
|
|
||
Last update: T_KSI (06.05.2005)
Oracle Reference Guide (Concepts, SQL Reference, PL/SQL User's Guide and Reference, Reference) Informix Reference Giude (SQL Reference Guide) Sybase Reference Guide (Administration Developer's Guide) SQL Server Reference Guide (MS SQL Server Reference Guide) |
|
||
Last update: T_KSI (13.05.2003)
1. Client server communication
2. DB tasks analysis, conceptual scheme
3. Database development process (ER-model)
4. Physical model development and optumalisation (table, type, attribute)
5. SQL commands, error recovery systems
6. Access rights
7. Typical DB constructs - opimalisation, typs and trics
8. Data locks, separation levels
9. Procedures, functions, packages, autonomious transactions
10. Triggers - how to use them
11. DB application use case, three tear connection
12. DB application development team leadership
13. Paralel and distributed DB systems |