Syllabus
SQL language for Oracle and MS SQL databases vs. ANSI SQL
- Tables and views
- Procedural extensions
- PL/SQL language in Oracle - triggers, procedures, functions and packages
- Transact-SQL in MS SQL - triggers, procedures and functions
- Object-relational extensions - objects, arrays, nested relations
- SQL query optimization
Design of relational and object-relational schemas
Design of server-side database applications
Restiction of access rights to application components
Transaction control, database locks
Annotation
SQL language for Oracle and MS SQL databases vs. ANSI SQL
- Tables, views
- Procedural extensions, PL/SQL language, Transact-SQL
- Object/relational extensions - abstract data types, objects, arrays, nested tables
- Query optimization
Relational and object/relational schema design.
Design of server-side running database applications.
Access rights management.
Transaction control, database locks