Databases

Databases
Licence InformatiqueParcours Computer Sciences (UFAZ) (délocalisé en Azerbaïdjan)

ComposanteUFR de mathématique et d'informatique

Description

Design and implement a Database, from scratch to a MySQL server, using PHP MyAdmin. The database structure is built from the Entity Relationship Diagram (ERD) from Conceptual Data Model, to Logical Data Model, and then to the Physical Data Model and the relational schema. PHP MyAdmin interface is used for Data Definition Language. Data Manipulation Language is used for processing data, mainly CRUD queries : CREATE, READ, UPDATE and DELETE queries. Other data format are also discussed : XML and JSON. This last format will enable us to learn about the MongoDB database, CRUD queries and MongoDB aggregation for transforming and analysing multiple documents in a collection by merging, filtering and calculating.

Compétences requises

Knowledge of the basic concepts of algorithms and programming. Basic computer skills (file management, text editor, ...)

Compétences visées

  • Interacting with a SQL DBMS server, either from a localhost environment, or from a remote web server.

  • Building a database structure from an Entity Relationship Diagram. Creating the database, the tables, importing data using PHP MyAdmin interface.

  • Performing SQL Queries

  • Working with a NoSQL storage system.

Bibliographie

Learn SQL Database Programming. Bush, Josephine. Packt Publishing. 2020

Contacts

Responsable(s) de l'enseignement