Advanced Databases by Imed Bouchrika

The Advanced Databases course is being taught by Imed Bouchrika at the University of Souk-Ahras. Imed Bouchrika received his Bsc and PhD degrees in Electronics and Computer Science from the University of Southampton in United Kingdom in 2004 and 2008 respectively. His research areas are image processing, biometrics and automated visual surveillance. The database course is aimed for Software Engineering Master II students.
The outline of the course is set as below:

Week 1
Lecture: Introduction to Databases
French Translation by Amira Hakim
Practical Work :
> Java Programming : Creating a Phonebook using a simple CSV file
> Database Porgramming : Creating a simple phone book using Java & a database ( HSQLDB )
To Read:
> Short Biography about Edgar Codd
> A Relational Model of Data for Large Shared Data Banks (1970)

Week 2
Lecture: Database Design
French Translation by Meriem Sari
Practical Work :
> Drawing ER Diagrams with Dia Tool using Chen Notation
To Read:
> Entity–relationship model

Week 3
Lecture: SQL Queries
Practical Work :
> Installing MySQL and phpMyAdmin on Windows using EasyPHP ( WAMP )
> SQL Simple Exercises using MySQL and phpMyAdmin
> Simple SELECT Query from a single table
To Read:
> SQL SELECT Tutorial : Searching & Querying the database
> Join : SELECT Tutorial using multiple database tables

Week 4
Lecture: Advanced SQL Queries
Practical Work :
>Advanced SQL SELECT Tutorial using Aggegrate Functions by Examples
>SQL tutorial for using Having with Examples
>SQL SELECT Tutorial for Nested Queries ( Sub Queries )
>Advanced Database Quiz Level 1
>Foreign Keys Made Simple with MySQL by examples
To read
> W3 School SQL Tutorials

Week 5
Lecture: ORDBMS – Oracle
Practical Work :
> Tutorial for how to Get started to learn Oracle
> Oracle : Type/Object Creation, Inheritance and Method Implementation with Examples
> Making Connection to Oracle Database System with Java
>
To read
> Main Features and Advantages Object-Relational Database systems ( ORDBMS )
> Oracle® Database Object-Relational Developer’s Guide

Week 6
Lecture: Transactions
Practical Work :
>
>
To read
>

Week 7
Lecture: XML, DTD & xSchema
Practical Work :
> Practice and Learn Document Type Definition to validate XML
> Free Install XMLCopyEditor to Validate your XML against DTD and XSD
> Practice XSD Schema online to validate XML documents by Examples
> Automatically Generate XSD from XML using FreeFormatter.com
To read
> Introduction to XML Document Type Definition by Examples
> Simple Introduction to XML Schema ( XDS )

Week 8
Lecture: Lecture: xPath & xQuery
Practical Work :
> Learn xPath for Searching XML online with Examples
> xPath Processing for XML documents using Java
> BaseX : Tutorial for using an XML Native Database Management System
To read
> xPath Made Simple : Tutorial for xPath Expression Languation

Week 9
Lecture: Data Mining & Analysis
Practical Work :
>
>
To read
>

Week 10
Lecture: OLAP
Practical Work :
>
>
To read
>

Week 11
Lecture: Database Optimization
Practical Work :
>
>
To read
>

Week 12
Lecture: Distributed Databases
Practical Work :
>
>
To read
>