Bases de donnéesInformatique Fondamentale (STI)

• Manage SQL language: query, update and create databases, with implementation using SQLite software
• Understanding a few theoretical language requests: relational algebra, relational calculus

• Introduction to the Relational Model : Database Schema, Keys, Schema Diagrams
• Introduction to SQL : SQL Data Definition, Basic Structure of SQL Queries, Additional Basic Operations, Set Operations, Null Values, Aggregate Functions, Nested Subqueries, Modification of the Database
• Intermediate SQL : Join Expressions, Views, Integrity Constraints, SQL Data Types and Schemas
• Formal Relational Query Languages : Relational Algebra, Tuple Relational Calculus, Domain Relational Calculus

Continuous Control Integral: 50% Interro on paper + 50% TD machine output

• Silberschatz, Korth, Sudarshan. Database System Concepts, McGraw-Hill, 2010. https://www.db-book.com/db6/index.html