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

Code	Subject	
MIH1001	Database Servers	

Section	Sem.	Hours: C+S+L	Category	Type	
Databases	2	2+1+0	speciality	compulsory	

Teaching Staff in Charge	Prof. ŢÂMBULEA Leon, Ph.D., leon@cs.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.	
Bibliography	1. AULT MICHAEL, Oracle9i Administration and Management, John Wiley & Sons 2002
2. DAWES CHIP, STEVEN FEUERSTEIN, BILL PRIBYL, Oracle PL/SQL Language Pocket Reference, O@Reilly 2003.
3. GALLARDO DAVID J., Java&#8482; Oracle&reg; Database Development, Prentice Hall 2002.
4. GREENWALD RICK,JIM MILBERY, Oracle9i AS&#8482; Portal Bible, Hungry Minds, Inc. 2001.
5. HARRINGTON, J.L., SQL Cleary Explained, AP Professional, (Academic Press), 1998.
6. INGRAM GEOFF, High-Performance Oracle, Wiley Publishing, Inc. 2002.
7. LONEY KEVIN, GEORGE KOCH,  Oracle9i: The Complete Reference, McGraw-Hill/Osborne 2002.
8. POPESCU, I., Modelarea bazelor de date. Editura Tehnica, Bucuresti 2001.
9. POPESCU, I., Oracle8. Prelucrarea avansata a informatiei. Editura Tehnica, Bucuresti 1999.
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
	
Assessment	Practical part and a written part consisting of theoretical questions.