overview of database languages an architectures;
the basic relational model;
SQL: data definition, constraints and basic queries and updates;
SQL: advanced queries, assertions, triggers and views;
formal relational languages: the algebra and calculus;
conceptual data modeling using entities and relationships;
mapping a conceptual design into a logical design;
UML for database application design;
object and object-relational databases: concepts, models, languages and standards;
XML: concepts, languages and standards;
SQL application programming using C and Java;
SQL web programming using C PHP;
database design theory: introduction to normalization using functional and multivalued dependencies;
database design theory: normalization algorithms;
database file organizations: unordered, ordered and hashed files of records;
database file indexing techniques, b-trees and B+ trees;
introduction to query processing and query optimization techniques;
introduction to data base tuning and physical design issued;
foundations of databases transaction processing;
introduction to protocols for concurrency control in databases;
introduction to database recovery protocols;
emerging database technologies and applications;
advanced database models and applications;
introduction to database security;
introduction to distributed databases;
introduction to information retrieval;
data mining concepts;
overview of data warehousing and OLAP