Databases in Network Applications ITI1106

Course content:
1. Presentation of the guidelines of course. Selected methods of SQL 2003.
2. Advanced SQL functions.
3. Introduction to PL/SQL.
4. Procedures, functions, packages.
5. Collections.
6. Operations on large objects.
7. Introduction to HTML.
8. Introduction to PHP.
9. Advanced PHP.
10. Creating forms.
11. Web applications with Oracle database.
12. Queries and transactions using SQL statements.
13. Queries and transactions using the instructions for the PL/SQL.
14. Oracle transactions on large objects.
15. Summary.

Learning outcomes: ability to design web applications with database.