Babes-Bolyai University of Cluj-Napoca
Faculty of Mathematics and Computer Science
Study Cycle: Master
SUBJECT
| MIH1001 | Database Servers |
| 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. |
| 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 |