Babes-Bolyai University of Cluj-Napoca
Faculty of Mathematics and Computer Science
Study Cycle: Graduate

SUBJECT

Code
Subject
MI075 Database Servers
Section
Semester
Hours: C+S+L
Category
Type
Computer Science - in Romanian
8
2+0+2
optional
Mathematics-Computer Science - in Romanian
8
2+0+2
optional
Teaching Staff in Charge
Prof. ŢÂMBULEA Leon, Ph.D.,  leoncs.ubbcluj.ro
Lect. CÂMPAN Alina, Ph.D.,  alinacs.ubbcluj.ro
Aims
To learn database servers.
Content
1. Client/server technology.
2. Oracle system. SQL. SQL*Plus.
3. Concurrency control. Security in a database. Users managemet.
4. Oracle database in Visual Basic and Delphi.
5. PL/SQL. Objects in Oracle.
6. Transactions.
7. Oracle database administrator.
8. Database backup and recovery.
9. Query optimization.
10. Distributed database.
11. Web and Oracle.
References
1. AUSTIN, D., colectiv, Oracle8, Editura Image, 1999 (traducerea cartii: David Austin, Using Oracle8, Macmillan Computer Publishing, USA, 1998; Exista si o versiune HTML).
2. HARRINGTON, J.L., SQL Cleary Explained, AP Professional, (Academic Press), 1998.
3. LOCKMAN, D., Developing Personal Oracle7 for Windows 95 Applications, Macmillan Computer Publishing, USA, 1997.
4. LUERS, T., Bazele Oracle 7, Editura Teora, 1998.
5. Oracle8 and Oracle8 Enterprise Edition, On-Line Generic Documentation, Oracle Corporation, 1997.
6. POPESCU, I., Oracle8. Prelucrarea avansata a informatiei. Editura Tehnica, Bucuresti 1999.
7. POPESCU, I., Modelarea bazelor de date. Editura Tehnica, Bucuresti 2001.
8. http://cis.gsu.edu/~shong/teaching/cis473/projects/oracle.html.
9. http://www.cs.umbc.edu/help/oracle8.
10. STEPHENS, R.K., R.R. PLEW, B. MORGAN, J. PERKINS, Teach Yourself SQL in 21 Days, Second Edition, Macmillan Computer Publishing, http://www.mcp.com.
11. WHALEN, E., DELUCA, S.A., Teach Yourself Oracle 8 In 21 Days, Macmillan Computer Publishing, USA, 1997, http://www.mcp.com.
Assessment
Practical part and a written part consisting of theoretical questions.
Links: Syllabus for all subjects
Romanian version for this subject
Rtf format for this subject