Databases

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.

Discipline(s)

• Informatique

Bibliographie

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

Contact