Dr. Dan Pescaru
   Associate Professor

Home  |   Teaching   |   Research & Stuff  |  Publications

 

Teaching

Courses

Expert Systems (SE - Sisteme Expert)
AC Faculty, UPT,  year:  V C (1999-2008), IV C (2009 - )
Textbooks:
1. S. Russell, P. Norvig - Artificial Intelligence, a Modern Approach, SE, Prentice Hall, 2003, ISBN 0-13-080302-2.
2. Simon Haykin, "Neural Networks - a comprehensive foundation", Macmillan Pub. Co, 1998, ISBN 0-13-273350-1.
3. D. Waterman, "A Guide to Expert Systems", Addison Wesley Pub. Co., 1985, ISBN  0-201-08313-2.
Lectures: Decision Support Systems based on Statistical Data: Bayes theorem, alternatives calculus, logistic model; Knowledge Based Systems: forward chaining, backward chaining, certain factors; Fuzzy Expert Systems: fuzzy logic, fuzzy inference, fuzzy controllers; Symbolic Processing Graphs: blackboard model, conceptual graphs; Neural Network Based Systems: perceptron, self-organizing networks, Hopfield networks, back-propagation, Bayesian networks, Towell networks, CNN, Deep learning.
Lecture notes(pdf): SE Part I, SE Part II, SE Part III
Labs: B623 drd.ing. Marius Baba: Th 14:00-20:00
Lista subiecte examen.
Note 2019 - P1-24.04.19, P2-07.05.19, P3(28.05.19).
Data pezentarea P3: 28.05.2019, 10:00, ASPC

Databases (EN)
AC Faculty, UPT,  year:  II CTI-EN (2014 - 2017)
Textbook:
1 . R- Ramakrishnan si J. Gehrke, "Database Management Systems", 3rd edition, ISBN 007-2465-63-8, McGraw-Hill, 2003.
Lecures:Introduction. DBMS. Data Storage. Data modeling. The ER model. Data organization and access optimization. Relational algebra. DB query languages. Physical modeling of relational data. DB optimization. Normal forms. SQL. Using DDL and DML. SQL Execution plan. Introduction in query optimization. Implementing DB clients in Oracle APEX. Implementing Web databases using MySQL and PHP. Overview of database administration and security.
Lecture notes(pdf): LN Databases
Labs: B623 (dr.ing. Codruta Istin)
Exam results 2018: cv.upt.ro
Next presentation (P2): 07.01.2019, 14:00, A109.

Database Design (EN)
AC Faculty, UPT,  year:  IV CTI-EN (2015 - )
Textbook:
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.
Lecures:Introduction, Oracle DBMS, Oracle Database Design, Oracle SQL, Oracle PL/SQL, Object-Relational DBMS, Oracle Object-relational Model, NoSQL Databases.
Lecture notes(pdf): LN Database Design
Labs: Lab1 Lab1 Ex
Exam results 2019 IV CTI-EN: P3(21.03.2019)
Restante 2019 (P1): Mo, 09.12.2019 14:00 A117.
Labs: as.drd.eng. Marius Baba, B623

Foundations of Software Engineering (FIS - Fundamante de Inginerie Software)
AC Faculty, UPT,  years:  II Inf (2009-)
Textbooks:
1. L.A. Maciaszek, B.L. Liong - "Practical Software Engineering", Addison-Wesley, Pearson Education, 2005, ISBN 0-321-20465-4.
2. I. Sommerville - "Software Engineering", Addison-Wesley, Pearson Education, 8th Edition, 2006, ISBN 0-321-21026-3.
Lecture notes
Cap.1 Introduction (pdf)
Cap.2 Lifecycle (pdf)
Cap.3
Requirements Engineering (pdf)
Cap.4 Modelling Languages (pdf)
Cap.5 Arhitectural Design (pdf))
Cap.5a Object Oriented Principles (pdf)
Cap.6 Software Development (pdf)
Cap.7 Testing and Validation (pdf)
Cap.8
Project Management (pdf)
Labs: B623,   Thursday, 8-12, 14-16
2011-2019 Lab (dr.ing. Codruta Istin)  
Note FIS Restanta 2019/2020 P1 29.11.2019.

Advanced Databases  
AC Faculty, UPT,  year:  I MSE (2012/2013)
Textbooks:
1. R- Ramakrishnan si J. Gehrke, "Database Management Systems", 3rd edition, ISBN 007-2465-63-8, McGraw-Hill, 2003.
Lecures: Introduction. Relational Query Execution and Optimization. Data Storage and Indexing. Transactions Management. Concurrency Control and Crash Recovery. Database Installation and Performance Tuning. Distributed Databases. Object Oriented Databases. Object-Relational Databases. Data Warehouses. OLAP.
Couse notes: www.cv.upt.ro
Labs/Prj: B623 (as.ing. Ovidiu Parvu)


