Database Engineering - L2H

The main objective of this course is to master the basic notions allowing to develop  DB applications by exploiting the contributions of different tools, namely: the SQL standard and the 4th generation languages (PL/SQL, pg/plsql, etc.). Here, the practical aspect is fundamental to acquire the basics of application development in any environment.

The outline of this course is as follows: 

    • Chapter 1: The SQL language -Part I-
      •  The data definition language (DDL)
    • Chapter 2: The SQL language -Part II-
      •  The data manipulation language (DML)
    • Chapter 3: The PL/SQL Language  -Part I-
      • Introduction to PL/SQL
      • Variables and constants
      • Conditional and repetitive processing
      • Cursors
      • Exceptions 
    • Chapter 4: The PL/SQL Language  -Part II-     
      • Sub programs
      • Stored subprograms
      • Packages
    • Chapter 5 : Triggers 
Level: L2