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

SUBJECT

Code
Subject
MIH1001 Database Servers
Section
Semester
Hours: C+S+L
Category
Type
Databases
2
2+0+2
speciality
compulsory
Teaching Staff in Charge
Prof. ŢÂMBULEA Leon, Ph.D.,  leoncs.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. 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™ Oracle® Database Development, Prentice Hall 2002.
4. GREENWALD RICK,JIM MILBERY, Oracle9i AS™ 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.
Links: Syllabus for all subjects
Romanian version for this subject
Rtf format for this subject