[Wiki] A database is an organized collection of data. 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.
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.
|Course track||Labs track|
Basic knowledge of relational database formalization and design.
The classes will be given in French by default. Slides will be in French/ English and available in PDF.
- coming soon
Project (Download here)
• Team of 2 students at most;
• The work must be provided as a report and CD containing the data and SQL scripts before: May 10, 2016
• The date of the individual oral examination will be communicated later.