Dr. Dan Pescaru
   Associate Professor

Home  |   Teaching   |   Research & Stuff  |  Publications

 

Database Design (EN)

AC Faculty, UPT,  year:  IV CTI-EN (2015-...)
Textbooks:
1. Mary Beth Roeser & Al., Oracle Database PL/SQL Language Reference 12c, Oracle, 2015.
2. Sheila Moore & Al., Oracle Database SQL Language Reference 12c, Oracle, 2014.
3. R- Ramakrishnan si J. Gehrke, "Database Management Systems", 3rd edition, ISBN 007-2465-63-8, McGraw-Hill, 2003.

Lecture notes(pdf):
C1. Introduction. Content. Short Review on Relational Model.
C2. Oracle DBMS.
C3. Oracle SQL language (I).
C4. Oracle SQL language (II).
C5. Oracle PL/SQL Basics.
C6. Oracle PL/SQL using Cursors. Packages. Functions.
C7. Oracle PL/SQL Exception Model. Triggers. DB Consistency.
C8. The Oracle Object Model.
C9. NoSQL Systems.

PL/SQL Examples.

Lab: B623
Marks:
Exam results 2018: P1(15.01.18), P2(16.02.2018), P2(16.03.2018)

Last update: 20.03.2018
Computers Department, "Politehnica" University of Timisoara, Romania