Advanced Web Programming  
AC Faculty, UPT,  year:  II MSE (2010-2013)
Textbooks:
1. James Governor, Duane Nickull, Dion Hinchcliffe, "Web 2.0 Architectures", ISBN: 978-0-596-51443-3, O'Reilly, 2009.
2. B. Brinzarea, C. Darie, F. Chereches-Tosa, M. Bucica, "AJAX and PHP: Building Responsive Web Applications", ISBN : 1904811825, Packt Publishing, 2006.
3. Michael Mahemoff, "Ajax Design Patterns", ISBN: 978-0-596-10180-0, O'Reilly, 2009.
4. Andrew Watt, Chris Lilley, "SVG unleashed", ISBN-10: 0-672-32429-6, SAMS, 2003.
Lecures: History. Web 2.0. Research issues. Web technologies. Client side scripting. Server side scripting. Ajax. Web applications frameworks. Rich Internet Applications. Web services. Web mashups. SMIL. Joomla. SVG.
Labs/Prj: B623 (conf.dr.ing. Dan Pescaru), Friday 10-14


Databases Administration (ABD - Administrare Baze de Date)   
AC Faculty, UPT,  year:  I Master TI (2010)
Textbooks:
1. E-book: Dan Pescaru - "Baze de Date"

2. Gehrke Ramakrishnan - "Database Managament Systems", McGraw Hill Higher Education, (2003)
3. D. Pescaru - "Baze de Date Relationale si Orientate pe Obiecte", Ed. Politehnica, (2001)
Lecures: Introducere: BD, SGBD, SQL,BD Web; Proiectarea bazelor de date, Algebra Relationala, Normalizarea unei baze de date, Administrarea dictionarelor de date; Interogarea datelor, Extragerea informatiilor de sumarizare, Securitatea si protectia datelor: Utilizatori si Privilegii, Proiectarea unui sistem de gestiune a accesului, Replicarea datelor; Baze de date Web: Sistemul Web,  Continut Web static si dinamic; PHP: Generarea dinamic a continutului, Tipuri de date, Extragerea datelor din formulare HTML,  Controlul fluxului, Reutilizarea codului, Administrarea sesiunilor, Utilizarea fisierelor externe, Utilizare cookies; Administrarea aplicatiilor e-comerce, aplicatii specifice unor domenii particulare
Labs: B623, Friday 12-16



Multimedia Databases (BDMM - Baze de Date Multimedia)  
ETC Faculty, UPT,  year:  V MM (2003-2008)
Textbooks:
1. Book: D. Pescaru - "Baze de Date Relationale si Orientate pe Obiecte", Ed. Politehnica
2. Setrag Khoshafian, Brad Baker - "Multimedia and Imaging Databases", Morgan Kauffman Inc., (1996)
3. D. Pescaru - "Baze de Date Relationale si Orientate pe Obiecte", Ed. Politehnica, (2001)
Lecures: Introducere: BD, SGBD, SQL,BD Web,BD Multimedia; Proiectarea si crearea unei baze de date: Proiectarea unei baze de date, Crearea unui dictionar de date, Elemente de Algebra Relationala, Normalizarea unei baze de date; Tipuri de date, operatori si functii: Tipuri de date, Operatori, Functii, Tabele; Interogarea datelor: Selectia simpla, Sortarea si filtrarea datelor, Crearea de campuri calculate, Extragerea informatiilor de sumarizare, JOIN; Securitatea si protectia datelor: Utilizatori si Privilegii, Proiectarea unui sistem de gestiune a accesului, Replicarea datelor; Baze de date Web: Sistemul Web, Servere Web, HTTP, HTML, Continut Web static si dinamic; Limbajul PHP: Generarea dinamic a continutului, Tipuri de date, Extragerea datelor din formulare HTML, Operatori, expresii; Controlul fluxului, Tablouri,Functii, Reutilizarea codului; Controlul sesiunilor, Utilizarea fisierelor, Utilizare cookies; Accesul unei baze de date din PHP: Conectarea la o baza de date, Rularea interogarilor, Obtinerea si afisarea datelor, Adaugarea, stergerea si modificarea datelor; Baze de date multimedia: Aplicatii e-comerce, Aplicatii specifice unor domenii particulare, Interogarea datelor multimedia
Labs: B623, Friday 8-20
 

Multimedia Programming (PM - Programare Multimedia)
 
