Dr. Dan Pescaru    Associate Professor

Home  |   Teaching   |   Research & Stuff  |  Publications

Databases (EN) AC Faculty, UPT,  year:  II CTI-EN (2014-15) 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): C1. Introduction. DBMS. Data Storage. C2. Data modeling. The ER model. Data organization and access optimization. C3. Relational algebra. Operators. DB query languages. C4. Indexing. DB optimization. C5. SQL. Using DDL. Active queries. C6. SQL. Data projection, selection, ordering and joins. C7. SQL Subqueries. Union and difference. C8. SQL. Data aggregation. C9. SQL Execution plan. Introduction in query optimization. C10. Implementing DB clients in Oracle APEX. Forms and reports. C11. Implementing Web databases using MySQL and PHP. C12. Overview of database administration and security. Lab: B623 PROGRMARE I restanta ani terminali (an IV CTI-EN): 14.12.2017, 17:00 sala A204. Last update: 10.07.2017

Computers Department, "Politehnica" University of Timisoara, Romania

This Web Page Created with PageBreeze Free HTML Editor