Data Bases

[Wiki] A database is an organized collection of data.[1] It is the collection of schemas, tables, queries, reports, views, and other objects. The data are typically organized to model aspects of reality in a way that supports processes requiring information, such as modelling the availability of rooms in hotels in a way that supports finding a hotel with vacancies.

A database management system (DBMS) is a computer software application that interacts with the user, other applications, and the database itself to capture and analyze data. A general-purpose DBMS is designed to allow the definition, creation, querying, update, and administration of databases. Well-known DBMSs include MySQL, PostgreSQL, MongoDB, MariaDB, Microsoft SQL Server, Oracle, Sybase, SAP HANA, MemSQL and IBM DB2.

Goals

After completing this course, students will be able to:

  • Describe database concepts and considerations.
  • Understand the basic concepts of relational databases.
  • Create database schema using DDL (Data Definition Language.
  • Run data manipulation statements (DML).
  • Design and Implement Tables.
  • Describe advanced table designs
  • Ensure Data Integrity through Constraints.
  • Describe indexes, including Optimized and Columnstore indexes
  • Design and Implement Views.
  • Control database access to specific objects, Manage schema objects et Manage objects with data dictionary views.
  • Retrieve row and column data from tables.
  • Control privileges at the object and system level.
  • Create indexes and constraints; alter existing schema objects.

Outline

Course track Labs track (Pr. Amine BENAMRANE)
  • Chapter 1: Introduction to database
  • Chapter 2: ER Diagrams
  • Chapter 3: Relational algebra and relational database
  • Chapter 4: SQL
  • Chapitre 5 : Functional dependency
  • Chapitre 6 : Normal forms
  • Chapitre 7 : Concurrent access management
  • Lab 1: Oracle and SQL Plus cmd
  • Lab 2: Oracle Modeler
  • Lab 3 : SQL 1
  • Lab 4 : SQL 2
  • Lab 5 : SQL 3
  • Lab 6 : SQL 4
  • Lab 7 : SQL 5

Prerequisites and related courses

Basic knowledge of relational database formalization and design.

Language and material

The classes will be given in French by default. Slides will be in French/ English and available in PDF.

Bibliography

  • coming soon

Tentative Schedule

DATE (DD/MM/YY) TIME CONTENT MATERIAL
Week 1
  • 08:00 AM to 10:00 AM
  • Introduction to database
Week 2
  • 10:00 AM to 12:00 AM
  • 16:00 PM to 18:00 AM
  • 08:00 AM to 10:00 AM
  • Entity Relationship diagram
Week 3
  • 08:00 AM to 10:00 AM
  •  Relational algebra and relational database
Week 4
  • 10:00 AM to 12:00 AM
  • 16:00 PM to 18:00 AM
  • 08:00 AM to 10:00 AM
  • Introduction to SQL
Week 5
  • 10:00 AM to 12:00 AM
  • 16:00 PM to 18:00 AM
  • 08:00 AM to 10:00 AM
  • Chapter 5 : Functional dependency
Week 6
  • 10:00 AM to 12:00 AM
  • 16:00 PM to 18:00 AM
  • 08:00 AM to 10:00 AM
  • Chapter 6 : Normal forms

Project (Download here)

Project requirements:

• Team of 2 students at most;
• The work must be provided as a report and CD containing the data and SQL scripts before: Thursday, December 15, 2016
• The date of the individual oral examination will be communicated later.