ETC Faculty, UPT,  year:  I Master TM (2009)
Lecures: Domeniul aplicatiilor multimedia, Proiectarea aplicatiilor multimedia (Cicluri de dezvoltare. Modele arhitecturale. Analiza cerintelor. Proiectarea aplicatiei.), Aplicatii Web multimedia (Implementarea interfetelor. Limbajele HTML, XHTML, CSS.), Limbaje CSS (Client Side Script) (Limbajul JavaScript. Modelul DOM. Adobe Flash. Limbajul ActionScript.), Limbaje SSS (Server Side Script) (Limbajul PHP. Generarea elementelor multimedia. Librariile GD si PDFLib.), Limbaje specializate. Limbajul SMIL (Structura unui document SMIL. Obiecte multimedia. Sincronizarea obiectelor multimedia. Legături. Unelte.), Aplicatii RIA (Rich Internet Applications) (Tehnologii utilizate în dezvoltarea aplicatiilor de tip RIA. Tehnologia Ajax. Google Ajax API. Adobe Flex. Scalable Vector Graphics (SVG) ).
Labs:
B226, Monday 10-14


Databases (BD - Baze Date)
AC Faculty, UPT,  years:  II Inf (2007-2008)
Textbooks:
1. L.A. Maciaszek, B.L. Liong - "Practical Software Engineering", Addison-Wesley, Pearson Education, 2005, ISBN 0-321-20465-4.
2. I. Sommerville - "Software Engineering", Addison-Wesley, Pearson Education, 8th Edition, 2006, ISBN 0-321-21026-3.
Lectures: BD si SGBD:  Modelele de baze de date; Proiectarea unei baze de date; Modelul Entity-Relationship (ER). Baze de Date Relationale:  Modelul relational;  Dependente functionale; Chei primare si externe, integritatea cheilor; Anomalii de inserare, modificare, stergere. Algebra Relationala:  Operatii de selectie si proiectie; Operatii de uniune, intersectie si proiectie; Produsul cartezian si operatia de JOIN. Normalizarea BD Relationale:  Definirea dependentelor functionale; Reguli de inferenta; Forme normale. Proiectarea BD Relationale: Analiza aplicatiei; Definere constringeri in relatii, chei; Caracteristici ale relatiilor; Operatii in BD relationale. Limbajul xBase: Modelul xBase; SGBD Visual dBase; Operatii de gestionare a datelor; Rapoarte; Aplicatii client cu interfata grafica. Limbajul SQL: Interogari SQL; Local SQL; Oracle PL/SQL; Gestionarea datelor; Vederi; Tipuri de Join; Tranzactii; Implementari relational-obiectuale
Lecture Notes: (pdf)

Labs: B623
Labs page (conf.dr.ing. Dan Pescaru) 


Object Oriented Programming (POO - Programarea Orientata pe Obiecte) 
ETC Faculty, UPT,  year:  IV MM (2003-2007)
Textbooks:
1. B. Meyer – „Object-Oriented Software Construction”, Second Edition, Prentice Hall, 1997, ISBN 0-13-629155-4
2.
2.J. Gosling, B. Joy, G. Steele, G. Bracha – „The Java™ Language Specification”, Second Edition, Addison-Wesley, 2000, ISBN 0-201-31008-2
3. James W. Cooper – „Design Patterns in Java™ Technology”, SUN Press, 2000
Lecures: Notiuni fundamentale de programare orientata pe obiecte: Notiuni de baza, Clase si obiecte, Abstractizare, Principii de proiectare si programare orientata pe obiecte; Scurt istoric al paradigmelor de programare, Trecere în revista a limbajelor C, C++ si Java, Limbajul Java: Conceptul de masina virtuala; Functionarea unui program Java; Notiuni de baza: Tipuri de baza, variabile si constante, Expresii si operatori, Instructiuni, Folosirea tablourilor; Proiectarea unei aplicatii POO: Clase, Interfete, Agregarea, Mostenirea, Crearea ierarhiilor de clase, Segregarea interfetelor, Tratarea exceptiilor, Foloisre design patterns; Utilizarea bibliotecilor Java: Pachete Java, Crearea si utilizarea bibliotecilor de clase, Bibliotecile standard lang, io, util, Clase Java standard pentru aplicatii în domeniul prelucrarii imaginilor
Lecture notes: (zip)
Labs: B226
Lab Page (conf.dr.ing Dan Pescaru, as.dr.ing. Bucos Marian)

 

Labs

Databases (BD - Baze Date)
AC Faculty, UPT,  years:  III CTI (2008-)
Labs: B623 Monday 16-20
Labs page (conf.dr.ing. Dan Pescaru) 
Prezenta Lab 2012.

 

 

 

Last update: 28.11.2017

Computers Department, "Politehnica" University of Timisoara, Romania

 

 

 

This Web Page Created with PageBreeze Free HTML Editor